Google Play Developer Console provides access to a Google Cloud Storage folder with User Acquisition analytics data for my app at; gs://pubsite_prod_rev_XXXXXXXX/acquisition/retained_installers Can I get BigQuery to read from this data source? If not
I have managed to calculate total events by ISOweek but not unique events for a given Google Analytics Event using BigQuery. When checking GA, total_events matches the GA interface on the dot but unique_events are off. Do you know how I can solve thi
I am pulling data for a homepage heat map and I would like to only see pageviews where the previous page was the homepage. My data is imported Google Analytics tables - the metric 'previous page path' does not exist in BQ, so how would I go about wor
We are working on a project where a lot of data is involved. Now we recently read about Google BigQuery. But how can we export the data to this platform? We have seen the sample of importing logs into Google BigQuery. But this does not contain inform
My question is regarding writing to BigQuery from BigQuery Standard SQL UDF. I have a requirement that I have to do some calculations from within Standard SQL. And after those calculation I have to save those calculations data to BigQuery. What is th
Distance travelled between points: I have a set of gps points travelled by each vehicle. I am trying to retrieve the first and last records for each trip. Data: VehicleId TripId Latitude Longitude 121 131 33.645 -84.424 121 131 33.452 -84.409 121 131
Is it possible to create a partitioned table using BigQuery's web UI?Step 1 - Choose Dataset and click + or triangle icon Step 2 - In Partitioning Option pick Day
I need to create my custom (user defined) JS function in BigQuery. First, I want to create simple "starter" based on Google example, but in my situation I need to use data from column with dots in name (eg. "hits.item.transactionId") a
I want to aggregate on some fields and get any not null value on others. To be more precise the query looks something like: SELECT id, any_value(field1), any_value(field2) FROM mytable GROUP BY ID and the columns are like: ID | field1 | field 2 -----
I thought I'd be able to get what I needed by asking a simpler question referencing a simpler data example here, but I still need some help. I'm pretty new to querying json style data within BigQuery, and am having trouble with the analytics (events)
I'm dealing with a querying issue I'm struggling to work around. I have a database of names. What I'm looking to do is figure out those who have multiple names in the database tied to the same ID, where those names are very similar to each other: ID
I have a BigQuery table and I want to use a job with writeDisposition WRITE_TRUNCATE to overwrite the table with a subset of its rows. I am doing this because I'm trying to mimic a DELETE FROM - WHERE - operation. Suppose while the job is running, I
I'm working in BigQuery. I've got two tables: TABLE: orgs code: STRING group: STRING TABLE: org_employees code: STRING employee_count: INTEGER The code in each table is effectively a foreign key. I want to get all unique groups, with a count of the o
I am running into a bit of an issue when appending a JSON blob to an existing table in BigQuery; specifically, the existence of new, but not necessary, leaf elements in the JSON being appended is preventing me from appending the data. Using the UI, I
We have a usecase where we have hundreds of millions of entries in a table and have a problem splitting it up further. 99% of operations are append-only. However, we have occasional updates and deletes which Google itself says is only possible by del
I can see Google add button for datasets with many tables in it and this button simply doesn't work for me. You can click on it but nothing happens. Is it a Bug ? How can I get rid of it? This button will show details for the entire dataset in the ma
I'm using BigQuery for this. I have a subquery that pulls data from a table that has an account_id, product, date, and product_spend fields. This subquery calculates the total lifetime spend for each product for each 'account_id' by adding up each of
I have a table in BigQuery about number of contracts sent out on day to day basis: date contract 2014-05-04 {jeans = 5, caps = 12, CDs = 1, Microwaves = 7, other = 6} 2014-05-05 {cups = 7, other = 5} I need to filer out how many not classified contra
We are loading csv files into BigQuery. Each file will create a separate table. When we select from these tables, we do this mostly with a table query liek so: SELECT foo, bar FROM TABLE_QUERY(name_stub,'table_id CONTAINS "_something" and msec_t
Trying to figure out what to do when getJobComplete() returns false. I assume It means that the job failed so I should go ahead and resubmit it but need confirmation and no assumptions! thank youThe api pair jobs.query/jobs.getQueryResults is effecti
I have a dataset containing tables with similar table names ending in yyyymmdd. For example: myproject:mydataset.Sales20140815 myproject:mydataset.Sales20140816 myproject:mydataset.Sales20140817 myproject:mydataset.Sales20140818 ... myproject:mydatas
I'd like to be able to do some calculations by partition in BigQuery and then only output 1 row for each partition (rather than a row for every partition). E.g., if I had something like this table: Category | Location | Count A | 'home' | 20 A | 'wor
I have float data in a BigQuery table like 5302014.2 and 5102014.4. I'd like to run a BigQuery SQL that returns the values in String format, but the following SQL yields this result: select a, string(a) from my_table 5302014.2 "5.30201e+06" 5102
I have a Google App Engine program that calls BigQuery for data. The query usually takes 3 - 4.5 seconds and is fine but sometimes takes over five seconds and throws this error: DeadlineExceededError: The API call urlfetch.Fetch() took too long to re
How to do pagination using BigQuery ,when using javascript First I send request: var request = gapi.client.bigquery.jobs.query({ 'projectId': project_id, 'timeoutMs': '30000', 'query': query, 'maxResults' : 50, 'pageToken': pageToken }); This query w
I want to get the maximum value of 2 Integer (or 2 float). I know I can do it with a IF function like this: IF (column1 > column2, column1, column2) however I was wondering if a function to do that exists or if there is a plan to add that kind of fun
...Spent several hours trying what not and researching this forum. Quite pessimistic at this point about the usefulness of Google Big Query (GBQ) for anything more than trivial queries, but here is one last desperate try, maybe someone has better ide
The schema for my BigQuery table looks like: A:STRING,B:STRING,C:STRING,D:STRING,E:STRING,F:STRING,createdAt:INTEGER,updatedAt:INTEGER,I:STRING The file (JSON) in cloud storage has a single item and it looks like: { "A": "AAA", "B
Is there a way through the BigQuery Java library to load a table from a local CSV file? When I tried to pass in a local file URI to JobConfigurationLoad.setSourceUris() I received the error "Source URI must be a Google-Storage location". Related
In the BigQuery documentation it is mentioned that it uses OLAP functions. But the developer documentation does not mention MDX query language, dimension or fact tables. What OLAP features, if any, are in BQ and how are theyBigQuery is not a traditio
