Skip to main content
Solved

Is there any way we can see/edit the SQL query used while creating SQL catalog item

M
Star Blazer L1

Hi there, I have created a sql catalog item and published, profiled as well and would want to check/update the query if needed corrections. I don’t see options anywhere on the tabs (e.g., Data Quality/Relationships etc.) available on catalog item. Please help. I am using v15.4.1

Best answer by Lisa Kovalskaia

​@mp_ataccamauser hi! You can view the query on the SQL CI overview tab, but depending on the screen size you might have to scroll down, it’s all the way at the bottom. (If you want to make it appear higher up on this screen, you can! )

To edit the query, go to the CI’s three dot menu in the top right corner → Edit → on the next screen go to the bottom right and click Continue.

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

3 replies

Lisa Kovalskaia
Ataccamer
Forum|alt.badge.img+3

​@mp_ataccamauser hi! You can view the query on the SQL CI overview tab, but depending on the screen size you might have to scroll down, it’s all the way at the bottom. (If you want to make it appear higher up on this screen, you can! )

To edit the query, go to the CI’s three dot menu in the top right corner → Edit → on the next screen go to the bottom right and click Continue.

M
1 person likes this
  • M
    mp_ataccamauser
M
Star Blazer L1

Thanks ​@Lisa Kovalskaia I never scrolled till the extreme bottom of the page 😃 Is it also possible to see like what all tables have been used in the query of SQL catalog items let’s say for example in Relations/Lineage tab

Lisa Kovalskaia
1 person likes this
  • Lisa Kovalskaia
    Lisa Kovalskaia
M
Star Blazer L1

Oh I see we can add Relations ourselves, Cheers!

Lisa Kovalskaia
1 person likes this
  • Lisa Kovalskaia
    Lisa Kovalskaia

Reply


Community Terms of Use & ConditionsCookie settingsAccessibility statement

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