DEFAULT COLLATE

Create table option

Description

Collation determines how strings are sorted and compared in collation-supported operations. For more information, please refer to collation specification.

Default collate is supported by Snowflake using the DEFAULT_DDL_COLLATION clause instead.

Sample Source

BigQuery (Input Code)

CREATE TABLE table1 (
    col1 STRING 
) 
DEFAULT COLLATE 'und:ci';

Snowflake (Output Code)

CREATE TABLE table1 (
    col1 STRING
)
DEFAULT_DDL_COLLATION='und-ci';