search

wise-coders / dbschema

DbSchema Database Designer
https://dbschema.com
67 stars 3 forks source link

Snowflake views ddl come empty #86

Closed paddelia closed 1 year ago

paddelia commented 1 year ago

  1. Please include the DbSchema version, operating system and used database Downloaded a couple days ago

  2. The steps to reproduce this issue Connect to a snowflake db

  3. Views are not coming across, the columns is 0 and the definition is empty.

I may have to do something else to retrieve views ddl may be? image

wise-coders commented 1 year ago

Thank you for reporting this issue. We tried to reproduce this, but we got a different issue. We are using this query to load the view definition: SELECT table_name, view_definition FROM "${catalog}".INFORMATION_SCHEMA.views WHERE table_schema='${schema}'

When I execute this from the SQL Editor, I get an No active warehouse selected in the current session. Select an active warehouse with the 'use warehouse' command.

I use a Snowflake trial account, which does not have any warehouse.

Could you please try to test this query for us?