Get piwik data into bigquery

Plugins & Platform
1

Hi,

I am using piwik’s log analytics functionality which works great and uploads the data to piwik mysql database. I am planning to use the data in piwik tables and draw insights from data for which mysql will not be good option. So I want to push the data to google’s bigquery instead of mysql, do piwik have some sort of functionality in place for this?

2

Update: check out this FAQ also: https://matomo.org/faq/how-to/faq_24536/

you can call the APIs: http://piwik.org/docs/analytics-api/reference and push the data anywhere

3

I think question is too old. But I created a Python script to sync data between Piwik database and BigQuery so that we can do data analytics with BigQuery.
I have some idea to using BigQuery as for archive processing too. I’m going to implement it within next few months.