We have finally completed the refactor and we have now ready all UDF functions under the new system. You can explore documentation about it in our Official documentation
With this update now all functions are fully covered with test and we have a solid CI for new releases. You will notice that we have changed the locations of the functions, you should update to ensure you keep using the latest.
For example:
SELECT jslibs.h3.ST_H3(ST_GEOGPOINT(10,10),11)it is now:
SELECT carto-os.h3.ST_ASH3(ST_GEOGPOINT(10,10),11) If you have questions or want to discuss anything about the CARTO Spatial Extension we have created a Slack channel that you can join here:
The CARTO Spatial Extension for BigQuery is composed of a set of user-defined functions and procedures organized in a set of modules according to the functionality they offer. There are two types of modules: core modules, that are open source and free to use for anyone with a BigQuery account, and advanced modules, only available to CARTO account customers.
Visit the SQL Reference to see the full list of available modules. If you already have a CARTO account, please keep reading to learn how you can access the advanced modules.
The project is divided into modules, which are a set of components under a common geospatial topic, like quadkey or s2 indexes.
We recommend that you pin carto-os in your BigQuery console.
Quadkey is a geospatial index based on WebMercator tiles.
This is a basic module meant to be used as the foundation to create new modules. It doesn't contain any useful functionality.
In addition to the open source modules found here, CARTO also offers customers access to advanced modules to visualize and analyze data.
The CARTO BigQuery Tiler is a solution to visualize massive amounts of data in BigQuery. Here are a few screenshots of some visualizations created with it:
