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

Question

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

Raj D 616

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

MartinJaffer-MSFT 26,161 Reputation points

2020-07-22T17:45:34.57+00:00

@Raj D did @Vaibhav Chaudhari 's answer help you?
If not, could you let us know if you found your own solution?
If you found your own solution, could you share it with the community?
If you still need help, let me know whether that is Azure Data Lake Storage Gen1 or Gen2.
Raj D 616 Reputation points

2020-08-03T18:36:09.413+00:00

For some reason I get the below error if I were to post a new question.

Access Denied
You don't have permission to access "http://learn.microsoft.com/answers/questions/ask.html" on this server.
Reference #18.35f12417.1596479682.29a6cbe

Answer accepted by question author

0 additional answers

Your answer

MartinJaffer-MSFT 26,161 Reputation points

2020-07-22T17:45:34.57+00:00

@Raj D did @Vaibhav Chaudhari 's answer help you?
If not, could you let us know if you found your own solution?
If you found your own solution, could you share it with the community?
If you still need help, let me know whether that is Azure Data Lake Storage Gen1 or Gen2.
Raj D 616 Reputation points

2020-08-03T18:36:09.413+00:00

For some reason I get the below error if I were to post a new question.

Access Denied
You don't have permission to access "http://learn.microsoft.com/answers/questions/ask.html" on this server.
Reference #18.35f12417.1596479682.29a6cbe

Answer 1

Vaibhav Chaudhari 39,011 Volunteer Moderator

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

0 comments

Share via

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

0 additional answers

Your answer