Google BigQuery
Auxia's integration leverages GCP's IAM access control to pull in any relevant table for highly granular user targeting, feature creation, model training, and performance measurement.
Sharing a BigQuery Dataset with Auxia
Time required: <10 minutes
Step 1
Login to the GCP console and navigate to the BigQuery.
Step 2
Navigate to the dataset that needs to be shared. You can use the search pane on the left side bar.
Step 3
Click “Sharing”, and then “Permissions”.
Step 4
Click “Add Principal”.
Step 5
Add Auxia’s service account with the “BigQuery Data Viewer” role and click “Save”.
Once this step is completed, click save and a member of the Auxia team will reach out to you to proceed with next steps.
Ingesting user attributes
To begin ingesting user attributes, please ensure you have completed the steps here to structure your attributes table into rows or columns. Once you have completed the steps above to share the relevant Bigquery dataset or specific table with Auxia's service account, please complete the following steps:
Step 1: Navigate to your table
Step 2: Set 'enable_change_history=TRUE'
To proceed with the ingestion process, each table that's being ingested needs to have enable_change_history=TRUE
. You can do this by running the following command below.
This is necessary because Auxia uses either the 'CHANGES' table-valued function or the 'APPENDS' table-valued function to ingest the data incrementally for efficient and real-time feature creation.
Step 3: Validate the option list and contact Auxia
Once you've validated the enable_change_history
label is set toTRUE
within the table, please notify your Auxia POC.
Last updated