Is there any currency conversion function in GCP Bigquery?

Question

I'm trying to migrate a procedure from SAP HANA to GCP bigquery. The procedure in HANA uses a native function - CONVERT_CURRENCY in HANA which allows me to provide a historical date and it gives me the currency conversion for a specific currency to be converted in USD for that historical date. Trying to replicate the same in GCP and need help.

DataNath · Accepted Answer · 2024-02-28 13:25:42Z

2

There's not a native function in BigQuery for this - you'd need to create and populate a separate table with FX rates and join this to your main table based on the native currency and either a) the date field of interest or, b) a set date that you filter the FX table to if you're setting the date manually.

edited Feb 28, 2024 at 13:25

answered Feb 28, 2024 at 13:25

DataNath

463 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Is there any currency conversion function in GCP Bigquery?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related