Connectors

/

Destinations

/

Snowflake destination

  • 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

  1. First, navigate to the Airbyte website and log in to your account.

  2. Once you are logged in, click on the "Destinations" tab on the left-hand side of the screen.

  3. Scroll down until you find the Snowflake Data Cloud destination connector and click on it.

Configuration fields

Snowflake destination configuration fields
FieldTypeDescription
database*stringEnter the name of the database you want to sync data into
host*stringEnter your Snowflake account's locator (in the format...snowflakecomputing.com)
role*stringEnter the role that you want to use to access Snowflake
schema*stringEnter the name of the default schema
username*stringEnter the name of the user you want to use to access the database
warehouse*stringEnter the name of the warehouse that you want to use as a compute cluster
cdc_deletion_modestringWhether 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.
credentialsobjectDetermines 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

DataConnectorsCredentialsKeys

↕ metadata only

Airbyte control plane

OrchestrationMonitoringUI

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.