Polybase And Azure Data Studio

Rajendra Gupta continues his series on Polybase in SQL Server 2019 with a look at Polybase integration in Azure Data Studio:

We have learned earlier that PolyBase in SQL Server 2019 Preview allows access to various data sources such as SQL Server, Oracle, MongoDB, Teradata, and ODBC based sources etc. Azure Data Studio SQL Server 2019 preview extension currently supports for SQL Server and Oracle data sources only from the External table wizard.

In this series, we will create an external table for SQL Server and explore some more features around it.

Launch Azure Data Studio and connect to the SQL Server 2019 preview instance. Right click on the database and launch ‘Create External Table’.

Rajendra also looks at some of the Polybase DMVs and the notion of predicate pushdown, which is critical to understand for writing Polybase queries which perform well.

Related Posts

Azure Data Studio November Release

Alan Yu announces this month’s Azure Data Studio update: In November’s version of the monthly release blog, the emphasis was on fixing customer issues and adding and improving existing extensions. This includes: Updates to the SQL Server 2019 Preview extension Introducing the Paste the Plan extension Introducing the High Color Queries extension Improved Logging support […]

Read More

Using Polybase External Tables To Connect To Oracle

Rajendra Gupta continues his Polybase series: In part 2 of the series, we saw that the external table could be accessed similarly to a relational database table. One more advantage is that we can join them with any relational tables. Let us see how we can join the external table with the relational DB tables. I have […]

Read More

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Categories

November 2018
MTWTFSS
« Oct  
 1234
567891011
12131415161718
19202122232425
2627282930