Comparing integers to return Boolean in BigQuery: http://stackoverflow.com/questions/42555042/comparing-integers-to-return-boolean-in-bigquery
Stackoverflow
Comparing integers to return Boolean in BigQuery
Running a big query Select Case When query from the command line. When looking in a string, for a numeric value and casting that to an integer - this needs to be compared to a value and return a bo...
How to perform abundant task in django: http://stackoverflow.com/questions/42555121/how-to-perform-abundant-task-in-django
Stackoverflow
How to perform abundant task in django
I am working on an application where I have to get the data from google BigQuery to local Postgres.
So I am doing the following task in order to achieve this.
Export Table from BigQuery to Google
So I am doing the following task in order to achieve this.
Export Table from BigQuery to Google
Replace space of multiple files inside Google Cloud Storage: http://stackoverflow.com/questions/42557281/replace-space-of-multiple-files-inside-google-cloud-storage
Stackoverflow
Replace space of multiple files inside Google Cloud Storage
I have thousands of jsons on google cloud storage, but they have a specific field name (campaign name)
with a space, but before load (or create an external table) on bigquery I need to replace the ...
with a space, but before load (or create an external table) on bigquery I need to replace the ...
Bigquery - Simba JDBC error with scala anorm: http://stackoverflow.com/questions/42560475/bigquery-simba-jdbc-error-with-scala-anorm
Stackoverflow
Bigquery - Simba JDBC error with scala anorm
I'm trying to query bigquery from scala (2.11.8) using Simba JDBC Driver (bigquery jdbc 4.2) through anorm (2.5.3) and play framework (2.5.8) on Ubuntu 16.04. This si my code:
class BigQueryContro...
class BigQueryContro...
BigQuery - Delete rows from Partitioned Table: http://stackoverflow.com/questions/42561860/bigquery-delete-rows-from-partitioned-table
Stack Overflow
BigQuery - Delete rows from Partitioned Table
I have a Day-Partitioned Table on BigQuery. When I try to delete some rows from the table using a query like:
DELETE FROM `MY_DATASET.partitioned_table` WHERE id = 2374180
I get the following err...
DELETE FROM `MY_DATASET.partitioned_table` WHERE id = 2374180
I get the following err...
Bigrquery Error: oauth_listener() for scheduled script: http://stackoverflow.com/questions/42562108/bigrquery-error-oauth-listener-for-scheduled-script
Stackoverflow
Bigrquery Error: oauth_listener() for scheduled script
I have created a script which pulls data from BigQuery using the bigrquery package. The script works when run manually (does not ask for authorization even when the working directory does not incl...
How to get hits.second in BigQuery?: http://stackoverflow.com/questions/42562319/how-to-get-hits-second-in-bigquery
Stack Overflow
How to get hits.second in BigQuery?
I'm newb on BigQuery. Is-it possible to get hit.second in a way in BigQuery?
My idea would be after to concat hits_time, hits_hour, hits_minute with date to display in a column the date with time (...
My idea would be after to concat hits_time, hits_hour, hits_minute with date to display in a column the date with time (...
How do I convert a BigQuery row to JSON using the C# API?: http://stackoverflow.com/questions/42566229/how-do-i-convert-a-bigquery-row-to-json-using-the-c-sharp-api
Stack Overflow
How do I convert a BigQuery row to JSON using the C# API?
I am pulling some data from a BigQuery table using the code below in C#
BigQueryClient client = BigQueryClient.Create("<Project Name>");
BigQueryTable table = client.GetTab...
BigQueryClient client = BigQueryClient.Create("<Project Name>");
BigQueryTable table = client.GetTab...
BigQuery Window ORDER BY is not allowed if DISTINCT is specified: http://stackoverflow.com/questions/42567564/bigquery-window-order-by-is-not-allowed-if-distinct-is-specified
Stack Overflow
BigQuery Window ORDER BY is not allowed if DISTINCT is specified
I'm investigating porting some bigquery legacy sql containing windowed distinct counts like this
count(distinct brand_id) over (partition by user_id order by order_placed_at range between 7 * 24 *...
count(distinct brand_id) over (partition by user_id order by order_placed_at range between 7 * 24 *...
Is possible to add column(s) to an existing table using the google-cloud-java SDK: http://stackoverflow.com/questions/42567765/is-possible-to-add-columns-to-an-existing-table-using-the-google-cloud-java-sd
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