Snowflake Query Origin

The Snowflake Query origin reads data based on a custom Snowflake query. You might use a Snowflake Query origin when you have an existing query that you want to use to generate data for the pipeline.

When you configure the Snowflake Query origin, you simply specify the SQL query to use. As a best practice, verify that the query syntax produces the expected output in Snowflake before using it in the Snowflake Query origin.

Note: At this time, the COPY command is not supported.

For more information about Snowflake queries, see the Snowflake documentation.

Configuring a Snowflake Query Origin

Configure a Snowflake Query origin to read data from Snowflake using a SQL query.

  1. On the General tab, configure the following properties:
    General Property Description
    Name Stage name.
    Description Optional description.
    Cache Data Caches processed data.
  2. On the Query tab, specify the Snowflake SQL query to use.
    The query must include a SELECT statement and use valid Snowflake syntax. As a best practice, verify that the query syntax produces the expected output in Snowflake before using it in the Snowflake Query origin.
    Note: At this time, the COPY command is not supported.
    For more information about Snowflake queries, see the Snowflake documentation.