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)
Author: Bob Duffy
If you are running a SQL/Data User group or event I'm always happy to do a 50-60 minute virtual talk. Let me know bob@prodata.ie or @bob_duffy on twitter. 2022 Session Options 01. SqlPool Maintenance Fundamentals SQL Pools now support auto create status. But they do not support auto update stats and don’t quite have the … Continue reading Bob Duffy – User Group and Event Sessions for 2022