Error in courses/machine_learning/deepdive2/launching_into_ml/labs/python.BQ_explore_data.ipynb lab
VeerMuchandi opened this issue · 2 comments
VeerMuchandi commented
The queries to BQ to extract trips from the dataset fail
%%bigquery
SELECT
FORMAT_TIMESTAMP(
"%Y-%m-%d %H:%M:%S %Z", pickup_datetime) AS pickup_datetime,
pickup_longitude, pickup_latitude, dropoff_longitude,
dropoff_latitude, passenger_count, trip_distance, tolls_amount,
fare_amount, total_amount
# TODO 3: Set correct BigQuery public dataset for nyc-tlc yellow taxi cab trips
# Tip: For projects with hyphens '-' be sure to escape with backticks ``
FROM
LIMIT 10
Here is the error
Could not save output to variable 'trips'.
ERROR:
_blocking_poll() got an unexpected keyword argument 'retry'
yingding commented
You need to pin down the dependency of the google-cloud-bigquery, please use
!pip install --user google-cloud-bigquery==1.25.0 google-api-core==1.33.2
in cell 2