How can I grant individual permissions in Google Cloud Platform for BigQuery users: http://stackoverflow.com/questions/42569095/how-can-i-grant-individual-permissions-in-google-cloud-platform-for-bigquery-use
Stack Overflow
How can I grant individual permissions in Google Cloud Platform for BigQuery users
I need to setup very fine-grained access control for service accounts in GCP. I am seeing this error:
"user SERVICE_ACCOUNT does not have bigquery.jobs.create permission in
project PROJECT_ID"...
"user SERVICE_ACCOUNT does not have bigquery.jobs.create permission in
project PROJECT_ID"...
Is it possible to use a timestamp for several flatten tables in BigQuery?: http://stackoverflow.com/questions/42575060/is-it-possible-to-use-a-timestamp-for-several-flatten-tables-in-bigquery
Stackoverflow
Is it possible to use a timestamp for several flatten tables in BigQuery?
I would like to know if it is possible to query a flatten table with a specific timestamp function similar to a similar request:
FROM TABLE_DATE_RANGE([89571105.ga_sessions_], TIMESTAMP('2017-02-01...
FROM TABLE_DATE_RANGE([89571105.ga_sessions_], TIMESTAMP('2017-02-01...
BigQuery Issue with time query: http://stackoverflow.com/questions/42583109/bigquery-issue-with-time-query
How to exclude NULLs from ARRAY so query won't fail: http://stackoverflow.com/questions/42584478/how-to-exclude-nulls-from-array-so-query-wont-fail
Stackoverflow
How to exclude NULLs from ARRAY so query won't fail
ARRAY_AGG aggregate function includes NULLs in the arrays it builds. When such arrays are part of query result, query fails with error:
Array cannot have a null element; error in writing field ...
Array cannot have a null element; error in writing field ...
PubSub -> BigQuery - How to handle multiple independent topics?: http://stackoverflow.com/questions/42585559/pubsub-bigquery-how-to-handle-multiple-independent-topics
Stackoverflow
PubSub -> BigQuery - How to handle multiple independent topics?
We are using DataFlow to read from a set of PubSub topics and write the data to BigQuery. We are currently using one DataFlow job for each topic and writing them to the related BigQuery table. Is it
Big Query cache: http://stackoverflow.com/questions/42587283/big-query-cache
Stackoverflow
Big Query cache
I have three questions related to BigQuery's cache, as the ability to get results from cache greatly reduces costs on large queries.
If the data has not been modified, is there a way to extend the...
If the data has not been modified, is there a way to extend the...
How to show a sample of the data in BigQuery?: http://stackoverflow.com/questions/42588927/how-to-show-a-sample-of-the-data-in-bigquery
Setting up a service account with write permission to BigQuery Dataset: http://stackoverflow.com/questions/42601032/setting-up-a-service-account-with-write-permission-to-bigquery-dataset
BigQuery date partition from column: http://stackoverflow.com/questions/42607741/bigquery-date-partition-from-column
Stackoverflow
BigQuery date partition from column
I'm trying to understand how one would go about to load a date partitioned table from a csv file containing data for multiple days. I guess I'm looking for a similar feature relational databases of...
Google BigQuery no Table preview: http://stackoverflow.com/questions/42612272/google-bigquery-no-table-preview
Retrieve BigQuery in JSON format: http://stackoverflow.com/questions/42617114/retrieve-bigquery-in-json-format
Stackoverflow
Retrieve BigQuery in JSON format
I'm developing JAVA application that uses Google Big Query. I'm using Google Cloud Java Client for BigQuery API.
Can I get query result in JSON format with this API? If can't, how can I get query ...
Can I get query result in JSON format with this API? If can't, how can I get query ...
BigQuery - how many entries per partition?: http://stackoverflow.com/questions/42619910/bigquery-how-many-entries-per-partition
GROUP_CONCAT is an analytic function and must be accompanied by an OVER clause: http://stackoverflow.com/questions/42623451/group-concat-is-an-analytic-function-and-must-be-accompanied-by-an-over-clause
Query repeated fields negation NOT include: http://stackoverflow.com/questions/42624283/query-repeated-fields-negation-not-include
Stackoverflow
Query repeated fields negation NOT include
I'm trying to query a string repeated field using NOT contain (regex)
This is the query, where nickname is an array (repeated) of strings:
SELECT
name
FROM
[mytable]
WHERE
(NOT
This is the query, where nickname is an array (repeated) of strings:
SELECT
name
FROM
[mytable]
WHERE
(NOT
What algorithm is used to achieve APPROX_TOP_COUNT in BigQuery？: http://stackoverflow.com/questions/42625802/what-algorithm-is-used-to-achieve-approx-top-count-in-bigquery
how to set named parameter on bigquery query: http://stackoverflow.com/questions/42628367/how-to-set-named-parameter-on-bigquery-query
How extract subsets from string in bigquery: http://stackoverflow.com/questions/42628856/how-extract-subsets-from-string-in-bigquery
Stackoverflow
How extract subsets from string in bigquery
I have a string variable consisting of 4 parts looking either something like this:
social_CA_FR_bloom_build
or this:
social_DE_bloom_trgj4_67
(and different variations of this).
How would I w...
social_CA_FR_bloom_build
or this:
social_DE_bloom_trgj4_67
(and different variations of this).
How would I w...
Clickstream data in BigQuery - filtering customDimensions and customEvents simultaneously: http://stackoverflow.com/questions/42631498/clickstream-data-in-bigquery-filtering-customdimensions-and-customevents-simul
Managing data in two relational databases in a single location: http://stackoverflow.com/questions/42637658/managing-data-in-two-relational-databases-in-a-single-location
Drawing annotations over mapbox map: http://stackoverflow.com/questions/42531256/drawing-annotations-over-mapbox-map
Stackoverflow
Drawing annotations over mapbox map
I am using Mapbox as my mapping library. I am trying to add a functionality where user can draw an annotation and add a comment for it (see image). Now this annotation details (coordinates and mess...