---
title: "How to access your Skio dataset in BigQuery"
slug: "how-to-access-your-dataset-in-bigquery"
updated: 2026-03-10T20:23:24Z
published: 2026-03-10T20:23:24Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://help.skio.com/llms.txt
> Use this file to discover all available pages before exploring further.

# How to access your Skio dataset in BigQuery

> [!WARNING]
> 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.

> [!NOTE]
> Learn how to set up the [BigQuery integration](/help/docs/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](https://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.

![](https://cdn.us.document360.io/a953bba6-c70d-43ce-bc77-d7f32a8fc514/Images/Documentation/CleanShot 2026-03-10 at 16.21.38.png)
3. Click **SQL Query** to open a new query tab.
4. Type `SELECT 1;` into the editor and click **RUN**.

![](https://cdn.us.document360.io/a953bba6-c70d-43ce-bc77-d7f32a8fc514/Images/Documentation/CleanShot 2026-01-20 at 13.48.06.png)

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

> [!NOTE]
> 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**](/help/docs/bigquery-integration#how-to-grant-bigquery-permissions-for-administrators) (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](https://console.cloud.google.com/bigquery).
2. In the **Explorer** panel on the left, click **+ Add data**. ![](https://cdn.us.document360.io/a953bba6-c70d-43ce-bc77-d7f32a8fc514/Images/Documentation/CleanShot 2026-03-10 at 16.15.46.png)
3. Click **Star a project by name**in the bottom left corner and enter `largedata-380204` into the text box.

![](https://cdn.us.document360.io/a953bba6-c70d-43ce-bc77-d7f32a8fc514/Images/Documentation/CleanShot 2026-03-10 at 16.10.08.png)

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.

![](https://cdn.us.document360.io/a953bba6-c70d-43ce-bc77-d7f32a8fc514/Images/Documentation/CleanShot 2026-01-20 at 13.49.57.png)

### Step 3: Run queries against your Skio data

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

```sql
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.

![](https://cdn.us.document360.io/a953bba6-c70d-43ce-bc77-d7f32a8fc514/Images/Documentation/CleanShot 2026-03-06 at 15.46.45(1).png)

Add and remove users, groups, or service accounts that should have read access to your BigQuery dataset directly from the Skio Dashboard.
- **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.

> [!WARNING]
> Unless the project is linked to a billing account, query volume will be limited by the [BigQuery free tier](https://cloud.google.com/bigquery/pricing#free-tier).

### Step 1: Navigate to IAM settings

1. Go to [console.cloud.google.com/iam-admin/iam](https://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.

![](https://cdn.us.document360.io/a953bba6-c70d-43ce-bc77-d7f32a8fc514/Images/Documentation/CleanShot 2026-01-20 at 13.52.41.png)

### Step 2: Add the BigQuery Job User role

1. Click **+ Add Another Role**.

![](https://cdn.us.document360.io/a953bba6-c70d-43ce-bc77-d7f32a8fc514/Images/Documentation/CleanShot 2026-01-20 at 13.53.03.png)
2. Search for and select **BigQuery Job User**.
3. Click **Save**.

![](https://cdn.us.document360.io/a953bba6-c70d-43ce-bc77-d7f32a8fc514/Images/Documentation/CleanShot 2026-01-20 at 13.53.25.png)

The user should now have the **BigQuery Job User** role listed in the permissions table.