Upsolver SQLake

MySQL connection with SQL

To write your transformed data into a MySQL table using SQLake, you must first create a connection that provides the proper credentials to access your database.


Jump to

Connection options


Type: text
The connection string to use when connecting to the DB. This string can be copied directly from MySQL. The connection string should include the database itself at the end of the string.

USER_NAME — editable

Type: text
The user to authenticate to the DB with.

PASSWORD — editable

Type: text
The password to use.


Type: integer
(Optional) The maximum number of concurrent connections to the DB.
Limiting this may reduce load on the DB but could result in larger latencies in data.

COMMENT — editable

Type: text
(Optional) A description or comment regarding this connection.

Minimum example

Full example