Visual Query Builder does not populate schemas containing only views for Snowflake

[JakeS]

Issue: When connecting to a Snowflake instance that has schemas that contain only views, those schemas will not appear in visual query builder.

For example, in the image below from the Snowflake console, "TESTSCHEMA" contains only views and "TESTSCHEMA2" contains a view and a table:



In the Visual Query Builder in Alteryx, we can only see "TESTSCHEMA2":




Cause:

Defect DE17676 / TDCB-1208
Status: Fixed in 2021.4.


Workarounds:
-Add a table to the schema
-Write SQL manually or copy from another SQL editor to pull from the views

[ntobon]

There is another defect: "TDCE-5 - The VQB does not show Snowflake DBs in which all Schemas only contain Views". 

Defect DCE-5  is target for resolution in future release.

Workaround

1. Type SELECT * FROM <<one of the tables in the missing DB>> in SQL tab and navigate back to VQB and it appears or select the table from the table tab from the missing DB. Frustrating for users trying to build complex SQL statements (only select specific fields, joins, unions, etc.)

2. create a dummy table in a schema (only possible if user has the right level of access or if admin is willing to do this)