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