BigQuery: How to create a database ?

Create a new Catchr database:

On app.catchr.io, go to the Database menu and click "Add database".


Select a name (this is the name of the data base on Catchr).
Select your destination (only BigQuery is available now; if you need a new database destination, please ask us on the chat !)
Select your project ID as it is in the Google Cloud Platform:

Choose a dataset ID. It will be the name of the data set in BigQuery.

To find your Json key, you need to create a new service account. Follow this link and select a project on the page. Then, create a new service account:

Give it a name so you can easily find it (Catchr service account, for example). The ID will be generated after this name.
Enter a description if needed.
Click Create and continue


Then, we need to grant this account access to the project. To do so, give it the BigQuery Admin role:

There is no IAM condition to give.
Click Continue.

We then need to grant a user access to these services.
In both Service account user role and Service account admins role, enter the email you use on Catchr.

Create the service account.

Get your Json Key:
Identify your new service account; at the end of the row, click on the three dots and click on Manage Key.
Click Add Key on the new page, select JSON, and click Create.
Google will launch a file download on your computer. This file contains your JSON Key; open it with a simple text editor.
Please copy the entire key and paste it into Catchr to finish creating your database.

Here is a screenshot of my Database once created:


You can then create a new data stream to populate this database.

Updated on: 30/09/2024