Copy JSON data from rest api to Snowflake

pankaj chaturvedi 86 Reputation points
2023-01-25T14:58:43.9166667+00:00

Hi Team,

I want to copy data from REST API (Source) to Snowflake table(Sink) using azure data factory. Is that possible to load the data using Copy activity in ADF.I am looking forward your response.

Many thanks,

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,219 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. MartinJaffer-MSFT 26,226 Reputation points
    2023-01-26T18:15:36.22+00:00

    @pankaj chaturvedi Hello and welcome to Microsoft Q&A.

    Yes, you can copy from REST API to Snowflake.


  2. pankaj chaturvedi 86 Reputation points
    2023-01-27T09:25:44.65+00:00

    Hi @MartinJaffer-MSFT , Could you please let me know how did you achieve this as I am unable to load the data. I used source as SNOW REST API and Target is Snowflake table. In copy activity i used pre-copy script to create tables(create table tablename_*Dates(JSON_*DATA VARIANT)) dynamically and loading the data respective tables in snowflake. Copy activity is showing rows written in output but I am unable to see the rows in Snowflake table. Please let me know what am I missing here.Thanks

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.