Database connection overview

Count can't do much without your database.

Creating a new connection

Workspace owners can create a database connection using the "Connect a database" button in the left hand menu 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:

Admin projects

When a connection has been created successfully, Count automatically generates a project called "Admin project" within the new connection. By default, this project has access to all tables within the connection. To manage table access for other users, we suggest you create a new project with access to a smaller number of tables.

Demo connection

Workspace owners and admins can connect their workspace to Count's demo connection.

This provides a fully working database connection and comes loaded with example notebooks, datasets and tutorials to help you learn more about how Count works.

The connection is built on a BigQuery instance so all SQL needs to be written in the BigQuery standard SQL syntax.

If you haven't connected a database yet, you can choose to connect to our demo database instead.

Hint: If you accidentally delete or corrupt the example notebooks from the demo connection, you can delete the connection completely and re-add a new demo connection to your workspace.

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.co 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.

Refreshing the database schema

If the tables available to Count through its database credentials change, then you will need to ask Count to fetch the latest schema to see those changes reflected in Count.

This can be done at the bottom of the connection's settings menu:

If your schema is very large, Count will not import or refresh the schema. Your notebooks will always work, but database table and column names will not appear in the notebook data bar or in autocompletions. To see schema information, either:

  • Use database credentials that have access to tables with fewer than 256,000 columns in total.

  • Begin your notebooks with queries like SELECT * from my_table limit 1, then the schema of my_table will appear under 'Cells' in the notebook data bar.

Deleting a connection

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

Deleting a database connection also permanently deletes all the projects and notebooks which sit beneath the connection.