Stack Exchange

Felipe Hoffa

San Francisco, CA, United States

http://www.reddit.com/r/bigquery

Google Developer Advocate: Big data, BigQuery, Cloud.

https://www.reddit.com/r/bigquery
https://medium.com/@hoffa/

top accounts reputation activity favorites subscriptions

Top Questions

Best smartphone for sysadmins?

ssh monitoring remote-access mobile smartphone asked Jun 8 '09 at 19:23

serverfault.com

Stratified random sampling with BigQuery?

sql google-bigquery asked Oct 20 '18 at 0:41

stackoverflow.com

How to get the historical weather for any city with BigQuery?

sql google-bigquery weather opendata asked Jan 15 '16 at 4:57

stackoverflow.com

HAVERSINE distance in BigQuery?

google-bigquery geo asked Feb 6 '17 at 13:11

stackoverflow.com

How can I compute TF/IDF with SQL (BigQuery)

sql google-bigquery text-analysis asked Oct 31 '17 at 5:42

stackoverflow.com

How to simulate a pivot table with BigQuery?

google-bigquery asked Oct 16 '13 at 21:53

stackoverflow.com

Does BigQuery support regular expressions flags?

regex google-bigquery asked Jul 9 '14 at 23:09

stackoverflow.com

How to find the current top questions by number of views? Or the quarterly number of views per question?

discussion data-explorer data-dump statistics data-analysis asked Feb 20 at 23:13

meta.stackexchange.com

I want a “materialized view” of the latest records

google-bigquery asked Oct 25 '18 at 16:18

stackoverflow.com

I have daily tables on BigQuery. How to query the “newest” one?

google-bigquery asked Feb 10 '15 at 1:17

stackoverflow.com

Top Answers

Random Sampling in Google BigQuery

stackoverflow.com

Pros & cons of BigQuery vs. Amazon Redshift

stackoverflow.com

Row number in BigQuery?

stackoverflow.com

BigQuery SQL running totals

stackoverflow.com

BigQuery: SPLIT() returns only one value

stackoverflow.com

Google BigQuery CASE function

stackoverflow.com

STRING to DATE in BIGQUERY

stackoverflow.com

Delete duplicate rows from a BigQuery table

stackoverflow.com

BigQuery datatypes

stackoverflow.com

Google BigQuery pricing

stackoverflow.com

Calculate percentage of group using GROUP BY

stackoverflow.com

How to improve performance of GeoIP query in BigQuery?

stackoverflow.com

How to calculate Session and Session duration in Firebase Analytics raw data?

stackoverflow.com

amazon s3 vs google cloud storage

stackoverflow.com

BigQuery - NULL values

stackoverflow.com

How do you force rank on a node in dot?

stackoverflow.com

Using BigQuery with R for Analyzing Data

stackoverflow.com

Alternative to BigQuery for medium-sized data

stackoverflow.com

How to create temporary table in Google BigQuery

stackoverflow.com

To use or not to use “Zebra Stripes”, or Alternating Row Colors for Tables

ux.stackexchange.com

How to use Bigquery streaming insertall on app engine & python

stackoverflow.com

How to get the historical weather for any city with BigQuery?

stackoverflow.com

Google Big Query SQL - Get Most Recent Column Value

stackoverflow.com

How to Pivot table in Big Query

stackoverflow.com

How to find the most common bi-grams with BigQuery?

stackoverflow.com

Is there a way to select table_id in a Bigquery Table Wildcard Query

stackoverflow.com

What is the meaning of r in REGEXP_EXTRACT(word,r'(\w\w\'\w\w)')

stackoverflow.com

Google App Engine authorization for Google BigQuery

stackoverflow.com

How to do subselects in BigQuery

stackoverflow.com

How to simulate a pivot table with BigQuery?

stackoverflow.com