Snowflake

Set up a Snowflake connection

When inside a workbook, click View > Databases, then click the + icon and follow the on-screen instructions.

To find your account name, follow these instructions. Note that in some cases, it's necessary to include your cloud region in the identifier.

Create a Snowflake connection

For detailed instructions, see Connect your data to DataLab.

If you want to experiment with Snowflake without setting up a connection, you can use our sample data warehouse with London Public Transit data.

Query the database

You can now query the Snowflake data warehouse with a SQL cell. Select it in the Select source dropdown in the top left corner of a SQL cell, or select the sample Snowflake database.

Example of a SQL cell using the London Public Transport connection. The query result is available as TFL_JOURNEYS.