# 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](https://docs.snowflake.com/en/user-guide/admin-account-identifier). Note that in some cases, it's necessary to [include your cloud region in the identifier](https://docs.snowflake.com/en/user-guide/admin-account-identifier#format-2-legacy-account-locator-in-a-region).

<figure><img src="https://4179539225-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MZqboFGZzD87nn7oPsm%2Fuploads%2F1HwhCCuA46lfGj1qXthr%2FScreenshot%202023-06-30%20at%2014.02.03.png?alt=media&#x26;token=2123341f-27a2-45f7-9cd9-5f18c45b6032" alt=""><figcaption><p>Create a Snowflake connection</p></figcaption></figure>

For detailed instructions, see [connect-your-data-to-workspace](https://datalab-docs.datacamp.com/connect-to-data/connect-your-data-to-workspace "mention").

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](https://datalab-docs.datacamp.com/work/sql-cell "mention"). Select it in the **Select source** dropdown in the top left corner of a SQL cell, or select the sample Snowflake database.

<figure><img src="https://4179539225-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MZqboFGZzD87nn7oPsm%2Fuploads%2FPmMexjYjJG0IFtkWS0S0%2Fimage.png?alt=media&#x26;token=7d551ea5-6bf9-40ad-8695-a4ed94a1a7c0" alt=""><figcaption><p>Example of a SQL cell using the <code>London Public Transport</code> connection. The query result is available as <code>TFL_JOURNEYS</code>.</p></figcaption></figure>