Profile

Cover photo
Felipe Hoffa
Works at Google
3,088 followers|921,440 views
AboutPosts

Stream

Felipe Hoffa

Shared publicly  - 
 
 
Simple but very powerful new feature: write your own functions that can be used in BigQuery queries like built-in ones.
1 comment on original post
2
Add a comment...

Felipe Hoffa

Shared publicly  - 
 
All the NYC Taxi Trips: Now officially shared by the NYC TLC, up-to-date (June 2015) data

https://www.reddit.com/r/bigquery/comments/3fo9ao/nyc_taxi_trips_now_officially_shared_by_the_nyc/
8
3
Jason Hall's profile photoSamantha Hennessey's profile photo
Add a comment...

Felipe Hoffa

Shared publicly  - 
 
 
Saving the world - making your Minecraft server better with +Google Cloud Platform persistent storage and +Docker data volumes

See how to use persistent disks with Docker containers and learn how to schedule regular snapshots to safeguard your Minecraft world. Enjoy!
8 comments on original post
1
Add a comment...

Felipe Hoffa

Shared publicly  - 
 
Open data unleashed: The NYC taxi dataset hackathon

The NYC Taxi and Limo Commission released last year 174 million taxi trips from 2013 through a Freedom of Information Law request. In this video, they unveil the 2014 data on a historical date at the NYU Rudin Center for Transportation:

For the first time in the TLC history, data scientists, civic hackers, graphic designers, analysts, government policymakers, statistics hobbyists, and taxi drivers gathered to discover solutions to the taxi gap, which is estimated to miss out on about 11,000 rides daily.

Discuss: https://www.reddit.com/r/bigquery/comments/3d4ljg/video_open_data_unleashed_the_nyc_taxi_dataset/

NYU recap: http://wagner.nyu.edu/rudincenter/2015/04/taxi-shift-change-hackathon-event-recap/

2013 data and queries: https://www.reddit.com/r/bigquery/comments/28ialf/173_million_2013_nyc_taxi_rides_shared_on_bigquery
7
5
Alex Osterloh's profile photoMandy Waite's profile photo
Add a comment...

Felipe Hoffa

Shared publicly  - 
 
BigQuery UI secrets #2: You can auto-complete (press TAB)
18
4
Felipe Hoffa's profile photoRoberto Landrau's profile photoGerry Alvarez's profile photoRatna Koppaka's profile photo
2 comments
 
it's been there for a while :)
Add a comment...

Felipe Hoffa

Shared publicly  - 
 
 
This is the most fun we've had in the office in a while. We've even made some of those 'Inceptionistic' art pieces into giant posters. Beyond the eye candy, there is actually something deeply interesting in this line of work: neural networks have a bad reputation for being strange black boxes that that are opaque to inspection. I have never understood those charges: any other model (GMM, SVM, Random Forests) of any sufficient complexity for a real task is completely opaque for very fundamental reasons: their non-linear structure makes it hard to project back the function they represent into their input space and make sense of it. Not so with backprop, as this blog post shows eloquently: you can query the model and ask what it believes it is seeing or 'wants' to see simply by following gradients. This 'guided hallucination' technique is very powerful and the gorgeous visualizations it generates are very evocative of what's really going on in the network.
35 comments on original post
2
Add a comment...
Have them in circles
3,088 people
Higinio Juan Castro Rodriguez's profile photo
Dennis McCunney's profile photo
César Rodríguez R.'s profile photo
Francisco Peteh Betancourt's profile photo
Gonzalo Serrano's profile photo
Catalin Teodorescu's profile photo
Victoria D.'s profile photo
Michael Rainey's profile photo
noureddine shami's profile photo

Felipe Hoffa

commented on a post on Blogger.
Shared publicly  - 
 
BigQuery JavaScript User Defined Functions finally available for everyone! Also see a video we taped last year while the BigQuery JS UDF were being developed: https://www.youtube.com/watch?v=6TYA6hy44Jo
1
Felipe Hoffa's profile photo
 
Also released plenty of new features (UDFs, GCS file reading, > quota, UI, no more EACH, speed, slots, high compute pricing)

http://googlecloudplatform.blogspot.com/2015/08/Google-BigQuery-adds-UDF-support-for-deeper-cloud-analytics.html
Add a comment...

Felipe Hoffa

Shared publicly  - 
 
All the NYC Taxi Trips: Now officially shared by the NYC TLC, up-to-date (June 2015) data

https://www.reddit.com/r/bigquery/comments/3fo9ao/nyc_taxi_trips_now_officially_shared_by_the_nyc/
1
Add a comment...

Felipe Hoffa

Shared publicly  - 
 
When people write "Big Query" I'm all like  (#BigQuery)
11
1
Martin Thielecke (mthie)'s profile photoTodd Kerpelman's profile photoFelipe Hoffa's profile photo
2 comments
 
So "BigQuery" is right, but "AppEngine" is wrong? You cloud people are confusing.
Add a comment...

Felipe Hoffa

Shared publicly  - 
 
Visualizing 8 years of Reddit comments: A short video!

https://www.youtube.com/watch?v=l8MLIfU21pk
7
1
Daniela Ugarte Cisternas's profile photoJason Baumgartner's profile photoFelipe Hoffa's profile photo
2 comments
 
Great work!  This really illustrates the power of BigQuery when applied to social media.  There is just so much that can be done with this data.
Add a comment...

Felipe Hoffa

Shared publicly  - 
 
 
We recently switched from Godaddy dedicated servers to Google Cloud Compute VM servers and due to that, our system was running nice and cool during this record usage. Here's the CPU track showing a maximum of 27.5% utilization at the time of the record. Our (former) Godaddy server would have collapsed under this load. Godaddy doesn't offer a server powerful enough to handle our requirements. Google Cloud Compute offers plenty of power for about the same cost as the maxed out Godaddy system offered.
2 comments on original post
4
Add a comment...
People
Have them in circles
3,088 people
Higinio Juan Castro Rodriguez's profile photo
Dennis McCunney's profile photo
César Rodríguez R.'s profile photo
Francisco Peteh Betancourt's profile photo
Gonzalo Serrano's profile photo
Catalin Teodorescu's profile photo
Victoria D.'s profile photo
Michael Rainey's profile photo
noureddine shami's profile photo
Work
Occupation
Developer Advocate
Employment
  • Google
    Developer Advocate, 2013 - present
  • Google
    Software engineer, 2011 - present
Story
Tagline
From Chile. Working at Google. Living in San Francisco.
Bragging rights
"I find a duck's opinion of me is very much influenced by whether or not I have bread." --MH