Most voted "bigquery" questions
Bigquery is a Restful web service that enables interactive analysis of large data sets that work together with Google Storage.
Learn more…9 questions
Sort by count of
-
1
votes0
answers32
viewsJOIN in Bigquery
Good morning Personal. I am very beginner with SQL and need to do the following query, but Bigquery has error: Name Cnpj_radical not found Inside A at [3:6] Why can’t I call the JOIN ON alias?…
-
0
votes1
answer282
viewsHow to make a cumulative sum in Bigquery?
Hello. I need to create a Dashboard from a query. I would like to generate this column in the query always adding up to the previous month, ie a cumulative sum. ex: instead of: mês 1: 2 mês 2: 3 mês…
-
0
votes1
answer30
viewsmaximum hitNumber per visitID - google bigquery
I need to collect only the last hitnumber per visitID in a query from a Google database Analytics via google big query. Below follows my current code. I have reached the point of ordering the query…
-
0
votes0
answers29
viewsHow to access the value of an array within a while loop in SQL?
In the database I’m working on there are a number of salary variables that are registered as strings with entries like 0000001155,00. I’m using a combination of CAST and REPLACE to turn these…
-
0
votes1
answer19
viewsIs it possible to call a Procedure in Scheduled Queries (Schedule Queries) in the Big Query?
I tried several ways to call a Procedure through this interesting Big Query feature for scheduling queries. If it is possible to call Procedures through this feature, it will be a great opportunity…
-
0
votes0
answers42
viewsRepeat lines in Array: is it possible with UNNEST? or is there any other way? - Bigquery
I made this query in SQL in Bigquery (Google): SELECT FORMAT_DATE("%E4Y-%m", date) AS Mes, cliente, ARRAY_AGG( DISTINCT date ORDER BY date DESC LIMIT 2) AS date FROM…
-
-1
votes1
answer167
viewsHow to pick random values from a table in Bigquery (SQL)?
Hello. I have a table where I have in one column a registration number and in another the number of keys registered in this record. I am willing to take this data for analysis, however, as there are…
-
-1
votes1
answer379
viewsCannot access field on a value with type ARRAY
I’m trying to pull the spine name.pt_BR that is inside the column namebut I still don’t understand how to get it specifically in Bigquery. How to pull this info to give JOIN in another query later?…
-
-4
votes0
answers29
viewsIn Bigquerym, how to find a text in a column based on another table and column
I made the example below with a blocklist table (where I have all the words that cannot appear in a product description). The product table, where I want to find these blocklist words in the product…