Extract data for warehouse, other integrations

Trying to find out what options we have for extracting data which is in the retool hosted database for use in our data warehouse. I understand that it is a postgres database but assume it is multi tenet and we cannot connect directly to it. Is an API endpoint the only method to extract data?

Retool Database quickstart

Hi @Jaye_Howell, welcome to the forum! :wave:

You can connect to your Retool Database from external sources using a PSQL command or a connection URL. To obtain this, navigate to the Retool Database in the UI and click on it. You'll see a dropdown displaying the connection URL:

Screenshot 2024-11-20 at 4.11.40 PM