How to access your Skio dataset in BigQuery

Some steps may require your Google Cloud administrator to grant additional permissions. The Skio team can't directly modify your Google Cloud permissions, but we're happy to provide guidance.

Learn how to set up the BigQuery integration here.

How to access your dataset in Bigquery

Step 1: Verify your account has permission to run queries

Before you can query your Skio data, your account needs permission to launch jobs in BigQuery.

1. Go to console.cloud.google.com/bigquery.

2. Confirm your organization's Google Cloud project is selected in the project dropdown at the top of the page.

   

3. Click SQL Query to open a new query tab.

4. Type SELECT 1; into the editor and click RUN.

If the query runs successfully, you're all set. Continue to Step 2.

If the RUN button is grayed out and you see a message like "You need permissions for this action. Required permission(s): bigquery.jobs.create," your account needs additional permissions. Ask your Google Cloud administrator to follow the instructions in How to grant BigQuery permissions (below).

Step 2: Access your Skio dataset

Once you have the proper permissions, you can connect to your Skio dataset.

1. Go to console.cloud.google.com/bigquery.

2. In the Explorer panel on the left, click + Add.

3. Select Star a project by name.

4. In the text box, enter largedata-380204 and click Star.

The largedata-380204 project will now appear in the Explorer panel. Click the arrow to expand the project, then expand your dataset (named after your Skio store) to view the available tables. Click on any table to view its schema.

Step 3: Run queries against your Skio data

You can now write and execute SQL queries against your Skio data. For example:

SELECT * FROM `largedata-380204.your_dataset_name.Subscription`;

Replace your_dataset_name with the actual name of your dataset (e.g., skio_dev_site).

Managing access and permissions

By default, Skio manages read access to your data. However, you can take control of access management:

• Manage user access directly from the dashboard: In the lefthand menu of your Skio Dashboard, go to API & Integrations > Integrations > BigQuery and add or remove dataset viewers directly.
  

  

• Grant access to service accounts: If you need to connect batch jobs or third-party integrations (like Snowflake), share the service account name with Skio. If you've set up a Google Group, you can add the service account directly to the group.

• Access data via GCP bucket: Skio can also provide your data as files in a Google Cloud Storage bucket. This can be useful for data pipelining or specific third-party integrations. Contact Skio to set this up.

How to grant BigQuery permissions (for administrators)

If a user needs permission to run queries in BigQuery, a Google Cloud administrator can follow these steps.

Unless the project is linked to a billing account, query volume will be limited by the BigQuery free tier.

Step 1: Navigate to IAM settings

1. Go to console.cloud.google.com/iam-admin/iam.

2. Locate the user account in the list of principals.

3. Click the pencil icon next to their name to edit permissions.

Step 2: Add the BigQuery Job User role

1. Click + Add Another Role.
   

2. Search for and select BigQuery Job User.

3. Click Save.