...
| Database Name | DatabaseId | Description |
|---|---|---|
| Main DB |
| Stores users and metadata for flows, including datasets, and recipes. |
| Jobs DB | trifacta-activiti | Stores and maintains job execution status and details. |
| Scheduling DB | trifactaschedulingservice | Stores metadata for scheduled jobs. |
| Time-based Trigger DB | trifactatimebasedtriggerservice | Additional database required for scheduled jobs. |
| Configuration Service DB | trifactaconfigurationservice | Stores configuration settings for the workspace. |
| Artifact Storage Service DB | trifactaartifactstorageservice | Stores feature usage data such value mappings for the standardization feature. |
| Job Metadata Service DB | trifactajobmetadataservice | Stores metadata on job execution. |
For more information on setting up these databases, see Install Databases.
...
| Code Block |
|---|
pg_dump trifactaartifactstorageservice > trif_artifactstorageservDB_bkup_<date>.sql |
Job Metadata Service DB:
| Code Block |
|---|
pg_dump trifactajobmetadataservice > trif_jobmetadataservDB_bkup_<date>.sql |
MySQL
For more information on command options, see https://dev.mysql.com/doc/refman/5.7/en/mysqldump-sql-format.html.
...
| Code Block |
|---|
mysqldump trifactaartifactstorageservice > trif_artifactstorageservDB_bkup_<date>.sql |
Job Metadata Service DB:
| Code Block |
|---|
mysqldump trifactajobmetadataservice > trif_jobmetadataservDB_bkup_<date>.sql |
Scheduling
...
