Category "google-bigquery"

Is there a way to use a kmeans, tensorflow saved model in bigquery?

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

DISTINCT result of ARRAY_CONCAT_AGG in BigQuery

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

BigQuery cannot use analytic function in SELECT * REPLACE

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

BigQuery sort a CONCAT of multiple string columns in SELECT

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

Elastic search with Google Big Query

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

Convert Date to Text in BigQuery

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

ERROR - secure_channel() got an unexpected keyword argument 'default_scopes' with .to_dataframe() on bigquery object

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

Hit Number attribute equivalent in GA4 Big Query

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

Other Categories