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.
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".
- 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 RAW connects to a remote database, it adheres to the existing authorization rules and user privileges of that database. This means RAW'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, RAW maps its permissions locally within its environment. This ensures that user access in RAW is reflective of the original database’s security constraints.
- Dynamic Privileges Adjustment: As RAW 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.