Workspace Settings Page
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.
Option | Description |
|---|---|
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. |
Disabled | The setting is disabled. |
Edit | Click Edit to enter a specific value for the setting. |
Workspace Name
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.
Hide underlying file system to users
When enabled, workspace users cannot see locations in the default storage layer.
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.
Product walkthroughs
When enabled, new members are led through a tour of the product. After the tour is dismissed, it does not re-appear again to the member.
Note
This feature may need to be enabled in your environment by an administrator. For more information, see Enable Onboarding Tour.
Self service password reset
When enabled, workspace users can reset their own passwords via link on the login page.
Session Tags: Enable the use of session tags when assuming an IAM role
If you are using IAM roles to request temporary credentials for access to AWS resources, you can enable the use of session tags to make those requests. When a session tag is submitted, the Alteryx user is provided access to AWS resources based on the user's corresponding permissions within AWS, instead of having to specify those permissions in Designer Cloud Powered by Trifacta Enterprise Edition. This method leverages the existing permission infrastructure in your enterprise and simplifies the use of IAM roles in the Trifacta Application.
Note
After enabling the use of session tags, you must spin up a new EMR cluster, which forces EMR to use the newly deployed credential provider JAR file.
Note
Additional configuration is required. For more information, seeConfigure AWS Per-User Auth for Temporary Credentials.
Session Tags: The name of the session tag that holds the username as its value
When Session Tags: Enable the use of session tags when assuming an IAM role is enabled, you must specify the name of the session tag to be submitted to AWS containing the username of the Alteryx user requesting resources. Default value is trifacta-user.
For more information, see Configure AWS Per-User Auth for Temporary Credentials.
Session duration
Specify the length of time in minutes before a session expires. Default is 10080 (one week).
Show file location
When enabled, workspace users can see the locations of source and output files within the application.
Storage directories
Allow members of the workspace to change paths to their upload and output results locations through their user profile.
For more information, seeStorage Config Page.
User messaging
When enabled, workspace users can explore content through the Trifacta Application.
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
Connectivity feature
When enabled, workspace users can create connections to relational datasources.
Note
Disabling this feature hides existing relational connections.
See Relational Access.
Enable S3 connectivity
When enabled, base connectivity to S3 is enabled for workspace users.
Note
Additional platform configuration is required. See S3 Access.
Enable conversion of standard JSON files via conversion service
When enabled, the Trifacta Application utilizes the conversion service to ingest JSON files and convert them to a tabular format that is easier to import into the application. For more information seeWorking with JSON v2.
Note
This feature is enabled by default but can be disabled as needed. The conversion process performs cleanup and re-organization of the ingested data for display in tabular format.
When disabled, the Trifacta Application uses the old version of JSON import, which does not restructure the data and may require additional recipe steps to manually structure it into tabular format.
Note
The legacy version of JSON import is required if you are working with compressed JSON files or only Newline JSON files.
Note
Although imported datasets and recipes created under v1 of the JSON importer continue to work without interruption, the v1 version is likely to be deprecated in a future release. You should switch your old imported datasets and recipes to using the new version. Instructions to migrate are provided at the link below.
For more information, see Working with JSON v1.
Upgrade to connectivity
When enabled, workspace users are presented with the option to upgrade to a plan that supports connection to external data sources, if the feature is current disabled.
Upgrade to upload large files
When enabled, workspace users are presented with the option to upgrade to a plan that supports uploading large files, if the feature is current disabled.
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 Alteryx or any system outside of the Designer Cloud Powered by 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.
Note
This feature requires the machine learning service, which is enabled by default. For more information, see Miscellaneous Configuration.
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.
Option | Description |
|---|---|
disabled | Collaborative suggestions are not surfaced in the application. |
personal | Collaborative suggestions are based on the individual user's previous transformations. |
workspace | Collaborative suggestions are based on the transformations from all users in the workspace. |
Default | The 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.
Editor Scheduling
When enabled, flow editors are also permitted to create and edit schedules. For more information, see Flow View Page.
Note
The Scheduling feature may need to be enabled in your environment. When enabled, flow owners can always create and edit schedules.
When this feature is enabled, plan collaborators are also permitted to create and edit schedules. For more information, see Plan View Page.
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.
Plan feature
When enabled, users can create plans to execute sequences of recipes across one or more flows. For more information, see Plans Page.
For more information on plans and orchestration, see Overview of Operationalization.
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 for all types of outputs are typecast to their annotated types. This feature is enabled by default.
For non-schematized outputs, Designer Cloud Powered by Trifacta Enterprise Edition enforces casting of all values to the annotated data type of the column by default. For example, if the output value is -3.4 and the data type for the output column is Integer, the platform enforces Integer type casting and writes a null value instead.
true: All output values must match the data type of the output columns, or a null value is written.false: All output values are written in their output form, regardless of the column's data type.
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.
UI for range join
When enabled, workspace users can specify join key matching across a range of values. For more information, see Configure Range Join.
Webhooks
When enabled, webhook notification tasks can be configured on a per-flow basis in Flow View page. Webhook notifications allow you to deliver messages to third-party applications based on the success or failure of your job executions. For more information, see Create Flow Webhook Task.
Note
Additional configuration may be required. See Configure Webhooks.
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.
For more information on these actions, see Configure for Spark.
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.
Databricks Cluster Policies
When enabled, this feature allows the Designer Cloud Powered by Trifacta platform to leverage cluster policies that you have created for use when creating new Databricks clusters for job execution.
Note
You must create cluster policies before enabling this feature. Each user may select a cluster policy to use. Additional configuration and considerations may be required. If no policy is selected, jobs may still be executed.
For more information:
Databricks Job Management
Enables job execution on Databricks through a secondary method. When enabled, Databricks jobs are executed via the run/submit API endpoint, which avoids the job quota limitation imposed by Databricks clusters. This flag also enables deletion of Databricks jobs from the Databricks workspace.
For more information on these options:
Databricks Job Runs Submit Fallback
When this flag is enabled, users can execute Databricks jobs using the runs/submit API method as a fallback when the job quota limit is reached for a Databricks workspace.
For more information:
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.
Note
This feature requires the optimizer service, which is enabled by default, and the optimizer service database, which is installed by default. For more information on installing the database, see Install Databases.
This workspace setting can be overridden for individual flows. For more information, see Flow Optimization Settings Dialog.
SQL Scripts
When enabled, users may define SQL scripts to execute as part of a job's run. Scripts can be executed before data ingestion, after output publication, or both through any write-supported relational connection to which the user has access.
For more information, see Create Output SQL Scripts.
Photon execution
When enabled, users can choose to execute their jobs on Trifacta Photon, a proprietary running environment built for execution of small- to medium-sized jobs in memory on the Trifacta node.
Tip
When enabled, you can select to run jobs on Photon through the Run Jobs page. The default running environment is the one that is best for the size of your job.
When Trifacta Photon is disabled:
You cannot run jobs on the local running environment. All jobs must be executed on a clustered running environment.
Trifacta Photon is used for Quick Scan sampling jobs. If Trifacta Photon is disabled, the Trifacta Application attempts to run the Quick Scan job on another available running environment. If that job fails or no suitable running environment is available, the Quick Scan sampling job fails.
For more information, see Run Job Page.
Spark Whitelist Properties
Comma-separated list of additional Spark properties to be whitelisted for configuration of output objects while running Spark jobs.
Note
The Custom Spark Options feature must be enabled.
Scheduling and parameterization
Parameterization
By default, Designer Cloud Powered by Trifacta Enterprise Editionsupports the application of parameters to imported datasets. Datetime, wildcard, or variable parameters can be used to operationalize execution of jobs on different versions of the same dataset.
When enabled, users can create parameters, which can be applied to import, creating sample, and outputs. For more information, see Overview of Parameterization.
Schedule list
When enabled, administrators and workspace administrators can see a list of all schedules in the workspace.
Scheduling feature
When enabled, workspace users can schedule the execution of flows. See Add Schedule Dialog.
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.
Publish job results
When enabled, workspace users are permitted to publish results through the Output Destinations tab in the Job Details page to external datastores.
Note
These external datastores must be enabled and configured. See Connection Types.
For more information, see Job Details Page.
Publishing actions
When enabled, users are permitted to create custom publishing actions for their jobs.
When disabled, users must accept the default publishing actions.
For more information, see Run Job Page.
Notifications
Email notifications
When enabled, Designer Cloud Powered by Trifacta Enterprise Edition can send email notifications to users based on the success or failure of jobs.
Note
This feature requires access to an SMTP server to send emails. For more information, see Enable SMTP Email Server Integration.
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:
Setting | Description |
|---|---|
Never | Email notifications are never sent for job failures. |
Scheduled | Notifications are sent only when scheduled jobs fail. |
Ad hoc | Notifications are sent only when ad-hoc (manually executed) jobs fail. Tip Jobs executed via API are |
All | Notifications are sent for all job failures. |
Default | Notifications 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
These experimental features are not supported.
Warning
Experimental features are in active development. Their functionality may change from release to release, and they may be removed from the product at any time. Do not use experimental features in a production environment.
These settings may or may not change application behavior.
Cache data in the Transformer intelligently
When enabled, this feature allows the Trifacta Application to cache data from the Transformer page periodically based on Trifacta Photon execution time. This feature enables users to move faster between recipe steps.
Default language
Note
This experimental feature is not available unless you have been provided a custom build of the Designer Cloud Powered by Trifacta platform for deployment. Otherwise, this setting does nothing.
Select the default language to use in the Trifacta Application.
Execution time threshold (in milliseconds) to control caching in the Transformer
When intelligent caching in the Transformer is enabled, you can set the threshold time in milliseconds for when Trifacta Photon updates the cache. At each threshold of execution time in Trifacta Photon, the output of the intermediate recipe (CDF) steps are cached in-memory, which speeds up movements between recipe steps in the Trifacta Application.
Language localization
Note
This experimental feature is not available unless you have been provided a custom build of the Designer Cloud Powered by Trifacta platform for deployment. Otherwise, this setting does nothing.
When enabled, the Trifacta Application is permitted to display text in the selected language.
Show user language preference
When enabled, individual users can select a preferred language in which to display text in the Trifacta Application.
Note
This experimental feature requires installation of a language resource file on the Trifacta node. For this release, only U.S. English (default) and Korean are supported. For more information, please contact Alteryx Support.
Users can make personal language selections through their preferences. See Account Settings Page.
Wrangle to Python Conversion
Alpha 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.
Warning
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.
Tip
You can download and install the Python SDK to integrate use of the Trifacta Application in your Python environment. Use the visual tools of the Trifacta Application to build your transformations, and then generate Python Pandas code for use in your Python data pipelines. For more information, see Python SDK.