Page tree

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.


Database NameDatabaseIdDescription
Main DB


Stores users and metadata for flows, including datasets, and recipes.
Jobs DBtrifacta-activitiStores and maintains job execution status and details.
Scheduling DBtrifactaschedulingserviceStores metadata for scheduled jobs.
Time-based Trigger DBtrifactatimebasedtriggerserviceAdditional database required for scheduled jobs.
Configuration Service DBtrifactaconfigurationserviceStores configuration settings for the workspace.
Artifact Storage Service DBtrifactaartifactstorageservice

Stores feature usage data such value mappings for the standardization feature.

Job Metadata Service DBtrifactajobmetadataserviceStores metadata on job execution.

For more information on setting up these databases, see Install Databases.


Code Block



Code Block



NOTE: The following commands are for PostgreSQL 9.6 for all supported operating systems. For specific commands for other versions, please see the database documentation.


Tip: You may see performance improvements by backing up and restoring using .TAR files. However, there is a risk that .TAR support could change in the future. For more information, please see the PostgreSQL documentation.

Trifacta DB:

Code Block
pg_dump trifacta > trif_triDB_bkp_<date>.sql