load JSON files from blob storage which have folders like structure (YYYY-MM-DD/HH) in the Azure Synapse pipeline
I have a blob storage container where i have folder and subfolder like structure example:
Container: XYZ
Folder: yyyy-MM-dd
subFoller: HH
Dynamic mapping in Azure Synapse Copy Data Activity
We’re currently facing an issue while ingesting data from SQL Server into Avro files. While most of the data types are correctly identified (e.g., strings as strings, integers as integers), our date fields are being mapped as strings instead of dates. For instance, a date like “2012-10-01 14:58:45.8830000” is being treated as a string.