Can we convert .sav files into parquet in adf

Nuthana 1 Reputation point
2022-09-14T06:54:19.61+00:00

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 Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,337 questions
Azure Storage Accounts
Azure Storage Accounts
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
2,676 questions
Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
1,913 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,514 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaikMaheer-MSFT 37,896 Reputation points Microsoft Employee
    2022-09-15T11:31:01.527+00:00

    Hi @Nuthana ,

    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.