Azure SQL Database Elastic Queries OR External Table | 🔥 Free Azure SQL DBA Training 🔥

The elastic query feature enables you to run a Transact-SQL query that spans multiple databases in Azure SQL Database. It allows you to perform cross-database queries to access remote tables to query across data tiers with multiple databases. Using this feature, you can scale out queries to large data tiers and visualize the results in business intelligence (BI) reports.

#Elastic Queries #External Table #AzureSQL

[athara]

Awesome. You made it so easy to understand. Thanks... please keep bringing in more useful information.

[kishoreevani]

Thank you so much for this detailed explanation.

[MrZoomok]

Hi Nirav, that's what I really want to learn... Great lesson and thanks for your knowledge transfer

[pawanharne]

Hi Nirav, great explanation Thanks!
Can you create external table in Azure SQL DB with MongoDb
getting issue from 2 days

External data sources are not supported with type GENERIC.

[juturvenkat]

If possible pls share azure transcripts in every link description that would be great to us to learn and for practice thank you for such detailed explanation nirav ji

[srimadhuvamsibannuru]

Hi Sir, Can we create an external table with the location as adls gen 2 where the tables are present inside adls gen 2, can you please help me with, when I am trying the data source it is working fine but when I am creating the file format it is failing as we know there is no polybase in azure sql db, can you please help me if there is any other way, Thanks

[rajvel]

Hi Thank you for this, i need one help which is while inserting data into DB1 data from DB2 having extra column like 'Email' then it need to be create automatically in DB1 (difficult is lot of columns need to be create when not presented in DB1 column) so how will you compare .and please let me know how will i connect for this query (email or whatsapp).

[furaham]

Thank you for the excellent explanation; it's perfectly understandable. After setting up the external tables, I created my initial view involving three inner joins. Retrieving 1000 rows took 4 minutes. However, subsequent query firings didn't yield any results; they kept trying until I canceled them. Any thoughts?

[syedhussaini]

Can you please share SQL Scripts for all your videos

[legal]

Hi There, please can i get all the course script . Thanks

[nohoesnik]

I get the following error when selecting the external table: "An error occurred while establishing connection to remote data source: Login failed for user 'sqladmin'"

[sanjayschopra]

Hi, after implementing all the steps and while selecting data from external table I am getting an error occured while establishing connection to remote data source; please help me on this