How to Read Data From Azure Data Lake Storage Using Managed Instance with Data Virtualization!!

Published: 15 January 2024
on channel: Tales From The Field

800

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

Watch video How to Read Data From Azure Data Lake Storage Using Managed Instance with Data Virtualization!! online without registration, duration hours minute second in high quality. This video was added by user Tales From The Field 15 January 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 800 once and liked it 20 people.

2,126,826

32K

00:00:59