BigQuery: cast to dt.binary results in invalid datatype in compiled SQL

[tswast]

It appears that casting to ibis.expr.datatypes.binary results in BINARY as the data type. The correct name for this data type in BigQuery is BYTES

Code example

import ibis.bigquery
import ibis.expr.datatypes as dt

bigquery_client = ibis.bigquery.connect()
tbl = bigquery_client.table(
    "citibike_trips",
    database="bigquery-public-data.new_york_citibike"
)
expr = tbl[
    tbl["start_station_name"]
    .cast(dt.binary)
    .name("station_hash")
]
sql = expr.compile()
print(sql)

Output

SELECT CAST(`start_station_name` AS BINARY) AS `station_hash`
FROM `bigquery-public-data.new_york_citibike.citibike_trips`

This results in a Type not found: BINARY at [1:48] error when you paste this query in the BigQuery UI.