19. Create and query external tables from a file in ADLS in Azure Synapse Analytics

In this video, I discussed about creating and querying external table from a file in Azure data lake in Azure Synapse Analytics

Link for Azure Synapse Analytics Playlist:

Link for Azure Databricks Play list:

Link for Azure Functions Play list:

Link for Azure Basics Play list:

Link for Azure Data factory Play list:

Link for Azure Data Factory Real time Scenarios

Link for Azure LogicApps playlist

#Azure #AzureSynapse #AzureSynapseAnalytics

[yohannesmulu]

Thank you for such nice explanation. FYI: creating external table is also available for CSV files. The feature might be not available at the time of this video recording.

[vydudraksharam]

Thank you sir, Last few seconds gave big relief. I am searching with .csv file to generate external query automatically.

[abhijithkadam]

Love the way you make concepts sound so simple. Waiting for a video on COLUMN STORE INDEX :(

[angedion]

Good explainations :) Do you provide private classes?

[TheDouglasDale]

Always excellent content. Thank you sir.

[dwarak]

The videos are awesome brother. Could you try to upload more real case scenarios ?

[satpk]

Thank you for a very informative video. Can we build external tables from ADLS2 file share also?

[nekowhite]

Hi, thank you for the information. I have a similar external table and I saved it in a store procedure but now, I need to make a data factory pipeline that runs this process. Is it possible?

[mehranwani]

sir i am not getting that option of create external table in the new SQL Script

[ADITYA-ifpz]

If we don't use synapse can we create external table with data lake and azure sql database?

[rushankpatil-uicb]

can external tables be created with json file?