Schema Bulk Load from SQL Server to Snowflake

Created by @ebarner


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

42%20PM

Configuration

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

Downloads

Schema Bulk Load.slp (4.5 KB)

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

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