Google BigQuery integration supports moving data between Google BigQuery and Insider One for both import and export scenarios.
You can move data between Google BigQuery and Insider One in both directions. The setup process differs depending on whether you are importing data into Insider One or exporting Insider One data for use in BigQuery.
Google BigQuery integration supports two data flows:
Import: Import user attributes and events from Google BigQuery into Insider One by using the native integration.
Export: Export Insider One data to Google BigQuery through Google Cloud Storage.
Import data from Google BigQuery to Insider One
Use the native Google BigQuery integration to import user attributes and events from BigQuery tables or views into Insider One. You can map your BigQuery columns to Insider One identifiers, attributes, events, and event parameters, and configure a recurring synchronization schedule.
Get started with Send Google BigQuery Data to Insider One now.
Export Insider One data for use in Google BigQuery
To use Insider One data in Google BigQuery, export the data to a Google Cloud Storage bucket that you own. Insider One exports the configured event data, event parameters, and user attributes as CSV files at the configured export frequency. You can then load the exported files into BigQuery by using your existing Google Cloud pipeline.
The export includes only data generated after the integration is activated.
Get started with Export Data to Google Cloud Storage now.