Though all data is accessible via dashboards at https://camio.com/dashboard, you may also need the data to integrate with enterprise data warehouses. Camio offers an add-on service that creates a BigQuery dataset unique to your domain, along with permission to execute BigQuery jobs, so that you can automatically extract the data using standard SQL tools.

Please contact us to enable the domain dataset tables with the schema below.

Pre-requisites

Please send the email address of a Google Account you will use to authenticate your Power BI connector. That Google Account will be authorized by the Camio team with the permissions required to connect to BigQuery and synchronize data with Power BI:

bigquery.jobs.create
bigquery.readsessions.create
bigquery.readsessions.getData
bigquery.readsessions.update
resourcemanager.projects.get

Connecting to BigQuery

Please see https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-connect-bigquery

Tables

The dataset tables are prefixed with your domain (e.g. acme.com becomes the prefix acme_com for a table name of acme_com_impinging).

prefix_impinging
prefix_impinging_rates
prefix_impinging_user_camera_hour
prefix_mask
prefix_impinging_long_no_mask_day
prefix_impinging_long_no_mask_day_and_hour
prefix_mask_vs_no_mask_hour
prefix_mask_vs_no_mask_day

Schema

prefix_impinging

Field name	Type	Mode
user_id	STRING	NULLABLE
camera	STRING	NULLABLE
earliest_date	TIMESTAMP	NULLABLE
earliest_date_et	DATETIME	NULLABLE
earliest_date_ct	DATETIME	NULLABLE
earliest_date_pt	DATETIME	NULLABLE
hour	TIMESTAMP	NULLABLE
hour_et	DATETIME	NULLABLE
hour_ct	DATETIME	NULLABLE
hour_pt	DATETIME	NULLABLE
query_text	STRING	NULLABLE
labels	RECORD	NULLABLE
labels. label	STRING	NULLABLE
query_link	STRING	NULLABLE

prefix_impinging_rates

Field name	Type	Mode
user_id	STRING	NULLABLE
camera	STRING	NULLABLE
hour_et	DATETIME	NULLABLE
label	STRING	NULLABLE
total_category_count	INTEGER	NULLABLE
rate	FLOAT	NULLABLE

prefix_impinging_user_camera_hour

Field name	Type	Mode
user_id	STRING	NULLABLE
camera	STRING	NULLABLE
hour_et	DATETIME	NULLABLE
label	STRING	NULLABLE
total	INTEGER	NULLABLE

prefix_mask

Field name	Type	Mode
user_id	STRING	NULLABLE
camera	STRING	NULLABLE
earliest_date	TIMESTAMP	NULLABLE
earliest_date_et	DATETIME	NULLABLE
earliest_date_ct	DATETIME	NULLABLE
earliest_date_pt	DATETIME	NULLABLE
hour	TIMESTAMP	NULLABLE
hour_et	DATETIME	NULLABLE
hour_ct	DATETIME	NULLABLE
hour_pt	DATETIME	NULLABLE
labels	RECORD	NULLABLE
labels. label	STRING	NULLABLE
query_link	STRING	NULLABLE

prefix_impinging_long_no_mask_day

Field name	Type	Mode
user_id	STRING	NULLABLE
camera	STRING	NULLABLE
day	TIMESTAMP	NULLABLE
impinging_long_without_mask	INTEGER	NULLABLE

prefix_impinging_long_no_mask_day_and_hour

Field name	Type	Mode
user_id	STRING	NULLABLE
camera	STRING	NULLABLE
day	TIMESTAMP	NULLABLE
impinging_long_without_mask_day	INTEGER	NULLABLE
hour	TIMESTAMP	NULLABLE
impinging_long_without_mask_hour	INTEGER	NULLABLE

prefix_mask_vs_no_mask_hour

Field name	Type	Mode
user_id	STRING	NULLABLE
camera	STRING	NULLABLE
hour	TIMESTAMP	NULLABLE
mask	INTEGER	NULLABLE
no_mask	INTEGER	NULLABLE
mask_percentage	FLOAT	NULLABLE

prefix_mask_vs_no_mask_day

Field name	Type	Mode
user_id	STRING	NULLABLE
camera	STRING	NULLABLE
day	TIMESTAMP	NULLABLE
mask	INTEGER	NULLABLE
no_mask	INTEGER	NULLABLE
mask_percentage	FLOAT	NULLABLE

Automated data warehouse integration with BigQuery and Power BI