Skip to content
  • There are no suggestions because the search field is empty.

How to enable Sellforte to fetch your data from BigQuery

Sellforte can fetch data directly from a customer-managed Google BigQuery environment. This setup is recommended for recurring datasets where customers manage their own data pipelines and access controls.

All data fetched from BigQuery must follow the relevant Sellforte data specification.

Overview of the setup

The BigQuery fetch setup consists of two steps:

  1. The customer prepares a BigQuery table or view that matches the Sellforte data specification

  2. The customer grants Sellforte read-only access and permission to execute query jobs

Once completed, Sellforte fetches the data automatically on an agreed schedule.

1. Preparing your data in BigQuery

Customers are responsible for preparing the data in BigQuery in a format that matches the Sellforte data specification.

This typically means:

  • Creating a table or view in BigQuery

  • Ensuring required fields, data types, and granularity match the specification

  • Including only the data that should be ingested by Sellforte

How the data is produced (for example joins, transformations, or upstream pipelines) is fully up to the customer.

2. Granting Sellforte access

Sellforte requires read-only access to your BigQuery data and permission to execute query jobs in order to fetch the data.

Access is granted to a Sellforte service account, which will be provided by Sellforte.

Dataset-level access (read-only)

Grant access on the dataset that contains the Sellforte-ready table or view:

  • BigQuery Data Viewer (roles/bigquery.dataViewer)

This allows Sellforte to read data from tables and views, but not modify them.

Project-level access (query execution)

Grant access on the GCP project:

  • BigQuery Job User (roles/bigquery.jobUser)

This allows Sellforte to execute the query jobs required to fetch the data.
No write, admin, or schema modification permissions are required.

Sellforte only executes read-only queries against the specified dataset.

Completing the setup

Once the data is prepared and access has been granted:

  • Share the project ID, dataset name, and table or view name with Sellforte

  • Sellforte validates access and schedules automated data fetching

No further manual actions are required unless the schema changes.