Page tree

Release 8.7



Contents:

   

Contents:


This section contains miscellaneous configuration topics to enable minor features of the platform.

Limits

For more information, see Configure Application Limits.

Configure File Format Support

Configure CSV field delimiters

When you publish a CSV file, by default the fields in the file are comma-separated. Optionally, you can configure a different field delimiter.

Tip: During publication, you can specify whether the output file includes double quote marks around each field. For more information, see Run Job Page.

Steps:

  1. You can apply this change through the Admin Settings Page (recommended) or
    trifacta-conf.json
    . For more information, see Platform Configuration Methods.
  2. To enable the feature, verify that the following parameter has been set to true:

    "feature.publishDelimiterQuoteOption.enabled": true,
  3. If you wish to specify the delimiter character using a Unicode value, please set the following to true:

    "feature.publishDelimiterQuoteOption.enableUnicodeCSVDelimiters": true,
  4. Search for the following parameter:

    "webapp.outputCsvDelimiter"
  5. In the textbox, enter the string that is used as the delimiter.
    1. Strings can be more than one character in length.
    2. If you have enabled the Unicode CSV delimiters feature, you can enter Unicode characters in the following format:

      \uXXXX

      where XXXX is the Unicode value for the character.

      NOTE: The delimiter value is used as the default value for each job. The default can be overridden on a per-job basis. For more information, see Run Job Page.

  6. Save your changes.

Supported Filename Extensions

You cannot upload a file with an unsupported or unlisted file extension. As needed, you can add extensions to the list of supported file formats, which enables the file to be uploaded. 

  • Extensions are case-sensitive. .xml and .XML must both be listed.
  • A leading period is required.

NOTE: Even if the file extension is added to this list, the platform may not be able to process the file. For more information, see Supported File Formats.


NOTE: The Trifacta platform prevents the uploading of files with extensions that are disabled through specific configuration flags. For example, if you disable BZIP2 or Avro files, you cannot re-enable them by adding their extensions to this configuration list.


Steps:

  1. You can apply this change through the Admin Settings Page (recommended) or
    trifacta-conf.json
    . For more information, see Platform Configuration Methods.
  2. Locate the following parameter and add file extensions. In the example, two new extensions have been added to the list:

    "webapp.client.allowedFileExtensions": [".log",".LOG"],

    Tip: To allow the uploading of files that do not have a file extension, enter a value of "" (empty string) in the array. Files without extensions are treated as TXT files by the Trifacta platform.

  3. Save your changes and restart the platform.

Infer compression scheme

For imported files, the Trifacta application infers compression based on the filename extension. For example, all files that have the .gz extension at the end of the filename are decompressed as GZIP files. This is the default behavior.

As needed, the Trifacta application can be configured to infer any compression that has been applied to the file based on reading in the few bytes of the file. Based on that data signature, the file is passed to the appropriate internal service for decompression. 

Tip: This method is preferred if it's possible for filename extension to be improperly specified for the compression scheme.

Steps:

  1. You can apply this change through the Admin Settings Page (recommended) or
    trifacta-conf.json
    . For more information, see Platform Configuration Methods.
  2. Locate the following parameter and set it to true:

    "eature.inferCompressionFromFileSignature.enabled": false,
  3. Save your changes and restart the platform.

Enabling Features

For more information on the feature flags to enable or disable features, see Configure Features.

Other Configuration Topics



This page has no comments.