How do I load data from Microsoft SQL Server into my warehouse?
This recipe copies a table from Microsoft SQL Server into your warehouse using ingestr. The source URI uses the mssql scheme with an ODBC driver parameter and the source table is given as schema.table.
Command
ingestr ingestDefined in
CLI
Works with
Microsoft SQL Server to any ingestr destination
What you get
Full table loadODBC driver supportIncremental sync
How it works in code
$ ingestr ingest \
--source-uri 'mssql://user:password@host:1433/dbname?driver=ODBC+Driver+18+for+SQL+Server&TrustServerCertificate=yes' \
--source-table 'dbo.users' \
--dest-uri $SNOWFLAKE_URI --dest-table 'dbo.users'Run ingestr ingest and ingestr loads the Microsoft SQL Server data into your warehouse.
Related use cases
Load a specific source
Replicate a Postgres database into Snowflake
How do I replicate a Postgres database into Snowflake?
Load a specific sourceReplicate a database incrementally
How do I keep a database table in sync without full reloads (CDC-style)?
Load a specific sourceLoad Google Sheets into your warehouse
How do I load a Google Sheet into my warehouse?
Move data with one command
Open source. Source URI in, destination URI out, incremental by default.