This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
FAQ
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Search instead forย 
Did you mean:ย 

Can see Tables not Views of DB

Karthika
New Contributor II

โ€Ž01-21-2021 08:14 PM

I am able to see my all Database tables from Snowflake in the snaps. But I have a database View that I use in Snowflake. Is there any way to see the Views so I can use a Snowflake snap and a select query that fetches data from the View. The snaps can only access Tables.

0 Kudos
2 REPLIES 2

igormicev
Contributor

โ€Ž01-23-2021 08:25 AM

Itโ€™s more practical to use the โ€œSnowflake - Executeโ€ snap and get the desired columns from the view. Just write in the SQL statement and execute.

Karthika
New Contributor II
In response to igormicev

โ€Ž01-25-2021 06:26 AM

Thanks. I am able to see the view now without any changes. Interesting. I am thinking it was another path related bug saying the view canโ€™t be reached. I fixed the path. But still the view was not showing up. I closed Snaplogic and opened the next day and it was gone. My only guess is that the old bug which was not cleared when fixing the path, but cleared only when I closed the application.

0 Kudos