Json in synapses

Question

Json in synapses

Vineet S 1,390

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

Vineet S 1,390 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
Anonymous

2024-09-02T19:11:45.6533333+00:00

@Vineet S

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 Flow to convert JSON to Parquet by adding a Sink transformation and selecting Parquet as the output format.
Vineet S 1,390 Reputation points

2024-09-02T19:22:42.6233333+00:00

json file is attached
Anonymous

2024-09-03T11:35:13.1866667+00:00

@Vineet S yes Iam referring to the source and sink transformation settings with data flow activity configuration
Anonymous

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.