I have a column with data type Array(String) in spanner. How can I append value to an array for update queries I’m able to update the values using this command But the problem with this update is it overrides the previous values. I want to append these values to the ones that are already present. Is there any command that
Tag: google-cloud-platform
Problem Bigquery stored procedure not filtering
I’m trying to use a stored procedure to get some data from my clients filtering a table by date and channel of purchase in a query that looks something like this: After running the procedure, I use the following call: The call executes and returns a table, but the result is never filtered. The dates don’t correspond to ‘2021-09-11’ and
How to Unpivot a Struct in BigQuery?
I have a table with an ID and then a struct. I want to turn each element of the struct into a new row with the struct field name being a value in the column Period and the value being the structures value. See table below Query that generated the table: Current data I tried this: But I get this
How to connect a Spring Boot service from Google Cloud Run to SQL cloud instance?
I have created an SQL instance. It is working. Then, I have uploaded the docker image for my Spring Boot app on Container Registry. My goal is to run the app on Google Cloud Run, but in order for it to work, it has to connect to the database. Thus, when creating the service I give it the image and
Google BigQuery Federated Query connection Error
I am trying to use the Federated Query functionality in BigQuery to query some data from my Cloud SQL Postgres DB. Unfortunately I get the following error: It is quite similar to the error discussed here, but it was not solved (the word that appears in the quotes is different though): Connection Error while running federated query in BigQuery to
Can’t found the poroblem within this Hive Query [closed]
Closed. This question is not reproducible or was caused by typos. It is not currently accepting answers. This question was caused by a typo or a problem that can no longer be reproduced. While similar questions may be on-topic here, this one was resolved in a way less likely to help future readers. Closed last year. Improve this question EDIT:
BigQuery – JOIN on two tables using string and array
We have two tables in BigQuery like below: Table A Name | Question | Answer —–+———–+——- Bob | Interest | a Bob | Interest | b Sue | Interest | a Sue | Interest | c Joe | …
BigQuery SQL conditional IN
I have been trying to construct a conditional IN like below, but this gives me the scalar subquery produced more than one element error. How should I approach this type of query instead? The tables are not related. Answer Try this below- As your other tables are not related, you can try this below logic-
How to deal with semantic version data type in BigQuery
I know that there is no data type in BigQuery. What would you prefer to deal with semantic versions in BigQuery? I have the following schema: software_version column is string but the data I store there is in semver format: `MAJOR.MINOR.PATCH-prerelease I especially want to perform operators < > =. This returns true, but according to the semver definition it’s
GCP Bigquery – query empty values from a record type value
I’m trying to query all resources that has empty records on a specific column but I’m unable to make it work. Here’s the query that I’m using: SELECT service.description, project.labels, cost …