question

Nuthana-0788 avatar image
0 Votes"
Nuthana-0788 asked ShaikMaheer-MSFT answered

Can we convert .sav files into parquet in adf

I have .sav file i need to read this file in adf dataset I am using binary formart as source.
My main work is to convert .sav files into parquet formart.

Eg.source as binary and sink is parquet

When we are taking binary as source sink also should be the same binary.

Can anyone help on this..

azure-data-factoryazure-storage-accountsazure-databricksazure-data-lake-storage
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ShaikMaheer-MSFT avatar image
0 Votes"
ShaikMaheer-MSFT answered

Hi @Nuthana-0788 ,

Thank you for posting query in Microsoft Q&A Platform.

Are you sure data inside .sav file is suitable to load as parquet file?

Try to rename .sav extension to .parquet manually and then try to load that .parquet file in to storage account and then from ADF create a dataset for that parquet file see under schema tab of that dataset if you are getting schema correctly.

If yes, then inside sink tab of copy activity, create a dataset with binary type and then in the path of sink dataset mentioned filename field value with a filename ends with .parquet extension.

Please let me know how it goes.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @Nuthana-0788 , Just checking if you get chance to share updates on above?

0 Votes 0 ·