buffer.sql

select
state_name,

# first, we create the centroid for each state
# then using the buffer function, we create
# a 50 mile buffer around each centroid

# https://docs.carto.com/spatial-extension-bq/sql-reference/transformations/

bqcarto.transformations.st_buffer(
    st_centroid(state_geom),
50, "miles") as geom
from
`bigquery-public-data.geo_us_boundaries.states`