Contents:
To centralize common enablement configuration on a per-workspace basis, a number of configuration properties are being migrated from trifacta-conf.json into the Alteryx® application.
- In prior releases, some of these settings may have been surfaced in the Admin Settings page. See Admin Settings Page.
- For more information on configuration in general, see Platform Configuration Methods.
To assist administrators in managing these settings, these section provides a per-release set of updates and a map of old properties to new settings.
- These settings now appear in the Workspace Settings page. To access, from the left menu bar select User menu > Admin console > Workspace settings.
- For more information, see Workspace Settings Page.
Release Updates
Release 7.6
Migrated parameters
The following parameters have been migrated from the Admin Settings page (sourced from trifacta-conf.json) into the Workspace Settings page (sourced from Configuration Service):
Old | New Configuration Service property | Description |
|---|---|---|
aws.s3.enabled | Enable S3 Connectivity | When set to During upgrade, this setting may be disabled in some deployments. If your pre-upgrade environment was connected to S3, please verify that this setting is enabled in the Workspace Settings Page. See Workspace Settings Page. For more information, see Enable S3 Access. |
For more information, see Workspace Settings Page.
Use of Spark native libraries now automatic for EMR and Databricks
Prior to Release 7.6, you could configure Spark to use Spark libraries that were either 1) on the local Alteryx node or 2) available on the cluster and provided by the Spark vendor.
Beginning in Release 7.6, Spark automatically uses the vendor libraries for EMR and Databricks clusters. If you are using a Hadoop version of Spark, you can still choose to use the local libraries.
| Setting | Old value | New Value |
|---|---|---|
spark.useVendorSparkLibraries | Default is false. | Default is NOTE: This value is ignored for EMR and Databricks clusters. |
For more information:
Release 7.1
Unused parameters
| Setting | Changed | Setting Description | Notes |
|---|---|---|---|
| feature.parameterization.maxNumberOfFilesForExecution.databricksSpark | removed | Maximum number of parameterized source files that are permitted to be executed as part of an Azure Databricks job. | Method by which parameterization is now done no longer requires a union operation between source datasets, so this setting was no longer needed. |
Migrate Data Service properties to Configuration Service
Prior to Release 7.1, a number of properties related to the Data Service have been moved from the application.properties configuration file on the Alteryx node into the Configuration Service, where these properties can be better managed across product versions and editions.
NOTE: These properties are not intended for customer modification. If you believe that you need to make changes to these property values, please contact Alteryx Customer Success and Services.
| Old application.properties property | New Configuration Service property |
|---|---|
| com.trifacta.dataservice.oracle.whitelist | dataservice.vendors.oracle.import.whitelist |
| com.trifacta.dataservice.oracle.greylist | dataservice.vendors.oracle.import.greylist |
| com.trifacta.dataservice.oracle.ciphers | dataservice.vendors.oracle.ciphers |
| com.trifacta.dataservice.postgres.greylist | dataservice.vendors.postgres.import.greylist |
| com.trifacta.dataservice.postgres.whitelist | dataservice.vendors.postgres.import.whitelist |
| com.trifacta.dataservice.databricks.whitelist | dataservice.vendors.databricks.import.whitelist |
| com.trifacta.dataservice.hive.whitelist | dataservice.vendors.hive.import.whitelist |
| com.trifacta.dataservice.glue.whitelist | dataservice.vendors.glue.import.whitelist |
| com.trifacta.dataservice.sqlserver.whitelist | dataservice.vendors.sqlserver.import.whitelist |
| com.trifacta.dataservice.sqlserver.greylist | dataservice.vendors.sqlserver.import.greylist |
| com.trifacta.dataservice.sqldatawarehouse.whitelist | dataservice.vendors.sqldatawarehouse.import.whitelist |
| com.trifacta.dataservice.sqldatawarehouse.greylist | dataservice.vendors.sqldatawarehouse.import.greylist |
| com.trifacta.dataservice.snowflake.whitelist | dataservice.vendors.snowflake.import.whitelist |
| com.trifacta.dataservice.snowflake.greylist | dataservice.vendors.snowflake.import.greylist |
| com.trifacta.dataservice.redshift.whitelist | dataservice.vendors.redshift.import.whitelist |
| com.trifacta.dataservice.teradata.whitelist | dataservice.vendors.teradata.import.whitelist |
| com.trifacta.dataservice.teradata.greylist | dataservice.vendors.teradata.import.greylist |
| com.trifacta.dataservice.trifacta.postgresql.fetchSize | dataservice.vendors.postgres.import.fetchSize |
| com.trifacta.dataservice.trifacta.redshift.fetchSize | dataservice.vendors.redshift.import.fetchSize |
| com.trifacta.dataservice.trifacta.oracle.fetchSize | dataservice.vendors.oracle.import.fetchSize |
| com.trifacta.dataservice.trifacta.sqlserver.fetchSize | dataservice.vendors.sqlserver.import.fetchSize |
| com.trifacta.dataservice.trifacta.sources.databricks.enabled | dataservice.vendors.databricks.enabled |
| com.trifacta.dataservice.trifacta.sources.hive.enabled | dataservice.vendors.hive.enabled |
| com.trifacta.dataservice.trifacta.sources.glue.enabled | dataservice.vendors.glue.enabled |
| com.trifacta.dataservice.trifacta.sources.redshift.enabled | dataservice.vendors.redshift.enabled |
| com.trifacta.dataservice.trifacta.sources.postgres.enabled | dataservice.vendors.postgres.enabled |
| com.trifacta.dataservice.trifacta.sources.sqlserver.enabled | dataservice.vendors.sqlserver.enabled |
| com.trifacta.dataservice.trifacta.sources.teradata.enabled | dataservice.vendors.teradata.enabled |
| com.trifacta.dataservice.trifacta.sources.oracle.enabled | dataservice.vendors.oracle.enabled |
| com.trifacta.dataservice.trifacta.sources.bigquery.enabled | dataservice.vendors.bigquery.enabled |
| com.trifacta.dataservice.trifacta.sources.sqldatawarehouse.enabled | dataservice.vendors.sqldatawarehouse.enabled |
| com.trifacta.dataservice.trifacta.sources.snowflake.enabled | dataservice.vendors.snowflake.enabled |
| com.trifacta.dataservice.databricks.publish.type.integer | dataservice.vendors.databricks.publish.typeMap.integer |
| com.trifacta.dataservice.databricks.publish.type.string | dataservice.vendors.databricks.publish.typeMap.string |
| com.trifacta.dataservice.databricks.publish.type.bool | dataservice.vendors.databricks.publish.typeMap.bool |
| com.trifacta.dataservice.databricks.publish.type.float | dataservice.vendors.databricks.publish.typeMap.float |
| com.trifacta.dataservice.databricks.publish.type.datetime | dataservice.vendors.databricks.publish.typeMap.datetime |
| com.trifacta.dataservice.hive.publish.type.integer | dataservice.vendors.hive.publish.typeMap.integer |
| com.trifacta.dataservice.hive.publish.type.string | dataservice.vendors.hive.publish.typeMap.string |
| com.trifacta.dataservice.hive.publish.type.bool | dataservice.vendors.hive.publish.typeMap.bool |
| com.trifacta.dataservice.hive.publish.type.float | dataservice.vendors.hive.publish.typeMap.float |
| com.trifacta.dataservice.hive.publish.type.datetime | dataservice.vendors.hive.publish.typeMap.datetime |
| com.trifacta.dataservice.redshift.publish.type.integer | dataservice.vendors.redshift.publish.typeMap.integer |
| com.trifacta.dataservice.redshift.publish.type.string | dataservice.vendors.redshift.publish.typeMap.string |
| com.trifacta.dataservice.redshift.publish.type.bool | dataservice.vendors.redshift.publish.typeMap.bool |
| com.trifacta.dataservice.redshift.publish.type.float | dataservice.vendors.redshift.publish.typeMap.float |
| com.trifacta.dataservice.redshift.publish.type.datetime | dataservice.vendors.redshift.publish.typeMap.datetime |
| com.trifacta.dataservice.snowflake.publish.type.integer | dataservice.vendors.snowflake.publish.typeMap.integer |
| com.trifacta.dataservice.snowflake.publish.type.string | dataservice.vendors.snowflake.publish.typeMap.string |
| com.trifacta.dataservice.snowflake.publish.type.bool | dataservice.vendors.snowflake.publish.typeMap.bool |
| com.trifacta.dataservice.snowflake.publish.type.float | dataservice.vendors.snowflake.publish.typeMap.float |
| com.trifacta.dataservice.snowflake.publish.type.datetime | dataservice.vendors.snowflake.publish.typeMap.datetime |
| com.trifacta.dataservice.snowflake.publish.type.time | dataservice.vendors.snowflake.publish.typeMap.time |
| com.trifacta.dataservice.snowflake.publish.type.date | dataservice.vendors.snowflake.publish.typeMap.date |
| com.trifacta.dataservice.sqldatawarehouse.publish.type.integer | dataservice.vendors.sqldatawarehouse.publish.typeMap.integer |
| com.trifacta.dataservice.sqldatawarehouse.publish.type.string | dataservice.vendors.sqldatawarehouse.publish.typeMap.string |
| com.trifacta.dataservice.sqldatawarehouse.publish.type.bool | dataservice.vendors.sqldatawarehouse.publish.typeMap.bool |
| com.trifacta.dataservice.sqldatawarehouse.publish.type.float | dataservice.vendors.sqldatawarehouse.publish.typeMap.float |
| com.trifacta.dataservice.sqldatawarehouse.publish.type.datetime | dataservice.vendors.sqldatawarehouse.publish.typeMap.datetime |
| com.trifacta.dataservice.sqldatawarehouse.publish.type.time | dataservice.vendors.sqldatawarehouse.publish.typeMap.time |
| com.trifacta.dataservice.azure.database.resource | dataservice.azure.databaseResource |
| com.trifacta.dataservice.trifacta.hive.forcekint | dataservice.vendors.hive.forcekint |
| com.trifacta.dataservice.trifacta.sources.snowflake.intermediateformat | dataservice.vendors.snowflake.intermediateformat |
| com.trifacta.dataservice.teradata.disable_ordering | dataservice.vendors.teradata.disableOrdering |
| com.trifacta.dataservice.hive.publish.disableDistributedBy | dataservice.vendors.hive.publish.disableDistributedBy |
Release 6.5
Admin Settings or | Workspace setting | Update |
|---|---|---|
| n/a | Show output directory in profile view | This parameter has been hidden, as it is now enabled by default. |
| n/a | Show upload directory in profile view | This parameter has been hidden, as it is now enabled by default. |
Release 6.4.1
Following parameter was moved in this release:
Admin Settings or | Workspace setting | Update |
|---|---|---|
| webapp.connectivity.customSQLQuery.enabled | Enable custom SQL query | Feature is now enabled at the workspace or tier level. For more information on this feature, see Enable Custom SQL Query. |
| webapp.enableTypecastOutput | Schematized output | Feature is now enabled at the workspace or tier level. For more information, see Miscellaneous Configuration. |
Release 6.4
Parameters from Release 6.0 that are no longer available in the Workspace Settings page are now enabled by default for all users.
Some new features for this release may be enabled or disabled through the Workspace Settings page.
Release 6.0
Initial release of the Workspace Settings page. See below for configuration mapping.
Configuration Mapping
The following mapping between old trifacta-conf.json settings and new Workspace settings is accurate for the current release.
Admin Settings or | Workspace setting | Update |
|---|---|---|
| webapp.walkthrough.enabled | Product walkthroughs | |
| webapp.session.durationInMins | Session duration | |
| webapp.enableDataDownload | Sample downloads | |
| webapp.enableUserPathModification | Allow the user to modify their paths | |
| webapp.enableSelfServicePasswordReset | Enable self service password reset | |
| webapp.connectivity.customSQLQuery.enabled | Enable custom SQL query | |
| outputFormats.Parquet | Parquet output format | |
| outputFormats.JSON | JSON output format | |
| outputFormats.CSV | CSV output format | |
| outputFormats.Avro | Avro output format | |
| outputFormats.TDE | TDE output format | |
| feature.scheduling.enabled | Enable Scheduling feature | |
| feature.scheduling.schedulingManagementUI | Scheduling management UI (experimental) | Now hidden. |
| feature.scheduling.upgradeUI | Show users a modal to upgrade to a plan with Scheduling | Now hidden. |
| feature.sendFlowToOtherPeople.enabled | Allow users to send copies of flows to other users | As of Release 6.10, this feature has been removed from the product. |
| feature.flowSharing.enabled | Enable Flow Sharing feature | |
| feature.flowSharing.upgradeUI | Show users a modal to upgrade to a plan with Flow Sharing | Now hidden. |
| feature.enableFlowExport | Allow users to export their flows | |
| feature.enableFlowImport | Allow users to import flows into the platform | |
| feature.hideAddPublishingActionOptions | Forbid users to add non-default publishing actions | |
| feature.hideUnderlyingFileSystem | Hide underlying file system to users | |
| feature.publishEnabled | Enable publishing | |
| feature.rangeJoin.enabled | Enable UI for range join | |
| feature.showDatasourceTabs | Show datasource tabs in the application | |
| feature.showFileLocation | Show file location | |
| feature.showOutputHomeDirectory | Show output directory in profile view | |
| feature.showUploadDirectory | Show upload directory in profile view | |
| metadata.branding | Branding to use in-product for this deployment | Now hidden. |
| webapp.connectivity.enabled | Enable Connectivity feature | |
| webapp.connectivity.upgradeUI | Show users a modal to upgrade to a plan with Connectivity | |
| feature.apiAccessTokens.enabled | API Access Token |
This page has no comments.