ReadMeFeed / Community knowledge
Real questions. Useful conversations. Find the people who know your stack.
Is it possible to iterate over an array in bigquery in standard sql? Basically declare an array of strings representing table fields. ex : DECLARE FIELDS_TO_CHECK ARRAY<STRING>; SET FIELDS_TO_CHECK = ['field1', 'field2', 'field3' ]; and then iterate on this array to create requests getting percentage of non null value on this field : select count(FIELD
Asked · Jul 23
answered · Jul 23
I created a query in Google Bigquery which is connected to a Topic which triggers the Cloud function. I want to schedule the query on-demand run. Once I schedule the query I am not able to find any option in UI to run that particular Query. Please let me know if some more clarification is required. I only see the following options in scheduled query UI page.
I am reading 10 million records from BigQuery and doing some transformation and creating the .csv file, the same .csv stream data I am uploading to SFTP server using Node.JS. This job taking approximately 5 to 6 hrs to complete the request locally. Solution has been delpoyed on GCP Cloud run but after 2 to 3 second cloud run is closing the container with 503
