Salesforce integration with Google BigQuery
How to Create new Google BigQuery data rows from new custom objects in Salesforce
Steps to automate
Use Nekton workflow automation service.Preparation
Create Nekton account. You can also use your existing Google account
to sign in.
Create automation
-
Click on the "Create new workflow" button, and then add "Automated step".
-
Set the step description to "Create new Google BigQuery data rows from new custom objects in Salesforce" and then click on "Automate".
-
Provide the necessary parameters and click on the "Test it" button to check your automation. If you had issues with it, you can click on "Automate" again to try a different one.
Create a schedule (optional)
If you want to run this automation on a schedule, click on the gear button on the workflow editor
screen
to configure it. For example, you can run this flow every hour or every day.
Automate Google BigQuery integrations
Google BigQuery actions
Nekton can use any feature that is available in Google BigQuery API.
Using our advanced AI, you can easily create custom automations for Google BigQuery.
Here are some typical actions you can do in your automated workflows.
Create Row
Creates a new row of data in a table.
Delete Rows
Deletes row(s) in an existing table in BigQuery
Update Row(s)
Updates new row(s) to an existing table in BigQuery
Get Rows for Job Completed
Gets batch of rows from completed jobs in BigQuery
Create Rows
Creates new rows of data in a table (accepts line items).
Import Data
Imports data into a table. The data must be in JSON format.
About Google BigQuery
BigQuery is Google's serverless and highly scalable enterprise data warehouse, designed to make all your data analysts productive.