API integration of Shopify to BigQuery

[nemo_minimalist]

Hi,
Please note: I am not well-versed with BigQuery.
I want to create sales report on Looker and for that I want to extract data to BigQuery from Shopify.
I want to extract data from Shopify using API conector.

Kindly help!

[aaronGCP]

I would use a cloud function to pull the data from the REST API and then write to BQ.

[pramodvallanur]

Hi, 

You can refer to this sample - This is from Salesforce to Bigquery, but similar concept - https://cloud.google.com/application-integration/docs/automate-salesforce-opportunity-to-bigquery-or... 

For your usecase:
Shopify - https://cloud.google.com/integration-connectors/docs/connectors/shopify/configure
BQ- https://cloud.google.com/integration-connectors/docs/connectors/bigquery/configure 

Connectors simplify without the need for you to understand the details of BQ APIs /SQL or even Shopify APIs. This not only includes configuration driven connectivity, but also on discovery of entities (tables in case of BQ, objects in Shopify), auto create fields, etc. It also provide all the security options supported so that can be rest assured.

It just not that, since your BQ schema would be different from Shopify- you can map them, conditional route, etc.

[shaaland]

You can also refer to this similar thread in the community here.
I also did a demo of this use case for a webinar, which you can watch here.