- Destination
- Warehouses and Lakes
- Generally available
Connect Snowflake data with any data source.
Replicate any source into Snowflake without custom pipelines.
- Sources
- 590+
- Certified support
- 5.2.0
Overview
What is the Airbyte Snowflake connector?
The Airbyte Snowflake connector loads data from 590+ Airbyte sources into Snowflake, with full refresh and incremental sync on a schedule you control.
- 01
Load from any source
Move data into Snowflake from 590+ Airbyte sources on a schedule you control.
- 02
Incremental syncs
Pull only the records that changed since the last run instead of reloading everything.
- 03
Cloud or self-hosted
Run the Snowflake connector on Cloud, OSS, Hybrid.
Setup
Live in eleven steps
First, navigate to the Airbyte website and log in to your account.
Once you are logged in, click on the "Destinations" tab on the left-hand side of the screen.
Scroll down until you find the Snowflake Data Cloud destination connector and click on it.
You will be prompted to enter your Snowflake account information, including your account name, username, and password.
After entering your account information, click on the "Test" button to ensure that the connection is successful.
If the test is successful, click on the "Save" button to save your Snowflake Data Cloud destination connector settings.
You can now use the Snowflake Data Cloud destination connector to transfer data from your Airbyte sources to your Snowflake account.
To set up a data transfer, navigate to the "Sources" tab on the left-hand side of the screen and select the source you want to transfer data from.
Click on the "Create New Connection" button and select the Snowflake Data Cloud destination connector as your destination.
Follow the prompts to set up your data transfer, including selecting the tables or data sources you want to transfer and setting up any necessary transformations or mappings.
Once you have set up your data transfer, click on the "Run" button to start the transfer process.
Configuration fields
| Field | Type | Description |
|---|---|---|
| database* | string | Enter the name of the database you want to sync data into |
| host* | string | Enter your Snowflake account's locator (in the format...snowflakecomputing.com) |
| role* | string | Enter the role that you want to use to access Snowflake |
| schema* | string | Enter the name of the default schema |
| username* | string | Enter the name of the user you want to use to access the database |
| warehouse* | string | Enter the name of the warehouse that you want to use as a compute cluster |
| cdc_deletion_mode | string | Whether to execute CDC deletions as hard deletes (i.e. propagate source deletions to the destination), or soft deletes (i.e. leave a tombstone record in the destination). Defaults to hard deletes. |
| credentials | object | Determines the type of authentication that should be used. |
Hybrid deployment
Sovereign by architecture, not by policy.
The data plane runs in your environment. Records, credentials and keys stay with you; the control plane only receives configuration and job metadata.
- Cloud
- OSS
- Hybrid
Your environment
Airbyte control plane
FAQ
Snowflake connector questions
What data can I load into Snowflake with Airbyte?
Airbyte moves data from any supported source into Snowflake on a schedule you control, with full refresh and incremental sync where the destination supports it.
Does the Snowflake connector support incremental sync?
Yes. The Snowflake destination supports full refresh and incremental sync, so Airbyte can load only the records that changed since the last sync.
Where can I run the Snowflake connector?
Run the Snowflake connector on Cloud, OSS, Hybrid. Hybrid deployments keep the data plane in your environment while the control plane orchestrates syncs.
Didn't find your answer? Talk to sales
Start loading data into Snowflake in minutes.
Free 14-day trial. No credit card needed.