search

appsmithorg / appsmith

Platform to build admin panels, internal tools, and dashboards. Integrates with 25+ databases and any API.
https://www.appsmith.com
Apache License 2.0
34.63k stars 3.74k forks source link

[Feature]: To support the handling of temporary tables. MySQL and Snowflake. #24052

Open felix-appsmith opened 1 year ago

felix-appsmith commented 1 year ago

Is there an existing issue for this?

Summary

Currently, temporary tables cannot be managed because each query opens a new session or sessions are restarted at regular intervals. This instability makes it impossible to work with temporary tables from Appsmith. Temporary tables are a powerful feature that should exist.

Why should this be worked on?

We need to work on supporting temporary tables as soon as possible because they provide valuable functionality, such as improved performance, better data organization, and advanced data analysis capabilities. By enabling temporary table support, we can enhance our system, attract more users, and align with industry standards. This feature is essential for maximizing the potential of our platform and ensuring we meet the needs of our users effectively.

GreenFlux commented 1 year ago

another EE customer has requested support for temporary views in MySQL: https://theappsmith.slack.com/archives/C05QUCS74J2/p1693934341529719