Azure SQL Database Elastic Queries

One of the features missing from Azure SQL database is the ability to create Linked Servers.
However there is something similar called Azure SQL Database Elastic Query
This allows you to run queries against another Azure SQL database or Data Warehouse.
This video demonstrate how to setup and use Elastic Queries

[@chetankathote8342]

Very Very Thank you Mr.David. Your video helped a lot !!

[@harshakrishnapyda7283]

Hi, Thanks for explaining it so well.

[@jackroark6928]

VERY useful! Thank you!

[@taranbirbajwasingh3124]

I am encountering below issue Failed to connect to the target database: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The target principal name is incorrect.) I am using private end point as I have disabled the public access to my sql server

[@uhimabindu]

Hi, Thanks for explaining it so well. Just one question please, Are Elastic Queries in preview or live?

[@amitjaju9060]

Hello Sir, I have a scenario where in particular folder we have 2 file with different format and 2 external table created to read those file. Now I got multiple files with same format and file name except timestamp is different for all so how can I read all those same file format file with same naming convention except timestamp is different for all using external table. I don't want to create new external table and with subfolder option . Can we read all same file format files with wild card. Please help me here

[@amitjaju9060]

Hello Sir, I am seeing all your videos and all are very knowledgeable. I have below query could you please help me with these. I have 1 external table conatins 10 columns which reads data from processing blob file .But external table unable to read the blob file because few rows has 9 fields and few have 10 and this is happening because last column if no data then no delimeter coming for that from Source .So how can we assign last filed as NULL if not present through external table. Thanks in advance

[@shamshadalam5998]

Great video, explained well. Can we extract data to azure database from azure data warehouse using type=Hadoop. Do we need to create external table with all the columns available in external table or we can create external table with only required columns. Would be a great help, kindly answer.

[@shauryasingh8751]

Hello, thanks for explaining it no efficiently. Just a question, I have an existing stored procedure which uses a table from another database. If we follow your steps and create external table to that particular table. Will my stored procedure run normally or do I have to make any changes?

[@DavidPostlethwaiteSQL]

You shouldn't have to make any changes

[@CoopmanGreg]

Great Video! Am I able to setup an Elastic Query from one database to another database on an entirely different serve or can I only run elastic query across databases located on the same server? Thank you.

[@CoopmanGreg]

Sorry, I re-watched the video and you explained my question perfectly and answered it as yes, you can query against dbs in different servers.

[@PeaceUrSoul]

Is it nessary to create external table for each table in source DB?

[@DavidPostlethwaiteSQL]

yes you will need to create an external table for every table you want to query

[@jonhucks8342]

So when a company ask for Azure experience what might they be looking for if I am already a SQL server developer? Do I technically have the skills to say I know Azure if Sql server offers Azure abilities now?

[@sarthaks]

This is really helpful, can you please share the tsql-code for this video

[@DavidPostlethwaiteSQL]

you can find the source code in my free eBook which you can download from www.gethynellis.com

[@sarthaks]

Thanks!

[@DavidzzHD]

Could I run an INSERT INTO currentdatabase.table SELECT * FROM external table?

[@TheEsisia]

I have the same question.

[@smritisinghal7287]

Yes

[@jz9859]

Is there way to move some data from one database to the External database?

[@DavidPostlethwaiteSQL]

The external database is read only. Not seen anything from Microsoft to say that has changed

[@sidesw1pe]

You're asking if it's possible to export data from a database?

[@itnaveen1]

I see only SELECT query . Can we perform INSERT /UPDATE /DELETE Query ?

[@DavidPostlethwaiteSQL]

Only SELECT queries are supported at the moment

[@dksmca1]

No