Questions tagged [Google BigQuery] (5)

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...

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...

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,...

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...

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