Database connection overview

Get started by connecting your database or dbt to Countdbt

Creating a new connection

Workspace owners and admins can create a database connection using the Connect a database button in the sidebar of the workspace home page.

Supported databases

Count supports many of the most popular databases, and support for more is coming soon.

Information on how to connect to each database can be found on the following pages:

• Athena

• Azure Synapse

• BigQuery

• Databricks

• MySQL

• PostgreSQL

• Redshift

• Snowflake

• SQL Server

Demo connection

Workspace owners and admins can also add Count's demo connection. This connection is a BigQuery instance, so all SQL needs to be written in the BigQuery standard SQL syntax.

Connecting the demo database

How the connection works

Count is built with security in mind and we have a number of measures in place to protect your data and take care of your database's integrity:

1. All traffic between your database, Count and any workspace users is fully encrypted using HTTPS and SSL/TLS.

2. We don't take a copy of your database or alter your tables.

3. We make sure to protect your database from too much load by only running queries when necessary and limiting the number of results which get returned.

More information on our security procedures can be found in our Security overview.

Connection settings

Some settings are common across all database connections:

• Color - set a custom color for this connection. Cells referencing tables in this connection will have this color by default. The connection color can also be overridden per-canvas.

• Use DuckDB by default for visuals - with this setting enabled, new visuals created while this connection is selected will execute on the in-memory database in the canvas, rather than on this connection.

Deleting a connection

A database connection can be deleted at the bottom of the connection's settings menu.

Deleting a database connection will remove it from any projects that reference it. Any cells that rely on this connection will return errors, and will not return results until switched to a different connection.