Introducing the CARTO Spatial Extension for BigQuery
Our Spatial Extension is a suite of functions and procedures that enhance the geospatial capabilities available in BigQuery.
The extension runs natively within BigQuery, leveraging its computational power and scalability and avoiding the need for time consuming ETL processes.
What are the key components of the Spatial Extension for BigQuery?
BigQuery TilerUsing our BigQuery Tiler, visualize massive spatial datasets hosted in BigQuery and easily integrate them into CARTO maps and custom spatial applications.
Data EnrichmentEnhance your spatial analysis using functions to enrich data with thousands of curated datasets from our Data Observatory.
Unlock key spatial functions in BigQuery
The Spatial Extension gives you access to an ever-growing number of geospatial modules that you can use straight from your BigQuery console.
Core functions are open source and free to use for anyone with a BigQuery account.
Incorporate spatial functions seamlessly into your SQL code
SELECT bqcarto.h3.COMPACT( bqcarto.h3.ST_ASH3_POLYFILL(geom,11)) as geo FROM `carto-do-public-data.carto.geography_usa_censustract_2019` WHERE geoid='36061009900') SELECT bqcarto.h3.ST_BOUNDARY(h3) as geom FROM data,UNNEST(geo) as h3``