Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
The Snowflake connector is supported in Data Factory for Microsoft Fabric with the following capabilities.
Supported capabilities
| Supported capabilities | Gateway | Authentication |
|---|---|---|
| Dataflow Gen2 (source and destination) | None On-premises Virtual network |
Snowflake Microsoft Account Key-pair Service Principal (SPN) |
| Pipeline - Copy activity (source/destination) - Lookup activity - Script activity |
None On-premises Virtual network |
Snowflake Microsoft Account Key-pair |
| Copy job (source/destination) - Full load - Incremental load - CDC - Append - Override - CDC Merge |
None On-premises Virtual network |
Snowflake Microsoft Account Key-pair |
Related content
To learn about how to connect to a Snowflake database in Dataflow Gen2, go to Set up your Snowflake connection.
To learn about writing to Snowflake, including update methods and schema options, see Snowflake destination settings.
To learn about the copy activity configuration for Snowflake in pipelines, go to Configure Snowflake in a copy activity.