Connect to MySQL (Private Beta)
Sigma supports connections to the MySQL database, for release 8.0 or higher.
This feature is currently in Private Beta. Beta features are subject to quick, iterative changes. As a result, this document may not reflect the most current version.
- Request access to this feature through your Account Representative.
- Request access to this feature through our Sales team.
- Admin privileges in your Sigma organization.
For more information, see User account types.
- A MySQL account with READ privileges for the relevant databases and tables.
If planning to upload CSV data, the account must have WRITE privileges.
- Sigma supports MySQL version 8.0 and higher.
When connecting from Sigma to a MySQL data store, Sigma does not support the following features and interactions:
- Dataset warehouse views
- Connecting to the warehouse through OAuth
- Input tables
- Following functions: ArrayAgg, Corr, CumulativeCorr, MovingCorr, Median, PercentileCont, and PercentileDisc
Create a connection
Follow these basic steps to create a connection:
- Click the user icon at the top right of your screen.
The user icon is usually composed of your initials.
- In the drop-down menu, select Add connection.
- The Add new connections page appears.
- In the Connection details, specify these:
- Specify the Name of the new connection. Sigma displays this name in the connection list.
- Here, we use MySQL connection.
- Select the tile that represents the data warehouse you use.
- Here, click the MySQL tile.
- In the Connection Credentials section, specify the following:
- The path to your database. This can be a URL, or an IP address.
- The port that Sigma uses to connect to the host.
- The default port for MySQL is
- The username, or account, for connecting to the MySQL data warehouse.
- For example,
- Enter the password that corresponds to the User on the MySQL account.
- The name of the database you plan to query.
- Enable TLS
- This switch enables or disables TLS encryption on your connection.
- Enabled by default.
- SSH Tunnel
- This switch enables the SSH protocol for secure remote login. For details, see Connect through SSH.
- Disabled by default.
- In the Connection Features section, specify the following:
- Connection timeout
- The time before timeout (or cancellation), in seconds, that Sigma waits for the query to return results.
- Default is 120, or 2 minutes.
- Connection queue size
- The number of concurrent interactive queues that Sigma establishes for the connection.
- Default is 8.
- Use friendly names
- This switch makes column names from the data source more readable.
- For example, a database column ORDER_NUMBER appears as Order Number.
- On by default.
- In the Write Access section, decide if you require write access.
See Set up write access.
- Enable write access
- Necessary for one of the following features:
- Off by default.
- After you specify all the parameters of the connection, click Create.
- After you successfully create your connection, Sigma displays it on the screen.
- To verify your connection, click Browse Connection, and then explore the visible databases and tables.
- Click Add Permission to grant data access for users in your organization.
See Data permissions.
- The new connection also appears in the list of connections you have in your account.