Amazon Glue DataBrew · JSON Structure

Glue Databrew Excel Options Structure

Represents a set of options that define how DataBrew will interpret a Microsoft Excel file when creating a dataset from that file.

Type: object Properties: 3
Data AnalyticsData PreparationETLMachine Learning

ExcelOptions is a JSON Structure definition published by Amazon Glue DataBrew, describing 3 properties. It conforms to the https://json-structure.org/meta/core/v0/# meta-schema.

Properties

SheetNames SheetIndexes HeaderRow

Meta-schema: https://json-structure.org/meta/core/v0/#

JSON Structure

Raw ↑
{
  "$schema": "https://json-structure.org/meta/core/v0/#",
  "$id": "https://raw.githubusercontent.com/api-evangelist/amazon-glue-databrew/refs/heads/main/json-structure/glue-databrew-excel-options-structure.json",
  "name": "ExcelOptions",
  "description": "Represents a set of options that define how DataBrew will interpret a Microsoft Excel file when creating a dataset from that file.",
  "type": "object",
  "properties": {
    "SheetNames": {
      "allOf": [
        {
          "$ref": "#/components/schemas/SheetNameList"
        },
        {
          "description": "One or more named sheets in the Excel file that will be included in the dataset."
        }
      ]
    },
    "SheetIndexes": {
      "allOf": [
        {
          "$ref": "#/components/schemas/SheetIndexList"
        },
        {
          "description": "One or more sheet numbers in the Excel file that will be included in the dataset."
        }
      ]
    },
    "HeaderRow": {
      "allOf": [
        {
          "$ref": "#/components/schemas/HeaderRow"
        },
        {
          "description": "A variable that specifies whether the first row in the file is parsed as the header. If this value is false, column names are auto-generated."
        }
      ]
    }
  }
}