Hi everyone. I’m trying to load data from Azure Blob Storage (put there by Airbyte) into a dedicated sql pool landing zone, (ie, with the _airbyte_data unflattened), and wondering if anyone has done or tried this before? I can’t seem to get azure to read json blob storage and unflatten 😖

🤔 I'm really not sure if Azure has anything built in for this... within Airbyte the normalization process is done with dbt, would that work? We have a tutorial here: https://airbytehq.github.io/operator-guides/transformation-and-normalization/transformations-with-sql

Thanks for the reply @Sunny Hashmi (Airbyte). I’m aware that the Azure Blob Storage connector does not support transforms in/of itself (due to blob storage being a supported dbt environment), but I was hoping that someone has tried to use airbyte to EL data into Azure Synapse (via blob storage) and worked on the transform 🤷