Access data in PostgreSQL
Last updated
Was this helpful?
Last updated
Was this helpful?
In order to make the Data Observatory subscriptions accessible in your PostgreSQL database, first of all CARTO needs to create and register your subscriptions in your CARTO account. Once this first step has been done, Admin users of your CARTO organization will be able to see the list of active subscriptions in the Data Observatory section in Settings.
Once your subscriptions have been created, the CARTO team will proceed with the data transfers so to make the data accessible directly on your PostgreSQL database. Please contact your CARTO representative if you need to start this process on demand (e.g. public data subscriptions).
In order to make your subscriptions available in your PostgreSQL database, CARTO will share you access to the data in an GCS bucket. We will give you the instructions in order to create the tables in the PostgreSQL database by loading the files directly from the GCS bucket.
As a prerequisite, you should have PSQL installed and working from the terminal.
In order to use the data from your Data Observatory subscriptions that have been transferred directly to your PostgreSQL database you should not use the Data Observatory tabs in Data Explorer, Workflows or Builder, but directly your own PostgreSQL connections.
