@Abhiram Patil Welcome to Microsoft Q&A forum and thanks for reaching out here.
As per your description, while creating the copy pipeline for ingesting the data to your ADLS Gen2 location, in the destinations dataset configuration you have selected File format as JSON
, which has resulted in the above error. This is because when you tried to select new SQL query
> bulk
then Synapse Analytics uses COPY statement for loading from external storage accounts. And this statement supports only the below file types:
Hence to overcome the issue, while creating the destination dataset, in the configuration section instead of JSON
format try creating a DelimitedText
. This should help overcome the problem.
Hope this helps.
Please don’t forget to Accept Answer
and Yes
for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.