google-bigquery tag

13 questions


1 answers
405 views
0
A logic that uses SQL to link the IDs of the same users of multiple systems and shake them.

For each unique user ID in multiple systems, we would like to use a unique ID to link the same user ID.I'm having a hard time deciding what logic to use in SQL, so could you give me some advice?There ...

2 years ago

3 answers
137 views
0
How to save JSON strings in BigQuery and aggregate the values in the array

Looking at the following entry in Qiita, I am trying various things because I think that if I can do this, I will be able to analyze the log better.http://qiita.com/hakobera/items/5e280ad33d72f82de39c...

2 years ago

1 answers
111 views
0
Trigger fails when connecting to BigQuery and retrieving data from spreadsheet

I wrote the process of retrieving the data aggregated by BigQuery in GAS and outputting it to a spreadsheet.The following are the queries to retrieve:select * from(SELECT appid, count (userno) as cnt ...


1 answers
117 views
0
Understanding How to Extract Data Within a Specified Time Period: No matching signature for operator BETWEEN for argument types: TIMESTAMP, DATE, DATE

You want to specify a specific column (timestamp type) for the data table in a big query to extract only data within any period of time.·Satei_date is within 2 monthsThe query is listed as follows, bu...

2 years ago

1 answers
118 views
0
Import Error in Adwords Editor

I received CSV data that I exported information from the other company's admin words editor, so when I tried to import it into a newly created account, I got an error No Required Account Column and I ...

2 years ago

1 answers
137 views
0
BQ → Data Portal Updates

I don't know if the question here is appropriate because it's a data portal.Display data entering BQ on the data portal in real timeI don't know how to do it.If anyone knows, please let me know!

2 years ago

1 answers
147 views
0
How to Return Google BigQuery Results in Multiple Json Format in Python

We have created an API that allows us to do the following in the Python framework, Flask.I use Google BigQuery as the destination DB for SQL.複数 Obtain multiple request parameters (luid) in a list and ...


1 answers
117 views
0
I am having trouble pouring firebase authentication information into Bigquery.

I would like to pour the authentication credentials of the firebase that I use to handle the credentials for analysis into BigQuery, but it is not working.https://support.google.com/firebase/answer/63...


1 answers
92 views
0
A method of outputting only records with a specific structure in a bigquery

Register the following json data as a sample.For example, to write a sql statement that prints only records with the first line of History structure, I'd like to get the size of Books.History and comp...

2 years ago

1 answers
125 views
0
I want to import spreadsheet data in Bigquery

I imported the spreadsheet data in bigquery, and the following sentence appears.Why?Failed to create table: Invalid field name .Fields must contain only letters, numbers, and underscores, start with l...

- 1 - »

© 2024 OneMinuteCode. All rights reserved.