Default DATE Snowflake: invalid identifier 'DATE'

Question

Hello I've an error on default value in Snowflake by using this code.

CREATE OR REPLACE TABLE XXX.YYYY (
 ID NUMBER(8) NOT NULL,
 DERN TIMESTAMP(0) ,
 OBSDATE TIMESTAMP(0)  NOT NULL,
 DATFULL DATE DEFAULT DATE);

I got this error: Unexpected error running Liquibase: SQL compilation error: error line 5 at position 25 invalid identifier 'DATE' [Failed SQL: (904)? Why this error does Snowflake use DATE? Thanks

Answer 1

I assume you want to use CURRENT_DATE as default value?

Then this is the code:

CREATE OR REPLACE TABLE XXX.YYYY (
 ID NUMBER(8) NOT NULL,
 DERN TIMESTAMP(0) ,
 OBSDATE TIMESTAMP(0)  NOT NULL,
 DATFULL DATE DEFAULT CURRENT_DATE);