@pankaj chaturvedi Hello and welcome to Microsoft Q&A.
Copy JSON data from rest api to Snowflake
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,
2 answers
Sort by: Most helpful
-
-
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