Support Avro format
Please add support in Azure SQL DW for Avro files.
17
votes
2 comments
-
Ralph Kemperdick
commented
Supporting Avro is quite suitable for changing data schemas. The Avro format supports the ability to store data what ever columns are added to it. The capability of Azure data factory on schema drift is very well suited to the Avro format. Avro has been widely adopted as a flexible data exchange format. So why not support AVRO as a first class citizen in Azure SQL Pools?
-
Boddupalli, Srikanth
commented
AVRO is the preferred way to stream data and this becomes a major roadblock if we cannot read Avro files using external tables in the synapse (avoiding duplication of data).