How to Read Data From Azure Data Lake Storage Using Managed Instance with Data Virtualization!!
In this video Daniel Taylor, aka @DBABulldog , and Bradley Ball, aka @SQLBalls , join forces to show you how you can read THOUSANDS of files realtime and simultaniously from your #AzureDataLake #AzureStorage using #AzureSQL #managedinstance !
Chapters
00:00 Introduction
01:27 Review the Documentation
02:11 Demo - The data in Azure Storage Explorer
03:00 Demo - Create the Master Key
04:18 Demo - Create a Database Scoped Credential
04:59 Demo - Create External Data Source
05:47 Demo - Use OPENROWSET to read the data
06:44 Demo - Create External File Format
08:13 Demo - Create External Table & Read the Data
10:59 Sound Off
Here's the video that used the #AzureSQL MI data in #MicrosoftFabric
Microsoft Fabric Copilot for Data Factory! ETL & Date Dimension with Plain Text!
• Microsoft Fabric Copilot for Data Fac...
Data virtualization with Azure SQL Managed Instance
https://learn.microsoft.com/en-us/azu...
/*******************
/CONNECT WITH US!!
/*******************
Tales from the Field
Twitter: / talesftfield
Linkedin: / 100091910
Blusky: https://bsky.app/profile/talesfromthe...
Bradley Ball
Twitter: / sqlballs
Linkedin: / sqlballs
Blusky : https://bsky.app/profile/sqlballs.bsk...
Daniel Taylor
Twitter: / dbabulldog
Linkedin: / danieltaylor3
Blusky: https://bsky.app/profile/dbabulldog.b...
Neeraj Jhaveri
Twitter: / neeraj_jhaveri
Linkedin: / neerajjhaveri
Blusky: https://bsky.app/profile/neerajny.bsk...
Josh Luedeman
Twitter: / joshluedeman
Linkedin: / joshluedeman
Blusky: https://bsky.app/profile/joshluedeman...
Andrés Padilla
Twitter: / nodestreamio
Linkedin: / andrespadillaandrade
Смотрите видео How to Read Data From Azure Data Lake Storage Using Managed Instance with Data Virtualization!! онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Tales From The Field 15 Январь 2024, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 800 раз и оно понравилось 20 людям.