Error: `schema "cdb_observatory" does not exist`

[csobier]

Reported by @andy-esch , some of the code snippets have cdb_observatory.<function_name>, but carto throws errors schema "cdb_observatory" does not exist.

This seems to be specific to the Discovery Functions only. The other OBS functions don’t have that prefix?

• original code stored here: https://github.com/CartoDB/observatory-extension/blob/develop/doc/discovery_functions.md
• live docs pulling from this repo: https://carto.com/docs/carto-engine/data/discovery-functions/

@hannahblue, can you try to track when this change was implemented, and let me know what the new doc requirements are?

[hannahblue]

@ramiroaznar can the Response team look into this please?

cc @juanignaciosl

[ramiroaznar]

Which ones are returning that error?

[andy-esch]

The code samples list the cdb_observatory schema, but that schema doesn't seem to exist anymore. For example, here's a code snippet from here:

SELECT * FROM cdb_observatory.OBS_GetAvailableNumerators(
  ST_MakeEnvelope(-74, 41, -73, 40, 4326), '{section/tags.united_states, subsection/tags.employment, subsection/tags.age_gender}');

That gives the schema error, but if you remove the cdb_observatory., the function works as expected.

[ramiroaznar]

I think this is not a RT task. DO team should take care of this. And then change the docs accordingly.

[javitonino]

We can just remove the cdb_observatory prefix from the docs, and that's it. Internally, that schema is used, but it should never have been present in the user-facing documentation.

[javitonino]

PR https://github.com/CartoDB/observatory-extension/pull/317