6/17/21: We have completed maintenance for the Search functionality on the Community. If you are seeing any issues, please try to clear your cache first. If the issue persists please email Community@alteryx.com

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

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

JakeS
Alteryx
Alteryx
Created
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:

SnowflakeSchemas.png

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

SnowflakeSchemasAlteryx.png

This behavior is defined in DE17676.

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