Import Json using SQL Dedicated Pool in Azure Synapse Analytics (SQLDW)

This blog shows how to easily Extract Json and XML objects and Arrays into SQDW using COPY INTO SQLDW is a bit behind other vendors like snowflake when it comes to being able to query Json natively off a data lake as they have native support. To get around this we simply load the Json … Continue reading Import Json using SQL Dedicated Pool in Azure Synapse Analytics (SQLDW)