pyapacheatlas.readers.excel.ExcelReader.make_template

static ExcelReader.make_template(filepath, **kwargs)

Generate an Excel template file and write it out to the given filepath.

Parameters

• filepath (str) – The file path to store an XLSX file with the template Tables and Columns sheets.

• bulkEntity_sheet (str) – Defaults to “BulkEntities”

• updateLineage_sheet (str) – Defaults to “UpdateLineage”

• columnMapping_sheet (str) – Defaults to “ColumnMapping”

• entityDef_sheet (str) – Defaults to “EntityDefs”

• classificationDef_sheet (str) – Defaults to “ClassificationDefs”

• include_deprecated (bool) – Set to True if you want to include tabs that have been deprecated. For this release, it includes TablesLineage and FineGrainColumnLineage.

• table_sheet (str) – Defaults to “TablesLineage”

• column_sheet (str) – Defaults to “FineGrainColumnLineage”

• source_prefix (str) – Defaults to “Source” and represents the prefix of the columns in Excel to be considered related to the source table or column.

• target_prefix (str) – Defaults to “Target” and represents the prefix of the columns in Excel to be considered related to the target table or column.

• process_prefix (str) – Defaults to “Process” and represents the prefix of the columns in Excel to be considered related to the table process.

• column_transformation_name (str) – Defaults to “transformation” and identifies the column that represents the transformation for a specific column.