Skip to content
FastBI Docs Docs
Pricing examples Open app

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”
  1. Open Connections, select Add connection, then PostgreSQL, MySQL, or Amazon Redshift.
  2. In Access configuration, enter a connection string or the host, port, username, and password. Set Require TLS / SSL to match your database requirements, then select Continue.
  3. In Connector choices, confirm the database. A complete connection string can already specify it. Select Continue.
  4. In Name your connection, enter Display name and select Save & test. FastBI tests the complete configuration before saving and queuing catalog synchronization.
  5. Confirm the expected tables in Catalog and run a small query.
PostgreSQL access configuration with host, port, user, password, TLS, and IP whitelisting controls
Configure database access first. Choose the database and connection name in the next steps.

PostgreSQL and MySQL also offer My Database requires IP Whitelisting. Enable it and follow the network guidance if your database uses an IP allowlist. 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.