Upsolver SQLake
Search…
⌃K

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.

Syntax

Jump to

Connection options

CONNECTION_STRING — editable

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.

MAX_CONCURRENT_CONNECTIONS — editable

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