Questions tagged [Google BigQuery] (5)

1
answer

Google BigQuery?

Colleagues, kind time of day. Recently I came across Google Cloud Platform. I really liked Google Cloud Storage. Okay, just convenient. The question is, did someone service BigQuery. I have a certain amount of data supplied on 50Gb per month. In the Pricing section I see the price tag at$ 80 per terabyte of stored data. T...
duane_Kub asked October 3rd 19 at 08:29
1
answer

How to upload unique content with json?

Has JSON which is parsed from the site every 15 minutes. It contains a bunch of orders. After all this JSON is sent to Google Cloud Storage and from there to Google BigQuery. The problem is, that we need to check that any orders already in the BigQuery table so that the content is not repeated. Prompt in what direction to l...
Chyna.Ki asked September 15th 19 at 17:33
1
answer

What's wrong with the SQL query in GOOGLE BIGQUERY?

Friends, help to solve the problem. Trying to build a funnel for the URL, the request fails with the following: "Error: Cannot group by an aggregate." Take data from Google Analytics.Here is the query itself: SELECT COUNT(DISTINCT s1.clientId ) AS s1.User s1.page.pagePath FROM ( SELECT COUNT(DISTINCT clientId ) as User,...
camron87 asked July 23rd 19 at 18:06
0
answer

What happened to the Individual account in bigquery.cloud.google.com?

Hello. I was given video Analytics (to understand what it is). You need to go to bigquery.cloud.google.com, log in, select the account type Individual, to specify the details of a plastic card and begin work. I do everything like in the video:... I go and see Account type: Legal entity And there is no choice in any gmail ac...
heidi21 asked June 26th 19 at 17:06
0
answer

How to get a list of all repositories projects on the Go in Google BigQuery (github_repos датасетt)?

How to download a list of all repositories projects on the Go in Google BigQuery (github_repos датасетt)?
thalia56 asked June 21st 19 at 12:35
  • 1