This section describes how to configure the Sisense environment with the properties defined above. Configurations are applied globally (for all cubes) via CLI commands.
Create two yaml files, for Storage and Connections, to be used to update the Sisense environment configurations: Storage yaml holds the intermediate storage details
- storageType: AMAZON_S3
accessKey: the access key if needed for authentication.
secretKey: the secret key if needed for authentication.
bucketName: the staging bucket name
bucketRegion: the bucket region
Connections yaml holds the CDWH details
- connectionString: host_string:port
user: the user name
password: the password for the user above
role: which role related to the user (required only for Snowflake connections)
database: database name
permissions: what permissions granted to the role defined (e.g writer)
buildDestination: destination (e.g redshift)