# Snowflake ### How to Connect Airbook to Snowflake Connecting Airbook to Snowflake allows you to leverage your Snowflake data for robust analysis and insights. Follow these steps to set up your Snowflake connector in Airbook and start querying your data. {% embed url="" %}
### Step-by-Step Guide 1. **Prepare Your Snowflake Account:** * Open your Snowflake UI in a new tab. 2. **Retrieve Snowflake Account URL:** * In the Snowflake UI, locate your account URL. This URL is typically displayed in the format `https://.snowflakecomputing.com`. 3. **Trim the URL:** * Copy your Snowflake account URL and remove the `https://` prefix and everything after `.snowflakecomputing.com`. You should be left with `.snowflakecomputing.com`. 4. **Navigate to Airbook Connections:** * Switch over to your Airbook workspace and click on the "Connections" tab located on the sidebar. 5. **Select Snowflake Connector:** * From the list of available data sources, select "Snowflake." 6. **Enter Connection Details:** * In the connection setup screen, enter the following information: * **Account URL:** Paste the trimmed Snowflake account URL (`.snowflakecomputing.com`). * **Database Name:** Enter the name of the database you want to use. For example, you can use `SNOWFLAKE_SAMPLE_DATA`. * **Username:** Enter the username you use to log into your Snowflake account. * **Password:** Enter the corresponding password for your Snowflake account. 7. **Whitelist Our IP Address:** * To ensure seamless connectivity and the ability to query your database without interruptions, please whitelist our IP address: **34.122.205.142**. This step is crucial for establishing a secure and stable connection between your database and Airbook, allowing us to retrieve and analyze your data effectively. 8. **Test Connection:** * Click the "Test Connection" button to ensure Airbook can connect to your Snowflake database. If the test is successful, you'll see a success message. Otherwise, you'll be prompted to make the required corrections to your database credentials. 9. **Save and Connect:** * Once the connection test is successful, save your configuration. You’ll be prompted to give the connection a schema name. Enter a descriptive name and save it. 10. **Wait for Ingestion:** * Your Snowflake data will start ingesting into Airbook. This process may take a while depending on the volume of data. If your Snowflake data doesn’t show up immediately, give it a few minutes. You will receive an email notification once the data ingestion is complete. ### Querying Data from Snowflake Now that your Snowflake account is connected, querying data is simple: 1. **Go to the Query Section:** * Navigate to the query section in your Airbook workspace. 2. **Run a Query:** * Enter your SQL query to fetch data from Snowflake and hit the "Run Query" button. 3. **View Results:** * Your query results will be displayed, showing how easy it is to access and analyze data from Snowflake within Airbook. --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.airbook.io/connect/snowflake.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.