Connect your data
Connect your database or data warehouse to Buster.
Getting started
You can manage all of your data sources from the “Data sources” tab. To connect a new database or warehouse, click the “New data source” button.
You can connect your database to Buster via a ready-only user. The following integrations are currently supported:
Postgres, MySQL, BigQuery, Snowflake, Redshift, SQL Server, Databricks, Supabase
By default, Buster does not store your data.
1. Create a read-only user
Buster accesses your database through a read-only user. This user needs access to the following:
- All tables and columns that would be used in answering user questions.
- Access to schema information such as schemas, tables, and columns.
- Access to all intermediate tables or columns that would be used to join across tables.
Enabling access to these tables and columns does not mean that end-users will be able to query them. See schema selection to understand how you can manage access controls across your tables and columns.
2. Allowlist our IP addresses
If you would like to allowlist our IP addresses, they are: 44.219.39.124 34.230.173.35 100.26.25.127
3. Select your tenancy
Select your database tenancy from one of the following options:
Multi-tenant
Multi-tenant
Multi-tenant architectures have all customers in the same database. Records are separated on a row-by-row basis, typically by some sort of customer id. If your SQL queries between customers look like the example below, you likely have a multi-tenant architecture.
Below is a diagram of a multi-tenant architecture.
Single-tenant
Single-tenant
Single-tenant architectures have customer data broken out into different logical or physical locations. If your SQL queries between customers look like the example below, you likely have a single-tenant architecture.
Below is a diagram of a single-tenant architecture.
4. Select your environment
For any testing, development, or staging datasources, we recommend using the development environment. This introduces an extra layer of security and prevents access to production environments during development.
5. Input your database credentials
Depending on your data source, your credentials will look slightly different:
Postgres
Postgres
Host: This is where your database is active. (Example: rds.amazonaws.com)
Port: The port your database uses. (Example: 5432)
Database Name: The name of the database you are connecting to. (Example: postgres)
Username: The username of the read-only user you created. (Example: buster)
Password: The password that you assigned to the read-only user at creation. (Example: supersecure!)
Schemas: The schema(s) you would like to connect to Buster.
If your customers are separated by schema, do not connect all schemas. Only connect the schemas necessary to answer a single customer’s questions.
SSH Config: If you require a connection through a bastion or jump host, reach out to us: [email protected]
MySQL
MySQL
Host: This is where your database is active. (Example: rds.amazonaws.com)
Port: The port your database uses. (Example: 3306)
Username: The username of the read-only user you created. (Example: buster)
Password: The password that you assigned to the read-only user at creation. (Example: supersecure!)
If your customers are separated by schema, do not connect all schemas. Only connect the schemas necessary to answer a SINGLE customers questions.
Database Name(s): The name of the database(s) you are connecting to. (Example: ecommerce_db)
If you’re customers are separated by database, do not connect all databases. Only connect the databases necessary to answer a SINGLE customers questions.
SSH Config: If you require a connection through a bastion or jump host, reach out to us: [email protected]
SQL Server
SQL Server
Host: This is where your database is active. (Example: rds.amazonaws.com)
Port: The port your database uses. (Example: 3306)
Username: The username of the read-only user you created. (Example: buster)
Password: The password that you assigned to the read-only user at creation. (Example: supersecure!)
If your customers are separated by schema, do not connect all schemas. Only connect the schemas necessary to answer a single customer’s questions.
Database Name(s): The name of the database(s) you are connecting to. (Example: ecommerce_db)
If you’re customers are separated by database, do not connect all databases. Only connect the databases necessary to answer a single customer’s questions.
SSH Config: If you require a connection through a bastion or jump host, reach out to us: [email protected]
BigQuery
BigQuery
Json Credentials: This is the file that was given when you created the service account.
This user must have the bigquery.jobs.create role and have access to the schema information for the project you’re connecting.
Project ID: This is the identifier for the project you are connecting to. (Example: buster_project)
Dataset ID (Optional): By default, Buster will pull in all datasets in a project. However, if you want to limit Buster to a specific dataset within a project, you would do that here.
If your customers are separated by dataset, do not connect all datasets. Only connect the dataset necessary to answer a single customer’s questions.
Restrict Tables (Optional): By default, Buster will pull in all tables in a project. However, if you want to limit Buster to specific tables within a project and dataset, you would do that here.
Databricks
Databricks
Host: This is where your data warehouse is active. (Example: cloud.databricks.com)
API Key: This is an API Key with read-only access to your cluster.
Warehouse ID: The identifier of the warehouse you are connecting to.
Catalog: The name of the catalog that you are connecting to
Redshift
Redshift
Reach out to us for help with Redshift connections: [email protected]
Snowflake
Snowflake
Reach out to us for help with Snowflake connections: [email protected]
If you need assistance connecting to Buster via SSH, reach out to us: [email protected]