CartoDB/analytics-toolbox-core

ST_PLACEKEYWHERE.sql file is empty

garrywilliams opened this issue · 3 comments

garrywilliams commented

Many thanks for making this functionality available.

I've deployed the functions to our own bucket so that we use them against our data in the eu-west2 region.

However, I noticed that the file sql/placekey/ST_PLACEKEYWHERE.sql is empty which breaks the deployment script i.e. it fails and then the other scripts aren't loaded (and subsequent 'function not found' errors if attempting to run queries).

As a work-around I copied the function script from your bucket and updated the file. I can create a PR for this, but probably quicker/easier for you to do?

jatorre commented

Good catch... we really need the continuos integrations test here which will come soon.

I have pushed it and ius deploying now. Curious you could not use the functions on the predefined US region? or is eu-west2 outside the generic eu region?

  • 👍1
garrywilliams commented

Thanks @jatorre. I may have missed some config or referencing somewhere, but the EU region functions were unavailable to the eu-west2 dataset. I also have some data in the EU region and the functions in the EU did work on that data as expected.

jatorre commented