Configuring Materialized View database information
In CDP Private Cloud Base, PostgreSQL is configured during the installation of SQL Stream Builder (SSB) as a service. You can review the database configuration for SSB using Cloudera Manager.
Where to find the PostgreSQL database information?
- Go to your cluster in Cloudera Manager.
- Select SQL Stream Builder from the list of services
- Click Configuration.
- Filter down the configuration parameters to Materialized View
Engine.The following information is listed about the PostgreSQL database:
- Database Name
- Database Host
- Database Port
- Database User
- Database Password