CREATE CONNECTION

Creates a new connection between Upsolver and the specified service.

Supported connection options are listed below; check the relevant connection type to see all the connection options available when connecting to that service.

See also:

ALTER CONNECTION, DROP CONNECTION

Syntax

CREATE 
    --cloud storage
    { S3    
    --metastores
    | GLUE_CATALOG
    --streaming systems
    | KINESIS
    | KAFKA
    --databases
    | 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_]*;

Connection options

Cloud storage

• Amazon S3

Metastores

• AWS Glue Data Catalog

Streaming systems

• Amazon Kinesis

• Apache Kafka

Databases

• Amazon Redshift

• Elasticsearch

• Microsoft SQL Server

• MongoDB

• MySQL

• PostgreSQL

• Snowflake