GoPie
Get started
Menu
On this page

Database & cloud sources

Connect to Snowflake

Import any query result from a Snowflake warehouse as a dataset.

Before you start

Snowflake credentials are packed into a single connection string:

user:password@account/database?warehouse=WH&role=ROLE
  • account is your Snowflake account identifier (the part before .snowflakecomputing.com).
  • warehouse and role are optional — omit them to use the user's defaults.

The user needs read access to the objects in your query, and the warehouse must be one it can use.

Connect

  1. From your project, select Create Dataset, then the Snowflake tile under Connect to Database.
  2. Name the dataset and paste the credentials string.
  3. Write the SQL query whose result becomes the dataset — for example SELECT * FROM MY_DB.PUBLIC.ORDERS. Qualify table names with database and schema as you would in Snowflake.
  4. Optionally set a Timestamp column and an AI context hint, then select Import dataset.

Enable incremental refresh

Set Timestamp column to a growing column in your result (such as UPDATED_AT). Incremental refreshes append only rows newer than the last run; full refresh remains available either way. See Refresh & scheduled refreshes.

Note

The import runs your query on your Snowflake warehouse, so normal Snowflake compute charges apply — scope the query to what you need.

Give feedback