cloudera.exe.prereq_ssb_database role – Set up database and user accounts for SQL Stream Builder

Note

This role is part of the cloudera.exe collection (version 3.0.0).

It is not included in ansible-core. To check whether it is installed, run ansible-galaxy collection list.

To install it use: ansible-galaxy collection install cloudera.exe..

To use it in a playbook, specify: cloudera.exe.prereq_ssb_database.

Entry point main – Set up database and user accounts for SQL Stream Builder

New in cloudera.exe 3.0.0

Synopsis

  • Set up the SQL Stream Builder (SSB) database and its associated user accounts, ensuring proper configuration for SSB operations.

  • Default values are used for the username, password, and database names, but these can be overwritten by setting appropriate variables.

Parameters

Parameter

Comments

database_admin_password

string / required

The password for the database administrative user.

database_admin_user

string / required

The username with administrative privileges to manage the database.

database_host

string / required

The hostname or IP address of the database server to establish the connection.

database_type

string / required

Specifies the type of database to connect to (e.g., PostgreSQL, MySQL, Oracle).

Choices:

  • "postgresql"

  • "mysql"

  • "oracle"

ssb_admin_database

string

The name of the database to be created for SQL Stream Builder.

Default: "ssb_admin"

ssb_admin_password

string

The password for the SQL Stream Builder database user.

Default: "ssb_admin"

ssb_admin_username

string

The username for the SQL Stream Builder database user and owner of the database.

Default: "ssb_admin"

ssb_mve_database

string

The name of the database to be created for Materialized View Engine.

Default: "ssb_mve"

ssb_mve_password

string

The password for the Materialized View Engine database user.

Default: "ssb_mve"

ssb_mve_username

string

The username for the Materialized View Engine database user and owner of the database.

Default: "ssb_mve"

Authors

  • Cloudera Labs