CODEWITHSUNDEEP
azure-sql-databasedata-warehouse
Sam
Sam

Reputation: 323

SQL Azure database : Query SQL server Azure data warehouse data

Is there any option to query the Azure SQL Data warehouse (Cloud) from the Azure SQL Server database (Cloud)? We have a central warehouse hosted in cloud with all the domains needed for the Application. It would be great if we can use those tables as external tables using the approach described at https://azure.microsoft.com/en-us/blog/querying-remote-databases-in-azure-sql-db.

Upvotes: 0

Views: 422

Answers (2)

R Kelly
R Kelly

Reputation: 45

You can access Azure SQL Data Warehouse from Azure SQL using external tables Here's the article: https://learn.microsoft.com/en-us/sql/t-sql/statements/create-external-table-transact-sql

Example:

CREATE MASTER KEY
CREATE DATABASE SCOPED CREDENTIAL dwcredential WITH IDENTITY = '<username>', 
SECRET = '<password>';

CREATE EXTERNAL DATA SOURCE sqldw WITH
(
    TYPE = RDBMS,
    LOCATION = N'<dwserver>.database.windows.net',
    DATABASE_NAME = N'<dwdatabasename>',
    CREDENTIAL = dwcredential
)
GO

CREATE EXTERNAL TABLE [<azuresqltablename>]( 
    [col1] [int] NOT NULL,
    [col2] [int] NOT NULL
)    
WITH
(
    DATA_SOURCE = sqldw,
    SCHEMA_NAME = 'dbo', --schema name of remote table
    OBJECT_NAME = '<dwtablename>' --table name of remote table
);

Upvotes: 1

Josh G
Josh G

Reputation: 61

Querying Data Warehouse from SQL DB is currently unsupported.

Upvotes: 3

Related Questions