The Optimizer service manages optimizations of job executions that involve queries to relational sources. Based on the enabled optimizations, the service can tune the SQL to optimize queries for better performance and less data transfer.
The Optimizer service database must be installed. This database is installed as part of normal install and upgrade operations. For more information, see Install Databases.
- You can apply this change through the Admin Settings Page (recommended) or
trifacta-conf.json. For more information, see Platform Configuration Methods.
Locate the following configuration:
- Verify that the
enabledparameter is set to
- Additional configuration settings are described below.
|Set this value to |
|Host of the Optimizer service. Leave this value as |
Port number that Optimizer service uses to communicate. Default value is
When set to
This value should be set to
The following parameters can be modified as needed.
Maximum time in seconds that the service is permitted to optimize a job. If this time is exceeded, the service errors out, and the job proceeds without optimization. Default value is
This value may be increased if optimization is desired for any of the following:
Maximum number of passes the service is permitted to make on a recipe to optimize a job. If this number of passes is exceeded, the job is partially optimized. Default value is
This value may be increased if the full suite of optimizations is desired for complex recipes with more than 100 steps.
Enable for workspace users
A workspace administrator must enable optimizations for workspace users.
- You apply this change through the Workspace Settings Page. For more information, see Platform Configuration Methods.
Locate the following setting and set it to
- Users can now optimize jobs at the flow level. See below.
Enable optimizations for individual flows
For an individual flow, you can specify the set of optimizations to apply to the job. In Flow View, select Optimization settings from the flow context menu. For more information, see Flow Optimization Settings Dialog.
You can configure how logging is managed for the Optimizer service. For more information on configuring logging for the Optimizer service, see Configure Logging for Services.
This page has no comments.