Serverless Scripting with Azure Functions to Move Data
In this video we look at Azure Functions and how they can help you expand your ETL functionality in Azure and assist with moving data around in Azure.
Koen Verbeeck is a seasoned business intelligence consultant with over a decade of experience with the Microsoft Data Platform. He holds several certifications, including Azure Data Engineer. He's a prolific writer, with over 375 articles on technologies such as Microsoft Fabric, SSIS, ADF, SSAS, SSRS, MDS, Power BI, Snowflake and Azure services. He has spoken at various events such as PASS, SQLBits, dataMinds Connect and many others. He frequently delivers educational webinars on MSSQLTips.com. For his efforts, Koen has been awarded the Microsoft MVP data platform award for many years.
- MSSQLTips Awards:
- Leadership Award (200+ Tips) - 2021
- Author of the Year - 2014/2020/2022
- Author Contender - 2024/2025
Incremental File Load using Azure Data Factory
In this article we look at how to configure Azure Data Factory to be able to incrementally load new files.
Snowflake Tutorial Overview
In this Snowflake tutorial, we go over the basics of the product and features which make it stand out against its competitors.
Setting up a Snowflake Account
Learn how to setup a Snowflake account and activate your account in this step by step outline to get started with Snowflake.
Snowflake Architecture and Pricing Example
Snowflake architecture is built for the cloud with true separation of storage and compute. Learn about Snowflake Architecture and pricing.
Creating a Snowflake Database Schema and Tables
In this part of the tutorial we will see different methods for creating database objects.
Loading Data Into Snowflake
In this part of the tutorial we look at the COPY INTO statement which is able to load data quickly and efficiently into a table.
Querying Data in Snowflake
In this section we look at how to query Snowflake data and how to get better performance for queries.
Snowflake Query History
In this section of the Snowflake tutorial we look at how to get Snowflake query history for queries that have been executed.
Snowflake Time Travel
Learn to query data from different points in time to move forward and backwards with how the data has changed with Snowflake time travel.
Snowflake Regular Expression, Alias and ILIKE
Learn about features in Snowflake such as a Snowflake regular expression, Snowflake alias and Snowflake ILIKE.
Power BI and Snowflake
In this part of the Snowflake tutorial we take a high level view of how to query Snowflake with Power BI to build reports.
Snowflake Tutorial Next Steps
This article has several additional things you can do to continue your Snowflake learning with these Snowflake next steps.
Process Blob Files Automatically using an Azure Function with Blob Trigger
In this tip we will give an example of an Azure Function which will read a Json file from a blob container and write its contents to an Azure SQL Database table.
Power BI Dashboard vs Report vs Workbook
This tip looks at these different methods to present data using Power BI such as Power BI Dashboards, Power BI Workbooks and Power BI Reports.
SSIS Power Query Source
In this article we look at how to use a Power Query source when building a SQL Server Integration Services package.
Azure Data Factory Multiple File Load Example – Part 2
In this article we will create a metadata-driven pipeline using the ForEach activity in Azure Data Factory to load files in parallel.
How to Load Multiple Files in Parallel in Azure Data Factory – Part 1
In this article we look at how to load multiple data files in parallel using Azure Data Factory with an example and a step by step tutorial.
How To Call Logic App Synchronously From Azure Data Factory
In this article we look at how to call Logic App synchronously from Azure Data Factory.
How to Build your First Power BI Dashboard
In this tip we'll learn how we can start building our first Power BI dashboard.
Synchronously Refreshing a Power BI Dataset using Azure Logic Apps
In this tip we will implement a polling mechanism to verify if the Power BI dataset has refreshed successfully.
Integrate Azure Function into Azure Data Factory Pipeline
We will integrate an Azure Function into Azure Data Factory using Snowflake and these steps can be used for any Azure Function integration.
Azure Function to Execute SQL on Snowflake Database
In this article we look at how to create an Azure Function that can be used in Azure Data Factory to query a Snowflake Database.
Create an Azure Function to Connect to a Snowflake Database – Part 1
In this tip we look at how to connect to a Snowflake database when using Azure Data Factory pipelines.