I am trying to use DBT Cloud to create derived views in Snowflake.
The underlying tables in Snowflake are themselves views that have been shared with me via the.
However, when I try to preview a super basic model:
SELECT * FROM xxxx;
I keep getting into the error:
Server error: Database Error in rpc request (from remote system)
002003 (42S02): SQL compilation error:
Object 'xxxx' does not exist or not authorized.
I've tweeked privileges and other things, but I can't figure the right configuration to get this working.
Any ideas?