Snowflake to get schema without import query

Description

Issue:
Retrieving the schema currently takes several minutes and often results in a timeout. This is due to the plugin relying on the importQuery property to fetch the schema, which is inefficient—especially when displaying all columns of a table or view.

Proposed Solution:
Optimize schema retrieval by bypassing the importQuery and instead leveraging the database's native DESCRIBE command, which is significantly faster.
Additionally, introduce a new UI field where users can specify the table name. This will allow metadata to be fetched directly via the DatabaseMetaData interface, rather than executing a LIMIT 1 query. This approach avoids unnecessary delays, particularly for columnar databases like Snowflake where data retrieval can be slower.

Release Notes

None

Activity

Show:
Pinned fields
Click on the next to a field label to start pinning.

Details

Assignee

Reporter

Fix versions

Priority

Created last week
Updated last week