aggregation_tables

[Shoaib Burq]

Hi all

any idea what the following config in `app_config.yml` do.

aggregation_tables:
    host: 'localhost'
    port: '5432'
    dbname: 'dataservices_db'
    username: 'geocoder_api'
    password: ''
    tables:
      admin0: 'ne_admin0_v3'
      admin1: 'global_province_polygons'

I ask coz I get the following errors in my pg logs

2020-02-04 12:07:57 UTC [13953]: [3-1] user=geocoder_api,db=dataservices_db,app=[unknown],client=127.0.0.1 FATAL:  database "dataservices_db" does not exist
2020-02-04 12:07:57 UTC [13952]: [3-1] user=cartodb_user_2ec5b169-248f-4a06-9379-13656c55e437,db=cartodb_user_2ec5b169-248f-4a06-9379-13656c55e437_db,app=cartodb_sqlapi,client=127.0.0.1 ERROR:  PL/Proxy function cdb_dataservices_client._cdb_service_quota_info(2): [dataservices_db] PQconnectPoll: FATAL:  database "dataservices_db" does not exist

It would be great to get an architectural drawing of how data services integrate with the rails app and user accounts.

[Nikita Voloshenko]

Bump. Would like to figure out how this works as well. Especially, does this grant an access to a remote db

[Shoaib Burq]

I have managed to get a little further with this see this: 

https://gist.github.com/sabman/92832fcceea2a805114c29ed218a88e7

If anyone has a potential solution to the issue I'm seeing with permissions on the FDW tables I'd love to get some feedback!

Thanks

Shoaib Burq

--

https://twitter.com/sabman