Schema Info

Schema Name: sfdl_stage_redshift.analytics_reference_unit_group_lookup

created: 2018-05-09 10:50:39
disabled: False
format: raw
id: 522
is_partitioned: False
is_schema_datatyped: True

name:

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

type: redshift

Schema Versions: 15

Version 906641

created: 2026-04-17 03:45:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_unit_group_lookup`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/reference_unit_group_lookup/2026-04-17/1776415490'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_unit_group_lookup"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_unit_group_lookup/2026-04-17/1776415490
id: 906641
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: 522
schema_scan_id: 6415221
updated: 2026-04-17 03:45:29

Version 906389

created: 2026-04-16 03:49:10

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_unit_group_lookup`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/reference_unit_group_lookup/2026-04-16/1776329340'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_unit_group_lookup"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_unit_group_lookup/2026-04-16/1776329340
id: 906389
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: 522
schema_scan_id: 6414639
updated: 2026-04-16 03:49:22

Version 906181

created: 2026-04-15 03:43:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_unit_group_lookup`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/reference_unit_group_lookup/2026-04-15/1776242592'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_unit_group_lookup"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_unit_group_lookup/2026-04-15/1776242592
id: 906181
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: 522
schema_scan_id: 6414157
updated: 2026-04-15 03:43:43

Version 905967

created: 2026-04-14 03:38:30

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_unit_group_lookup`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/reference_unit_group_lookup/2026-04-14/1776155873'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_unit_group_lookup"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_unit_group_lookup/2026-04-14/1776155873
id: 905967
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: 522
schema_scan_id: 6413653
updated: 2026-04-14 03:38:42

Version 905756

created: 2026-04-13 03:31:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_unit_group_lookup`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/reference_unit_group_lookup/2026-04-13/1776069066'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_unit_group_lookup"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_unit_group_lookup/2026-04-13/1776069066
id: 905756
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: 522
schema_scan_id: 6413112
updated: 2026-04-13 03:31:28

Version 905566

created: 2026-04-12 03:38:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_unit_group_lookup`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/reference_unit_group_lookup/2026-04-12/1775983092'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_unit_group_lookup"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_unit_group_lookup/2026-04-12/1775983092
id: 905566
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: 522
schema_scan_id: 6412729
updated: 2026-04-12 03:38:45

Version 905346

created: 2026-04-11 03:21:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_unit_group_lookup`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/reference_unit_group_lookup/2026-04-11/1775895652'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_unit_group_lookup"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_unit_group_lookup/2026-04-11/1775895652
id: 905346
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: 522
schema_scan_id: 6412330
updated: 2026-04-11 03:21:14

Version 905173

created: 2026-04-10 03:59:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_unit_group_lookup`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/reference_unit_group_lookup/2026-04-10/1775811571'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_unit_group_lookup"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_unit_group_lookup/2026-04-10/1775811571
id: 905173
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: 522
schema_scan_id: 6411878
updated: 2026-04-10 04:00:03

Version 904948

created: 2026-04-09 04:00:07

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_unit_group_lookup`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/reference_unit_group_lookup/2026-04-09/1775725196'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_unit_group_lookup"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_unit_group_lookup/2026-04-09/1775725196
id: 904948
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: 522
schema_scan_id: 6411351
updated: 2026-04-09 04:00:19

Version 904705

created: 2026-04-08 03:31:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_unit_group_lookup`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/reference_unit_group_lookup/2026-04-08/1775637079'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_unit_group_lookup"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_unit_group_lookup/2026-04-08/1775637079
id: 904705
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: 522
schema_scan_id: 6410826
updated: 2026-04-08 03:31:51

Version 904497

created: 2026-04-07 03:33:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_unit_group_lookup`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/reference_unit_group_lookup/2026-04-07/1775550779'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_unit_group_lookup"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_unit_group_lookup/2026-04-07/1775550779
id: 904497
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: 522
schema_scan_id: 6410321
updated: 2026-04-07 03:33:56

Version 904276

created: 2026-04-06 03:44:24

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_unit_group_lookup`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/reference_unit_group_lookup/2026-04-06/1775465039'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_unit_group_lookup"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_unit_group_lookup/2026-04-06/1775465039
id: 904276
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: 522
schema_scan_id: 6409770
updated: 2026-04-06 03:44:35

Version 904095

created: 2026-04-05 03:44:08

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_unit_group_lookup`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/reference_unit_group_lookup/2026-04-05/1775378633'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_unit_group_lookup"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_unit_group_lookup/2026-04-05/1775378633
id: 904095
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: 522
schema_scan_id: 6409403
updated: 2026-04-05 03:44:20

Version 903874

created: 2026-04-04 03:23:05

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_unit_group_lookup`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/reference_unit_group_lookup/2026-04-04/1775290959'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_unit_group_lookup"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_unit_group_lookup/2026-04-04/1775290959
id: 903874
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: 522
schema_scan_id: 6409004
updated: 2026-04-04 03:23:16

Version 903667

created: 2026-04-03 03:44:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_unit_group_lookup`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/reference_unit_group_lookup/2026-04-03/1775205823'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_unit_group_lookup"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_unit_group_lookup/2026-04-03/1775205823
id: 903667
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: 522
schema_scan_id: 6408521
updated: 2026-04-03 03:44:29

Schema Scans: 15

Last at 2026-04-17 03:45:15

Scan 6415221

duration: 0:00:14.187334

exit_message:

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

id: 6415221

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-stage",
            "key": "meta/reference_unit_group_lookup/2026-04-17/1776415490/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_unit_group_lookup/2026-04-17/1776415490",
        "key": "raw/reference_unit_group_lookup/2026-04-17/1776415490/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_unit_group_lookup",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13208499940429209221,
        "service_name": "redshift_unloads",
        "span_id": 6875712622247211358,
        "trace_id": 14489829033764254580
    }
}

running: False
schema_name_id: 522
start_time: 2026-04-17 03:45:15
success: True
trace_id: 14489829033764254580

Scan 6414639

duration: 0:00:11.727120

exit_message:

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

id: 6414639

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-stage",
            "key": "meta/reference_unit_group_lookup/2026-04-16/1776329340/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_unit_group_lookup/2026-04-16/1776329340",
        "key": "raw/reference_unit_group_lookup/2026-04-16/1776329340/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_unit_group_lookup",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 16765632416175071098,
        "service_name": "redshift_unloads",
        "span_id": 3403384094473878783,
        "trace_id": 1922405411632645597
    }
}

running: False
schema_name_id: 522
start_time: 2026-04-16 03:49:10
success: True
trace_id: 1922405411632645597

Scan 6414157

duration: 0:00:11.586880

exit_message:

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

id: 6414157

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-stage",
            "key": "meta/reference_unit_group_lookup/2026-04-15/1776242592/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_unit_group_lookup/2026-04-15/1776242592",
        "key": "raw/reference_unit_group_lookup/2026-04-15/1776242592/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_unit_group_lookup",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 9298988288896756208,
        "service_name": "redshift_unloads",
        "span_id": 17627445829546704722,
        "trace_id": 17563922383568665868
    }
}

running: False
schema_name_id: 522
start_time: 2026-04-15 03:43:31
success: True
trace_id: 17563922383568665868

Scan 6413653

duration: 0:00:11.626718

exit_message:

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

id: 6413653

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-stage",
            "key": "meta/reference_unit_group_lookup/2026-04-14/1776155873/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_unit_group_lookup/2026-04-14/1776155873",
        "key": "raw/reference_unit_group_lookup/2026-04-14/1776155873/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_unit_group_lookup",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 10601525160684727657,
        "service_name": "redshift_unloads",
        "span_id": 3764271070088474976,
        "trace_id": 1739317408045080206
    }
}

running: False
schema_name_id: 522
start_time: 2026-04-14 03:38:30
success: True
trace_id: 1739317408045080206

Scan 6413112

duration: 0:00:14.305216

exit_message:

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

id: 6413112

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-stage",
            "key": "meta/reference_unit_group_lookup/2026-04-13/1776069066/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_unit_group_lookup/2026-04-13/1776069066",
        "key": "raw/reference_unit_group_lookup/2026-04-13/1776069066/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_unit_group_lookup",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 2678011425197549742,
        "service_name": "redshift_unloads",
        "span_id": 11910779380021753294,
        "trace_id": 11688249847980912205
    }
}

running: False
schema_name_id: 522
start_time: 2026-04-13 03:31:14
success: True
trace_id: 11688249847980912205

Scan 6412729

duration: 0:00:11.632573

exit_message:

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

id: 6412729

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-stage",
            "key": "meta/reference_unit_group_lookup/2026-04-12/1775983092/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_unit_group_lookup/2026-04-12/1775983092",
        "key": "raw/reference_unit_group_lookup/2026-04-12/1775983092/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_unit_group_lookup",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 2428561516854796872,
        "service_name": "redshift_unloads",
        "span_id": 17292044615502127080,
        "trace_id": 16128460489281664443
    }
}

running: False
schema_name_id: 522
start_time: 2026-04-12 03:38:34
success: True
trace_id: 16128460489281664443

Scan 6412330

duration: 0:00:11.657274

exit_message:

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

id: 6412330

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-stage",
            "key": "meta/reference_unit_group_lookup/2026-04-11/1775895652/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_unit_group_lookup/2026-04-11/1775895652",
        "key": "raw/reference_unit_group_lookup/2026-04-11/1775895652/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_unit_group_lookup",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 14367827230269423786,
        "service_name": "redshift_unloads",
        "span_id": 660703813657906330,
        "trace_id": 10510543237628851406
    }
}

running: False
schema_name_id: 522
start_time: 2026-04-11 03:21:02
success: True
trace_id: 10510543237628851406

Scan 6411878

duration: 0:00:14.225295

exit_message:

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

id: 6411878

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-stage",
            "key": "meta/reference_unit_group_lookup/2026-04-10/1775811571/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_unit_group_lookup/2026-04-10/1775811571",
        "key": "raw/reference_unit_group_lookup/2026-04-10/1775811571/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_unit_group_lookup",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 935346956781151367,
        "service_name": "redshift_unloads",
        "span_id": 4740646770892551633,
        "trace_id": 13532569294779874086
    }
}

running: False
schema_name_id: 522
start_time: 2026-04-10 03:59:49
success: True
trace_id: 13532569294779874086

Scan 6411351

duration: 0:00:11.743002

exit_message:

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

id: 6411351

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-stage",
            "key": "meta/reference_unit_group_lookup/2026-04-09/1775725196/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_unit_group_lookup/2026-04-09/1775725196",
        "key": "raw/reference_unit_group_lookup/2026-04-09/1775725196/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_unit_group_lookup",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 5314936235821569448,
        "service_name": "redshift_unloads",
        "span_id": 2445900062098191039,
        "trace_id": 2932311069080477925
    }
}

running: False
schema_name_id: 522
start_time: 2026-04-09 04:00:07
success: True
trace_id: 2932311069080477925

Scan 6410826

duration: 0:00:11.693231

exit_message:

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

id: 6410826

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-stage",
            "key": "meta/reference_unit_group_lookup/2026-04-08/1775637079/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_unit_group_lookup/2026-04-08/1775637079",
        "key": "raw/reference_unit_group_lookup/2026-04-08/1775637079/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_unit_group_lookup",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 16371667479630273397,
        "service_name": "redshift_unloads",
        "span_id": 13961905063598235928,
        "trace_id": 11914742433878683495
    }
}

running: False
schema_name_id: 522
start_time: 2026-04-08 03:31:40
success: True
trace_id: 11914742433878683495

Scan 6410321

duration: 0:00:14.284991

exit_message:

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

id: 6410321

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-stage",
            "key": "meta/reference_unit_group_lookup/2026-04-07/1775550779/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_unit_group_lookup/2026-04-07/1775550779",
        "key": "raw/reference_unit_group_lookup/2026-04-07/1775550779/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_unit_group_lookup",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 5181124079725013100,
        "service_name": "redshift_unloads",
        "span_id": 13875054638148673896,
        "trace_id": 6379505485603439812
    }
}

running: False
schema_name_id: 522
start_time: 2026-04-07 03:33:41
success: True
trace_id: 6379505485603439812

Scan 6409770

duration: 0:00:11.765576

exit_message:

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

id: 6409770

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-stage",
            "key": "meta/reference_unit_group_lookup/2026-04-06/1775465039/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_unit_group_lookup/2026-04-06/1775465039",
        "key": "raw/reference_unit_group_lookup/2026-04-06/1775465039/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_unit_group_lookup",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 11472490478158407625,
        "service_name": "redshift_unloads",
        "span_id": 5575545067397076443,
        "trace_id": 9735566761828769765
    }
}

running: False
schema_name_id: 522
start_time: 2026-04-06 03:44:24
success: True
trace_id: 9735566761828769765

Scan 6409403

duration: 0:00:11.707279

exit_message:

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

id: 6409403

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-stage",
            "key": "meta/reference_unit_group_lookup/2026-04-05/1775378633/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_unit_group_lookup/2026-04-05/1775378633",
        "key": "raw/reference_unit_group_lookup/2026-04-05/1775378633/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_unit_group_lookup",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 12509591555637638470,
        "service_name": "redshift_unloads",
        "span_id": 8461655950627346911,
        "trace_id": 14473921679010495905
    }
}

running: False
schema_name_id: 522
start_time: 2026-04-05 03:44:08
success: True
trace_id: 14473921679010495905

Scan 6409004

duration: 0:00:11.717054

exit_message:

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

id: 6409004

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-stage",
            "key": "meta/reference_unit_group_lookup/2026-04-04/1775290959/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_unit_group_lookup/2026-04-04/1775290959",
        "key": "raw/reference_unit_group_lookup/2026-04-04/1775290959/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_unit_group_lookup",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 16623894392560288254,
        "service_name": "redshift_unloads",
        "span_id": 8981158989852786253,
        "trace_id": 3133668911428467467
    }
}

running: False
schema_name_id: 522
start_time: 2026-04-04 03:23:04
success: True
trace_id: 3133668911428467467

Scan 6408521

duration: 0:00:14.255177

exit_message:

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

id: 6408521

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-stage",
            "key": "meta/reference_unit_group_lookup/2026-04-03/1775205823/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_unit_group_lookup/2026-04-03/1775205823",
        "key": "raw/reference_unit_group_lookup/2026-04-03/1775205823/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_unit_group_lookup",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3152535665901934042,
        "service_name": "redshift_unloads",
        "span_id": 1835485234273826238,
        "trace_id": 17966912586039213648
    }
}

running: False
schema_name_id: 522
start_time: 2026-04-03 03:44:15
success: True
trace_id: 17966912586039213648

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:45:15

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/reference_unit_group_lookup/2026-04-17/1776415490'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_unit_group_lookup`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_unit_group_lookup"
}

Server:

hostname: schemamanager-5c55c886bf-h2ts4
name: schema_manager
process_start: 2025-10-21 13:03:27
sf_env: stage
version: 2112174301

Raw:

{
    "name": {
        "created": "2018-05-09 10:50:39",
        "disabled": false,
        "format": "raw",
        "id": 522,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_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:45:15",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/reference_unit_group_lookup/2026-04-17/1776415490'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_unit_group_lookup`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_unit_group_lookup"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}