Syntax

CREATE 
    --cloud storage
    { S3    
    --metastores
    | GLUE_CATALOG
    | HIVE_METASTORE
    | ICEBERG_REST_CATALOG
    --streaming systems
    | CONFLUENT
    | KAFKA
    | KINESIS 
    --databases
    | CLICKHOUSE
    | ELASTICSEARCH
    | REDSHIFT
    | MONGODB
    | MSSQL
    | MYSQL
    | POSTGRES
    | SNOWFLAKE }
    CONNECTION 
        <connection_identifier> 
        [{ connection_options }];

CREATE CONNECTION

Creates a new connection between Upsolver and the specified service.

Syntax

CREATE 
    --cloud storage
    { S3    
    --metastores
    | GLUE_CATALOG
    | HIVE_METASTORE
    | ICEBERG_REST_CATALOG
    --streaming systems
    | CONFLUENT
    | KAFKA
    | KINESIS 
    --databases
    | CLICKHOUSE
    | ELASTICSEARCH
    | REDSHIFT
    | MONGODB
    | MSSQL
    | MYSQL
    | POSTGRES
    | SNOWFLAKE }
    CONNECTION 
        <connection_identifier> 
        [{ connection_options }];

Connection identifier

Valid identifiers match the following format:

identifier = "([^"]|"")*"|[A-Za-z_][A-Za-z0-9_]*;

CREATE CONNECTION

Syntax

Connection identifier

Connection options

Cloud storage

Metastores

Streaming systems

Databases

CREATE CONNECTION

Syntax

Connection identifier

Connection options

Cloud storage

Metastores

Streaming systems

Databases