Snowflake Use Warehouse

Queries and Resources
1

I successfully configured a Snowflake Resource using a newly created user and role, RETOOL and RETOOL_READ_ONLY, respectively.

image
image899×1063 42.7 KB

I can successfully query the SNOWFLAKE_SAMPLE_DATA table within a Retool App.

image
image1736×1071 180 KB

However, I'd like to use the schema browser if possible.

Is this a permissions issue or something else?

Thanks!

2

Hey @Anthony_Torres, looks like Snowflake can throw that error when the db user doesn't have the appropriate permissions to run the query. In this instance it would be the query we run to grab the schema. If you update the user permissions, are you able to use see the schema / use GUI mode?