python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - google-bigquery

Alternative to using cross-join when dealing with two tables with millions of rows

I am following the script below to find the closest lat-lon record on BigQuery. #standardSQL SELECT AS VALUE ARRAY_AGG(STRUCT<id_a INT64, id_b STRING>(a.id, b.id) ORDER BY ST_DISTANCE(a.point, ...
test-img

LKB

google-bigquery

Votes: 0

Answers: 2

Latest Answer

Try below alternative SELECT a_id, b_id FROM ( SELECT a.id a_id, b.id b_id, ST_DISTANCE(a.point, b.point) distance FROM (SELECT id, ST_GEOGPOINT(lon, lat) point FROM `project.dataset.table_a`) a ...
test-img

Mikhail Berlyant

What is the keyboard shortcut for converting code to uppercase in bigquery?

I am new to big-query and I needed to know the shortcut for converting a text or line text into uppercase in macbook. In Teradata and others I used to do ctrl + U. I do not see any shortcuts for such ...
test-img

Scott85044

google-bigquery

Votes: 0

Answers: 1

Latest Answer

You can get to this operation: highlight the text you want uppercased press F1, the command palette will come up use the quick filter to type: upper and choose and by selecting it will run most used...
test-img

Pentium10

How to pass a parameter into bigquery query on colab

I have a Bigquery query on colab: from google.colab import auth auth.authenticate_user() print('Authenticated') project_id = '[your project ID]' sample_count = 2000 df = pd.io.gbq.read_gbq(''' SELE...
test-img

Carlos

python

sql

google-bigquery

google-colaboratory

Votes: 0

Answers: 2

Latest Answer

As far as python cares, the query you're passing to bigquery is a string, so it cannot call your variable. Like this: end_year = max(record.year) # set end_year df = pd.io.gbq.read_gbq(''' SELECT n...
test-img

Mike Karp

Is sharing dataset in the Bigquery is migration?

We need to migrate the data from the old GCP instance to new instance( with new organization node). I am using the "share dataset" option to move the data. It is very convenient approach. Do...
test-img

Radhika

sql

google-cloud-platform

google-bigquery

migration

Votes: 0

Answers: 1

Latest Answer

It's depend on what you want to achieve. The share dataset feature allow other to access the data because you have granted the permission. However, the data doesn't move and still belong to the old GC...
test-img

guillaume blaquiere

Posts

Questions

Blogs

Jobs