Links

Common SQL Syntax

Identifiers

Valid identifiers match the following format:
identifier = "([^"]|"")*"|[A-Za-z_][A-Za-z0-9_]*;

Column types

COLUMN_TYPE = { DATE
| TIMESTAMP
| BIGINT
| DOUBLE
| STRING
| BOOLEAN
| DECIMAL(precision, scale) }
To learn more about the various data types supported, see Data Types.

Trait representation

When there is a trait in the request (e.g. CONTENT_TYPE), it can be created in two ways:
If there are no additional properties, it can be used as an identifier:
CONTENT_TYPE = JSON
If there are properties, we create it as an object_options, and add an option type that represents the type of the trait:
CONTENT_TYPE = (
TYPE = CSV
INFER_TYPES = false
HEADER = 'h1,h2,h3'
)
Last modified 28d ago