Shruti Goyal on 30 Aug 2023 13:24:13
It is easier to create a table using the CREATE TABLE template from the SSMS wizard.
The CREATE TABLE definition generated by the wizard is not compatible with Fabric and has to be modified.
CREATE TABLE [aw].[DimDate](
[Date] [date] NOT NULL,
[Day] [int] NOT NULL,
[DayOfYear] [int] NOT NULL,
[WeekOfMonth] [int] NULL,
[WeekOfYear] [int] NOT NULL,
[Year] [int] NOT NULL,
[RowChecksum] [int] NULL,
CONSTRAINT [PK_DimDate] PRIMARY KEY NONCLUSTERED
(
[Date] ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO