I am using dbt Core to read data from views in Snowflake.
Views in snowflake are created on data in salesforce data cloud using zero copy integration. Data resides in salesforce and is shared live.
I keep getting ’ schema does not exist or not authorised’, when I do ‘select * from view’. Have checked connecting role access to the schema and other details.
Does dbt restrict reading live shared data?