medium_agc1_bq1.sql

#standardSQL
SELECT
  ...,
  station.lon AS station_longitude
FROM
  `bigquery-public-data.noaa_gsod.gsod{{execution_date.year-8}}` AS gsob
JOIN
  `bigquery-public-data.noaa_gsod.stations` AS station
ON
  CAST(gsob.stn AS INT64)=station.usaf
  AND CAST(gsob.wban AS INT64)=station.wban
WHERE
    CAST(CONCAT(CAST((CAST(year AS INT64) + 8) AS STRING),'-',CAST(mo AS STRING),'-',CAST(da AS STRING)) AS DATE)
    = '{{ ds }}'