Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.sourcemedium.com/docs/llms.txt

Use this file to discover all available pages before exploring further.

If you can’t run queries yet, use this page to request the exact access your internal Google Cloud admin should grant.

​
Minimum required roles

For a read-only analyst workflow, request:
  1. Project-level role
    • roles/bigquery.jobUser
  2. Dataset-level roles
    • roles/bigquery.dataViewer on sm_transformed_v2
    • roles/bigquery.dataViewer on sm_metadata
Optional:
  1. roles/bigquery.dataViewer on sm_experimental (if querying MTA/experimental tables)
  2. roles/bigquery.dataViewer on any custom tenant datasets you need
roles/bigquery.jobUser lets users create query jobs. roles/bigquery.dataViewer lets users read/query dataset data.

​
Copy/paste message to send your admin

Subject: BigQuery access request for SourceMedium analysis

Hi Admin Team,

Please grant BigQuery access for:
- Principal: <user-or-group-email>
- Project: <PROJECT_ID>

Required permissions:
1) Project-level role:
   - roles/bigquery.jobUser

2) Dataset-level roles:
   - roles/bigquery.dataViewer on <PROJECT_ID>.sm_transformed_v2
   - roles/bigquery.dataViewer on <PROJECT_ID>.sm_metadata

Optional (if needed for MTA/experimental analysis):
- roles/bigquery.dataViewer on <PROJECT_ID>.sm_experimental

Success criteria after grant:
- `bq query --use_legacy_sql=false --dry_run 'SELECT 1 AS ok'` succeeds
- `bq query --use_legacy_sql=false "SELECT 1 FROM \`<PROJECT_ID>.sm_transformed_v2.obt_orders\` LIMIT 1"` succeeds

Thanks.

​
How admins grant this access

  1. Project role (bigquery.jobUser):
    • Go to IAM for the project and grant the role to the user/group.
  2. Dataset roles (bigquery.dataViewer):
    • In BigQuery, open dataset sharing/permissions and grant role on each required dataset.

​
Official references

  1. BigQuery IAM roles:
  2. Dataset/table/view IAM in BigQuery:
  3. Project IAM role management:

SM BigQuery Analyst

Skill overview and install path.

BigQuery Essentials

First queries and SourceMedium table usage.