Skip to main content
Question

SQL Catalog Item Creation Issue

  • January 29, 2025
  • 2 replies
  • 17 views
K
Universe Traveller

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?

    Did this topic help you find an answer to your question?

    2 replies

    C
    Data Pioneer
    Forum|alt.badge.img+1
    • C_RData Pioneer
    • Data Pioneer
    • 5 replies
    • January 29, 2025

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

    Cansu
    K
    2 people like this
    • Cansu
      Cansu
    • K
      kellymremzilyb
    K
    Universe Traveller
    • kellymremzilybUniverse Traveller
    • Author
    • Universe Traveller
    • 2 replies
    • January 30, 2025

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

    C
    Cansu
    2 people like this
    • C
      C_R
    • Cansu
      Cansu

    Reply


    Most Liked this week

    Community Terms of Use & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings