Install Yellowfin on PostgreSQL specific schema

Eric Hagfors ●

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

1

Eric Hagfors ● ●

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

Reply URL

1

Victor Cardenas ●

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

Thanks for the promptness in answering.

Reply URL

1

Eric Hagfors ●

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

Best,

Eric

Reply URL

Install Yellowfin on PostgreSQL specific schema

Replies (3)