Skip to main content

I am trying to create a SQL catalog item to filter out the inactive records.  When I create the SQL catalog item I get the following error message:

SQL compilation error: Object 'DEV_SOURCE.SAPMDG.VTLFA1' does not exist or not authorized.

I can see the data tab for this table.  I can run profiling/DQ insights tab so I’m not sure what is happening.  I have created the query with the schema name and without the schema name. 

Shouldn’t the credentials be the same to create the SQL catalog item?

Could this be related to credential configuration? Maybe DBA can grant access?

I figured out the issue.  Snowflake requires quotes around the table name.

Reply


Community Terms of Use & ConditionsCookie settings