Schema Info

Schema Name: sfdl_prod_redshift.analytics_reference_unit_group_lookup

created: 2018-05-08 15:05:44
disabled: False
format: raw
id: 426
is_partitioned: False
is_schema_datatyped: True

name:

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

type: redshift

Schema Versions: 15

Version 1717845

created: 2026-04-17 03:18:26

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_unit_group_lookup`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_unit_group_lookup`\n(\n `unit_group_size_key`  int , `unit_group`  varchar(10) , `min_sqft`  int , `max_sqft`  int , `_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/reference_unit_group_lookup/2026-04-17/1776413898'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_unit_group_lookup"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_unit_group_lookup/2026-04-17/1776413898
id: 1717845
processed: 1

raw_data:

{
    "_origin": "4",
    "max_sqft": "3",
    "min_sqft": "2",
    "unit_group": "1",
    "unit_group_size_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "max_sqft": "int",
    "min_sqft": "int",
    "unit_group": "varchar(10)",
    "unit_group_size_key": "int"
}

schema_name_id: 426
schema_scan_id: 162167891
updated: 2026-04-17 03:18:40

Version 1716622

created: 2026-04-16 03:53:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_unit_group_lookup`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_unit_group_lookup`\n(\n `unit_group_size_key`  int , `unit_group`  varchar(10) , `min_sqft`  int , `max_sqft`  int , `_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/reference_unit_group_lookup/2026-04-16/1776329590'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_unit_group_lookup"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_unit_group_lookup/2026-04-16/1776329590
id: 1716622
processed: 1

raw_data:

{
    "_origin": "4",
    "max_sqft": "3",
    "min_sqft": "2",
    "unit_group": "1",
    "unit_group_size_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "max_sqft": "int",
    "min_sqft": "int",
    "unit_group": "varchar(10)",
    "unit_group_size_key": "int"
}

schema_name_id: 426
schema_scan_id: 162112246
updated: 2026-04-16 03:53:44

Version 1715578

created: 2026-04-15 04:01:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_unit_group_lookup`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_unit_group_lookup`\n(\n `unit_group_size_key`  int , `unit_group`  varchar(10) , `min_sqft`  int , `max_sqft`  int , `_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/reference_unit_group_lookup/2026-04-15/1776243691'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_unit_group_lookup"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_unit_group_lookup/2026-04-15/1776243691
id: 1715578
processed: 1

raw_data:

{
    "_origin": "4",
    "max_sqft": "3",
    "min_sqft": "2",
    "unit_group": "1",
    "unit_group_size_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "max_sqft": "int",
    "min_sqft": "int",
    "unit_group": "varchar(10)",
    "unit_group_size_key": "int"
}

schema_name_id: 426
schema_scan_id: 162057532
updated: 2026-04-15 04:01:56

Version 1714230

created: 2026-04-14 03:35:56

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_unit_group_lookup`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_unit_group_lookup`\n(\n `unit_group_size_key`  int , `unit_group`  varchar(10) , `min_sqft`  int , `max_sqft`  int , `_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/reference_unit_group_lookup/2026-04-14/1776155743'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_unit_group_lookup"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_unit_group_lookup/2026-04-14/1776155743
id: 1714230
processed: 1

raw_data:

{
    "_origin": "4",
    "max_sqft": "3",
    "min_sqft": "2",
    "unit_group": "1",
    "unit_group_size_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "max_sqft": "int",
    "min_sqft": "int",
    "unit_group": "varchar(10)",
    "unit_group_size_key": "int"
}

schema_name_id: 426
schema_scan_id: 162000785
updated: 2026-04-14 03:36:07

Version 1713022

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_unit_group_lookup`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_unit_group_lookup`\n(\n `unit_group_size_key`  int , `unit_group`  varchar(10) , `min_sqft`  int , `max_sqft`  int , `_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/reference_unit_group_lookup/2026-04-13/1776070431'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_unit_group_lookup"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_unit_group_lookup/2026-04-13/1776070431
id: 1713022
processed: 1

raw_data:

{
    "_origin": "4",
    "max_sqft": "3",
    "min_sqft": "2",
    "unit_group": "1",
    "unit_group_size_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "max_sqft": "int",
    "min_sqft": "int",
    "unit_group": "varchar(10)",
    "unit_group_size_key": "int"
}

schema_name_id: 426
schema_scan_id: 161943077
updated: 2026-04-13 03:54:21

Version 1711838

created: 2026-04-12 03:55:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_unit_group_lookup`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_unit_group_lookup`\n(\n `unit_group_size_key`  int , `unit_group`  varchar(10) , `min_sqft`  int , `max_sqft`  int , `_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/reference_unit_group_lookup/2026-04-12/1775984104'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_unit_group_lookup"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_unit_group_lookup/2026-04-12/1775984104
id: 1711838
processed: 1

raw_data:

{
    "_origin": "4",
    "max_sqft": "3",
    "min_sqft": "2",
    "unit_group": "1",
    "unit_group_size_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "max_sqft": "int",
    "min_sqft": "int",
    "unit_group": "varchar(10)",
    "unit_group_size_key": "int"
}

schema_name_id: 426
schema_scan_id: 161893763
updated: 2026-04-12 03:55:26

Version 1710648

created: 2026-04-11 04:02:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_unit_group_lookup`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_unit_group_lookup`\n(\n `unit_group_size_key`  int , `unit_group`  varchar(10) , `min_sqft`  int , `max_sqft`  int , `_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/reference_unit_group_lookup/2026-04-11/1775898127'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_unit_group_lookup"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_unit_group_lookup/2026-04-11/1775898127
id: 1710648
processed: 1

raw_data:

{
    "_origin": "4",
    "max_sqft": "3",
    "min_sqft": "2",
    "unit_group": "1",
    "unit_group_size_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "max_sqft": "int",
    "min_sqft": "int",
    "unit_group": "varchar(10)",
    "unit_group_size_key": "int"
}

schema_name_id: 426
schema_scan_id: 161842644
updated: 2026-04-11 04:02:29

Version 1709475

created: 2026-04-10 04:04:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_unit_group_lookup`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_unit_group_lookup`\n(\n `unit_group_size_key`  int , `unit_group`  varchar(10) , `min_sqft`  int , `max_sqft`  int , `_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/reference_unit_group_lookup/2026-04-10/1775811879'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_unit_group_lookup"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_unit_group_lookup/2026-04-10/1775811879
id: 1709475
processed: 1

raw_data:

{
    "_origin": "4",
    "max_sqft": "3",
    "min_sqft": "2",
    "unit_group": "1",
    "unit_group_size_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "max_sqft": "int",
    "min_sqft": "int",
    "unit_group": "varchar(10)",
    "unit_group_size_key": "int"
}

schema_name_id: 426
schema_scan_id: 161787363
updated: 2026-04-10 04:04:57

Version 1708332

created: 2026-04-09 03:46:16

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_unit_group_lookup`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_unit_group_lookup`\n(\n `unit_group_size_key`  int , `unit_group`  varchar(10) , `min_sqft`  int , `max_sqft`  int , `_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/reference_unit_group_lookup/2026-04-09/1775724365'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_unit_group_lookup"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_unit_group_lookup/2026-04-09/1775724365
id: 1708332
processed: 1

raw_data:

{
    "_origin": "4",
    "max_sqft": "3",
    "min_sqft": "2",
    "unit_group": "1",
    "unit_group_size_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "max_sqft": "int",
    "min_sqft": "int",
    "unit_group": "varchar(10)",
    "unit_group_size_key": "int"
}

schema_name_id: 426
schema_scan_id: 161730693
updated: 2026-04-09 03:46:30

Version 1707114

created: 2026-04-08 03:36:10

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_unit_group_lookup`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_unit_group_lookup`\n(\n `unit_group_size_key`  int , `unit_group`  varchar(10) , `min_sqft`  int , `max_sqft`  int , `_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/reference_unit_group_lookup/2026-04-08/1775637357'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_unit_group_lookup"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_unit_group_lookup/2026-04-08/1775637357
id: 1707114
processed: 1

raw_data:

{
    "_origin": "4",
    "max_sqft": "3",
    "min_sqft": "2",
    "unit_group": "1",
    "unit_group_size_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "max_sqft": "int",
    "min_sqft": "int",
    "unit_group": "varchar(10)",
    "unit_group_size_key": "int"
}

schema_name_id: 426
schema_scan_id: 161675823
updated: 2026-04-08 03:36:24

Version 1705914

created: 2026-04-07 03:32:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_unit_group_lookup`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_unit_group_lookup`\n(\n `unit_group_size_key`  int , `unit_group`  varchar(10) , `min_sqft`  int , `max_sqft`  int , `_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/reference_unit_group_lookup/2026-04-07/1775550757'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_unit_group_lookup"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_unit_group_lookup/2026-04-07/1775550757
id: 1705914
processed: 1

raw_data:

{
    "_origin": "4",
    "max_sqft": "3",
    "min_sqft": "2",
    "unit_group": "1",
    "unit_group_size_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "max_sqft": "int",
    "min_sqft": "int",
    "unit_group": "varchar(10)",
    "unit_group_size_key": "int"
}

schema_name_id: 426
schema_scan_id: 161619679
updated: 2026-04-07 03:32:56

Version 1704686

created: 2026-04-06 03:40:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_unit_group_lookup`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_unit_group_lookup`\n(\n `unit_group_size_key`  int , `unit_group`  varchar(10) , `min_sqft`  int , `max_sqft`  int , `_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/reference_unit_group_lookup/2026-04-06/1775464818'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_unit_group_lookup"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_unit_group_lookup/2026-04-06/1775464818
id: 1704686
processed: 1

raw_data:

{
    "_origin": "4",
    "max_sqft": "3",
    "min_sqft": "2",
    "unit_group": "1",
    "unit_group_size_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "max_sqft": "int",
    "min_sqft": "int",
    "unit_group": "varchar(10)",
    "unit_group_size_key": "int"
}

schema_name_id: 426
schema_scan_id: 161561881
updated: 2026-04-06 03:40:38

Version 1703511

created: 2026-04-05 03:58:45

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_unit_group_lookup`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_unit_group_lookup`\n(\n `unit_group_size_key`  int , `unit_group`  varchar(10) , `min_sqft`  int , `max_sqft`  int , `_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/reference_unit_group_lookup/2026-04-05/1775379442'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_unit_group_lookup"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_unit_group_lookup/2026-04-05/1775379442
id: 1703511
processed: 1

raw_data:

{
    "_origin": "4",
    "max_sqft": "3",
    "min_sqft": "2",
    "unit_group": "1",
    "unit_group_size_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "max_sqft": "int",
    "min_sqft": "int",
    "unit_group": "varchar(10)",
    "unit_group_size_key": "int"
}

schema_name_id: 426
schema_scan_id: 161515857
updated: 2026-04-05 03:58:59

Version 1702313

created: 2026-04-04 03:24:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_unit_group_lookup`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_unit_group_lookup`\n(\n `unit_group_size_key`  int , `unit_group`  varchar(10) , `min_sqft`  int , `max_sqft`  int , `_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/reference_unit_group_lookup/2026-04-04/1775291081'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_unit_group_lookup"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_unit_group_lookup/2026-04-04/1775291081
id: 1702313
processed: 1

raw_data:

{
    "_origin": "4",
    "max_sqft": "3",
    "min_sqft": "2",
    "unit_group": "1",
    "unit_group_size_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "max_sqft": "int",
    "min_sqft": "int",
    "unit_group": "varchar(10)",
    "unit_group_size_key": "int"
}

schema_name_id: 426
schema_scan_id: 161460672
updated: 2026-04-04 03:25:04

Version 1701119

created: 2026-04-03 03:34:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_unit_group_lookup`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_unit_group_lookup`\n(\n `unit_group_size_key`  int , `unit_group`  varchar(10) , `min_sqft`  int , `max_sqft`  int , `_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/reference_unit_group_lookup/2026-04-03/1775205236'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_unit_group_lookup"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_unit_group_lookup/2026-04-03/1775205236
id: 1701119
processed: 1

raw_data:

{
    "_origin": "4",
    "max_sqft": "3",
    "min_sqft": "2",
    "unit_group": "1",
    "unit_group_size_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "max_sqft": "int",
    "min_sqft": "int",
    "unit_group": "varchar(10)",
    "unit_group_size_key": "int"
}

schema_name_id: 426
schema_scan_id: 161402144
updated: 2026-04-03 03:34:15

Schema Scans: 15

Last at 2026-04-17 03:18:26

Scan 162167891

duration: 0:00:14.209181

exit_message:

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

id: 162167891

payload:

{
    "datatype_dict": {
        "max_sqft": "int",
        "min_sqft": "int",
        "origin_key": "varchar",
        "unit_group": "varchar(10)",
        "unit_group_size_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_unit_group_lookup/2026-04-17/1776413898/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_unit_group_lookup/2026-04-17/1776413898",
        "key": "raw/reference_unit_group_lookup/2026-04-17/1776413898/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_unit_group_lookup",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 4024270638944452352,
        "service_name": "redshift_unloads",
        "span_id": 12957518915199923330,
        "trace_id": 7561686412207905739
    }
}

running: False
schema_name_id: 426
start_time: 2026-04-17 03:18:26
success: True
trace_id: 7561686412207905739

Scan 162112246

duration: 0:00:12.137543

exit_message:

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

id: 162112246

payload:

{
    "datatype_dict": {
        "max_sqft": "int",
        "min_sqft": "int",
        "origin_key": "varchar",
        "unit_group": "varchar(10)",
        "unit_group_size_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_unit_group_lookup/2026-04-16/1776329590/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_unit_group_lookup/2026-04-16/1776329590",
        "key": "raw/reference_unit_group_lookup/2026-04-16/1776329590/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_unit_group_lookup",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 6736913547405578918,
        "service_name": "redshift_unloads",
        "span_id": 7866467087147481559,
        "trace_id": 4343242561429664751
    }
}

running: False
schema_name_id: 426
start_time: 2026-04-16 03:53:32
success: True
trace_id: 4343242561429664751

Scan 162057532

duration: 0:00:14.241433

exit_message:

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

id: 162057532

payload:

{
    "datatype_dict": {
        "max_sqft": "int",
        "min_sqft": "int",
        "origin_key": "varchar",
        "unit_group": "varchar(10)",
        "unit_group_size_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_unit_group_lookup/2026-04-15/1776243691/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_unit_group_lookup/2026-04-15/1776243691",
        "key": "raw/reference_unit_group_lookup/2026-04-15/1776243691/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_unit_group_lookup",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 7870717819357710142,
        "service_name": "redshift_unloads",
        "span_id": 4239695499061205512,
        "trace_id": 13281437931603758958
    }
}

running: False
schema_name_id: 426
start_time: 2026-04-15 04:01:42
success: True
trace_id: 13281437931603758958

Scan 162000785

duration: 0:00:11.627125

exit_message:

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

id: 162000785

payload:

{
    "datatype_dict": {
        "max_sqft": "int",
        "min_sqft": "int",
        "origin_key": "varchar",
        "unit_group": "varchar(10)",
        "unit_group_size_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_unit_group_lookup/2026-04-14/1776155743/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_unit_group_lookup/2026-04-14/1776155743",
        "key": "raw/reference_unit_group_lookup/2026-04-14/1776155743/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_unit_group_lookup",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 1458823910114802692,
        "service_name": "redshift_unloads",
        "span_id": 13435879956426677424,
        "trace_id": 1318751447085266670
    }
}

running: False
schema_name_id: 426
start_time: 2026-04-14 03:35:55
success: True
trace_id: 1318751447085266670

Scan 161943077

duration: 0:00:14.209440

exit_message:

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

id: 161943077

payload:

{
    "datatype_dict": {
        "max_sqft": "int",
        "min_sqft": "int",
        "origin_key": "varchar",
        "unit_group": "varchar(10)",
        "unit_group_size_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_unit_group_lookup/2026-04-13/1776070431/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_unit_group_lookup/2026-04-13/1776070431",
        "key": "raw/reference_unit_group_lookup/2026-04-13/1776070431/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_unit_group_lookup",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 425383779246778817,
        "service_name": "redshift_unloads",
        "span_id": 1668448847132625713,
        "trace_id": 6135733871221958049
    }
}

running: False
schema_name_id: 426
start_time: 2026-04-13 03:54:07
success: True
trace_id: 6135733871221958049

Scan 161893763

duration: 0:00:14.153565

exit_message:

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

id: 161893763

payload:

{
    "datatype_dict": {
        "max_sqft": "int",
        "min_sqft": "int",
        "origin_key": "varchar",
        "unit_group": "varchar(10)",
        "unit_group_size_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_unit_group_lookup/2026-04-12/1775984104/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_unit_group_lookup/2026-04-12/1775984104",
        "key": "raw/reference_unit_group_lookup/2026-04-12/1775984104/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_unit_group_lookup",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 11641564059892535791,
        "service_name": "redshift_unloads",
        "span_id": 15620799935054399129,
        "trace_id": 1572674271433876425
    }
}

running: False
schema_name_id: 426
start_time: 2026-04-12 03:55:12
success: True
trace_id: 1572674271433876425

Scan 161842644

duration: 0:00:14.108657

exit_message:

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

id: 161842644

payload:

{
    "datatype_dict": {
        "max_sqft": "int",
        "min_sqft": "int",
        "origin_key": "varchar",
        "unit_group": "varchar(10)",
        "unit_group_size_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_unit_group_lookup/2026-04-11/1775898127/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_unit_group_lookup/2026-04-11/1775898127",
        "key": "raw/reference_unit_group_lookup/2026-04-11/1775898127/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_unit_group_lookup",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 18445856215055899117,
        "service_name": "redshift_unloads",
        "span_id": 2470166293773935144,
        "trace_id": 13950020720257314783
    }
}

running: False
schema_name_id: 426
start_time: 2026-04-11 04:02:15
success: True
trace_id: 13950020720257314783

Scan 161787363

duration: 0:00:11.600859

exit_message:

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

id: 161787363

payload:

{
    "datatype_dict": {
        "max_sqft": "int",
        "min_sqft": "int",
        "origin_key": "varchar",
        "unit_group": "varchar(10)",
        "unit_group_size_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_unit_group_lookup/2026-04-10/1775811879/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_unit_group_lookup/2026-04-10/1775811879",
        "key": "raw/reference_unit_group_lookup/2026-04-10/1775811879/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_unit_group_lookup",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13685851745791511219,
        "service_name": "redshift_unloads",
        "span_id": 1919725330862324669,
        "trace_id": 2333186617255524013
    }
}

running: False
schema_name_id: 426
start_time: 2026-04-10 04:04:46
success: True
trace_id: 2333186617255524013

Scan 161730693

duration: 0:00:14.161262

exit_message:

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

id: 161730693

payload:

{
    "datatype_dict": {
        "max_sqft": "int",
        "min_sqft": "int",
        "origin_key": "varchar",
        "unit_group": "varchar(10)",
        "unit_group_size_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_unit_group_lookup/2026-04-09/1775724365/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_unit_group_lookup/2026-04-09/1775724365",
        "key": "raw/reference_unit_group_lookup/2026-04-09/1775724365/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_unit_group_lookup",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 5279265633518271989,
        "service_name": "redshift_unloads",
        "span_id": 16246235507404167259,
        "trace_id": 12292415839969592964
    }
}

running: False
schema_name_id: 426
start_time: 2026-04-09 03:46:16
success: True
trace_id: 12292415839969592964

Scan 161675823

duration: 0:00:14.234220

exit_message:

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

id: 161675823

payload:

{
    "datatype_dict": {
        "max_sqft": "int",
        "min_sqft": "int",
        "origin_key": "varchar",
        "unit_group": "varchar(10)",
        "unit_group_size_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_unit_group_lookup/2026-04-08/1775637357/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_unit_group_lookup/2026-04-08/1775637357",
        "key": "raw/reference_unit_group_lookup/2026-04-08/1775637357/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_unit_group_lookup",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 18187686317262548662,
        "service_name": "redshift_unloads",
        "span_id": 10424386012372885953,
        "trace_id": 4254472851719636128
    }
}

running: False
schema_name_id: 426
start_time: 2026-04-08 03:36:10
success: True
trace_id: 4254472851719636128

Scan 161619679

duration: 0:00:11.581779

exit_message:

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

id: 161619679

payload:

{
    "datatype_dict": {
        "max_sqft": "int",
        "min_sqft": "int",
        "origin_key": "varchar",
        "unit_group": "varchar(10)",
        "unit_group_size_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_unit_group_lookup/2026-04-07/1775550757/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_unit_group_lookup/2026-04-07/1775550757",
        "key": "raw/reference_unit_group_lookup/2026-04-07/1775550757/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_unit_group_lookup",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 1559737082236302912,
        "service_name": "redshift_unloads",
        "span_id": 11395085019448637215,
        "trace_id": 16808807463429625391
    }
}

running: False
schema_name_id: 426
start_time: 2026-04-07 03:32:44
success: True
trace_id: 16808807463429625391

Scan 161561881

duration: 0:00:14.216891

exit_message:

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

id: 161561881

payload:

{
    "datatype_dict": {
        "max_sqft": "int",
        "min_sqft": "int",
        "origin_key": "varchar",
        "unit_group": "varchar(10)",
        "unit_group_size_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_unit_group_lookup/2026-04-06/1775464818/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_unit_group_lookup/2026-04-06/1775464818",
        "key": "raw/reference_unit_group_lookup/2026-04-06/1775464818/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_unit_group_lookup",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 17614642523402547356,
        "service_name": "redshift_unloads",
        "span_id": 9594249633566186053,
        "trace_id": 7485811718333314969
    }
}

running: False
schema_name_id: 426
start_time: 2026-04-06 03:40:24
success: True
trace_id: 7485811718333314969

Scan 161515857

duration: 0:00:14.226320

exit_message:

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

id: 161515857

payload:

{
    "datatype_dict": {
        "max_sqft": "int",
        "min_sqft": "int",
        "origin_key": "varchar",
        "unit_group": "varchar(10)",
        "unit_group_size_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_unit_group_lookup/2026-04-05/1775379442/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_unit_group_lookup/2026-04-05/1775379442",
        "key": "raw/reference_unit_group_lookup/2026-04-05/1775379442/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_unit_group_lookup",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3759862152122929735,
        "service_name": "redshift_unloads",
        "span_id": 15416405873125571585,
        "trace_id": 751785448795601795
    }
}

running: False
schema_name_id: 426
start_time: 2026-04-05 03:58:44
success: True
trace_id: 751785448795601795

Scan 161460672

duration: 0:00:11.700380

exit_message:

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

id: 161460672

payload:

{
    "datatype_dict": {
        "max_sqft": "int",
        "min_sqft": "int",
        "origin_key": "varchar",
        "unit_group": "varchar(10)",
        "unit_group_size_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_unit_group_lookup/2026-04-04/1775291081/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_unit_group_lookup/2026-04-04/1775291081",
        "key": "raw/reference_unit_group_lookup/2026-04-04/1775291081/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_unit_group_lookup",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 9715937775053157815,
        "service_name": "redshift_unloads",
        "span_id": 14094874099491858553,
        "trace_id": 1541334914202500814
    }
}

running: False
schema_name_id: 426
start_time: 2026-04-04 03:24:53
success: True
trace_id: 1541334914202500814

Scan 161402144

duration: 0:00:11.618786

exit_message:

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

id: 161402144

payload:

{
    "datatype_dict": {
        "max_sqft": "int",
        "min_sqft": "int",
        "origin_key": "varchar",
        "unit_group": "varchar(10)",
        "unit_group_size_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_unit_group_lookup/2026-04-03/1775205236/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_unit_group_lookup/2026-04-03/1775205236",
        "key": "raw/reference_unit_group_lookup/2026-04-03/1775205236/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_unit_group_lookup",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 2779766064023372413,
        "service_name": "redshift_unloads",
        "span_id": 17374507587642909613,
        "trace_id": 840903941325494836
    }
}

running: False
schema_name_id: 426
start_time: 2026-04-03 03:34:04
success: True
trace_id: 840903941325494836

Partitions:

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

Schema:

attributes:

{
    "_origin": "string",
    "max_sqft": "int",
    "min_sqft": "int",
    "unit_group": "varchar(10)",
    "unit_group_size_key": "int"
}

created: 2026-04-17 03:18:26

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_unit_group_lookup`\n(\n `unit_group_size_key`  int , `unit_group`  varchar(10) , `min_sqft`  int , `max_sqft`  int , `_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/reference_unit_group_lookup/2026-04-17/1776413898'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_unit_group_lookup`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_unit_group_lookup"
}

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-05-08 15:05:44",
        "disabled": false,
        "format": "raw",
        "id": 426,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_redshift",
            "table": "analytics_reference_unit_group_lookup"
        },
        "type": "redshift"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "_origin": "string",
            "max_sqft": "int",
            "min_sqft": "int",
            "unit_group": "varchar(10)",
            "unit_group_size_key": "int"
        },
        "created": "2026-04-17 03:18:26",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_unit_group_lookup`\n(\n `unit_group_size_key`  int , `unit_group`  varchar(10) , `min_sqft`  int , `max_sqft`  int , `_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/reference_unit_group_lookup/2026-04-17/1776413898'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_unit_group_lookup`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_unit_group_lookup"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}