MS SQL Server - Azure DWH

Card Puncher Data Processing

Not supported

Data type that cannot participate in a columnstore index:

  • xml
  • binary
  • varbinary

Constraint:

  • No Primary and foreign Key. Seeprimary-and-foreign-key-constraints
  • Enforced unique constraints are not supported. To create an unenforced unique constraint you must include the NOT ENFORCED syntax as part of your statement.
  • Clustered primary key constraints are not supported in Azure SQL Data Warehouse. Explicitly create an unenforced NONCLUSTERED primary key constraint instead.

Upload

Bulk insert is now MS SQL Server - bulk copy program utility (bcp)

Doc: bcp

Syntax

Root documentation

Primary Key

Actually, you can't define a primary key in a create table or alter table column statement (for now 20180219, you can only define a default constraint). You still can define a primary key if you add a column.

ALTER TABLE dbo.DimAccount 
   add columnNamePK int 
   CONSTRAINT PK_DimAccount PRIMARY KEY NONCLUSTERED NOT ENFORCED;
  • Delete
ALTER TABLE dbo.DimAccount drop constraint PK_DimAccount;
ALTER TABLE dbo.DimAccount drop column columnNamePK;

Documentation / Reference





Discover More
Card Puncher Data Processing
MS SQL Server - bulk copy program utility (bcp)

bcp is a command-line bulk load utility that allows you to copy data between SQL Server, data files, and SQL Data Warehouse ASCII Microsoft...



Share this page:
Follow us:
Task Runner