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?
