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:
• 1. Introduction to Azu...
Link for Azure Databricks Play list:
• 1. Introduction to Az...
Link for Azure Functions Play list:
• 1. Introduction to Azu...
Link for Azure Basics Play list:
• 1. What is Azure and C...
Link for Azure Data factory Play list:
• 1. Introduction to Azu...
Link for Azure Data Factory Real time Scenarios
• 1. Handle Error Rows i...
Link for Azure LogicApps playlist
• 1. Introduction to Azu...
#Azure #AzureSynapse #AzureSynapseAnalytics

[@yohannesmulu1]

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.

[@WafaStudies]

Thank you for sharing this

[@dataengineerazure2983]

@@WafaStudies Thanks ! What is the difference between creating the external table from ADLGen 2 and Section 13, Section 14? Thanks

[@dannya.5812]

The "Create external table" option doesn't appear when I right click on a csv file currently. I only see the "Bulk Load" option. Is there a way for me to enable the external table feature?

[@vydudraksharam5960]

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

[@WafaStudies]

Thank you 😊

[@abhijithkadam383]

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

[@WafaStudies]

Thank you 😊. Will do soon

[@dwarak8927]

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

[@WafaStudies]

This playlist is to cover all Synapse concepts step by step like a book. I will plan another playlist parallelly to create videos on Synapse real time scenarios too very soon. Thank you.

[@TheDouglasDale]

Always excellent content. Thank you sir.

[@SivaIT88]

Thank you for such nice explanation.

[@angedion3718]

Good explainations :) Do you provide private classes?

[@satpk]

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

[@WafaStudies]

Yes u can

[@anthony281190]

Excelent Channel.

[@WafaStudies]

Thank you 😊

[@anthony281190]

How can i send a csv to a specific root of data lake if the process fail?

[@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?

[@deepak0417]

Superb bro, great going

[@WafaStudies]

Thank you :-)

[@anthony281190]

Terrific video!!!!

[@WafaStudies]

Thank you 😊

[@mehranwani2722]

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

[@ADITYA-if5pz]

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

[@rushankpatil-ui3cb]

can external tables be created with json file?

[@sachinv9923]

Thanks

[@WafaStudies]

Thank you 😊

[@papachoudhary5482]

Thanks Sir

[@WafaStudies]

Welcome 🤗