
types.default.sl.yml Maven / Gradle / Ivy
---
version: 1
types:
- name: "string"
primitiveType: "string"
pattern: ".+"
sample: "Hello World"
comment: "Any set of chars"
ddlMapping:
bigquery: STRING
snowflake: STRING
postgres: varchar(8000)
synapse: Varchar(8000) # https://docs.microsoft.com/fr-fr/azure/synapse-analytics/metadata/table
duckdb: VARCHAR
- name: "variant"
primitiveType: "variant"
pattern: ".+"
sample: "\"Hello World\""
comment: "Valid JSON object"
ddlMapping:
bigquery: STRING
snowflake: VARIANT
postgres: JSONB
synapse: NVARCHAR(MAX) # https://docs.microsoft.com/fr-fr/azure/synapse-analytics/metadata/table
duckdb: JSON
- name: "integer"
pattern: "[-|\\+|0-9][0-9]*"
primitiveType: "long"
sample: "1234"
comment: "Int number"
ddlMapping:
bigquery: INT64
snowflake: INT
synapse: int
postgres: INT
duckdb: INTEGER
- name: "int"
pattern: "[-|\\+|0-9][0-9]*"
primitiveType: "long"
sample: "1234"
comment: "Int number"
ddlMapping:
bigquery: INT64
snowflake: INT
synapse: int
postgres: INT
duckdb: INTEGER
- name: "byte"
primitiveType: "byte"
pattern: "."
sample: "x"
comment: "Any set of chars"
ddlMapping:
bigquery: INT64
snowflake: INT
synapse: smallint
postgres: INT
duckdb: TINYINT
- name: "double"
primitiveType: "double"
pattern: "[-+]?\\d*\\.?\\d+[Ee]?[-+]?\\d*"
sample: "-45.78"
comment: "Any floating value"
ddlMapping:
bigquery: FLOAT64
snowflake: DOUBLE
synapse: float
postgres: DOUBLE PRECISION
duckdb: DOUBLE
- name: "long"
primitiveType: "long"
pattern: "-?\\d+"
sample: "-64564"
comment: "any positive or negative number"
ddlMapping:
bigquery: INT64
snowflake: INTEGER
synapse: bigint
postgres: INT
duckdb: BIGINT
- name: "short"
primitiveType: "short"
pattern: "-?\\d+"
sample: "564"
comment: "any positive or negative number"
ddlMapping:
bigquery: INT64
snowflake: INTEGER
synapse: smallint
postgres: smallint
duckdb: SMALLINT
- name: "boolean"
primitiveType: "boolean"
pattern: "(?i)true|yes|[y1]|t<-TF->(?i)false|no|[n0]|f"
sample: "TruE"
ddlMapping:
bigquery: BOOL
snowflake: BOOLEAN
synapse: bit
postgres: BOOLEAN
duckdb: BOOLEAN
- name: "timestamp"
primitiveType: "timestamp"
pattern: "yyyy-MM-dd HH:mm:ss"
sample: "2019-12-31 23:59:02"
comment: "date/time in epoch millis"
ddlMapping:
bigquery: TIMESTAMP
snowflake: TIMESTAMP
synapse: datetime2
postgres: TIMESTAMP
duckdb: TIMESTAMPTZ
- name: "decimal"
primitiveType: "decimal"
pattern: "[-+]?\\d*\\.?\\d+[Ee]?[-+]?\\d*"
sample: "-45.787686786876"
comment: "Any floating value"
ddlMapping:
bigquery: NUMERIC
snowflake: DECIMAL
synapse: decimal
postgres: DECIMAL
duckdb: DECIMAL
- name: "date"
primitiveType: "date"
pattern: "yyyy-MM-dd"
sample: "2018-07-21"
comment: "Date in the format yyyy-MM-dd"
ddlMapping:
bigquery: DATE
snowflake: DATE
synapse: date
postgres: DATE
duckdb: DATE
- name: "basic_iso_date"
primitiveType: "timestamp"
pattern: "BASIC_ISO_DATE"
sample: "20111203"
comment: "Timestamp based on yyyMMdd pattern"
ddlMapping:
bigquery: TIMESTAMP
snowflake: TIMESTAMP
synapse: datetime2
postgres: TIMESTAMP
duckdb: TIMESTAMPTZ
- name: "iso_local_date"
primitiveType: "timestamp"
pattern: "ISO_LOCAL_DATE"
sample: "2011-12-03"
comment: "Timestamp based on yyyy-MM-dd pattern"
ddlMapping:
bigquery: TIMESTAMP
snowflake: TIMESTAMP
synapse: datetime2
postgres: TIMESTAMP
duckdb: TIMESTAMPTZ
- name: "iso_offset_date"
primitiveType: "timestamp"
pattern: "ISO_OFFSET_DATE"
sample: "2011-12-03+02:00"
comment: "Timestamp based on `ISO Date with offset` pattern"
ddlMapping:
bigquery: TIMESTAMP
snowflake: TIMESTAMP
synapse: datetime2
postgres: TIMESTAMP
duckdb: TIMESTAMPTZ
- name: "iso_date"
primitiveType: "timestamp"
pattern: "ISO_DATE"
sample: "2011-12-03+02:00"
comment: "Timestamp based on `ISO Date with or without offset` pattern"
ddlMapping:
bigquery: TIMESTAMP
snowflake: TIMESTAMP
synapse: datetime2
postgres: TIMESTAMP
duckdb: TIMESTAMPTZ
- name: "iso_local_date_time"
primitiveType: "timestamp"
pattern: "ISO_LOCAL_DATE_TIME"
sample: "2011-12-03T10:15:30"
comment: "Timestamp based on `ISO Local Date and Time` pattern"
ddlMapping:
bigquery: TIMESTAMP
snowflake: TIMESTAMP
synapse: datetime2
postgres: TIMESTAMP
duckdb: TIMESTAMPTZ
- name: "iso_offset_date_time"
primitiveType: "timestamp"
pattern: "ISO_OFFSET_DATE_TIME"
sample: "2011-12-03T10:15:30+01:00"
comment: "Timestamp based on `ISO Local Date and Time` pattern"
ddlMapping:
bigquery: TIMESTAMP
snowflake: TIMESTAMP
synapse: datetime2
postgres: TIMESTAMP
duckdb: TIMESTAMPTZ
- name: "iso_zoned_date_time"
primitiveType: "timestamp"
pattern: "ISO_ZONED_DATE_TIME"
sample: "2011-12-03T10:15:30+01:00[Europe/Paris]"
comment: "Timestamp based on `ISO Zoned Date Time` pattern"
ddlMapping:
bigquery: TIMESTAMP
snowflake: TIMESTAMP
synapse: datetime2
postgres: TIMESTAMP
duckdb: TIMESTAMPTZ
- name: "iso_date_time"
primitiveType: "timestamp"
pattern: "ISO_DATE_TIME"
sample: "2011-12-03T10:15:30+01:00[Europe/Paris]"
comment: "Timestamp based on `ISO Date and time with ZoneId` pattern"
ddlMapping:
bigquery: TIMESTAMP
snowflake: TIMESTAMP
synapse: datetime2
postgres: TIMESTAMP
duckdb: TIMESTAMPTZ
- name: "iso_ordinal_date"
primitiveType: "timestamp"
pattern: "ISO_ORDINAL_DATE"
sample: "2012-337"
comment: "Timestamp based on `year and day of year` pattern"
ddlMapping:
bigquery: TIMESTAMP
snowflake: TIMESTAMP
synapse: datetime2
postgres: TIMESTAMP
duckdb: TIMESTAMPTZ
- name: "iso_week_date"
primitiveType: "timestamp"
pattern: "ISO_WEEK_DATE"
sample: "2012-W48-6"
comment: "Timestamp based on `Year and Week` pattern"
ddlMapping:
bigquery: TIMESTAMP
snowflake: TIMESTAMP
synapse: datetime2
postgres: TIMESTAMP
duckdb: TIMESTAMPTZ
- name: "iso_instant"
primitiveType: "timestamp"
pattern: "ISO_INSTANT"
sample: "2011-12-03T10:15:30Z"
comment: "Timestamp based on `Date and Time of an Instant` pattern (UTC only)"
ddlMapping:
bigquery: TIMESTAMP
snowflake: TIMESTAMP
synapse: datetime2
postgres: TIMESTAMP
duckdb: TIMESTAMPTZ
- name: "rfc_1123_date_time"
primitiveType: "timestamp"
pattern: "RFC_1123_DATE_TIME"
sample: "Tue, 3 Jun 2008 11:05:30 GMT"
comment: "Timestamp based on `RFC 1123 / RFC 822` patterns"
ddlMapping:
bigquery: TIMESTAMP
snowflake: TIMESTAMP
synapse: datetime2
postgres: TIMESTAMP
duckdb: TIMESTAMPTZ
© 2015 - 2025 Weber Informatics LLC | Privacy Policy