Hello Samriddhi , Welcome to MS Q&A
To copy JSON data from Service Bus to ADLS Gen 2 and then to Synapse Dedicated SQL Pool, you can create a pipeline in Azure Data Factory that contains a copy activity to ingest data from Service Bus into ADLS Gen2, and then another copy activity to copy data from ADLS Gen2 into Synapse Dedicated SQL Pool. Here are the high-level steps to accomplish this:
- Create a source dataset for Service Bus in Azure Data Factory.
- Create a sink dataset for ADLS Gen2 in Azure Data Factory.
- Create a pipeline in Azure Data Factory that contains a copy activity to copy data from Service Bus to ADLS Gen2.
- Create a sink dataset for Synapse Dedicated SQL Pool in Azure Data Factory.
- Create another pipeline in Azure Data Factory that contains a copy activity to copy data from ADLS Gen2 to Synapse Dedicated SQL Pool.
For more detailed steps and information on how to create pipelines and datasets in Azure Data Factory, refer to the following documentation:
- Ingest data into a dedicated SQL pool
- Load data into Azure Data Lake Storage Gen2 with Azure Data Factory
- Copy and transform data in Azure Data Lake Storage Gen2 using Azure Data Factory or Azure Synapse Analytics
Kindly check and accept answer if it helps , if any questions , please let me know
Thanks
Deepanshu