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.
Is there any currency conversion function in GCP Bigquery?
138 Views Asked by Atul Singh At
1
There are 1 best solutions below
Related Questions in GOOGLE-CLOUD-PLATFORM
- Google Logging API - What service name to use when writing entries from non-Google application?
- Custom exception message from google endpoints exception
- Unable to connect database of lamp instance from servlet running on tomcat instance of google cloud
- How to launch a Jar file using Spark on hadoop
- Google Cloud Bigtable Durability/Availability Guarantees
- How do I add a startup script to an existing VM from the developer console?
- What is the difference between an Instance and an Instance group
- How do i change files using ftp in google cloud?
- How to update all machines in an instance group on Google Cloud Platform?
- Setting up freeswitch server on Google cloud compute
- Google Cloud Endpoints: verifyToken: Signature length not correct
- Google Cloud BigTable connection setup time
- How GCE HTTP Cross-Region Load Balancing implemented
- Google Cloud Bigtable compression
- Google cloud SDK code to execute via cron
Related Questions in GOOGLE-BIGQUERY
- Get the last data of my google analytics dataset
- Is there any form to write to BigQuery specifying the name of destination tables dynamically?
- How to obtain java repositories having maximum number of stars in GitHub-Archive
- Possible to create BigQuery Table/Schema without populating with Data?
- Google spreadsheet script authorisation to BigQuery
- Google BigQuery Optimization Strategies
- Error when I try to create different BigQuery tables at the same pipeline execution
- Run BigQuery without login authentication
- Is there a CityHash Python (2.7) Implementation for Google App Engine?
- pandas read_gbq returns httplib.ResponseNotReady
- Designing an API on top of BigQuery
- BigQuery row level security permissions
- What is the best way to fuzzy compare two tables
- Query Google Bigquery Through Python In Google App Engine
- How to integrate Google Bigquery with c# console application
Related Questions in HANA
- Is there a way to freeze the entire SAP HANA Database
- Calling R function within SQL - HANA database
- Does SAP HANA support incremental backup
- How to add a (primary) key to an existing table using SAP HANA
- Splitting SQL Columns into Multiple Columns Based on Specific Column Value
- Creating a Scroll_Insensitive ResultSet using the SAP Hana JDBC Driver
- HANA SQLScript dbms_output.put_line() equivalent?
- dynamic fill and create a structure in oData with SAP Hana Calculation View
- Model inconsistency during activation?
- How to use a column list in a database trigger on SAP HANA
- Memory allocation failed: How to combine four result sets into one table
- How to transport HANA Views from one system to another using Hybris
- Hana Parameterised stored proc issue simple jdbc template
- script not running through cron. Works fine when executed manually
- Upload an array in HANA
Related Questions in FORMAT-CURRENCY
- Problem with DT export data to excel after formatCurrency(mark = ' ')
- formatCurrency in DT::renderDataTable when datatable has no columns
- Babel formatting error for negative values in currency
- Why does PHP give me a fatal error for sending the (according to the manual) correct arguments to NumberFormatter's format()?
- Missing locale data for the locale "de-DE"
- How to format currencies on MAKE.com using a number as input
- Jest defaults to format currency to "en-US" even when the window navigator language is mocked to be "en-GB"
- How to apply currency format on specific rows in R
- How to format currency with input in reactjs
- How to add the results of a case
- Convert a number to currency format in Angular 10
- FormatCurrency is not a function
- Is there any currency conversion function in GCP Bigquery?
- Have I found a bug in PHP's NumberFormatter's "formatCurrency" function?
- PHP NumberFormatter, formatCurrency method rounds number for Serbian dinar
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
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.