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

Поділитися
Вставка
  • Опубліковано 16 лип 2023
  • ----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
    );

КОМЕНТАРІ •