Learn more about the BigQuery Integration here.
Step 1: Navigate to the BigQuery integration
In the left-hand menu of your Skio Dashboard, go to API & Integrations > Integrations > BigQuery at the bottom of the page. Click Enable.
Step 2: Choose a dataset name
Enter a name for your BigQuery dataset. A few rules to keep in mind:
Your dataset name will be automatically prefixed with
skio_(e.g.,skio_yourstore)Use only lowercase letters, numbers, and underscores
Keep it to 32 characters or fewer (not including the
skio_prefix)Dataset names are permanent once created and cannot be changed
The form validates your name in real time and checks that it's unique before letting you proceed.
Step 3: Enable GCS export (optional)
Toggle on Enable GCS export if you want Skio to also export your dataset tables as compressed CSV files to a Google Cloud Storage bucket. The bucket will be named {your_dataset_name}_export.
You can turn this on or off at any time after setup.
Step 4: Enable the integration
Click Enable BigQuery. Your dataset is created instantly.
Managing users
Once enabled, you can add or remove dataset viewers directly in the integration.
Add and remove users, groups, or service accounts that should have read access to your BigQuery dataset directly from the Skio Dashboard.
Follow the steps in our guide here to access your Skio dataset in BigQuery.