Schema Info

Schema Name: sfdl_prod_redshift.analytics_dwh_dim_unit_type

created: 2018-02-28 10:52:57
disabled: False
format: raw
id: 254
is_partitioned: False
is_schema_datatyped: True

name:

{
    "database": "sfdl_prod_redshift",
    "table": "analytics_dwh_dim_unit_type"
}

type: redshift

Schema Versions: 15

Version 1717887

created: 2026-04-17 03:35:01

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_unit_type`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_unit_type`\n(\n `audit_id`  bigint , `unit_type_key`  int , `unit_type`  varchar(24) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit_type/2026-04-17/1776414887'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_unit_type"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit_type/2026-04-17/1776414887
id: 1717887
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "unit_type": "2",
    "unit_type_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "unit_type": "varchar(24)",
    "unit_type_key": "int"
}

schema_name_id: 254
schema_scan_id: 162168000
updated: 2026-04-17 03:35:12

Version 1716650

created: 2026-04-16 04:05:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_unit_type`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_unit_type`\n(\n `audit_id`  bigint , `unit_type_key`  int , `unit_type`  varchar(24) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit_type/2026-04-16/1776330318'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_unit_type"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit_type/2026-04-16/1776330318
id: 1716650
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "unit_type": "2",
    "unit_type_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "unit_type": "varchar(24)",
    "unit_type_key": "int"
}

schema_name_id: 254
schema_scan_id: 162113297
updated: 2026-04-16 04:05:48

Version 1715571

created: 2026-04-15 03:50:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_unit_type`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_unit_type`\n(\n `audit_id`  bigint , `unit_type_key`  int , `unit_type`  varchar(24) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit_type/2026-04-15/1776243045'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_unit_type"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit_type/2026-04-15/1776243045
id: 1715571
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "unit_type": "2",
    "unit_type_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "unit_type": "varchar(24)",
    "unit_type_key": "int"
}

schema_name_id: 254
schema_scan_id: 162056522
updated: 2026-04-15 03:51:04

Version 1714291

created: 2026-04-14 04:03:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_unit_type`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_unit_type`\n(\n `audit_id`  bigint , `unit_type_key`  int , `unit_type`  varchar(24) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit_type/2026-04-14/1776157421'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_unit_type"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit_type/2026-04-14/1776157421
id: 1714291
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "unit_type": "2",
    "unit_type_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "unit_type": "varchar(24)",
    "unit_type_key": "int"
}

schema_name_id: 254
schema_scan_id: 162001930
updated: 2026-04-14 04:04:00

Version 1713041

created: 2026-04-13 03:59:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_unit_type`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_unit_type`\n(\n `audit_id`  bigint , `unit_type_key`  int , `unit_type`  varchar(24) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit_type/2026-04-13/1776070705'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_unit_type"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit_type/2026-04-13/1776070705
id: 1713041
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "unit_type": "2",
    "unit_type_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "unit_type": "varchar(24)",
    "unit_type_key": "int"
}

schema_name_id: 254
schema_scan_id: 161943756
updated: 2026-04-13 03:59:34

Version 1711830

created: 2026-04-12 03:50:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_unit_type`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_unit_type`\n(\n `audit_id`  bigint , `unit_type_key`  int , `unit_type`  varchar(24) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit_type/2026-04-12/1775983826'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_unit_type"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit_type/2026-04-12/1775983826
id: 1711830
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "unit_type": "2",
    "unit_type_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "unit_type": "varchar(24)",
    "unit_type_key": "int"
}

schema_name_id: 254
schema_scan_id: 161893652
updated: 2026-04-12 03:50:49

Version 1710621

created: 2026-04-11 03:42:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_unit_type`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_unit_type`\n(\n `audit_id`  bigint , `unit_type_key`  int , `unit_type`  varchar(24) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit_type/2026-04-11/1775896913'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_unit_type"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit_type/2026-04-11/1775896913
id: 1710621
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "unit_type": "2",
    "unit_type_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "unit_type": "varchar(24)",
    "unit_type_key": "int"
}

schema_name_id: 254
schema_scan_id: 161841464
updated: 2026-04-11 03:42:30

Version 1709441

created: 2026-04-10 03:28:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_unit_type`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_unit_type`\n(\n `audit_id`  bigint , `unit_type_key`  int , `unit_type`  varchar(24) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit_type/2026-04-10/1775809670'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_unit_type"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit_type/2026-04-10/1775809670
id: 1709441
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "unit_type": "2",
    "unit_type_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "unit_type": "varchar(24)",
    "unit_type_key": "int"
}

schema_name_id: 254
schema_scan_id: 161786187
updated: 2026-04-10 03:28:36

Version 1708348

created: 2026-04-09 03:51:10

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_unit_type`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_unit_type`\n(\n `audit_id`  bigint , `unit_type_key`  int , `unit_type`  varchar(24) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit_type/2026-04-09/1775724663'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_unit_type"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit_type/2026-04-09/1775724663
id: 1708348
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "unit_type": "2",
    "unit_type_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "unit_type": "varchar(24)",
    "unit_type_key": "int"
}

schema_name_id: 254
schema_scan_id: 161730732
updated: 2026-04-09 03:51:24

Version 1707142

created: 2026-04-08 04:02:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_unit_type`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_unit_type`\n(\n `audit_id`  bigint , `unit_type_key`  int , `unit_type`  varchar(24) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit_type/2026-04-08/1775638866'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_unit_type"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit_type/2026-04-08/1775638866
id: 1707142
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "unit_type": "2",
    "unit_type_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "unit_type": "varchar(24)",
    "unit_type_key": "int"
}

schema_name_id: 254
schema_scan_id: 161676974
updated: 2026-04-08 04:03:03

Version 1705952

created: 2026-04-07 03:54:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_unit_type`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_unit_type`\n(\n `audit_id`  bigint , `unit_type_key`  int , `unit_type`  varchar(24) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit_type/2026-04-07/1775552034'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_unit_type"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit_type/2026-04-07/1775552034
id: 1705952
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "unit_type": "2",
    "unit_type_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "unit_type": "varchar(24)",
    "unit_type_key": "int"
}

schema_name_id: 254
schema_scan_id: 161619845
updated: 2026-04-07 03:54:17

Version 1704697

created: 2026-04-06 03:50:26

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_unit_type`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_unit_type`\n(\n `audit_id`  bigint , `unit_type_key`  int , `unit_type`  varchar(24) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit_type/2026-04-06/1775465419'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_unit_type"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit_type/2026-04-06/1775465419
id: 1704697
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "unit_type": "2",
    "unit_type_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "unit_type": "varchar(24)",
    "unit_type_key": "int"
}

schema_name_id: 254
schema_scan_id: 161561921
updated: 2026-04-06 03:50:40

Version 1703518

created: 2026-04-05 04:00:55

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_unit_type`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_unit_type`\n(\n `audit_id`  bigint , `unit_type_key`  int , `unit_type`  varchar(24) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit_type/2026-04-05/1775379648'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_unit_type"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit_type/2026-04-05/1775379648
id: 1703518
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "unit_type": "2",
    "unit_type_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "unit_type": "varchar(24)",
    "unit_type_key": "int"
}

schema_name_id: 254
schema_scan_id: 161516195
updated: 2026-04-05 04:01:09

Version 1702323

created: 2026-04-04 03:31:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_unit_type`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_unit_type`\n(\n `audit_id`  bigint , `unit_type_key`  int , `unit_type`  varchar(24) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit_type/2026-04-04/1775291511'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_unit_type"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit_type/2026-04-04/1775291511
id: 1702323
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "unit_type": "2",
    "unit_type_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "unit_type": "varchar(24)",
    "unit_type_key": "int"
}

schema_name_id: 254
schema_scan_id: 161460694
updated: 2026-04-04 03:32:11

Version 1701166

created: 2026-04-03 03:52:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_unit_type`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_unit_type`\n(\n `audit_id`  bigint , `unit_type_key`  int , `unit_type`  varchar(24) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit_type/2026-04-03/1775206345'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_unit_type"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit_type/2026-04-03/1775206345
id: 1701166
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "unit_type": "2",
    "unit_type_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "unit_type": "varchar(24)",
    "unit_type_key": "int"
}

schema_name_id: 254
schema_scan_id: 161402360
updated: 2026-04-03 03:52:58

Schema Scans: 15

Last at 2026-04-17 03:35:01

Scan 162168000

duration: 0:00:11.643414

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162168000

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "unit_type": "varchar(24)",
        "unit_type_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_unit_type/2026-04-17/1776414887/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit_type/2026-04-17/1776414887",
        "key": "raw/dwh_dim_unit_type/2026-04-17/1776414887/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_unit_type",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 187632864267205665,
        "service_name": "redshift_unloads",
        "span_id": 13620867400082233637,
        "trace_id": 2117633362976470916
    }
}

running: False
schema_name_id: 254
start_time: 2026-04-17 03:35:01
success: True
trace_id: 2117633362976470916

Scan 162113297

duration: 0:00:14.365300

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162113297

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "unit_type": "varchar(24)",
        "unit_type_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_unit_type/2026-04-16/1776330318/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit_type/2026-04-16/1776330318",
        "key": "raw/dwh_dim_unit_type/2026-04-16/1776330318/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_unit_type",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8135948156371350023,
        "service_name": "redshift_unloads",
        "span_id": 12953480959959810444,
        "trace_id": 3695547880478070832
    }
}

running: False
schema_name_id: 254
start_time: 2026-04-16 04:05:34
success: True
trace_id: 3695547880478070832

Scan 162056522

duration: 0:00:11.704892

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162056522

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "unit_type": "varchar(24)",
        "unit_type_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_unit_type/2026-04-15/1776243045/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit_type/2026-04-15/1776243045",
        "key": "raw/dwh_dim_unit_type/2026-04-15/1776243045/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_unit_type",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 16668602222456351960,
        "service_name": "redshift_unloads",
        "span_id": 6959392234388609563,
        "trace_id": 1923814742939772306
    }
}

running: False
schema_name_id: 254
start_time: 2026-04-15 03:50:53
success: True
trace_id: 1923814742939772306

Scan 162001930

duration: 0:00:11.699851

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162001930

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "unit_type": "varchar(24)",
        "unit_type_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_unit_type/2026-04-14/1776157421/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit_type/2026-04-14/1776157421",
        "key": "raw/dwh_dim_unit_type/2026-04-14/1776157421/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_unit_type",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 2430781850844251842,
        "service_name": "redshift_unloads",
        "span_id": 8634448416307068056,
        "trace_id": 164169898478902169
    }
}

running: False
schema_name_id: 254
start_time: 2026-04-14 04:03:48
success: True
trace_id: 164169898478902169

Scan 161943756

duration: 0:00:11.558158

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161943756

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "unit_type": "varchar(24)",
        "unit_type_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_unit_type/2026-04-13/1776070705/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit_type/2026-04-13/1776070705",
        "key": "raw/dwh_dim_unit_type/2026-04-13/1776070705/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_unit_type",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 16429350283103182649,
        "service_name": "redshift_unloads",
        "span_id": 18056768854621075088,
        "trace_id": 13284144277278470180
    }
}

running: False
schema_name_id: 254
start_time: 2026-04-13 03:59:22
success: True
trace_id: 13284144277278470180

Scan 161893652

duration: 0:00:14.119890

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161893652

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "unit_type": "varchar(24)",
        "unit_type_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_unit_type/2026-04-12/1775983826/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit_type/2026-04-12/1775983826",
        "key": "raw/dwh_dim_unit_type/2026-04-12/1775983826/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_unit_type",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 1877904855343186326,
        "service_name": "redshift_unloads",
        "span_id": 9739193409073876231,
        "trace_id": 5436805577425152035
    }
}

running: False
schema_name_id: 254
start_time: 2026-04-12 03:50:35
success: True
trace_id: 5436805577425152035

Scan 161841464

duration: 0:00:11.597099

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161841464

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "unit_type": "varchar(24)",
        "unit_type_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_unit_type/2026-04-11/1775896913/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit_type/2026-04-11/1775896913",
        "key": "raw/dwh_dim_unit_type/2026-04-11/1775896913/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_unit_type",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 17644732881982716140,
        "service_name": "redshift_unloads",
        "span_id": 10858450358162967926,
        "trace_id": 9005465486692378076
    }
}

running: False
schema_name_id: 254
start_time: 2026-04-11 03:42:18
success: True
trace_id: 9005465486692378076

Scan 161786187

duration: 0:00:14.090757

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161786187

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "unit_type": "varchar(24)",
        "unit_type_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_unit_type/2026-04-10/1775809670/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit_type/2026-04-10/1775809670",
        "key": "raw/dwh_dim_unit_type/2026-04-10/1775809670/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_unit_type",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8151012183211102848,
        "service_name": "redshift_unloads",
        "span_id": 16032711395368087605,
        "trace_id": 9674355202631840484
    }
}

running: False
schema_name_id: 254
start_time: 2026-04-10 03:28:22
success: True
trace_id: 9674355202631840484

Scan 161730732

duration: 0:00:14.137391

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161730732

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "unit_type": "varchar(24)",
        "unit_type_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_unit_type/2026-04-09/1775724663/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit_type/2026-04-09/1775724663",
        "key": "raw/dwh_dim_unit_type/2026-04-09/1775724663/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_unit_type",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3440679007905085246,
        "service_name": "redshift_unloads",
        "span_id": 16668508752829585835,
        "trace_id": 12304731914304458933
    }
}

running: False
schema_name_id: 254
start_time: 2026-04-09 03:51:10
success: True
trace_id: 12304731914304458933

Scan 161676974

duration: 0:00:14.071314

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161676974

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "unit_type": "varchar(24)",
        "unit_type_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_unit_type/2026-04-08/1775638866/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit_type/2026-04-08/1775638866",
        "key": "raw/dwh_dim_unit_type/2026-04-08/1775638866/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_unit_type",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 16803026593743199593,
        "service_name": "redshift_unloads",
        "span_id": 3918279664297239039,
        "trace_id": 1978092203766467759
    }
}

running: False
schema_name_id: 254
start_time: 2026-04-08 04:02:49
success: True
trace_id: 1978092203766467759

Scan 161619845

duration: 0:00:14.096523

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161619845

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "unit_type": "varchar(24)",
        "unit_type_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_unit_type/2026-04-07/1775552034/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit_type/2026-04-07/1775552034",
        "key": "raw/dwh_dim_unit_type/2026-04-07/1775552034/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_unit_type",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13989751527476801877,
        "service_name": "redshift_unloads",
        "span_id": 15939347800756999634,
        "trace_id": 1169158337512987454
    }
}

running: False
schema_name_id: 254
start_time: 2026-04-07 03:54:03
success: True
trace_id: 1169158337512987454

Scan 161561921

duration: 0:00:14.205871

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161561921

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "unit_type": "varchar(24)",
        "unit_type_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_unit_type/2026-04-06/1775465419/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit_type/2026-04-06/1775465419",
        "key": "raw/dwh_dim_unit_type/2026-04-06/1775465419/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_unit_type",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3274886440745731562,
        "service_name": "redshift_unloads",
        "span_id": 2753427548480319742,
        "trace_id": 10398642111366614062
    }
}

running: False
schema_name_id: 254
start_time: 2026-04-06 03:50:26
success: True
trace_id: 10398642111366614062

Scan 161516195

duration: 0:00:14.172215

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161516195

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "unit_type": "varchar(24)",
        "unit_type_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_unit_type/2026-04-05/1775379648/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit_type/2026-04-05/1775379648",
        "key": "raw/dwh_dim_unit_type/2026-04-05/1775379648/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_unit_type",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 9378424533662873337,
        "service_name": "redshift_unloads",
        "span_id": 1053359500171689519,
        "trace_id": 11631150056128169469
    }
}

running: False
schema_name_id: 254
start_time: 2026-04-05 04:00:55
success: True
trace_id: 11631150056128169469

Scan 161460694

duration: 0:00:14.140081

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161460694

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "unit_type": "varchar(24)",
        "unit_type_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_unit_type/2026-04-04/1775291511/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit_type/2026-04-04/1775291511",
        "key": "raw/dwh_dim_unit_type/2026-04-04/1775291511/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_unit_type",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 12106515494351749973,
        "service_name": "redshift_unloads",
        "span_id": 15545248423747392660,
        "trace_id": 631640535122439030
    }
}

running: False
schema_name_id: 254
start_time: 2026-04-04 03:31:57
success: True
trace_id: 631640535122439030

Scan 161402360

duration: 0:00:14.085799

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161402360

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "unit_type": "varchar(24)",
        "unit_type_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_unit_type/2026-04-03/1775206345/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit_type/2026-04-03/1775206345",
        "key": "raw/dwh_dim_unit_type/2026-04-03/1775206345/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_unit_type",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 5874329306575075110,
        "service_name": "redshift_unloads",
        "span_id": 2693083534770342120,
        "trace_id": 14404704957530116830
    }
}

running: False
schema_name_id: 254
start_time: 2026-04-03 03:52:44
success: True
trace_id: 14404704957530116830

Partitions:

count: 0
ddl: None
name: None
state:
```
[]
```
type: None

Schema:

attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "unit_type": "varchar(24)",
    "unit_type_key": "int"
}

created: 2026-04-17 03:35:01

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_unit_type`\n(\n `audit_id`  bigint , `unit_type_key`  int , `unit_type`  varchar(24) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit_type/2026-04-17/1776414887'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_unit_type`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_unit_type"
}

Server:

hostname: schemamanager-5475496c57-7dpqb
name: schema_manager
process_start: 2026-01-09 11:27:47
sf_env: prod
version: 2112174301

Raw:

{
    "name": {
        "created": "2018-02-28 10:52:57",
        "disabled": false,
        "format": "raw",
        "id": 254,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_redshift",
            "table": "analytics_dwh_dim_unit_type"
        },
        "type": "redshift"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "_origin": "string",
            "audit_id": "bigint",
            "unit_type": "varchar(24)",
            "unit_type_key": "int"
        },
        "created": "2026-04-17 03:35:01",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_unit_type`\n(\n `audit_id`  bigint , `unit_type_key`  int , `unit_type`  varchar(24) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_unit_type/2026-04-17/1776414887'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_unit_type`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_unit_type"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}