Snowflake in DataGrip - No introspection for dynamic tables
I am able to see dynamic tables and their columns in the databse explorer. I can also select * or select a subset of columns from them. But when I type out a specific column name from the dynamic table, DataGrip highlights it and shows an ‘unable to resolve column <column_name>’ error. Code completion is also unavailable for dynamic tables.
Has anyone else who works with Snowflake dynamic tables in DataGrip run into this, and if so, how did you resolve it?
Please sign in to leave a comment.
The support of dynamic tables has been implemented not a while ago
https://youtrack.jetbrains.com/issue/DBE-18526/Snowflake-Add-support-for-DYNAMIC-tables
What are your current IDE version and your current settings under Suggest Objects From in File | Settings | Editor | General | Code Completion?
My current DataGrip version is 2024.1.3. My suggest objects from setting is ‘All available schemas’.
Please see if upgrading to 2024.1.4 or 2024.2 solves this and if not, please provide examples of your table definition so we can perform additional tests.
I recently re-installed datagrip on a new laptop and experienced this issue, when previously it worked.
I noticed that in Database Explorer, next to the the database name there is a greyish icon with the text ‘0 of X’, where X is the number of schemas.
Click on that and you then select the schema you want. Then hopefully you will have Intellisence based on the schema.
Hi Rob,
Can you clarify how the issue is reflected in the UI? Are you able to query and locate the dynamic tables in Database Explorer? To investigate your issue, please upload the following logs onto our FTP https://uploads.jetbrains.com/
- idea log from Help - Show Log in Files
- database log from Help - Show SQL Log in Files
- data model (see screenshot below)
Please provide your upload id in your reply
> Can you clarify how the issue is reflected in the UI?
The issue was that the schema I wished to use was not automatically selected.
As a casual user of datagrip, it was not apparent that the database had multiple schemas and that my desired one was not selected.
As selecting all schemas, depending on the amount of data they have, could lead to lengthy and unwanted wait times to synchronize all the objects within your database, we allow our users to make a choice and customize the list of schemas they want to retrieve.
If the schema absence was related to not being checked in the schema list and you are able to query the data from it, then we should be good for now. However, if you're still experiencing issues, please provide more details so we can have a closer look.
I resolved this issue by un-installing DataGrip and re-installing version 2024.2.2
Please let me know if you need my assistance.