Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,566 questions
Json in synapses
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 13%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
Vineet S
750
Reputation points
Hi, how to run json file on synapse workspace.. Tried with data flow but not reading files after data using flattens transformation... Trying convert in parquet..Pls share screenshot(file attached). have selected data.ap_lt_os_pri.idfs_calculated_options.edit_all in unroll by but not getting full data...Screenshot is appreciated
{count} votes
-
Vineet S 750 Reputation points
2024-09-01T22:31:23.9633333+00:00 have selected data.ap_lt_os_pri.idfs_calculated_options.edit_all in unroll by but not getting full data...Screenshot is appreciated
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 61%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
phemanth 10,240 Reputation points Microsoft Vendor2024-09-02T19:11:45.6533333+00:00 Welcome to the Microsoft Q&A and thank you for posting your questions here
could you please share more details on your data flow with screen shots.
converting to Parquet, make sure that the schema is correctly defined and that all necessary fields are included. You can use the
Data Flowto convert JSON to Parquet by adding aSinktransformation and selecting Parquet as the output format.
-
Vineet S 750 Reputation points
2024-09-02T19:22:42.6233333+00:00 json file is attached
-
-
phemanth 10,240 Reputation points Microsoft Vendor
2024-09-04T15:52:36.0433333+00:00 @Vineet S We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Sign in to comment
Sign in to answer