BigQuery Integration

What is the BigQuery integration?

What kind of data is included?

All data available through code.skio.com is included in this integration, delivered as raw tables within your BigQuery warehouse. This includes subscription records, customer data, order history, and related metrics.

How to set up the BigQuery integration

To enable the BigQuery integration, reach out to your Merchant Success Manager or email success@skio.com. Skio will create and share a dataset with a user you control in your Google Cloud project.

Before we can share a dataset with you, you’ll need:

1. A BigQuery account

2. Email(s) of team members that should have access

3. Your service email (you can find this under IAM & Admin > Service Accounts in your Google Cloud Console)

Once the integration is set up, follow the steps below to access your data.

How to access your Skio data 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.

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:

• Delegate access control: Provide Skio with a Google Group you control. You can then add or remove members from the group without contacting Skio.

• 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.

FAQ