Schema Bulk Load from SQL Server to Snowflake

[dmiller]

Created by @ebarner

---

This pipeline loads the schema from the specified SQL Server table into the Snowflake table.

Configuration

Sources: SQL Server table
Targets: Snowflake table
Snaps used: SQL Server - Select, Snowflake - Bulk Load

Downloads

Schema Bulk Load.slp (4.5 KB)

[srivera]

Thanks for the pattern.

• Have you tested this with various data types, such as, MSSQL BIT and VARBINARY?
• I’m looking to make this more generic so I could pass in a list of tables to the SQLServer Select Snap and migrate each table.

Thanks in advance,

Sonny

[dmiller]

I’m checking with the team as the person who originally created the example is no longer a member of the Community.