SNS parameters
The following parameters configure Amazon Simple Notification Service (SNS) notifiers. These parameters can only be set at the database level and some, if unset, fall back to their equivalent S3 parameters.
Notifiers must be disabled and then reenabled for these parameters to take effect:
=> ALTER NOTIFIER sns_notifier DISABLE;
=> ALTER NOTIFIER sns_notifier ENABLE;
| Parameter | Description | Falls back to |
|---|---|---|
| SNSAuth |
ID and secret key for authentication, equivalent to the AccessKeyID and SecretAccessKey in AWS. For example:
Default: "" (empty string) |
AWSAuth |
| SNSCAFile |
File name of the TLS server certificate bundle to use. Setting this parameter overrides the Vertica default CA bundle path specified in the SystemCABundlePath parameter. If set, this parameter overrides the Vertica default CA bundle path specified in the SystemCABundlePath parameter.
Default: "" (empty string) |
AWSCAFile |
| SNSCAPath |
Path Vertica uses to look up TLS server certificates. The file name of the TLS server certificate bundle to use. If set, this parameter overrides the Vertica default CA bundle path specified in the SystemCABundlePath parameter.
Default: "" (empty string) |
AWSCAPath |
| SNSEnableHttps |
Boolean, specifies whether to use the HTTPS protocol when connecting to S3, can be set only at the database level with ALTER DATABASE. If you choose not to use TLS, this parameter must be set to 0. Default: 1 (enabled) |
None |
| SNSEndpoint |
URL of the SNS API endpoint. If this parameter is set to an empty string and the region is specified (either by SNSRegion or its fallback to AWSRegion), Vertica automatically infers the appropriate endpoint. If you use FIPS, you must manually specify a FIPS-compliant endpoint. Default: "" (empty string) |
None |
| SNSRegion |
AWS region for the SNSEndpoint. This parameter can only be configured with one region at a time. Default: "" (empty string) |
AWSRegion |