Allow LiveRamp to Access Your BigQuery Data
If your data is stored in Google BigQuery, you can allow LiveRamp to ingest data from your BigQuery tables by having a data source created in LiveRamp Connect.
Note
This workflow is in limited availability and is by invitation only.
Provide the following details to your LiveRamp customer success manager (CSM) for each BigQuery environment you want LiveRamp to ingest data from:
Data source name: The name you want to use for this data source.
GCP project ID: The Google Cloud project that owns the datasets and tables you want LiveRamp to ingest.
Table name: The name of the specific table that should be ingested. Provide full identifiers if possible (for example, "project.dataset.table".
Columns to ingest: Whether LiveRamp should ingest all columns or only specific columns (provide the exact column names).
Google service account key (JSON): A service account key file (JSON) for an account with read access to the tables you listed (for example, a role such as "BigQuery Data Viewer" on the relevant datasets).
Tip
Next Steps
For offline (PII-based) data, if this is the first file you're uploading to this dataset, create a support case so the support team can make sure everything ingests correctly. See 'Considerations When Uploading the First File to a Dataset" for more information.
Within about 20 minutes after uploading, you can check the ingestion status of your uploaded files on the Files page, either by clicking the "GO TO FILES PAGE" link or by selecting Data In → Files in the navigation menu. For more information on the ingestion process for Activation workflow files, see "Overview of the File Ingestion Process for Activation Workflow Files".
Once your data has been ingested (usually within 1-3 days), you can manage it in Connect and distribute it to your desired destinations.