Connect a Microsoft Azure SQL Data Warehouse database to your Stitch account as a destination.
Using Microsoft Azure SQL Data Warehouse
Nested JSON Data Structures & Row Count Impact MongoDB and many SaaS integrations use nested structures, which means each attribute (or column) in a table could have its own set of attributes. Depending on the type of destination you’re using, Stitch may deconstruct these nested structures into separate tables.
Microsoft Azure SQL Data Warehouse Destination Reference Reference documentation for Stitch’s Microsoft Azure SQL Data Warehouse destination, including info about Stitch features, replication, and transformations.
Destination & Integration Compatibility Verify your integrations’ compatibility with your data warehouse.
System tables and columns When data is loaded into your destination, Stitch will create some additional columns and tables. Learn about these system columns and tables and how Stitch uses them.
Stitch and Destination Reserved Keywords A reference of Stitch and destination-reserved keywords.
Primary Key System Table (_sdc_primary_keys) Some of Stitch’s destinations don’t have native support for Primary Keys. To ensure data can be de-duped during loading, Stitch will create a Primary Keys table for each integration schema.