Automated data warehouse integration with BigQuery and Power BI

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.

Tables

The dataset tables are prefixed with your domain (e.g. acme_impinging if your domain were acme.com).

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

prefix_impinging_rates

prefix_impinging_long_no_mask_day

prefix_impinging_long_no_mask_day_and_hour

prefix_mask_vs_no_mask_hour

Have more questions? Submit a request

Comments