Getting started

Connecting a Microsoft Azure SQL Data Warehouse Destination to Stitch

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.


Reference

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.


Questions? Feedback?

Did this article help? If you have questions or feedback, feel free to submit a pull request with your suggestions, open an issue on GitHub, or reach out to us.