Connect Snowflake
Last updated
Last updated
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.
Prepare Your Snowflake Account:
Open your Snowflake UI in a new tab.
Retrieve Snowflake Account URL:
In the Snowflake UI, locate your account URL. This URL is typically displayed in the format https://<account_identifier>.snowflakecomputing.com.
Trim the URL:
Copy your Snowflake account URL and remove the https:// prefix and everything after .snowflakecomputing.com. You should be left with <account_identifier>.snowflakecomputing.com.
Navigate to Airbook Connections:
Switch over to your Airbook workspace and click on the "Connections" tab located on the sidebar.
Select Snowflake Connector:
From the list of available data sources, select "Snowflake."
Enter Connection Details:
In the connection setup screen, enter the following information:
Account URL: Paste the trimmed Snowflake account URL (<account_identifier>.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.
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.
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.
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.
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.
Now that your Snowflake account is connected, querying data is simple:
Go to the Query Section:
Navigate to the query section in your Airbook workspace.
Run a Query:
Enter your SQL query to fetch data from Snowflake and hit the "Run Query" button.
View Results:
Your query results will be displayed, showing how easy it is to access and analyze data from Snowflake within Airbook.