Skip to main content

MySQL

MySQL is a supported data source for SQL queries.

How to Setup​

To connect to a MySQL data source you need to register a MySQL credential. This requires:

  • the name of the credential (which you can choose);
  • the hostname, port, username, password and database to connect to.

Table Mappings​

The tables available in the remote database are available to query using the name of the credential as the "schema name".

For instance, if you register a credential and call it "db01", then you can query a table in it using e.g. "SELECT * FROM db01.table".

Limitations​

  • MySQL versions 8.0+ are supported. Versions 5.xx are untested.
  • There is a known issue with processing MySQL enumerations. Currently these are not supported. Tables or views that use enumerations fail to be processed as well. In such cases, manual interventions are required in order to isolate the necessary tables and views without using enumerations.

Authorization and User Privileges​

  • Remote Schema Authorization: When the platform connects to a remote database, it adheres to the existing authorization rules and user privileges of that database. This means platform's access to data and schema elements is dictated by the permissions set in the remote database.
  • Local Schema Permissions Mapping: Once the remote schema is made available, the platform maps its permissions locally within its environment. This ensures that user access in the platform is reflective of the original database’s security constraints.
  • Dynamic Privileges Adjustment: As the platform synchronizes with the remote database, any changes in user privileges or authorization rules are dynamically updated locally. This feature maintains consistent security and access control, mirroring the remote database’s settings.