Data Lake in a Day - Lab 4 Ingest into Azure Synapse Analytics (SQL DW)

In this lab I show you how to load the data which was processed in lab 3. You can find the instructions for this lab at github.com/davedoesdemos/Data... to follow along yourself.
In part one of the Data Lake in a Day series I showed you how to set up the infrastructure for the whole workshop with a simple one click deployment using an ARM template. If you've not already done so, go and run through that video at • Data Lake in a Day 1 -... .
In part two of the series I took you through Lab 1, this lab showed you how easy it is to ingest data from a database into the data lake. See that video at • Data Lake in a Day 2 -...
Part three introduced you to what a data lake is and what it's for, and can be found at • Data Lake in a day - S...
Part four was the second session covering how a data lake is organised and is at • Data Lake in a Day - S...
In part five I covered lab 2 where we downloaded weather data for various cities and can be found at • Data Lake in a Day - L...
In the last video I showed you how to use Data Factory with Mapping Data Flows to process and curate the data to produce a data model • Data Lake in a Day - L...
0:00 - Introduction to the lab
1:18 - Configure network and security for Synapse
1:52 - Modify the Data Flow to load data into Synapse
4:22 - Showing the resulting table in SQL DW (Synapse)
4:56 - Wrap up
You can find the whole one day workshop at github.com/davedoesdemos/Data... including all lab materials, data and instructions.
If you're new to data lakes please ask any questions you have below. Also please comment if you found this workshop series useful or if you'd like to see more of this kind of content.
For all of my other demos, go to davedoesdemos.com or go straight to the GitHub page at github.com/davedoesdemos/Demo.... Also please subscribe to the channel to make sure the latest demos show up in your playlist!

[@OneTwo-fj8us]

It would be useful if you went into a bit of detail around the Synapse setup - how it's configured including the databases etc. Have greatly enjoyed the series so far!

[@DaveDoesDemos]

Thanks for the comment. It's been on my list of things to do for a long time. This series was designed just to show how a modern data platform fits together so I kept the details light and as you can see the data flow was quite contrived to ensure it was easy to understand. While I still intend to go into more detail on Synapse I've found that in the real world setting up Synapse is quite easy and the challenges lie with things like governance so my videos have gone in that direction. You'd be surprised how many people can set up a database in Synapse but can't organise a data lake! Hopefully I'll get on to the details soon though, now that Synapse is released to the public :)

[@DaveDoesDemos]

I should probably add, there wasn't any extra setup here, I literally just created a blank database!

[@DaveDoesDemos]

This is the penultimate video of the series. If there is a subject you'd like covered let me know here in the comments!