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
Replication Job
Single Entity Job
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 staging in the data lake
Create an to load data into the staging table
Create a for each target
Create a to ingest into multiple target schemas
Create a staging in the data lake
Create an to load data into the staging table
Create a that auto-creates a sub-job for each source table to copy data to the target table