PostgreSQL, MySQL, and Redshift
Prepare access
Section titled “Prepare access”Use a database account with access to the schemas and tables you want to analyze. Prefer a dedicated read-only account. Have the host, port, database, username, password, and SSL requirements ready.
Connect
Section titled “Connect”- Open Connections and select PostgreSQL, MySQL, or Amazon Redshift.
- Enter the connection string or the individual connection fields.
- Configure SSL to match your database requirements.
- Save and wait for catalog synchronization.
- Confirm the expected tables in Catalog and run a small query.
PostgreSQL and MySQL also offer a static-IP connection option. Use the connection UI’s network guidance if your database requires an supported list. The same option is not offered for Redshift.
Troubleshoot
Section titled “Troubleshoot”- Timeout: check the host, port, firewall, and network reachability.
- Authentication error: check the database user, password, and selected database.
- Missing tables: check schema and table privileges, then synchronize again.
- SSL error: confirm the database’s SSL requirements with its administrator.