As needed, the Trifacta® databases can be installed as PostgreSQL DBs on Amazon RDS. Amazon Relational Database Service (Amazon RDS) makes it easy to set up, operate, and scale a relational database in the cloud.
- MySQL is not supported for installation on Amazon RDS.
- SSL connectivity is not supported.
NOTE: You can use the suggested defaults below for sizing your RDS instance. If you have questions or concerns about sizing recommendations, please contact Alteryx Support.
- Admin access to an Amazon RDS account
Initialize RDS instance
In your RDS dashboard, click Launch a DB instance.
NOTE: The RDS instance must be launched in the same Amazon region as the Trifacta node.
- For Select Engine: Select PostgresSQL.
- For Production?: Choose Yes if you are deploying the database for a production instance of the Trifacta platform. Otherwise, select No.
- DB Engine:
For the DB details, see below:
NOTE: Except as noted below, properties should be specified according to your enterprise requirements.
- License Model:
- DB Engine Version: For more information on the supported versions of PostgreSQL, see System Requirements.
Allocated Storage: at least
- License Model:
For Advanced Settings, please apply the following settings:
Network and Security:
VPC security group must allow for access from the Trifacta platform.
The port number can be changed as needed. See System Ports.
Populate other properties according to your enterprise requirements.
To complete the set up click Launch DB Instance.
Create a master username and password for the DB instance.
NOTE: In the configuration instructions listed below, this master username is referenced as:
- When the RDS DB instance is up and running, please collect the following information, which is used later:
- Public DNS
- Port Number
- Admin username
- Admin password
Configure the Trifacta platform for RDS
Please complete the following steps to integrate the Trifacta platform with the DB instance you just created.
In the RDS console, you must find the Public DNS endpoint for the RDS instance you created:
Under Instances, expand the name of the instance you created.
The DNS endpoint should be listed under the name in the Endpoint section.
Set the host for each database to the Public DNS endpoint for the RDS instance:
Database Property Main database webapp.database.host Jobs database batch-job-runner.database.host Scheduling database scheduling-service.database.host Time-based Trigger database time-based-trigger-service.database.host Configuration Service database configuration-service.database.host Artifact Storage Service database artifact-storage-service.database.host
To set custom database names, usernames, and passwords:
For each database below, you can review the database name, username, and password.
Database Property Main database webapp.database.name webapp.database.username webapp.database.password Jobs database batch-job-runner.database.name batch-job-runner.database.username batch-job-runner.database.password Scheduling database scheduling-service.database.name scheduling-service.database.username scheduling-service.database.password Time-Based Trigger database time-based-trigger-service.database.name time-based-trigger-service.database.username time-based-trigger-service.database.password Configuration Service database configuration-service.database.name configuration-service.database.username configuration-service.database.password Artifact Storage Service database artifact-storage-service.database.name artifact-storage-service.database.username artifact-storage-service.database.password
- Make changes in the file as needed and save.
Initialize the databases
Use the following steps to initialize the databases required by the platform.
- The installing user must have write permissions to the directory from which the commands are executed.
- The installing user must have sudo privileges.
Switch to the Postgres user. Launch psql.
NOTE: Unless the port number for postgres has been modified, it should be listening at the default value:
Launch psql using the following command, applying the admin password when prompted:
Public DNS value for the RDS instance
Port number value for the RDS instance
Admin username for the RDS instance
Password for admin username
Execute the following commands using the
NOTE: The values in platform configuration must match the values that you use below. Below are the default values.
Configure non-default connections
If you have used non-default values for the username, password, host, or port value for either database, you must update platform configuration.
NOTE: Do not modify the other properties in these sections unless necessary.
The following parameters apply to the Trifacta database only:
Set this value to
|Specifies the maximum permitted idle time for a database connection before it is automatically closed.|
Defines the maximum permitted database connections for the Trifacta database.
Additional parameters are described below.
Scheduling service database
Time-based trigger service database
Configuration service database
Artifact storage service database
Database Parameter Reference
The following generalized parameters apply to one or more of the databases.
Host of the database. Default value is
|Port number for the database. Default value is |
|Name of the database. This value should match what was used during installation.|
|The username to use to connect to the database.|
|Password to use to connect to the database.|
|This value should be set to |
|Name of the database. Do not modify.|
Save your changes and restart the platform.
- To review database logs in RDS, locate the Instance details page in the RDS console.
- Click Recent Events and Logs.
- If your account has the appropriate permissions, all Trifacta database logs are available here.
This page has no comments.