Connecting to Google BigQuery from Microsoft Excel-Part 1

The following are the resources you need to do what is shown in the demo.

• https://cloud.google.com/bigquery/partners/simba-drivers/
• Microsoft Excel
• Google BigQuery.

This is the query that was used in the demo.

[code language=”sql”]
SELECT STRFTIME_UTC_USEC(pickup_datetime,’%Y-%m’) as TripMonth
, SUM(trip_distance) as total_trip_distance
, SUM(fare_amount) as total_fare_amount
, SUM(extra) as total_extra_amount
, SUM(mta_tax) as total_mta_tax
, SUM(tip_amount) as total_tip_amount
, SUM(tolls_amount) as total_tolls_amount
, SUM(ehail_fee) as total_ehail_fee
, SUM(total_amount) as total_paid_amount
FROM [nyc-tlc:green.trips_2014]
GROUP BY TripMonth
ORDER BY TripMonth
[/code]