Install Yellowfin on PostgreSQL specific schema

Victor Cardenas shared this question 3 months ago
Answered

Hi, is it possible to use a specific PostgreSQL database schema for Yellowfin installation?
Right now it creates everything in the "public" schema.
 

Best Answer
photo

Hi Victor,

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?

Thanks,

Eric

Comments (3)

photo
1

Hi Victor,

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?

Thanks,

Eric

photo
1

Thank you very much, that approach to achieve it is totally reasonable and will serve my purpose perfectly.


Thanks for the promptness in answering.

photo
1

Glad to help, Victor! I'll go ahead and mark this questioned as Answered, have a good day!

Best,

Eric