Reputation: 101
How to access Table from one Azure SQL DW from another Azure SQL DW?
I want to access table in another SQL DWH inside stored procedure in my current Azure SQL DWH. I searched online found only methods for SQL Database only. Please tell if anyone has figured out any workaround.
PS: Is it possible to sync tables in two DWH, i.e, every time there is an update in table in one DWH it copies into same table in another DWH.
Upvotes: 0
Views: 347
Answers (1)
Reputation: 3078
The current release of Azure Synapse does not support cross-database queries.
Your best option to move data between instances of Azure Synapse is to use Polybase to export and import the data. You can schedule this activity using Azure Data Factory or Azure Functions.
Keep your eye on our up-coming announcements, we'll support your requirement for cross-database queries in the near future.
Upvotes: 1
Related Questions
- insert on synapse DW in ssms
- cross database access in azure synapse sql pools
- Synapse Analytics - Can't see the tables list in the dedicated sql pool
- DML operations on Tables in Different databases of AzureSQL PaaS
- External table Azure Synapse does't returning data
- How to make a Azure SQL Exec or select another table/procedure in another Azure SQL
- How do I link two tables of the same name across two Azure SQL Server databases?
- How to Cross Database Queries in Azure SQL with Same Table name and structure on both database
- Connect to Master Database in Azure SQL DW
- Azure SQL get data from another non-Azure sql server using Linked Server