ScowttCentro de ayuda

Este artículo solo está disponible en inglés.

Para Data owners · Actualizado el 6 nov 2026

Share data through BigQuery

If your data lives in BigQuery, or can be exported there, you grant Scowtt read-only access to the relevant dataset. Your data stays in your own Google Cloud project; nothing is copied or moved. Scowtt queries the dataset directly on a schedule, so there's no export job to run. This article covers CRM and offline data in BigQuery. For Google Analytics 4, see Connect Google Analytics 4 (GA4).

How it works: Scowtt sends you an access address. You grant it read-only access to a dataset and send Scowtt the details. Scowtt checks the data with you.

Before you start

  • Owner or BigQuery Admin rights on the Google Cloud project that holds the data.
  • Your Scowtt access address from your Scowtt team. It looks like yourcompany-datasharing@scowtt.com and is unique to your company.
  • For CRM data: one row per record or per stage change, each with an updated-at timestamp, covering at least 12 months of history (24 preferred). If the data isn't in BigQuery yet, a tool such as Fivetran, dbt or a scheduled export can load it on a schedule.

Share a dataset

  1. Scowtt: Send your access address

    Your Scowtt team sends your Scowtt access address. It looks like yourcompany-datasharing@scowtt.com and is unique to your company.

  2. You: Put the tables in one dataset

    For example, scowtt_shared. To share only some columns or rows, create views of your tables in that dataset instead of copying them.

  3. You: Grant Scowtt read-only access

    In the BigQuery console, open the dataset, then Sharing > Permissions > Add principal. Add your Scowtt access address with the role BigQuery Data Viewer and save.

    Google's step-by-step guide: Grant access to a dataset.

  4. You: Send Scowtt the dataset details

    Send your Scowtt team the project ID, dataset ID, the tables included, the dataset location (for example US or EU) and how often the tables refresh.

  5. Scowtt: Check the data with you

    Scowtt confirms access and validates the backfill with you before recurring reads start.

Good to know

  • Scowtt runs its queries from its own Google Cloud project, so query costs are billed to Scowtt. You pay only for storing the data.
  • Policy error when adding the Scowtt address? Your organization restricts sharing to its own domain. Ask your Scowtt team for Scowtt's Google Workspace customer ID. Your Google Cloud admin can allow it in the domain restricted sharing policy, or add an exception for this dataset.
  • Refresh CRM tables at least 4 times a day, ideally hourly. See Data refresh schedule.
  • To end access, remove the Scowtt address from the dataset.

Who does what

StepWhoWhat changes hands
Send your access addressScowttYour Scowtt access address
Put the tables in one datasetYou—
Grant Scowtt read-only accessYouBigQuery Data Viewer for your Scowtt address
Send Scowtt the dataset detailsYouProject ID, dataset ID, tables, location, refresh schedule
Check the data with youScowttConfirmation, or fixes needed
Choose how to connect your dataThere are several ways to share CRM and analytics data with Scowtt. Your Scowtt team will help you pick the one that fits your environment best.Data refresh scheduleScowtt works best with fresh data, because predictions reach your ad platforms while campaigns are still optimizing.