Loading data from BigQuery to Salesforce

1
votes

I have two datasources - Salesforce(SF) and BigQuery(BQ). All the data from SF is available in BQ.

So my question is can we load data from BQ to SF?.

Here's what I want to achieve -

I want to do some calculation in BQ using SF data fields and create 3/4 new fields in BQ. And then I want to load these new fields into SF in respective objects (e.g. Lead, Opportunities, etc.). Once I have these new fields in SF, I can then create reports/dashboards in SF.

So is loading data from BQ to SF possible? .

While I can create these fields in SF as well; but due to some limitation this is currently not possible. So thought of doing it in a reverse way?

Kindly help.

1
google-bigquerysalesforce

1 Answers

1
votes

Short answer is yes this is possible.

You have a couple of options available to implement this. For example you can interact with BigQuery using "Salesforce Connect", or you use the BigQuery connector.

The following explains in detail the use of Salesforce Connect Salesforce Connect, here you can review the use and implementation of Google BigQuery Connection