Synapsesql pool

Question

Hello team,
I want to create the GetDate() in synapse sqlpool for one of the column in the table .

I am using this table in data factory pipeline dynamically. So i can't create select statement. So i need to display current date and time in the select statement for column3.So I need to mention in create table statement.
Please advise.

Create table Table1
(
column1 nvarchar NULL,
column2 [int] NULL,
CAST(GETDATE() AS datetime) AS column3
)
WITH ( DISTRIBUTION = ROUND_ROBIN, HEAP )

Answer 1

Hey @Rohit Kulkarni ,
Unfortunatley synapse doesnt allow functions as default constraints.

CREATE TABLE dbo.doc_exz (column_a INT, column_b varchar(50));  
GO  
INSERT INTO dbo.doc_exz (column_a) VALUES (7);  
GO  
ALTER TABLE dbo.doc_exz  
  ADD CONSTRAINT DF_Doc_Exz_Column_B  
  DEFAULT getdate() FOR column_b;  
GO  

The above code would work for Azure SQL database but not synapse.
you would get the below error:
An expression cannot be used with a default constraint. Specify only constants for a default constraint.

So ideally the best way would be to insert getdate() into rows while inserting data into synapse table