How to resolve "INVALID_ARGUMENT" issue while creating expressions with double quotes on Google BigQuery Data Source?
Issue Overview
Users may encounter the “INVALID_ARGUMENT” issue when creating expressions that include double quotes in the Google BigQuery data source. This article explains how to resolve this issue effectively.
Example of the Problem
When attempting to create an expression like the following, users may receive an error indicating “Invalid parameter(s) used in the expression”:
CONCAT('<a href="', [Field_name], '" target="_blank">Link</a>')
This error arises because the expression includes double quotes (") directly within the HTML tag. Google BigQuery interprets these quotes as part of the syntax, leading to confusion when the quotes are not escaped. Since double quotes are special characters in SQL, BigQuery expects them to be part of the code’s structure rather than a literal character within the string. Consequently, BigQuery cannot process the unescaped quotes.
Solution
To resolve this issue and achieve the desired expression without errors, users must escape the double quotes as follows:
CONCAT('<a href=\"', [Field_name], '\" target=\"_blank\"> Link </a>')
By escaping the double quotes with a backslash (\), the expression can be processed correctly by Google BigQuery.
Additional References
