正规365体育投注

Dark mode beta

You’ve been asking for dark mode for years.
The is finally here.

Change your preferences any time.

Questions tagged [google-bigquery]

Google BigQuery is a Google Cloud Platform product providing serverless queries of petabyte-scale data sets using SQL. BigQuery provides multiple read-write pipelines, and enables data analytics that transform how businesses analyze data.

Filter by
Sorted by
Tagged with
0
votes
2answers
30 views

Values increasing when JOIN Statement is added

I have been having some difficulties with this issue for a few days and I cannot figure it out. (Running this is Bigquery) For a marketing client, I am trying to obtain impressions and clicks per ...
0
votes
0answers
5 views

how we can use bq sdk to authenticate multiuser app

I have shiny app deployed on GCP and I am using gcloud SDK run queries on bigquery. Is it somehow possible to add multiuser authentication on gcloud SDK. I am using bq sdk because it is the only way ...
0
votes
0answers
13 views

Bigquery GIS , how to group coordinates per country using Openstreetmap dataset

I am working with a openstreetmap dataset in Bigquery, I made a query that return a list like this id, Long,lat,name. here is the query I am using SELECT ar.key, ar.value, osm_id, osm_way_id,...
0
votes
0answers
11 views

Were Simba JDBC drivers support Oracle data integrator?

Want to use google Big query as source from Oracle data integrator. Simba drivers were downloaded but having difficulty in getting connected to GBQ from ODI. Any suggestions?
0
votes
0answers
12 views

Project missing in bigQuery but datasets and tables still alive

I'm missing a project that i've been working on a couple of months ago. The datasets are still there in bigquery. Also the project is still in BQ. It's just no longer a project in my cloud platform....
1
vote
1answer
14 views

How to create a date partitioned table while using a loadjob in google Bigquery?

Would someone be able to explain how to create date partitioned table while using a loadjob in google Bigquery using JobConfig. http://cloud.google.com/bigquery/docs/creating-column-partitions#...
0
votes
3answers
23 views

BigQuery subtract elements in array

I was wondering how I could calculate the difference between elements in arrays that have only two elements, by subtracting the lesser from the greater. I started by referring to the code sample from ...
0
votes
1answer
15 views

Is there any way to run a BigQuery script from Google Cloud Datalab?

%%bq query SELECT 2; SELECT 3; Will result in a error. I also tried a more sophisticated approach like a few variations of: import google.datalab.bigquery as bq bq.Query(sql=''' SELECT 2; SELECT 3; ...
-1
votes
0answers
9 views

Not able to update Big query table with Transfer from a Storage file

I am not able to update a big query table from a storage file. I have latest data file and transfer runs successfully. But it say "8:36:01 AM Detected that no changes will be made to the destination ...
1
vote
1answer
14 views

Rename BigQuery columns in Apache Beam

I try to rename bigquery rows in an Apache Beam Pipeline in Python like in the following example : Having 1 PCollection with the full data and 1 other with only 3 fields renamed col1 in col1.2, col2 ...
0
votes
1answer
15 views

How to compare hard-coded values with table data in BigQuery?

I want to compare hard-coded values with table metadata (columns, data_types). How to realize in BigQuery the following usual SQL logic? (select 'complaint_type' as column_name, 'STRING' as data_type ...
0
votes
1answer
20 views

Writing a dataframe back to BQ table

job_config = bigquery.LoadJobConfig() # job_config.autodetect = True # job_config.source_format = bigquery.SourceFormat.NEWLINE_DELIMITED_JSON job_config = bigquery.LoadJobConfig(schema=[ ...
0
votes
1answer
19 views

Using EXCEPT keyword in BigQuery with non-table values

I want to compare table metadata (columns, data_types) with some hardcoded values. How to realize in BigQuery the following usual SQL logic? select column_name, data_type from `bigquery-public-data....
0
votes
0answers
12 views

INT32 type error when scanning parquet federated table. Bug or Expected behavior?

I am using BigQuery to query an external data source (also known as a federated table), where the source data is a hive-partitioned parquet table stored in google cloud storage. I used this guide to ...
0
votes
1answer
23 views

Insert data into / creating a sharded/wildcard table in BigQuery

There is a lot of documentation on gcp about querying sharded/wildcard tables [1][2], but I can't seem to figure out how to create or insert data into such as table. Here's a trivial and mostly ...

15 30 50 per page
1
2 3 4 5
875