Hi, is it possible to use a specific PostgreSQL database schema for Yellowfin installation?
Right now it creates everything in the "public" schema.
Thanks for reaching out to support with your question.
It is indeed possible to use a specific Postgres schema for your Yellowfin installation! I was able to do so by first creating my desired schema and adding a new login role as the schema owner with full permissions. I then used this login role's credentials in the database setup section of the Yellowfin install process. The installer proceeded to create the table structure inside my newly created schema as opposed to the "public" schema. The application ran as expected in my brief testing.
Hopefully this adequately answers your question?
Thank you very much, that approach to achieve it is totally reasonable and will serve my purpose perfectly.
Thanks for the promptness in answering.
Glad to help, Victor! I'll go ahead and mark this questioned as Answered, have a good day!
Comments have been locked on this page!