Pinned fields
Click on the next to a field label to start pinning.
Details
Assignee
Avinash AcharAvinash AcharReporter
Sanchit GargSanchit GargLabels
Fix versions
Priority
Major
Details
Details
Assignee
Avinash Achar
Avinash AcharReporter
Sanchit Garg
Sanchit GargLabels
Fix versions
Priority
Created last week
Updated last week
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 nativeDESCRIBE
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 aLIMIT 1
query. This approach avoids unnecessary delays, particularly for columnar databases like Snowflake where data retrieval can be slower.