Getting started

Connecting a Microsoft Azure Synapse Analytics Destination to Stitch

Connect a Microsoft Azure Synapse Analytics database to your Stitch account as a destination.


Using Microsoft Azure Synapse Analytics

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.


Troubleshooting

Destination Loading Error Reference Resolve errors related to loading data into your Stitch destination.

Destination Connection Error Reference Resolve errors related to connecting to your Stitch destination.


Reference

Microsoft Azure Synapse Analytics Destination Reference Reference documentation for Stitch’s Microsoft Azure Synapse Analytics 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.