Microsoft SQL Server
Learn the steps for ingesting your Microsoft SQL Server data into your target.
Last updated
Learn the steps for ingesting your Microsoft SQL Server data into your target.
Last updated
for your source Microsoft SQL Server database.
Create a connection to your source Microsoft SQL Server database.
Create a connection to your target (see the Supported Targets list below for links).
Create the entities for your target per the list in the Job Type & Steps column below. Note that there are multiple options for ingesting to Snowflake:
Ingestion Job
Create a staging table in the data lake
Create an ingestion job to load data into the staging table
Create a transformation job for each target
Replication Job
Create a replication job to ingest into multiple target schemas
Single Entity Job
Create a staging table in the data lake
Create an ingestion job to load data into the staging table
No-code Wizard
Alternatively, you can use the to get your pipelines started in super-quick time. The Wizard generates the code for you so you can optionally customize it for your requirements, and create advanced use cases.
Create a that auto-creates a sub-job for each source table to copy data to the target table