The data collected in the reports is available through a SQL interface in our BigQuery environment. Each report block in Atticus is accompanied by a ‘ViewDefinition’ responsible for converting its content to a tabular format. This document describes how data managers can interface with these tabular data exports through an SQL interface. We are using BigQuery to securely export and isolate the data that belongs your organization.
<aside> ℹ️ The BigQuery environment runs on our private Google Cloud. There we make sure that data resides in data centers located on Belgian territory. This way we can maximally comply with regulations.
</aside>
<aside> ⚠️ Access to our Google Cloud environment is managed with a special kind of key 🔑 , called a service account key. You will need to store this key a JSON-file in a secure place. Please be careful when moving this file around your systems. They are the access key to access all data collected in Atticus.
</aside>
Best practices for managing service account keys | IAM Documentation | Google Cloud
Make sure you have a database client that is capable to connect with Google BigQuery. Example: DBeaver.
Make sure you have a service-account-key.json file which grants you access to our BigQuery endpoint. [👉 Send us a request if you don't have this file](mailto:[email protected]?subject=Request%20for%20full%20data%20access%20service%20account%20key&body=I'm%20...%20from%20organization%20...%20and%20need%20a%20service%20account%20key%20to%20access%20the%20data%20exports%20in%20BigQuery.%0A%0ABest%2C%0A%0A...)
Open your database client and configure a new database connection with the service-account-key.json file.
<aside>
ℹ️ When asked to specify a project, please specify tiroapp-4cb17
</aside>
Need help with your database client? [👉 Let’s setup a video call](mailto:[email protected]?subject=Setup%20access%20to%20BigQuery%20with%20our%20DB%20client&body=I'm%20...%20from%20organization%20...%20and%20would%20like%20a%20video%20call%20to%20setup%20our%20connection%20with%20BigQuery.%0A%0AWe%20are%20using%20...%20as%20a%20client.%0A%0ABest%2C%0A%0...)