Enabling Managed Identity Authentication on Azure Functions in Data Factory

This blog shows you how to enable Managed Identity on an Azure Function call from ADF, this can help secure the Function by adding a second authentication method on top of the API Key. Enabling these options enforces https on all function calls, ADF handles authentication and so no custom headers, tokens or keys are … Continue reading Enabling Managed Identity Authentication on Azure Functions in Data Factory

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)