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.
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
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
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).
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?
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'"
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
Awesome. You made it so easy to understand. Thanks... please keep bringing in more useful information.
Thank you, I will
Deserves more likes and subscribes.
Thanks
Nice job explaining this Nirav.
Thanks
Hi Nirav, that's what I really want to learn... Great lesson and thanks for your knowledge transfer
Thanks
Thank you so much for this detailed explanation.
Good vid! Thanks mate!
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.
Thanks for sharing the knowledge.
My pleasure
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
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
Very good video. Thank you!
Thanks
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).
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?
No idea, Please upgrade to a higher service tier and check..
Good explanation
Keep watching
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'"
Password wrong?
Can you please share SQL Scripts for all your videos
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
What is the error? comment error code
Hi There, please can i get all the course script . Thanks