Press "Enter" to skip to content

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

Information virtualization with Azure SQL Managed Instance
https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/data-virtualization-overview?view=azuresql&tabs=managed-identity

Phases
00:00 Introduction
01:27 Review the Documentation
02:11 Demo – The information 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 review the information
06:44 Demo – Create External File Format
08:13 Demo – Create External Table & Read the Data
10:59 Sound Off

Stories from the Field.
Twitter: https://twitter.com/TalesftField.
Linkedin: https://www.linkedin.com/company/100091910/.
Blusky: https://bsky.app/profile/talesfromthefield.bsky.social.

In this video clip Daniel Taylor, also known as @DBABulldog, and Bradley Sphere, also known as @SQLBalls, sign up with pressures to reveal you exactly how you can review countless documents realtime and simultaniously from your #AzureDataLake #AzureStorage making use of #AzureSQL #managedinstance!

Right here’s the video clip that utilized the #AzureSQL MI information in #MicrosoftFabric
Microsoft Fabric Copilot for Data Factory! ETL & Date Dimension with Plain Text!

Josh Luedeman.
Twitter: https://twitter.com/joshluedeman.
Linkedin: https://www.linkedin.com/in/joshluedeman/.
Blusky: https://bsky.app/profile/joshluedeman.bsky.social.

/ *******************.
/ CONNECT WITH United States!!
/ *******************.

Bradley Ball.
Twitter: https://twitter.com/SQLBalls.
Linkedin: https://www.linkedin.com/in/sqlballs/.
Blusky: https://bsky.app/profile/sqlballs.bsky.social.

Daniel Taylor.
Twitter: https://twitter.com/dbabulldog.
Linkedin: https://www.linkedin.com/in/danieltaylor3/.
Blusky: https://bsky.app/profile/dbabulldog.bsky.social.

AndrΓ©s Padilla.
Twitter: https://twitter.com/nodestreamio.
Linkedin: https://www.linkedin.com/in/andrespadillaandrade/.

Neeraj Jhaveri.
Twitter: https://twitter.com/neeraj_jhaveri.
Linkedin: https://www.linkedin.com/in/neerajjhaveri/.
Blusky: https://bsky.app/profile/neerajny.bsky.social.