Loading data from Pigment into BigQuery

Hi Elliot! I hope you’re well!

While we don’t have a native connector (I’d recommend our ideas portal for this), there’s a few ways you can get your data into BigQuery.

If you have an ETL Tool you can use the Pigment APIs to export the data and import it into BigQuery, the BigQuery  you can also use our CSV Export to get the data from Pigment to then upload it into BigQuery.

If you’re happy to let me know what tools you have available, and the frequency of the load you’re aiming for I’d be happy to help come up with ideas on how you can do this!

All the best