How to get Forest to track and display SQL Views (Postgres) in the UI?

I don’t seem to be able to find any information on tracking SQL views with Forest from Google.

I’ve connected to my database and all the regular tables are there, but how can I display views or use the underlying queries from views?

Thank you =)

Hello Gavin,

Here is the documentation about SQL views :

Best regards,

Nicolas

Hi @nbouliol is SQL view supported on managed Forestadmin? I can’t find any documentation on what feature is available and refreshing (Sync database schema) does not seem to work

Hello @whollacsek

SQL views are not supported on managed Forest Admin

Hello @nbouliol,
I have the same question but without Sequelize.
I’ve created a new forest-admin project recently with PostgreSQL (and typescript).
I understand the logic with dataSources but it seems that we can’t import views anymore.
Do you have a solution for that?

I’m using:

 "@forestadmin/agent": "^1.29.1",
 "@forestadmin/datasource-sql": "^1.7.27",

Hello @Hugo_LARROUSSE,

Can you please open a different thread? Your problem seems related but not exactly the same as the one discussed here.

Thank you

2 Likes