Page tree

   

Contents:


The following settings can be customized for the user experience in your workspace. When you modify a setting, the change is immediately applied to the workspace. To access the page, select User menu > Admin console > Workspace settings.

NOTE: Users may not experience the changed environment until each user refreshes the application page or logs out and in again.

Enablement Options:

NOTE: Any values specified in the Workspace Settings page applies exclusively to the specific workspace and override any system-level defaults.

OptionDescription
Default

The default value is applied. This value may be inherited from higher level configuration.

Tip: You can review the default value as part of the help text.

Enabled

The setting is enabled.

NOTE: If the setting applies to a feature, the feature is enabled. Additional configuration may be required. See below.

DisabledThe setting is disabled.
EditClick Edit to enter a specific value for the setting.

General

Allow listing users

When enabled, individual users review and select from a list of all users in the Trifacta application.

NOTE: When this feature is disabled, users can access other users by providing the login email address of other users in screens such as the sharing dialogs.

Locale

Set the locale to use for inferring or validating data in the application, such as numeric values or dates. The default is United States.

NOTE: After saving changes to your locale, refresh your page. Subsequent executions of the data inference service use the new locale settings.

For more information, see Locale Settings.

Session duration

Specify the length of time in minutes before a session expires. Default is 10080 (one week).

Storage directories

Allow members of the workspace to change paths to their upload and output results locations through their user profile. See Storage Config Page.

User messaging

When enabled, workspace users can explore content through the Trifacta application.

Users can also begin in-app conversations with Trifacta Support.

API

API Access Token

When accessing the REST APIs, you can optionally use a token for simpler use and enhanced security.

NOTE: This feature may not be available in all environments.

NOTE: API access tokens must be enabled to use the API reference documentation available through the User menu.

For more information, see Access Tokens Page.

Allow users to generate access tokens

When enabled, individual workspace users can generate their own personal access tokens, which enable access to REST APIs. For more information, see Manage API Access Tokens.

Maximum lifetime for user generated access tokens (days)

Defines the maximum number of days that a user-generated access token is permitted for use in the product.

Tip: To permit generation of access tokens that never expire, set this value to -1.

For more information, see Manage API Access Tokens.

Connectivity

Custom SQL query

When enabled, users can create custom SQL queries to import datasets from relational tables.

Detect maximum column count in XLSX sheet

When you have enabled the Apache POI method for converting Excel files, you can enable this feature to force the conversion service to detect the maximum number of columns in an Excel sheet before beginning the conversion. This feature can improve detection of the structure of the sheet. For more information, see Import Excel Data.

NOTE: If the Java-based converter is enabled, you should enable Detect maximum column count in XLSX sheet.


NOTE: When enabled, this setting does not apply to files in XLS format.


When disabled, the conversion service uses the Python-based converter, which has been available in the product previously.

For more information, see Import Excel Data.

Enable Apache POI based converter for Excel data ingestion

When this setting is enabled, the conversion service uses the Java-based Apache POI method to convert Excel data for ingestion into the product. 

Tip: You should enable this setting, unless you are experiencing problems during Excel conversion.


Flows, recipes and plans

Collaborative suggestions

If desired, you can enable the inclusion of suggestion cards that are generated from recent use of the Trifacta application. As the application gathers more information about how you or members of your workspace apply transformations to your data, the suggestions become more meaningful for the data that you are processing.

NOTE: No data is shared with Trifacta or any system outside of the Trifacta platform.

These collaborative suggestion cards can be generated from individual usage or from workspace level usage. These suggestions appear under the Recently Used heading in the side panel.When this feature is enabled, individual users can still choose to opt-out of sharing their usage data with this feature. See User Profile Page.

OptionDescription
disabledCollaborative suggestions are not surfaced in the application.
personalCollaborative suggestions are based on the individual user's previous transformations.
workspaceCollaborative suggestions are based on the transformations from all users in the workspace.
DefaultThe default setting for the workspace is applied.

For more information, see Overview of Predictive Transformation.

Column from examples

When enabled, users can access a tool through the column menus that enables creation of new columns based on example mappings from the selected column. For more information, see Overview of TBE.


Export

When enabled, workspace users are permitted to export their flows and plans. Exported flows can be imported into other workspaces or product editions. 

NOTE: If plans are been enabled in your workspace, enabling this flag applies to flows and plans.

For more information, see Export Flow.

For more information, see Export Plan.

Import

When enabled, workspace users are permitted to import exported flows and plans.

NOTE: If plans have been enabled in your workspace, enabling this flag applies to flows and plans.

For more information, see Import Flow.

For more information, see Import Plan.

Sample downloads

When enabled, members can download the contents of the Transformer page at any time. For an individual step, a member can download the current sample, as modified by the current recipe up to the point of the current step. For more information, see Recipe Panel.

Schematized output

When enabled, all output columns are typecast to their annotated types. This feature is enabled by default.

Sharing

When enabled, workspace users are permitted to share flows and plans with other users in the workspace.

NOTE: If plans have has been enabled in your workspace, enabling this flag applies to flows and plans.

For more information, see Share a Flow.

For more information, see Share a Plan.

Job execution

Combine Spark Transform and Profile jobs into one.

When enabled, the transform and profiling tasks of a job executed on the Spark running environment are combined. The profiling task is executed as a part of the transform task, which eliminates any time spent orchestrating the profiling task and accessing the profiler input file on storage.

NOTE: When these two tasks are combined, publishing actions are not undertaken if the profiling task fails.

In the Job Details page, combined jobs appear in a Transform with profile card. See Job Details Page.

Custom Spark Options Feature

When enabled, users can override Spark configuration options for output objects before running Spark jobs.

Tip: When enabled, a default set of Spark configuration options is available for users. Additional properties can be specified through the Spark Whitelist Properties setting.



Logical and physical optimization of jobs

When enabled, the Trifacta application attempts to optimize job execution through logical optimizations of your recipe and physical optimizations of your recipes interactions with data.

This workspace setting can be overridden for individual flows. For more information, see Flow Optimization Settings Dialog.

Scheduling and parameterization





Publishing

Avro output format

When enabled, members can generate outputs in Avro format.

CSV output format

When enabled, members can generate outputs in CSV format.

Hyper output format

When enabled, members can generate outputs in Hyper format for publication and use on Tableau Server.

JSON output format

When enabled, members can generate outputs in JSON format.

Parquet output format

When enabled, members can generate outputs in Parquet format.

Notifications

Email notifications

When enabled,  Trifacta Wrangler Pro can send email notifications to users based on the success or failure of jobs. 

Email notifications: on job failure

When email notifications are enabled, you can configure the default setting for the types of failed jobs that generate an email to interested stakeholders. The value set here is the default value for each flow in the workspace.

Settings:

SettingDescription
NeverEmail notifications are never sent for job failures.
ScheduledNotifications are sent only when scheduled jobs fail.
Ad hoc

Notifications are sent only when ad-hoc (manually executed) jobs fail.

AllNotifications are sent for all job failures.
DefaultNotifications are sent based on the default settings for the product.

Default setting for job failures is scheduled.

Individual users can opt out of receiving notifications or configure a different email address. See Email Notifications Page

Emailed stakeholders are configured by individual flow. For more information, see Manage Flow Notifications Dialog.

Email notifications: on job success

When email notifications are enabled, you can configure the default setting for the types of successful jobs that generate an email to interested stakeholders. The value set here is the default value for each flow in the workspace.

For more information on the settings, see the previous section. Default setting is never.

Individual users can opt out of receiving notifications or configure a different email address. See Email Notifications Page.

Emailed stakeholders are configured by individual flow. For more information, see Manage Flow Notifications Dialog.

Experimental features


Wrangle to Python Conversion

EXPERIMENTAL FEATURE: When enabled, you can use an API endpoint to generate Python Pandas code that completes the steps required to generate an output in Python.

This feature may be modified or removed in a future release without warning. It is intended for demonstration purposes only and should not be enabled in a production environment.


For more information, see API Workflow - Wrangle Output to Python.

This page has no comments.