Geography functions

Preview BigQuery geography functions available in BigQuery compatibility mode. The GEOGRAPHY type is supported; see Data types and the Firebolt GEOGRAPHY type.

Function	Support
`ST_GEOGPOINT`	Supported
`ST_GEOGFROMTEXT`	Supported
`ST_GEOGFROMGEOJSON`	Supported
`ST_GEOGFROMWKB`	Supported
`ST_ASTEXT`	Supported
`ST_ASBINARY`	Supported
`ST_ASGEOJSON`	Supported
`ST_CONTAINS`	Supported
`ST_COVERS`	Supported
`ST_INTERSECTS`	Supported
`ST_DISTANCE`	Supported
`ST_X`	Supported
`ST_Y`	Supported

Other BigQuery ST_* functions are not yet available in this mode. For the full set of Firebolt geospatial functions, see the geospatial functions reference.

⌘I

Overview

Performance and Observability

Security

Self-Managed

Managed service

Guides

SQL reference

Compatibility modes

Release notes

API reference

Legal