Skip to main content

​
What are Connectors?

Connectors are secure connections to your data sources. Once connected, you can:
  • Query your data with SQL
  • Use Genie to ask questions
  • Build automated pipelines
  • Create and save datasets

​
Supported Data Sources

PostgreSQL

Most popular choice

MySQL

Full support

BigQuery

Google Cloud

Snowflake

Data warehouse

Redshift

AWS analytics

SQLite

Local files

​
Creating a Connector

1

Go to Connectors

Click Connectors in the sidebar, then click + New Connector
2

Choose Your Database Type

Select PostgreSQL, MySQL, BigQuery, or another supported type
3

Enter Connection Details

Fill in your database credentials: - Host: Your database server address
  • Port: Usually 5432 (PostgreSQL) or 3306 (MySQL) - Database: The database name - Username: Your database user - Password: Your database password
4

Test Connection

Click Test Connection to verify it works
5

Save

Give your connector a name and click Save

​
Connection Security

Your credentials are encrypted at rest and in transit. We never store your data—only the connection details needed to query it.

​
Best Practices

  • Use read-only users when possible
  • Whitelist our IPs if your database requires it
  • Rotate credentials periodically

​
Managing Connectors

​
Edit a Connector

  1. Go to Connectors
  2. Click on the connector you want to edit
  3. Update the details
  4. Click Save

​
Delete a Connector

  1. Go to Connectors
  2. Click the three-dot menu on the connector
  3. Select Delete
  4. Confirm deletion
Deleting a connector will break any tasks or pipelines that use it.

​
Troubleshooting