I'd like to take two columns (latitude and longitude) and create a single column with the combined information. The final goal is (a) see if I can gather useful
Update: I found a solution for my first question meaning changing to never expires: I applied this code to my dataset and the firesbase console now showing neve
How to use BigQuery from elixir code? I would like to use Big Query web API from elixir code. Although there is no elixir client SDK in SDK libraries page I w
I need to extract last 16 characters from a sentence under a title column of a table using bigquery. My table is like this: title No Commission inc GST - FY20 H
I am very new to google cloud and following an example in "Google BigQuery: The Definitive Guide" to learn to use this platform. I am trying to make a dataset t
I am executing a query for merging tables. I execute this same query every week, but this time it throws me an internal error. I waited and tried it again the s
I have some data where for each ID I want to aggregate two or more fields into an array, and I want them to match in terms of order. So for example if I have t
I know this is kind of stupid since BigQueryML now provides Kmeans with good initialization. Nonetheless I was required to train a model in tensorflow and then
I need to compute distinct set of items from the aggregated arrays. I cannot use the array_concat as suggested in similar threads, as I don't know how many arra
For a large database project of mine, I have adopted a structure of building tables with nested structs, and combining these tables together (again using struct
First I will present example of what I'm trying to achieve, and then will share a bit more info. This is a relatively straightforward task to explain, however I
I have the event logs loaded in elasticsearch engine and I visualise it using Kibana. My event logs are actually stored in the Google Big Query table. Currently
I need to convert date to text format in bigquery. I used below sytax in my query- STRING(DATE(TimeStanmp_1)). please let me know if this is correct
Environment Details Python 3.7.12 google-api-core 1.23.0 google-auth 1.35.0 bigquery 2.3.1 let me know if i can provide any other library versions We are queryi
Is there an equivalent of the attribute Hit Number from UA structure into GA4 structure in Bigquery. i'm trying to identify a unique row/event but except using