Azure SQL DW for Azure SQL DW using Polybase

Question

I know that you can use polybase, using an external table, to load a large amount of data from the Blob repository into Azure SQL DW. But is it likely that we can import data from SQL DW into another SQL DW using polybase directly? Or is there another way? There must be some way to avoid node control in SQL DW.

Answer 1

You might be better off using Azure Data Factory to move data between two Azure SQL Data Warehouses. This would make it easy to move data, but beware of any cost of moving data, especially when moving around a region. Start here . Check the "Use base" box.

If you just want to use Polybase and Blob Storage, you will have to:

• first export the data from the internal tables of the source system to the blob using CETAS .
• create external tables on files in the blob repository on the target system
• n The target system imports data from external tables into the database using CTAS . li>

Answer 2

, PolyBase Blob Storage Data Lake Store ( node)

Answer 3

You can create a new SQL DW from a geo-backup, which should be a full copy of SQL DW with a 24-hour SLA. First, click on create a new SQL DW and select the backup as an option, not a space or sample.