Workspace owners can create a database connection using the "Connect a database" button in the left hand menu of the workspace home page.
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:
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.
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.
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:
All traffic between your database, count.co and any workspace users is fully encrypted using HTTPS and SSL/TLS.
We don't take a copy of your database or alter your tables.
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.
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:
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.