Importing data from big query

We have a problem to build and import the data from GCP bigquery. It need to be automated. I will appreciate the approach and if possible some sample code (written in python etc) to get the data from bigquery into anaplan datahub

Accepted answers

JaredDolich

@AvnishGoel

The absolute best article written for data integration with Python is this one from @chase.hippen. He provides the python code for both basic authentication and also for CA Certificates so you'll be covered. Size of the data is not an issue. He covers how to chunk the file too.

https://community.anaplan.com/t5/Best-Practices/Using-Python-3-with-the-Anaplan-API/ta-p/33150

If you need a specific example that's not covered in this article, reply back here, we'll get you what you need.

All comments

JaredDolich

@AvnishGoel

https://community.anaplan.com/t5/Best-Practices/Using-Python-3-with-the-Anaplan-API/ta-p/33150

If you need a specific example that's not covered in this article, reply back here, we'll get you what you need.

jwakefield

If you want it automated and business owned then you should be looking at Anaplan hyperconnect or onecloud.io https://support.onecloud.io/support/solutions/articles/48000985250-google-bigquery-bizapp

Otherwise you could look at accessing bigquery via jdbc using something like simba https://cloud.google.com/bigquery/providers/simba-drivers and then using Anaplan connect to automate.

Python would be adding a layer of complexity typically not needed for pure data integration.

guillaume_arnau

Speaking of JDBC connector, please check here if you still need:

https://community.anaplan.com/t5/Best-Practices/Easily-Integrate-Data-From-Google-BigQuery-With-Anaplan-Connect/ta-p/84626

Quick Links

Can you help?

Unanswered questions

Workaround for Formula & Closing Balance summary methods together in Polaris
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…
AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…