Integration of Currency Convert with BigQuery

Connect Currency Convert to Google BigQuery in WitCloud and store daily exchange rates for the currency pairs you choose.

Updated

Introduction

This module saves daily currency exchange rates in Google Cloud BigQuery. The rates come from the National Bank of Poland (NBP). You choose the currency pairs, and WitCloud stores the rate of each pair for every day, so you can convert revenue and costs into one currency in your analyses.

Configuration guide

Follow the steps below to set up Currency Convert. Once the setup is complete, the exchange rates will be transferred to your BigQuery project. This integration needs no authorization.

Module setup

Go to Integrations in the menu and click Add integration.

Integrations list with the Add integration button

Select Currency Convert from the list of available integrations.

Integration catalog with Currency Convert selected

Enter the Collect name, e.g., "Currency Convert PL".

Collect name field filled in with the example name Currency Convert PL

In the Currencies field, choose the currency you convert from and the currency you convert to. Click Add to add another pair. Every pair becomes one column in the table.

Currencies field with two rows, EUR to PLN and USD to PLN, and the Add button

Click Next.

Historical data and scheduling

In the Historical Data field, enter the number of days for which you want to fetch historical rates. You can enter up to 365 days.

Historical Data field filled in with 365 days

A data synchronization schedule will be created automatically. More information on this topic can be found here.

Click Create to complete the configuration.

Data collection settings with the Create button

Done! The exchange rates for your currency pairs will now be synchronized with BigQuery.

Data schema

Besides the columns below, the table has one column for every currency pair you chose. It is named after the pair in lowercase, e.g. eur_to_pln, and holds the value of one unit of the first currency in the second one. For days without an NBP publication, the last known rate is used.

Data schema for currency_converters
Field NameModeType
dateNULLABLESTRING
date_YYYYMMDDNULLABLESTRING
amountNULLABLEINTEGER
eur_to_plnNULLABLEFLOAT