jeremy thomas
01/30/2024, 6:10 PMColumn information could not be retrieved.
This might happen due to either insufficient permissions or an outdated Elementary dbt package.
We are using elementary 0.13.1, which is above the requirement, and I granted the permissions in Snowflake according to the setup guide, which states:
It is recommended to create a read only user for the elementary schema only.
When I look at the troubleshooting linked under the error message, I see this:
check that the user you are using to connect to your database has permissions to access the information schema
However, in Snowflake, you cannot grant privileges directly on information_schema, per this link: https://community.snowflake.com/s/article/Insufficient-privileges-to-operate-on-schema-I[…]are-the-INFORMATION-SCHEMA-of-a-manually-created-database
I am a little lost on how to move forward from here, any help would be greatly appreciated.Daniel Pollak
01/31/2024, 2:29 PMjeremy thomas
01/31/2024, 2:30 PMIt is recommended to create a read only user for the elementary schema only.