Friday , December 6 2024

What Is PolyBase In SQL Server

In today’s article, we will be talking about What is Polybase? and how we can extract data from SQL to SQL with Polybase.

Polybase is one of the auxiliary tools that SQL Server offers us.

Thanks to this, we can join our tables from different sources into a single database and make queries.

Some of these sources include MSSQL, Postgresql, MYSQL, Hadoop, Azure blog storage, etc.

In order to use Polybase, we need to select the fields related to Polybase during the installation.

After selecting this, you can perform the installations.

SQL201901 – Instance where data will be collected

SQL201902 – Instance where data will be retrieved

First, we enable it via sp_configure. (SQL201901)

After enabling, we create a database in the instance where our data will be collected.

Continue with the polybase configurations by coming back to the SQL201901 server.

We create our credential for the connection.

We create a data source and fill in the access information.

We have created the Credential and Data Source and our connections are complete. We are creating an external table appropriate for the table we want to retrieve data from.

As seen below, our table was created under the external table heading in the database.

We can use the familiar select statement to query data.

Loading

About Faruk Erdem

Leave a Reply

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