Linked Questions

Popular Questions

Data Types in Azure Data Lake Gen2 not maintained

Asked by At

I currently have a pipeline that is loading many tables from oracle to ADLS Gen2. The pipeline is parametrized and loop over source tables with their corresponding schemas. However, when I load the data in the blob storage, the data types are not preserved. If I load the data to a target sql database, the data types are maintained perfectly . Using the import schema in the adf is not an option for me because I am loading many tables at once.

I know AWS has a service called glue catalog that helps you track your metadata when it is loaded to s3 buckets. Does Azure have something similar ? Or Does Azure have another way to maintain the data types when the data is loaded to a blob storage ?

thanks

Related Questions