CartoDB/analytics-toolbox-core

Function not found: jslibs.turf.ST_BUFFER

cvargas-xbrein opened this issue · 2 comments

cvargas-xbrein commented

I am executing a query in BigQuery, but this is not working, I get the following error:

Function not found: jslibs.turf.ST_BUFFER at [2: 3]

But this line works perfectly:
SELECT jslibs.turf.ST_BUFFER (ST_GEOGPOINT (-33.2187979, -70.6843369), 1000, 'meters', 10) AS geo;

image

image

Algunenano commented

Hi there, Is it possible that you are not running your query in the US region?

Functions can't be shared across regions so the extension currently only support the US (jslibs.turf.ST_BUFFER) and EU (jslibs.eu_turf.ST_BUFFER) multi regions. To use it on other regions or under VPC you'll need to deploy them yourself in your own project.

  • 👍2
vdelacruzb commented

Closing this issues as we finally have deployed ST_BUFFER under the new repo structure.
Please use:
bqcarto.transformation.ST_BUFFER
and in Europe:
bqcartoeu.transformation.ST_BUFFER

Example:
SELECT bqcarto.transformation.ST_BUFFER(ST_GEOGPOINT(-74.00, 40.7128), 1, 'kilometers', 10);

  • 👍1