Run the setup script.
Using theACCOUNTADMIN role, create an Airbyte-specific warehouse, database, schema, user, and role. This keeps Airbyte’s costs attributable and its permissions granular.Load data into Snowflake from 600+ sources
How it works
How do you load data into Snowflake with Airbyte?
Airbyte’s setup script creates a dedicated warehouse, database, schema, user, and role, so your Airbyte load path is isolated from everything else in the account.
Grant permissions.
The role needsUSAGE on the warehouse and OWNERSHIP on the database. Airbyte creates schemas automatically if the user has CREATE SCHEMA, and it needs ALTER TABLE on destination tables so schema evolution works.Configure the destination.
Add Snowflake as a destination in Airbyte and supply the connection details. Then select your streams, set each to Incremental Sync - Append + Deduped where the source exposes a primary key, and run the first sync.How it works
What happens to your grants when Airbyte syncs?
Not a philosophy. A set of specific, verifiable guarantees about the infrastructure your data runs on.
Grants survive.
Airbyte clones with COPY GRANTS rather than swapping tables, so the roles you granted stay granted.
History survives.
When a column disappears at the source, Airbyte keeps the column and its historical data and writes NULL going forward.
Bad rows do not kill the sync.
Values that exceed Snowflake’s size or precision limits are nulled and the change is recorded in _AIRBYTE_META instead of failing the run.
CREATE OR REPLACE TABLE ... CLONE ... COPY GRANTS;Introduced in connector version 4.0.47, specifically to preserve table grants.
Airbyte versus Snowflake’s native loading options
Snowflake ships several ways to get data in, and most of them assume the data is already in cloud storage in the right shape. That assumption is where the work actually is.
| Method | Best for | Limits | Use Airbyte instead when |
|---|---|---|---|
| COPY INTO from an external stage | Files you already land in S3, GCS, or Azure Blob | You own extraction, file formatting, scheduling, and retries | Your data starts in an API or an operational database, not a bucket |
| Snowpipe | Continuous micro-batch loading of files as they arrive | Still assumes something else puts files in the bucket | You need the extraction half, not just the load half |
| Snowpipe Streaming | Low-latency row-level ingestion | You write and operate the client application | You want connectors rather than a client to maintain |
| Native Snowflake connectors | A short list of first-party sources | Limited catalog | Your source is not on that list |
| Data sharing | Consuming data from a provider already on Snowflake | No copy, and only works provider-to-consumer on Snowflake | The data lives outside Snowflake entirely |
Where Airbyte wins
The extraction half. Every native option starts from “assume the data is already in a stage.” Airbyte is the part that gets Salesforce, Postgres CDC, Stripe, and NetSuite into that state on a schedule, with schema drift handled, and then loads it.
Where it does not
If your pipeline already lands clean Parquet in S3 on a schedule you control, Snowpipe is cheaper and closer to the metal.
Compared to other managed connector platforms
| Airbyte | Fivetran | Native Snowflake connectors | |
|---|---|---|---|
| Source connectors | 600+ | Large catalog | Short first-party list |
| Open source | Yes, and self-hostable | No | No |
| Runs in your own VPC or on-prem | Yes, via Airbyte Flex | Limited | Not applicable, runs in Snowflake |
| Data retained on vendor servers | No | Processed on vendor infrastructure | Stays in Snowflake |
| Build your own connector | Connector Builder and CDK | Limited | No |
Sean Carver
Director of Data at PetDesk
"The real ROI is in our ability to iterate quickly, especially at our increasing scale. At the end of the day, you want a tool like that to just work. We can forget about it and know that it's configured and it's connecting and it's working. That hands-free capability is a big appeal for the platform.”
20+
data sources integrated and growing
+1
FTE engineer in productivity efficiency
85%+
reduction in data source integration time
Mondor La Grange
Head of BI and Data Engineering
"Unlike Fivetran's credit-based system that created budget uncertainty, Airbyte's pricing model allows Kuda to forecast expenses accurately and avoid surprise bills."
20+
data sources integrated and growing
+1
FTE engineer in productivity efficiency
85%+
reduction in data source integration time
Amy Zhao
Senior Manager of Data Engineering
"What's different from Stitch Data or Informatica is the way that we can configure Airbyte connections and Airbyte entities through code. That's a huge plus to us as data engineers, because we are used to checking code and being able to manage changes from Github."
3 to 1
reduction in data integrations solutions for reduced TCO
1
week Shopify and Stripe integration with Airbyte
Franziska Ibscher
Product Manager at Drivepoint
"Airbyte allows us to stay flexible while scaling from hundred-million to billion-dollar enterprise clients."
75%
of customers increased profitability
6.7%
EBITDA increase for customers
Which sources can you load into Snowflake?
All 600+ of them. These are the ones Snowflake users start with.
Databases
SaaS applications
Files and object storage
Events and streaming
KafkaEvents and streaming
Amazon KinesisEvents and streamingBrowse all 600+ sources
Not seeing yours?
Build it with the Connector BuilderHow does your data land in Snowflake?
Airbyte writes one final table per stream, typed on arrival. Every table carries five metadata columns: _AIRBYTE_RAW_ID, _AIRBYTE_GENERATION_ID, _AIRBYTE_EXTRACTED_AT, _AIRBYTE_LOADED_AT, and _AIRBYTE_META.
| Airbyte type | Snowflake type |
|---|---|
| STRING | TEXT |
| INTEGER | NUMBER |
| NUMBER | FLOAT |
| BOOLEAN | BOOLEAN |
| DATE | DATE |
| TIMESTAMP_WITH_TIMEZONE | TIMESTAMP_TZ |
| TIMESTAMP_WITHOUT_TIMEZONE | TIMESTAMP_NTZ |
| TIME_WITHOUT_TIMEZONE | TIME |
| OBJECT | OBJECT |
| ARRAY | ARRAY |
| UNION | VARIANT |
Schema evolution
Column added.
Airbyte adds the column to the destination table automatically.
Type changed.
Airbyte modifies the column type as needed. This requires ALTER TABLE on destination tables.
Column removed.
Airbyte retains the column and its historical data, and writes NULL for subsequent rows. Added in connector version 4.0.48 to prevent data loss from upstream schema changes.
The numbers
Teams running Airbyte in production
0M
pipelines synced daily
6960+
companies
199%
ROI, certified by Forrester
Sean Carver
Director of Data at PetDesk
"The real ROI is in our ability to iterate quickly, especially at our increasing scale. At the end of the day, you want a tool like that to just work. We can forget about it and know that it's configured and it's connecting and it's working. That hands-free capability is a big appeal for the platform.”
20+
data sources integrated and growing
+1
FTE engineer in productivity efficiency
85%+
reduction in data source integration time
Mondor La Grange
Head of BI and Data Engineering
"Unlike Fivetran's credit-based system that created budget uncertainty, Airbyte's pricing model allows Kuda to forecast expenses accurately and avoid surprise bills."
20+
data sources integrated and growing
+1
FTE engineer in productivity efficiency
85%+
reduction in data source integration time
Amy Zhao
Senior Manager of Data Engineering
"What's different from Stitch Data or Informatica is the way that we can configure Airbyte connections and Airbyte entities through code. That's a huge plus to us as data engineers, because we are used to checking code and being able to manage changes from Github."
3 to 1
reduction in data integrations solutions for reduced TCO
1
week Shopify and Stripe integration with Airbyte
Franziska Ibscher
Product Manager at Drivepoint
"Airbyte allows us to stay flexible while scaling from hundred-million to billion-dollar enterprise clients."
75%
of customers increased profitability
6.7%
EBITDA increase for customers
Deployment
Where Airbyte runs
Your warehouse credentials and your data do not have to leave your environment. Airbyte does not retain customer data on its servers.
Airbyte Cloud
Fully managed hosting on the Standard and Pro plans. Fastest path to a running pipeline.
Airbyte Flex
Hybrid deployment, with Airbyte’s data plane running in your cloud, VPC, or on-prem environment. You get 600+ connectors and a fully managed experience, while your data never touches our servers.
Self-Managed
Open source, your infrastructure, your rules.
compliance
Enterprise ready
Compliant with standards
SOC 2 Type II certified, GDPR and HIPAA support, with tools to help you meet internal and external regulatory requirements.
Uptime & SLA Guarantees
24/7 support and 99.9% availability backed by contractual SLAs and priority response times for mission-critical workloads.
'%3e%3ccircle%20cx='422'%20cy='422'%20r='222'%20fill='url(%23paint0_linear_0_4)'/%3e%3c/g%3e%3cdefs%3e%3cfilter%20id='filter0_f_0_4'%20x='0'%20y='0'%20width='844'%20height='844'%20filterUnits='userSpaceOnUse'%20color-interpolation-filters='sRGB'%3e%3cfeFlood%20flood-opacity='0'%20result='BackgroundImageFix'/%3e%3cfeBlend%20mode='normal'%20in='SourceGraphic'%20in2='BackgroundImageFix'%20result='shape'/%3e%3cfeGaussianBlur%20stdDeviation='100'%20result='effect1_foregroundBlur_0_4'/%3e%3c/filter%3e%3clinearGradient%20id='paint0_linear_0_4'%20x1='644'%20y1='477.911'%20x2='200.016'%20y2='475.206'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20offset='0.00480771'%20stop-color='%235D51D5'/%3e%3cstop%20offset='1'%20stop-color='%23D763EC'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e)
'%20stroke='url(%23paint0_linear_0_33)'%20stroke-width='3.99691'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_0_33'%20x1='117.909'%20y1='59.9537'%20x2='1.99846'%20y2='59.9537'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%235D51D5'/%3e%3cstop%20offset='1'%20stop-color='%23CECBF2'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e)
'%20stroke-width='1.35684'%20stroke-miterlimit='1.5'%20stroke-linejoin='round'/%3e%3c/g%3e%3c/svg%3e)
What does it cost?
On the Snowflake side, you pay warehouse credits for the compute time a load consumes, plus storage. A dedicated warehouse for Airbyte keeps loads from competing with analyst queries and makes the cost attributable.
Core
Always free. Self-managed
For teams comfortable running open source entirely on their own.
- Open source
- All 600+ connectors
- Your own infrastructure
Airbyte Cloud
Standard
Starting at $10 per month.
For practitioners who want fully managed software and prefer to be billed on data volume.
- Fully managed cloud hosting
- Volume-based pricing
- Deploy quickly
Airbyte Cloud
Pro
Capacity-based pricing.
For organizations that need scalability, governance, and security while simplifying pipeline management.
- Fully managed cloud hosting
- Capacity-based pricing, billed on Data Workers rather than data volume
- Multiple workspaces
- SSO and RBAC
- 15-minute syncs and custom mappings
- Premium support
Enterprise Flex
Capacity-based pricing.
For enterprises in regulated industries that need full control of their data with the convenience of managed SaaS.
- Sovereign data movement inside your own boundary
- Available on-premises and multi-region
- Hybrid deployment with an Airbyte-managed control plane
- All the features of Airbyte Pro, including premium support
FAQs
Didn’t find your answer?
Please don’t hesitate to reach out.
What is the best way to load data into Snowflake?
Does Airbyte use Snowpipe?
Will a sync drop the grants on my tables?
What happens when a value is too large for Snowflake?
How does Airbyte handle Snowflake schema changes?
What permissions does Airbyte need in Snowflake?
Can I run this inside my own cloud?
Other destinations
BigQuery
Airbyte stages files in Google Cloud Storage, then loads them into BigQuery with native load jobs. Warehouse compute stays on Google Cloud, and Airbyte never sits in the query path.
ClickHouse
Airbyte writes to ClickHouse over its native binary protocol with batch inserts. The setup needs a hostname, a port, and a user. No object storage, no staging permissions, no intermediate hop.
Databricks
Airbyte stages Avro files inside Unity Catalog Volumes, not an external bucket, so your data stays under your catalog’s governance from the first byte to the final table.
Build with Airbyte
Ship agents and pipelines in minutes, not days.