How to create external table for external source azure sql database table

Опубликовано: 26 Октябрь 2024
на канале: @SKRT_t

2,883

----connecting to the external source sql database

use sai

CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'password123';

-----run it
CREATE DATABASE SCOPED CREDENTIAL sqls
WITH IDENTITY = 'kumar', SECRET = '12345';

--------------run it

CREATE EXTERNAL DATA SOURCE sqld
WITH ( LOCATION

= 'sqlserver://sai.database.windows.net' ----sai.database.windows.net = servername

CREDENTIAL = sqls );

----- run it
CREATE EXTERNAL TABLE em(
Id int,
name [varchar](255) NULL,
salary int,
df int,
ddf decimal
) WITH (
LOCATION='sai.dbo.sai'--database.schema.tablename
DATA_SOURCE=sqld
);