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 option type that represents the type of the trait:

CONTENT_TYPE = (
    TYPE = CSV
    INFER_TYPES = false
    HEADER = 'h1,h2,h3'
)