Liquibase - liquibaseSchemaName parameter not working with Redshift

Community Answers
3

Below queries ran in order fixed the issue:

--run these ddls before first Liquibase run in target database
CREATE SCHEMA IF NOT EXISTS liquibase_non_prd;

GRANT ALL ON SCHEMA liquibase_non_prd TO GROUP readonly;
GRANT ALL ON SCHEMA liquibase_non_prd TO GROUP readwrite;

ALTER DEFAULT PRIVILEGES IN SCHEMA liquibase_non_prd GRANT ALL ON TABLES TO GROUP readonly;
ALTER DEFAULT PRIVILEGES IN SCHEMA liquibase_non_prd GRANT ALL ON TABLES TO GROUP readwrite;


--run these ddls after first Liquibase run in target database
GRANT ALL ON TABLE  liquibase_non_prd.chg_lg_lck_t TO GROUP readonly;
GRANT ALL ON TABLE  liquibase_non_prd.chg_lg_lck_t TO GROUP readwrite;

GRANT ALL ON TABLE  liquibase_non_prd.chg_lg_t TO GROUP readonly;
GRANT ALL ON TABLE  liquibase_non_prd.chg_lg_t TO GROUP readwrite;