import sql query data as a json document to azure data lake storage

Question

Hi, I am new to Azure Data Lake Storage. I am trying to import data from different vendor applications where data is hosted on a SQL Database in Azure virtual machines, trying to convert table data to json document and store it in Azure Data Lake Storage. And, What options are available to automate this.

Could you please guide me in the right direction.

SELECT *
  FROM [dbo].[table]
     FOR JSON PATH

Thank you

Could you please guide me in the right direction.

SELECT *
  FROM [dbo].[table]
     FOR JSON PATH

Thank you

Accepted Answer

You could think of using Azure data factory service to automate this. This service is used to orchestrate the ETL flow on Azure.

Create ADF, create pipeline and drag and drop Copy activity. Configure the source (SQL table), target connection (Json in ADLS) and this pipeline can be scheduled to run. Use this for reference - tutorial-hybrid-copy-data-tool

----------

If the response helped, do "Accept Answer" and upvote it -- Vaibhav

Share via

import sql query data as a json document to azure data lake storage

0 additional answers