Connections are used to provide Upsolver with the appropriate credentials to ingest your data into SQLake as well as to write out your transformed data to various services.
A connection in Upsolver is persistent, which means that after it is created, you can reuse it any time you need to connect to your database. Furthermore, the connection can be used by other users in your SQLake organization.
To create a new connection, simply provide the required credentials and configure any optional connection properties relevant to your requirements.
Note that only some of the connection options can be edited after the connection has been created.

SQL connection commands

Supported connections

Cloud storage


Streaming systems