Hello all, I was trying to create a query that will update certain data in the table from text input. After running update with SET campaign = "{{CampainInput.value}}" WHERE campaign_id = "{{table1.selectedRow.campaign_id}}" as a result to BQ is sended value in the form of SET campaign = " ? " …

Not collection correct values to push to bigquery

Mariya_Bahmat November 6, 2023, 8:57am 5

I have additionaly done it without quotation marks and data was delivered correctly.
For now I do not understand why it is not needed. Havent found in documentation any example for BQ directly.

2 Likes

Topic		Replies	Views
SQL query to postgres DB failing when using dynamic values 💬 Queries and Resources	3	75	October 17, 2024
How to push data to bigquery 💬 Queries and Resources javascript , sql , bigquery	8	5036	December 18, 2023
BigQuery Resource wrapping single quotes around all parameters 💬 Queries and Resources bigquery	2	2420	July 27, 2023
Dynamically add filter conditions to SQL 💬 Queries and Resources javascript , sql	14	9101	August 2, 2023
Mysql insert with different javascript objects in raw sql 💬 App Building javascript , sql	9	44	April 22, 2025

Not collection correct values to push to bigquery

Related topics