Send data to Azure Synapse Analytics

Azure Synapse Analytics is a limitless analytics service and data warehouse. Azure Synapse Analytics has four components: SQL analytics, Apache Spark, hybrid data integration, and a unified user experience.

This topic describes how to configure Amperity to send files to a cloud storage destination, load data from that destination to Azure Synapse Analytics, and then enable downstream applications and workflows.

Add cloud storage destination

This topic describes the steps that are required to send Apache Parquet files and delimited files (CSV, TSV, or PSV) to Azure Synapse Analytics from Amperity:

• Send the data to Amazon S3.

• Send the data to Azure Blob Storage.

• Send the data to Google Cloud Storage.

Load data to Azure Synapse Analytics

Load data from your preferred cloud storage location to Azure Synapse Analytics.

• Load data from Amazon S3 to Azure Synapse Analytics.

• Use Azure Data Factory to load data from Azure Blob Storage to Azure Synapse Analytics.

• Load data from Cloud Storage to Azure Synapse Analytics.

Enable downstream workflows

Loading data to Azure Synapse Analytics enables downstream workflows, including the use of applications like:

• Databricks

• Microsoft Power BI

• Tableau