Menu
Sign In to the Console
AWS Glue
Developer Guide

AWS Documentation » AWS Glue » Developer Guide » Programming ETL Scripts » General Information about Programming AWS Glue ETL Scripts » Format Options for ETL Output in AWS Glue

Format Options for ETL Output in AWS Glue

Various AWS Glue PySpark methods and transforms specify their input and/or output format using a format parameter and a format_options parameter. These parameters can take the following values:

format="avro"

This value designates the Apache Avro data format.

There are no format_options values for format="avro".

format="csv"

This value designates comma-separated-values as the data format (for example, see RFC 4180 and RFC 7111).

You can use the following format_options values with format="csv":

  • separator: Specifies the delimiter character. The default is a comma: ','.

  • escaper: Specifies a character to use for escaping. The default value is "none".

  • quoteChar: Specifies the character to use for quoting. The default is a double quote: '"'. Set this to '-1' to disable quoting entirely.

  • multiline: A Boolean value that specifies whether a single record can span multiple lines. This can occur when a field contains a quoted new-line character. You must set this option to "true" if any record spans multiple lines. The default value is "false", which allows for more aggressive file-splitting during parsing.

  • withHeader: A Boolean value that specifies whether to treat the first line as a header. The default value is "false".

  • skipFirst: A Boolean value that specifies whether to skip the first data line. The default value is "false".

format="ion"

This value designates Amazon Ion as the data format. (For more information, see the Amazon Ion Specification.)

Currently, AWS Glue does not support ion for output.

There are no format_options values for format="ion".

format="grokLog"

This value designates a log data format specified by one or more Logstash grok patterns (for example, see Logstash Reference (6.2]: Grok filter plugin).

Currently, AWS Glue does not support groklog for output.

You can use the following format_options values with format="grokLog":

  • logFormat: Specifies the grok pattern that matches the log's format.

  • customPatterns: Specifies additional grok patterns used here.

  • MISSING: Specifies the signal to use in identifying missing values. The default is '-'.

  • LineCount: Specifies the number of lines in each log record. The default is '1', and currently only single-line records are supported.

  • StrictMode: A Boolean value that specifies whether strict mode is enabled. In strict mode, the reader doesn't do automatic type conversion or recovery. The default value is "false".

format="json"

This value designates a JSON (JavaScript Object Notation) data format.

You can use the following format_options values with format="json":

  • jsonPath: A JsonPath expression that identifies an object to be written. For example, the following JsonPath expression targets the id field of a JSON object: 

    format="json", format_options={"jsonPath": "$.id"}

  • multiline: A Boolean value that specifies whether a single record can span multiple lines. This can occur when a field contains a quoted new-line character. You must set this option to "true" if any record spans multiple lines. The default value is "false", which allows for more aggressive file-splitting during parsing.

format="orc"

This value designates Apache ORC as the data format. (For more information, see the LanguageManual ORC.)

There are no format_options values for format="orc". However, any options that are accepted by the underlying SparkSQL code can be passed to it by way of the connection_options map parameter.

format="parquet"

This value designates Apache Parquet as the data format.

There are no format_options values for format="parquet". However, any options that are accepted by the underlying SparkSQL code can be passed to it by way of the connection_options map parameter.

format="xml"

This value designates XML as the data format, parsed through a fork the XML Data Source for Apache Spark parser.

You can use the following format_options values with format="xml":

  • rowtag: Specifies the XML tag in the file to treat as a row. Row tags cannot be self-closing.

  • encoding: Specifies the character encoding. The default value is "UTF-8".

  • excludeAttribute: A Boolean value that specifies whether you want to exclude attributes in elements or not. The default value is "false".

  • treatEmptyValuesAsNulls: A Boolean value that specifies whether to treat white space as a null value. The default value is "false".

  • attributePrefix: A prefix for attributes to differentiate them from elements. This prefix is used for field names. The default value is "_".

  • valueTag: The tag used for a value when there are attributes in the element that have no child. The default is "_VALUE".

  • ignoreSurroundingSpaces: A Boolean value that specifies whether the white space that surrounds values should be ignored. The default value is "false".

On this page: