Schema Info

Schema Name: sfdl_stage_redshift.analytics_helper_facility_unit_pricing

created: 2018-02-21 00:02:33
disabled: False
format: raw
id: 399
is_partitioned: False
is_schema_datatyped: True

name:

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

type: redshift

Schema Versions: 15

Version 906642

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_facility_unit_pricing`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_facility_unit_pricing`\n(\n `facility_key`  int , `avg_ppsqft_non_cc_5x5`  decimal(5,2) , `avg_ppsqft_non_cc_5x10`  decimal(5,2) , `avg_ppsqft_non_cc_5x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x10`  decimal(5,2) , `avg_ppsqft_non_cc_10x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x20`  decimal(5,2) , `avg_ppsqft_non_cc_10x25`  decimal(5,2) , `avg_ppsqft_non_cc_10x30`  decimal(5,2) , `avg_ppsqft_non_cc`  decimal(5,2) , `avg_ppsqft_cc_5x5`  decimal(5,2) , `avg_ppsqft_cc_5x10`  decimal(5,2) , `avg_ppsqft_cc_5x15`  decimal(5,2) , `avg_ppsqft_cc_10x10`  decimal(5,2) , `avg_ppsqft_cc_10x15`  decimal(5,2) , `avg_ppsqft_cc_10x20`  decimal(5,2) , `avg_ppsqft_cc_10x25`  decimal(5,2) , `avg_ppsqft_cc_10x30`  decimal(5,2) , `avg_ppsqft_cc`  decimal(5,2) , `_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/helper_facility_unit_pricing/2026-04-17/1776415507'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_facility_unit_pricing"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_facility_unit_pricing/2026-04-17/1776415507
id: 906642
processed: 1

raw_data:

{
    "_origin": "19",
    "avg_ppsqft_cc": "18",
    "avg_ppsqft_cc_10x10": "13",
    "avg_ppsqft_cc_10x15": "14",
    "avg_ppsqft_cc_10x20": "15",
    "avg_ppsqft_cc_10x25": "16",
    "avg_ppsqft_cc_10x30": "17",
    "avg_ppsqft_cc_5x10": "11",
    "avg_ppsqft_cc_5x15": "12",
    "avg_ppsqft_cc_5x5": "10",
    "avg_ppsqft_non_cc": "9",
    "avg_ppsqft_non_cc_10x10": "4",
    "avg_ppsqft_non_cc_10x15": "5",
    "avg_ppsqft_non_cc_10x20": "6",
    "avg_ppsqft_non_cc_10x25": "7",
    "avg_ppsqft_non_cc_10x30": "8",
    "avg_ppsqft_non_cc_5x10": "2",
    "avg_ppsqft_non_cc_5x15": "3",
    "avg_ppsqft_non_cc_5x5": "1",
    "facility_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "avg_ppsqft_cc": "decimal(5,2)",
    "avg_ppsqft_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_cc_5x5": "decimal(5,2)",
    "avg_ppsqft_non_cc": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
    "facility_key": "int"
}

schema_name_id: 399
schema_scan_id: 6415222
updated: 2026-04-17 03:45:30

Version 906399

created: 2026-04-16 03:57:11

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_facility_unit_pricing`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_facility_unit_pricing`\n(\n `facility_key`  int , `avg_ppsqft_non_cc_5x5`  decimal(5,2) , `avg_ppsqft_non_cc_5x10`  decimal(5,2) , `avg_ppsqft_non_cc_5x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x10`  decimal(5,2) , `avg_ppsqft_non_cc_10x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x20`  decimal(5,2) , `avg_ppsqft_non_cc_10x25`  decimal(5,2) , `avg_ppsqft_non_cc_10x30`  decimal(5,2) , `avg_ppsqft_non_cc`  decimal(5,2) , `avg_ppsqft_cc_5x5`  decimal(5,2) , `avg_ppsqft_cc_5x10`  decimal(5,2) , `avg_ppsqft_cc_5x15`  decimal(5,2) , `avg_ppsqft_cc_10x10`  decimal(5,2) , `avg_ppsqft_cc_10x15`  decimal(5,2) , `avg_ppsqft_cc_10x20`  decimal(5,2) , `avg_ppsqft_cc_10x25`  decimal(5,2) , `avg_ppsqft_cc_10x30`  decimal(5,2) , `avg_ppsqft_cc`  decimal(5,2) , `_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/helper_facility_unit_pricing/2026-04-16/1776329812'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_facility_unit_pricing"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_facility_unit_pricing/2026-04-16/1776329812
id: 906399
processed: 1

raw_data:

{
    "_origin": "19",
    "avg_ppsqft_cc": "18",
    "avg_ppsqft_cc_10x10": "13",
    "avg_ppsqft_cc_10x15": "14",
    "avg_ppsqft_cc_10x20": "15",
    "avg_ppsqft_cc_10x25": "16",
    "avg_ppsqft_cc_10x30": "17",
    "avg_ppsqft_cc_5x10": "11",
    "avg_ppsqft_cc_5x15": "12",
    "avg_ppsqft_cc_5x5": "10",
    "avg_ppsqft_non_cc": "9",
    "avg_ppsqft_non_cc_10x10": "4",
    "avg_ppsqft_non_cc_10x15": "5",
    "avg_ppsqft_non_cc_10x20": "6",
    "avg_ppsqft_non_cc_10x25": "7",
    "avg_ppsqft_non_cc_10x30": "8",
    "avg_ppsqft_non_cc_5x10": "2",
    "avg_ppsqft_non_cc_5x15": "3",
    "avg_ppsqft_non_cc_5x5": "1",
    "facility_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "avg_ppsqft_cc": "decimal(5,2)",
    "avg_ppsqft_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_cc_5x5": "decimal(5,2)",
    "avg_ppsqft_non_cc": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
    "facility_key": "int"
}

schema_name_id: 399
schema_scan_id: 6414649
updated: 2026-04-16 03:57:23

Version 906204

created: 2026-04-15 03:47:11

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_facility_unit_pricing`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_facility_unit_pricing`\n(\n `facility_key`  int , `avg_ppsqft_non_cc_5x5`  decimal(5,2) , `avg_ppsqft_non_cc_5x10`  decimal(5,2) , `avg_ppsqft_non_cc_5x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x10`  decimal(5,2) , `avg_ppsqft_non_cc_10x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x20`  decimal(5,2) , `avg_ppsqft_non_cc_10x25`  decimal(5,2) , `avg_ppsqft_non_cc_10x30`  decimal(5,2) , `avg_ppsqft_non_cc`  decimal(5,2) , `avg_ppsqft_cc_5x5`  decimal(5,2) , `avg_ppsqft_cc_5x10`  decimal(5,2) , `avg_ppsqft_cc_5x15`  decimal(5,2) , `avg_ppsqft_cc_10x10`  decimal(5,2) , `avg_ppsqft_cc_10x15`  decimal(5,2) , `avg_ppsqft_cc_10x20`  decimal(5,2) , `avg_ppsqft_cc_10x25`  decimal(5,2) , `avg_ppsqft_cc_10x30`  decimal(5,2) , `avg_ppsqft_cc`  decimal(5,2) , `_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/helper_facility_unit_pricing/2026-04-15/1776242812'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_facility_unit_pricing"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_facility_unit_pricing/2026-04-15/1776242812
id: 906204
processed: 1

raw_data:

{
    "_origin": "19",
    "avg_ppsqft_cc": "18",
    "avg_ppsqft_cc_10x10": "13",
    "avg_ppsqft_cc_10x15": "14",
    "avg_ppsqft_cc_10x20": "15",
    "avg_ppsqft_cc_10x25": "16",
    "avg_ppsqft_cc_10x30": "17",
    "avg_ppsqft_cc_5x10": "11",
    "avg_ppsqft_cc_5x15": "12",
    "avg_ppsqft_cc_5x5": "10",
    "avg_ppsqft_non_cc": "9",
    "avg_ppsqft_non_cc_10x10": "4",
    "avg_ppsqft_non_cc_10x15": "5",
    "avg_ppsqft_non_cc_10x20": "6",
    "avg_ppsqft_non_cc_10x25": "7",
    "avg_ppsqft_non_cc_10x30": "8",
    "avg_ppsqft_non_cc_5x10": "2",
    "avg_ppsqft_non_cc_5x15": "3",
    "avg_ppsqft_non_cc_5x5": "1",
    "facility_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "avg_ppsqft_cc": "decimal(5,2)",
    "avg_ppsqft_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_cc_5x5": "decimal(5,2)",
    "avg_ppsqft_non_cc": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
    "facility_key": "int"
}

schema_name_id: 399
schema_scan_id: 6414180
updated: 2026-04-15 03:47:23

Version 905998

created: 2026-04-14 03:54:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_facility_unit_pricing`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_facility_unit_pricing`\n(\n `facility_key`  int , `avg_ppsqft_non_cc_5x5`  decimal(5,2) , `avg_ppsqft_non_cc_5x10`  decimal(5,2) , `avg_ppsqft_non_cc_5x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x10`  decimal(5,2) , `avg_ppsqft_non_cc_10x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x20`  decimal(5,2) , `avg_ppsqft_non_cc_10x25`  decimal(5,2) , `avg_ppsqft_non_cc_10x30`  decimal(5,2) , `avg_ppsqft_non_cc`  decimal(5,2) , `avg_ppsqft_cc_5x5`  decimal(5,2) , `avg_ppsqft_cc_5x10`  decimal(5,2) , `avg_ppsqft_cc_5x15`  decimal(5,2) , `avg_ppsqft_cc_10x10`  decimal(5,2) , `avg_ppsqft_cc_10x15`  decimal(5,2) , `avg_ppsqft_cc_10x20`  decimal(5,2) , `avg_ppsqft_cc_10x25`  decimal(5,2) , `avg_ppsqft_cc_10x30`  decimal(5,2) , `avg_ppsqft_cc`  decimal(5,2) , `_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/helper_facility_unit_pricing/2026-04-14/1776156852'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_facility_unit_pricing"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_facility_unit_pricing/2026-04-14/1776156852
id: 905998
processed: 1

raw_data:

{
    "_origin": "19",
    "avg_ppsqft_cc": "18",
    "avg_ppsqft_cc_10x10": "13",
    "avg_ppsqft_cc_10x15": "14",
    "avg_ppsqft_cc_10x20": "15",
    "avg_ppsqft_cc_10x25": "16",
    "avg_ppsqft_cc_10x30": "17",
    "avg_ppsqft_cc_5x10": "11",
    "avg_ppsqft_cc_5x15": "12",
    "avg_ppsqft_cc_5x5": "10",
    "avg_ppsqft_non_cc": "9",
    "avg_ppsqft_non_cc_10x10": "4",
    "avg_ppsqft_non_cc_10x15": "5",
    "avg_ppsqft_non_cc_10x20": "6",
    "avg_ppsqft_non_cc_10x25": "7",
    "avg_ppsqft_non_cc_10x30": "8",
    "avg_ppsqft_non_cc_5x10": "2",
    "avg_ppsqft_non_cc_5x15": "3",
    "avg_ppsqft_non_cc_5x5": "1",
    "facility_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "avg_ppsqft_cc": "decimal(5,2)",
    "avg_ppsqft_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_cc_5x5": "decimal(5,2)",
    "avg_ppsqft_non_cc": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
    "facility_key": "int"
}

schema_name_id: 399
schema_scan_id: 6413684
updated: 2026-04-14 03:54:53

Version 905747

created: 2026-04-13 03:21:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_facility_unit_pricing`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_facility_unit_pricing`\n(\n `facility_key`  int , `avg_ppsqft_non_cc_5x5`  decimal(5,2) , `avg_ppsqft_non_cc_5x10`  decimal(5,2) , `avg_ppsqft_non_cc_5x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x10`  decimal(5,2) , `avg_ppsqft_non_cc_10x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x20`  decimal(5,2) , `avg_ppsqft_non_cc_10x25`  decimal(5,2) , `avg_ppsqft_non_cc_10x30`  decimal(5,2) , `avg_ppsqft_non_cc`  decimal(5,2) , `avg_ppsqft_cc_5x5`  decimal(5,2) , `avg_ppsqft_cc_5x10`  decimal(5,2) , `avg_ppsqft_cc_5x15`  decimal(5,2) , `avg_ppsqft_cc_10x10`  decimal(5,2) , `avg_ppsqft_cc_10x15`  decimal(5,2) , `avg_ppsqft_cc_10x20`  decimal(5,2) , `avg_ppsqft_cc_10x25`  decimal(5,2) , `avg_ppsqft_cc_10x30`  decimal(5,2) , `avg_ppsqft_cc`  decimal(5,2) , `_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/helper_facility_unit_pricing/2026-04-13/1776068486'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_facility_unit_pricing"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_facility_unit_pricing/2026-04-13/1776068486
id: 905747
processed: 1

raw_data:

{
    "_origin": "19",
    "avg_ppsqft_cc": "18",
    "avg_ppsqft_cc_10x10": "13",
    "avg_ppsqft_cc_10x15": "14",
    "avg_ppsqft_cc_10x20": "15",
    "avg_ppsqft_cc_10x25": "16",
    "avg_ppsqft_cc_10x30": "17",
    "avg_ppsqft_cc_5x10": "11",
    "avg_ppsqft_cc_5x15": "12",
    "avg_ppsqft_cc_5x5": "10",
    "avg_ppsqft_non_cc": "9",
    "avg_ppsqft_non_cc_10x10": "4",
    "avg_ppsqft_non_cc_10x15": "5",
    "avg_ppsqft_non_cc_10x20": "6",
    "avg_ppsqft_non_cc_10x25": "7",
    "avg_ppsqft_non_cc_10x30": "8",
    "avg_ppsqft_non_cc_5x10": "2",
    "avg_ppsqft_non_cc_5x15": "3",
    "avg_ppsqft_non_cc_5x5": "1",
    "facility_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "avg_ppsqft_cc": "decimal(5,2)",
    "avg_ppsqft_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_cc_5x5": "decimal(5,2)",
    "avg_ppsqft_non_cc": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
    "facility_key": "int"
}

schema_name_id: 399
schema_scan_id: 6413102
updated: 2026-04-13 03:22:03

Version 905578

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_facility_unit_pricing`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_facility_unit_pricing`\n(\n `facility_key`  int , `avg_ppsqft_non_cc_5x5`  decimal(5,2) , `avg_ppsqft_non_cc_5x10`  decimal(5,2) , `avg_ppsqft_non_cc_5x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x10`  decimal(5,2) , `avg_ppsqft_non_cc_10x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x20`  decimal(5,2) , `avg_ppsqft_non_cc_10x25`  decimal(5,2) , `avg_ppsqft_non_cc_10x30`  decimal(5,2) , `avg_ppsqft_non_cc`  decimal(5,2) , `avg_ppsqft_cc_5x5`  decimal(5,2) , `avg_ppsqft_cc_5x10`  decimal(5,2) , `avg_ppsqft_cc_5x15`  decimal(5,2) , `avg_ppsqft_cc_10x10`  decimal(5,2) , `avg_ppsqft_cc_10x15`  decimal(5,2) , `avg_ppsqft_cc_10x20`  decimal(5,2) , `avg_ppsqft_cc_10x25`  decimal(5,2) , `avg_ppsqft_cc_10x30`  decimal(5,2) , `avg_ppsqft_cc`  decimal(5,2) , `_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/helper_facility_unit_pricing/2026-04-12/1775984119'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_facility_unit_pricing"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_facility_unit_pricing/2026-04-12/1775984119
id: 905578
processed: 1

raw_data:

{
    "_origin": "19",
    "avg_ppsqft_cc": "18",
    "avg_ppsqft_cc_10x10": "13",
    "avg_ppsqft_cc_10x15": "14",
    "avg_ppsqft_cc_10x20": "15",
    "avg_ppsqft_cc_10x25": "16",
    "avg_ppsqft_cc_10x30": "17",
    "avg_ppsqft_cc_5x10": "11",
    "avg_ppsqft_cc_5x15": "12",
    "avg_ppsqft_cc_5x5": "10",
    "avg_ppsqft_non_cc": "9",
    "avg_ppsqft_non_cc_10x10": "4",
    "avg_ppsqft_non_cc_10x15": "5",
    "avg_ppsqft_non_cc_10x20": "6",
    "avg_ppsqft_non_cc_10x25": "7",
    "avg_ppsqft_non_cc_10x30": "8",
    "avg_ppsqft_non_cc_5x10": "2",
    "avg_ppsqft_non_cc_5x15": "3",
    "avg_ppsqft_non_cc_5x5": "1",
    "facility_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "avg_ppsqft_cc": "decimal(5,2)",
    "avg_ppsqft_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_cc_5x5": "decimal(5,2)",
    "avg_ppsqft_non_cc": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
    "facility_key": "int"
}

schema_name_id: 399
schema_scan_id: 6412742
updated: 2026-04-12 03:55:47

Version 905343

created: 2026-04-11 03:20:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_facility_unit_pricing`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_facility_unit_pricing`\n(\n `facility_key`  int , `avg_ppsqft_non_cc_5x5`  decimal(5,2) , `avg_ppsqft_non_cc_5x10`  decimal(5,2) , `avg_ppsqft_non_cc_5x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x10`  decimal(5,2) , `avg_ppsqft_non_cc_10x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x20`  decimal(5,2) , `avg_ppsqft_non_cc_10x25`  decimal(5,2) , `avg_ppsqft_non_cc_10x30`  decimal(5,2) , `avg_ppsqft_non_cc`  decimal(5,2) , `avg_ppsqft_cc_5x5`  decimal(5,2) , `avg_ppsqft_cc_5x10`  decimal(5,2) , `avg_ppsqft_cc_5x15`  decimal(5,2) , `avg_ppsqft_cc_10x10`  decimal(5,2) , `avg_ppsqft_cc_10x15`  decimal(5,2) , `avg_ppsqft_cc_10x20`  decimal(5,2) , `avg_ppsqft_cc_10x25`  decimal(5,2) , `avg_ppsqft_cc_10x30`  decimal(5,2) , `avg_ppsqft_cc`  decimal(5,2) , `_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/helper_facility_unit_pricing/2026-04-11/1775895629'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_facility_unit_pricing"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_facility_unit_pricing/2026-04-11/1775895629
id: 905343
processed: 1

raw_data:

{
    "_origin": "19",
    "avg_ppsqft_cc": "18",
    "avg_ppsqft_cc_10x10": "13",
    "avg_ppsqft_cc_10x15": "14",
    "avg_ppsqft_cc_10x20": "15",
    "avg_ppsqft_cc_10x25": "16",
    "avg_ppsqft_cc_10x30": "17",
    "avg_ppsqft_cc_5x10": "11",
    "avg_ppsqft_cc_5x15": "12",
    "avg_ppsqft_cc_5x5": "10",
    "avg_ppsqft_non_cc": "9",
    "avg_ppsqft_non_cc_10x10": "4",
    "avg_ppsqft_non_cc_10x15": "5",
    "avg_ppsqft_non_cc_10x20": "6",
    "avg_ppsqft_non_cc_10x25": "7",
    "avg_ppsqft_non_cc_10x30": "8",
    "avg_ppsqft_non_cc_5x10": "2",
    "avg_ppsqft_non_cc_5x15": "3",
    "avg_ppsqft_non_cc_5x5": "1",
    "facility_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "avg_ppsqft_cc": "decimal(5,2)",
    "avg_ppsqft_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_cc_5x5": "decimal(5,2)",
    "avg_ppsqft_non_cc": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
    "facility_key": "int"
}

schema_name_id: 399
schema_scan_id: 6412327
updated: 2026-04-11 03:21:02

Version 905129

created: 2026-04-10 03:18:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_facility_unit_pricing`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_facility_unit_pricing`\n(\n `facility_key`  int , `avg_ppsqft_non_cc_5x5`  decimal(5,2) , `avg_ppsqft_non_cc_5x10`  decimal(5,2) , `avg_ppsqft_non_cc_5x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x10`  decimal(5,2) , `avg_ppsqft_non_cc_10x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x20`  decimal(5,2) , `avg_ppsqft_non_cc_10x25`  decimal(5,2) , `avg_ppsqft_non_cc_10x30`  decimal(5,2) , `avg_ppsqft_non_cc`  decimal(5,2) , `avg_ppsqft_cc_5x5`  decimal(5,2) , `avg_ppsqft_cc_5x10`  decimal(5,2) , `avg_ppsqft_cc_5x15`  decimal(5,2) , `avg_ppsqft_cc_10x10`  decimal(5,2) , `avg_ppsqft_cc_10x15`  decimal(5,2) , `avg_ppsqft_cc_10x20`  decimal(5,2) , `avg_ppsqft_cc_10x25`  decimal(5,2) , `avg_ppsqft_cc_10x30`  decimal(5,2) , `avg_ppsqft_cc`  decimal(5,2) , `_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/helper_facility_unit_pricing/2026-04-10/1775809118'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_facility_unit_pricing"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_facility_unit_pricing/2026-04-10/1775809118
id: 905129
processed: 1

raw_data:

{
    "_origin": "19",
    "avg_ppsqft_cc": "18",
    "avg_ppsqft_cc_10x10": "13",
    "avg_ppsqft_cc_10x15": "14",
    "avg_ppsqft_cc_10x20": "15",
    "avg_ppsqft_cc_10x25": "16",
    "avg_ppsqft_cc_10x30": "17",
    "avg_ppsqft_cc_5x10": "11",
    "avg_ppsqft_cc_5x15": "12",
    "avg_ppsqft_cc_5x5": "10",
    "avg_ppsqft_non_cc": "9",
    "avg_ppsqft_non_cc_10x10": "4",
    "avg_ppsqft_non_cc_10x15": "5",
    "avg_ppsqft_non_cc_10x20": "6",
    "avg_ppsqft_non_cc_10x25": "7",
    "avg_ppsqft_non_cc_10x30": "8",
    "avg_ppsqft_non_cc_5x10": "2",
    "avg_ppsqft_non_cc_5x15": "3",
    "avg_ppsqft_non_cc_5x5": "1",
    "facility_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "avg_ppsqft_cc": "decimal(5,2)",
    "avg_ppsqft_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_cc_5x5": "decimal(5,2)",
    "avg_ppsqft_non_cc": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
    "facility_key": "int"
}

schema_name_id: 399
schema_scan_id: 6411833
updated: 2026-04-10 03:19:02

Version 904918

created: 2026-04-09 03:49:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_facility_unit_pricing`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_facility_unit_pricing`\n(\n `facility_key`  int , `avg_ppsqft_non_cc_5x5`  decimal(5,2) , `avg_ppsqft_non_cc_5x10`  decimal(5,2) , `avg_ppsqft_non_cc_5x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x10`  decimal(5,2) , `avg_ppsqft_non_cc_10x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x20`  decimal(5,2) , `avg_ppsqft_non_cc_10x25`  decimal(5,2) , `avg_ppsqft_non_cc_10x30`  decimal(5,2) , `avg_ppsqft_non_cc`  decimal(5,2) , `avg_ppsqft_cc_5x5`  decimal(5,2) , `avg_ppsqft_cc_5x10`  decimal(5,2) , `avg_ppsqft_cc_5x15`  decimal(5,2) , `avg_ppsqft_cc_10x10`  decimal(5,2) , `avg_ppsqft_cc_10x15`  decimal(5,2) , `avg_ppsqft_cc_10x20`  decimal(5,2) , `avg_ppsqft_cc_10x25`  decimal(5,2) , `avg_ppsqft_cc_10x30`  decimal(5,2) , `avg_ppsqft_cc`  decimal(5,2) , `_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/helper_facility_unit_pricing/2026-04-09/1775724549'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_facility_unit_pricing"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_facility_unit_pricing/2026-04-09/1775724549
id: 904918
processed: 1

raw_data:

{
    "_origin": "19",
    "avg_ppsqft_cc": "18",
    "avg_ppsqft_cc_10x10": "13",
    "avg_ppsqft_cc_10x15": "14",
    "avg_ppsqft_cc_10x20": "15",
    "avg_ppsqft_cc_10x25": "16",
    "avg_ppsqft_cc_10x30": "17",
    "avg_ppsqft_cc_5x10": "11",
    "avg_ppsqft_cc_5x15": "12",
    "avg_ppsqft_cc_5x5": "10",
    "avg_ppsqft_non_cc": "9",
    "avg_ppsqft_non_cc_10x10": "4",
    "avg_ppsqft_non_cc_10x15": "5",
    "avg_ppsqft_non_cc_10x20": "6",
    "avg_ppsqft_non_cc_10x25": "7",
    "avg_ppsqft_non_cc_10x30": "8",
    "avg_ppsqft_non_cc_5x10": "2",
    "avg_ppsqft_non_cc_5x15": "3",
    "avg_ppsqft_non_cc_5x5": "1",
    "facility_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "avg_ppsqft_cc": "decimal(5,2)",
    "avg_ppsqft_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_cc_5x5": "decimal(5,2)",
    "avg_ppsqft_non_cc": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
    "facility_key": "int"
}

schema_name_id: 399
schema_scan_id: 6411320
updated: 2026-04-09 03:49:46

Version 904732

created: 2026-04-08 03:55:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_facility_unit_pricing`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_facility_unit_pricing`\n(\n `facility_key`  int , `avg_ppsqft_non_cc_5x5`  decimal(5,2) , `avg_ppsqft_non_cc_5x10`  decimal(5,2) , `avg_ppsqft_non_cc_5x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x10`  decimal(5,2) , `avg_ppsqft_non_cc_10x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x20`  decimal(5,2) , `avg_ppsqft_non_cc_10x25`  decimal(5,2) , `avg_ppsqft_non_cc_10x30`  decimal(5,2) , `avg_ppsqft_non_cc`  decimal(5,2) , `avg_ppsqft_cc_5x5`  decimal(5,2) , `avg_ppsqft_cc_5x10`  decimal(5,2) , `avg_ppsqft_cc_5x15`  decimal(5,2) , `avg_ppsqft_cc_10x10`  decimal(5,2) , `avg_ppsqft_cc_10x15`  decimal(5,2) , `avg_ppsqft_cc_10x20`  decimal(5,2) , `avg_ppsqft_cc_10x25`  decimal(5,2) , `avg_ppsqft_cc_10x30`  decimal(5,2) , `avg_ppsqft_cc`  decimal(5,2) , `_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/helper_facility_unit_pricing/2026-04-08/1775638530'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_facility_unit_pricing"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_facility_unit_pricing/2026-04-08/1775638530
id: 904732
processed: 1

raw_data:

{
    "_origin": "19",
    "avg_ppsqft_cc": "18",
    "avg_ppsqft_cc_10x10": "13",
    "avg_ppsqft_cc_10x15": "14",
    "avg_ppsqft_cc_10x20": "15",
    "avg_ppsqft_cc_10x25": "16",
    "avg_ppsqft_cc_10x30": "17",
    "avg_ppsqft_cc_5x10": "11",
    "avg_ppsqft_cc_5x15": "12",
    "avg_ppsqft_cc_5x5": "10",
    "avg_ppsqft_non_cc": "9",
    "avg_ppsqft_non_cc_10x10": "4",
    "avg_ppsqft_non_cc_10x15": "5",
    "avg_ppsqft_non_cc_10x20": "6",
    "avg_ppsqft_non_cc_10x25": "7",
    "avg_ppsqft_non_cc_10x30": "8",
    "avg_ppsqft_non_cc_5x10": "2",
    "avg_ppsqft_non_cc_5x15": "3",
    "avg_ppsqft_non_cc_5x5": "1",
    "facility_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "avg_ppsqft_cc": "decimal(5,2)",
    "avg_ppsqft_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_cc_5x5": "decimal(5,2)",
    "avg_ppsqft_non_cc": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
    "facility_key": "int"
}

schema_name_id: 399
schema_scan_id: 6410854
updated: 2026-04-08 03:55:57

Version 904515

created: 2026-04-07 03:41:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_facility_unit_pricing`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_facility_unit_pricing`\n(\n `facility_key`  int , `avg_ppsqft_non_cc_5x5`  decimal(5,2) , `avg_ppsqft_non_cc_5x10`  decimal(5,2) , `avg_ppsqft_non_cc_5x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x10`  decimal(5,2) , `avg_ppsqft_non_cc_10x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x20`  decimal(5,2) , `avg_ppsqft_non_cc_10x25`  decimal(5,2) , `avg_ppsqft_non_cc_10x30`  decimal(5,2) , `avg_ppsqft_non_cc`  decimal(5,2) , `avg_ppsqft_cc_5x5`  decimal(5,2) , `avg_ppsqft_cc_5x10`  decimal(5,2) , `avg_ppsqft_cc_5x15`  decimal(5,2) , `avg_ppsqft_cc_10x10`  decimal(5,2) , `avg_ppsqft_cc_10x15`  decimal(5,2) , `avg_ppsqft_cc_10x20`  decimal(5,2) , `avg_ppsqft_cc_10x25`  decimal(5,2) , `avg_ppsqft_cc_10x30`  decimal(5,2) , `avg_ppsqft_cc`  decimal(5,2) , `_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/helper_facility_unit_pricing/2026-04-07/1775551266'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_facility_unit_pricing"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_facility_unit_pricing/2026-04-07/1775551266
id: 904515
processed: 1

raw_data:

{
    "_origin": "19",
    "avg_ppsqft_cc": "18",
    "avg_ppsqft_cc_10x10": "13",
    "avg_ppsqft_cc_10x15": "14",
    "avg_ppsqft_cc_10x20": "15",
    "avg_ppsqft_cc_10x25": "16",
    "avg_ppsqft_cc_10x30": "17",
    "avg_ppsqft_cc_5x10": "11",
    "avg_ppsqft_cc_5x15": "12",
    "avg_ppsqft_cc_5x5": "10",
    "avg_ppsqft_non_cc": "9",
    "avg_ppsqft_non_cc_10x10": "4",
    "avg_ppsqft_non_cc_10x15": "5",
    "avg_ppsqft_non_cc_10x20": "6",
    "avg_ppsqft_non_cc_10x25": "7",
    "avg_ppsqft_non_cc_10x30": "8",
    "avg_ppsqft_non_cc_5x10": "2",
    "avg_ppsqft_non_cc_5x15": "3",
    "avg_ppsqft_non_cc_5x5": "1",
    "facility_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "avg_ppsqft_cc": "decimal(5,2)",
    "avg_ppsqft_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_cc_5x5": "decimal(5,2)",
    "avg_ppsqft_non_cc": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
    "facility_key": "int"
}

schema_name_id: 399
schema_scan_id: 6410341
updated: 2026-04-07 03:41:27

Version 904290

created: 2026-04-06 03:46:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_facility_unit_pricing`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_facility_unit_pricing`\n(\n `facility_key`  int , `avg_ppsqft_non_cc_5x5`  decimal(5,2) , `avg_ppsqft_non_cc_5x10`  decimal(5,2) , `avg_ppsqft_non_cc_5x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x10`  decimal(5,2) , `avg_ppsqft_non_cc_10x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x20`  decimal(5,2) , `avg_ppsqft_non_cc_10x25`  decimal(5,2) , `avg_ppsqft_non_cc_10x30`  decimal(5,2) , `avg_ppsqft_non_cc`  decimal(5,2) , `avg_ppsqft_cc_5x5`  decimal(5,2) , `avg_ppsqft_cc_5x10`  decimal(5,2) , `avg_ppsqft_cc_5x15`  decimal(5,2) , `avg_ppsqft_cc_10x10`  decimal(5,2) , `avg_ppsqft_cc_10x15`  decimal(5,2) , `avg_ppsqft_cc_10x20`  decimal(5,2) , `avg_ppsqft_cc_10x25`  decimal(5,2) , `avg_ppsqft_cc_10x30`  decimal(5,2) , `avg_ppsqft_cc`  decimal(5,2) , `_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/helper_facility_unit_pricing/2026-04-06/1775465177'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_facility_unit_pricing"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_facility_unit_pricing/2026-04-06/1775465177
id: 904290
processed: 1

raw_data:

{
    "_origin": "19",
    "avg_ppsqft_cc": "18",
    "avg_ppsqft_cc_10x10": "13",
    "avg_ppsqft_cc_10x15": "14",
    "avg_ppsqft_cc_10x20": "15",
    "avg_ppsqft_cc_10x25": "16",
    "avg_ppsqft_cc_10x30": "17",
    "avg_ppsqft_cc_5x10": "11",
    "avg_ppsqft_cc_5x15": "12",
    "avg_ppsqft_cc_5x5": "10",
    "avg_ppsqft_non_cc": "9",
    "avg_ppsqft_non_cc_10x10": "4",
    "avg_ppsqft_non_cc_10x15": "5",
    "avg_ppsqft_non_cc_10x20": "6",
    "avg_ppsqft_non_cc_10x25": "7",
    "avg_ppsqft_non_cc_10x30": "8",
    "avg_ppsqft_non_cc_5x10": "2",
    "avg_ppsqft_non_cc_5x15": "3",
    "avg_ppsqft_non_cc_5x5": "1",
    "facility_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "avg_ppsqft_cc": "decimal(5,2)",
    "avg_ppsqft_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_cc_5x5": "decimal(5,2)",
    "avg_ppsqft_non_cc": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
    "facility_key": "int"
}

schema_name_id: 399
schema_scan_id: 6409784
updated: 2026-04-06 03:46:43

Version 904110

created: 2026-04-05 04:04:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_facility_unit_pricing`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_facility_unit_pricing`\n(\n `facility_key`  int , `avg_ppsqft_non_cc_5x5`  decimal(5,2) , `avg_ppsqft_non_cc_5x10`  decimal(5,2) , `avg_ppsqft_non_cc_5x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x10`  decimal(5,2) , `avg_ppsqft_non_cc_10x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x20`  decimal(5,2) , `avg_ppsqft_non_cc_10x25`  decimal(5,2) , `avg_ppsqft_non_cc_10x30`  decimal(5,2) , `avg_ppsqft_non_cc`  decimal(5,2) , `avg_ppsqft_cc_5x5`  decimal(5,2) , `avg_ppsqft_cc_5x10`  decimal(5,2) , `avg_ppsqft_cc_5x15`  decimal(5,2) , `avg_ppsqft_cc_10x10`  decimal(5,2) , `avg_ppsqft_cc_10x15`  decimal(5,2) , `avg_ppsqft_cc_10x20`  decimal(5,2) , `avg_ppsqft_cc_10x25`  decimal(5,2) , `avg_ppsqft_cc_10x30`  decimal(5,2) , `avg_ppsqft_cc`  decimal(5,2) , `_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/helper_facility_unit_pricing/2026-04-05/1775379839'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_facility_unit_pricing"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_facility_unit_pricing/2026-04-05/1775379839
id: 904110
processed: 1

raw_data:

{
    "_origin": "19",
    "avg_ppsqft_cc": "18",
    "avg_ppsqft_cc_10x10": "13",
    "avg_ppsqft_cc_10x15": "14",
    "avg_ppsqft_cc_10x20": "15",
    "avg_ppsqft_cc_10x25": "16",
    "avg_ppsqft_cc_10x30": "17",
    "avg_ppsqft_cc_5x10": "11",
    "avg_ppsqft_cc_5x15": "12",
    "avg_ppsqft_cc_5x5": "10",
    "avg_ppsqft_non_cc": "9",
    "avg_ppsqft_non_cc_10x10": "4",
    "avg_ppsqft_non_cc_10x15": "5",
    "avg_ppsqft_non_cc_10x20": "6",
    "avg_ppsqft_non_cc_10x25": "7",
    "avg_ppsqft_non_cc_10x30": "8",
    "avg_ppsqft_non_cc_5x10": "2",
    "avg_ppsqft_non_cc_5x15": "3",
    "avg_ppsqft_non_cc_5x5": "1",
    "facility_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "avg_ppsqft_cc": "decimal(5,2)",
    "avg_ppsqft_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_cc_5x5": "decimal(5,2)",
    "avg_ppsqft_non_cc": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
    "facility_key": "int"
}

schema_name_id: 399
schema_scan_id: 6409418
updated: 2026-04-05 04:04:49

Version 903895

created: 2026-04-04 03:39:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_facility_unit_pricing`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_facility_unit_pricing`\n(\n `facility_key`  int , `avg_ppsqft_non_cc_5x5`  decimal(5,2) , `avg_ppsqft_non_cc_5x10`  decimal(5,2) , `avg_ppsqft_non_cc_5x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x10`  decimal(5,2) , `avg_ppsqft_non_cc_10x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x20`  decimal(5,2) , `avg_ppsqft_non_cc_10x25`  decimal(5,2) , `avg_ppsqft_non_cc_10x30`  decimal(5,2) , `avg_ppsqft_non_cc`  decimal(5,2) , `avg_ppsqft_cc_5x5`  decimal(5,2) , `avg_ppsqft_cc_5x10`  decimal(5,2) , `avg_ppsqft_cc_5x15`  decimal(5,2) , `avg_ppsqft_cc_10x10`  decimal(5,2) , `avg_ppsqft_cc_10x15`  decimal(5,2) , `avg_ppsqft_cc_10x20`  decimal(5,2) , `avg_ppsqft_cc_10x25`  decimal(5,2) , `avg_ppsqft_cc_10x30`  decimal(5,2) , `avg_ppsqft_cc`  decimal(5,2) , `_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/helper_facility_unit_pricing/2026-04-04/1775291909'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_facility_unit_pricing"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_facility_unit_pricing/2026-04-04/1775291909
id: 903895
processed: 1

raw_data:

{
    "_origin": "19",
    "avg_ppsqft_cc": "18",
    "avg_ppsqft_cc_10x10": "13",
    "avg_ppsqft_cc_10x15": "14",
    "avg_ppsqft_cc_10x20": "15",
    "avg_ppsqft_cc_10x25": "16",
    "avg_ppsqft_cc_10x30": "17",
    "avg_ppsqft_cc_5x10": "11",
    "avg_ppsqft_cc_5x15": "12",
    "avg_ppsqft_cc_5x5": "10",
    "avg_ppsqft_non_cc": "9",
    "avg_ppsqft_non_cc_10x10": "4",
    "avg_ppsqft_non_cc_10x15": "5",
    "avg_ppsqft_non_cc_10x20": "6",
    "avg_ppsqft_non_cc_10x25": "7",
    "avg_ppsqft_non_cc_10x30": "8",
    "avg_ppsqft_non_cc_5x10": "2",
    "avg_ppsqft_non_cc_5x15": "3",
    "avg_ppsqft_non_cc_5x5": "1",
    "facility_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "avg_ppsqft_cc": "decimal(5,2)",
    "avg_ppsqft_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_cc_5x5": "decimal(5,2)",
    "avg_ppsqft_non_cc": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
    "facility_key": "int"
}

schema_name_id: 399
schema_scan_id: 6409024
updated: 2026-04-04 03:39:13

Version 903675

created: 2026-04-03 03:44:41

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_facility_unit_pricing`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_facility_unit_pricing`\n(\n `facility_key`  int , `avg_ppsqft_non_cc_5x5`  decimal(5,2) , `avg_ppsqft_non_cc_5x10`  decimal(5,2) , `avg_ppsqft_non_cc_5x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x10`  decimal(5,2) , `avg_ppsqft_non_cc_10x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x20`  decimal(5,2) , `avg_ppsqft_non_cc_10x25`  decimal(5,2) , `avg_ppsqft_non_cc_10x30`  decimal(5,2) , `avg_ppsqft_non_cc`  decimal(5,2) , `avg_ppsqft_cc_5x5`  decimal(5,2) , `avg_ppsqft_cc_5x10`  decimal(5,2) , `avg_ppsqft_cc_5x15`  decimal(5,2) , `avg_ppsqft_cc_10x10`  decimal(5,2) , `avg_ppsqft_cc_10x15`  decimal(5,2) , `avg_ppsqft_cc_10x20`  decimal(5,2) , `avg_ppsqft_cc_10x25`  decimal(5,2) , `avg_ppsqft_cc_10x30`  decimal(5,2) , `avg_ppsqft_cc`  decimal(5,2) , `_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/helper_facility_unit_pricing/2026-04-03/1775205872'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_facility_unit_pricing"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_facility_unit_pricing/2026-04-03/1775205872
id: 903675
processed: 1

raw_data:

{
    "_origin": "19",
    "avg_ppsqft_cc": "18",
    "avg_ppsqft_cc_10x10": "13",
    "avg_ppsqft_cc_10x15": "14",
    "avg_ppsqft_cc_10x20": "15",
    "avg_ppsqft_cc_10x25": "16",
    "avg_ppsqft_cc_10x30": "17",
    "avg_ppsqft_cc_5x10": "11",
    "avg_ppsqft_cc_5x15": "12",
    "avg_ppsqft_cc_5x5": "10",
    "avg_ppsqft_non_cc": "9",
    "avg_ppsqft_non_cc_10x10": "4",
    "avg_ppsqft_non_cc_10x15": "5",
    "avg_ppsqft_non_cc_10x20": "6",
    "avg_ppsqft_non_cc_10x25": "7",
    "avg_ppsqft_non_cc_10x30": "8",
    "avg_ppsqft_non_cc_5x10": "2",
    "avg_ppsqft_non_cc_5x15": "3",
    "avg_ppsqft_non_cc_5x5": "1",
    "facility_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "avg_ppsqft_cc": "decimal(5,2)",
    "avg_ppsqft_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_cc_5x5": "decimal(5,2)",
    "avg_ppsqft_non_cc": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
    "facility_key": "int"
}

schema_name_id: 399
schema_scan_id: 6408529
updated: 2026-04-03 03:44:53

Schema Scans: 15

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

Scan 6415222

duration: 0:00:12.040236

exit_message:

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

id: 6415222

payload:

{
    "datatype_dict": {
        "avg_ppsqft_cc": "decimal(5,2)",
        "avg_ppsqft_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_cc_5x5": "decimal(5,2)",
        "avg_ppsqft_non_cc": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
        "facility_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/helper_facility_unit_pricing/2026-04-17/1776415507/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/helper_facility_unit_pricing/2026-04-17/1776415507",
        "key": "raw/helper_facility_unit_pricing/2026-04-17/1776415507/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_facility_unit_pricing",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 2855888806825046320,
        "service_name": "redshift_unloads",
        "span_id": 1255277128532525344,
        "trace_id": 1624022607232765264
    }
}

running: False
schema_name_id: 399
start_time: 2026-04-17 03:45:18
success: True
trace_id: 1624022607232765264

Scan 6414649

duration: 0:00:12.076853

exit_message:

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

id: 6414649

payload:

{
    "datatype_dict": {
        "avg_ppsqft_cc": "decimal(5,2)",
        "avg_ppsqft_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_cc_5x5": "decimal(5,2)",
        "avg_ppsqft_non_cc": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
        "facility_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/helper_facility_unit_pricing/2026-04-16/1776329812/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/helper_facility_unit_pricing/2026-04-16/1776329812",
        "key": "raw/helper_facility_unit_pricing/2026-04-16/1776329812/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_facility_unit_pricing",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3612004219082150420,
        "service_name": "redshift_unloads",
        "span_id": 11567604706299005807,
        "trace_id": 2107180911622988199
    }
}

running: False
schema_name_id: 399
start_time: 2026-04-16 03:57:10
success: True
trace_id: 2107180911622988199

Scan 6414180

duration: 0:00:12.065426

exit_message:

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

id: 6414180

payload:

{
    "datatype_dict": {
        "avg_ppsqft_cc": "decimal(5,2)",
        "avg_ppsqft_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_cc_5x5": "decimal(5,2)",
        "avg_ppsqft_non_cc": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
        "facility_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/helper_facility_unit_pricing/2026-04-15/1776242812/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/helper_facility_unit_pricing/2026-04-15/1776242812",
        "key": "raw/helper_facility_unit_pricing/2026-04-15/1776242812/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_facility_unit_pricing",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 2981205526949892572,
        "service_name": "redshift_unloads",
        "span_id": 18119069184625924496,
        "trace_id": 3281822856559738072
    }
}

running: False
schema_name_id: 399
start_time: 2026-04-15 03:47:11
success: True
trace_id: 3281822856559738072

Scan 6413684

duration: 0:00:12.085055

exit_message:

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

id: 6413684

payload:

{
    "datatype_dict": {
        "avg_ppsqft_cc": "decimal(5,2)",
        "avg_ppsqft_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_cc_5x5": "decimal(5,2)",
        "avg_ppsqft_non_cc": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
        "facility_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/helper_facility_unit_pricing/2026-04-14/1776156852/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/helper_facility_unit_pricing/2026-04-14/1776156852",
        "key": "raw/helper_facility_unit_pricing/2026-04-14/1776156852/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_facility_unit_pricing",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13257504965902906809,
        "service_name": "redshift_unloads",
        "span_id": 10965329056765886176,
        "trace_id": 10651044402428370704
    }
}

running: False
schema_name_id: 399
start_time: 2026-04-14 03:54:41
success: True
trace_id: 10651044402428370704

Scan 6413102

duration: 0:00:12.062049

exit_message:

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

id: 6413102

payload:

{
    "datatype_dict": {
        "avg_ppsqft_cc": "decimal(5,2)",
        "avg_ppsqft_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_cc_5x5": "decimal(5,2)",
        "avg_ppsqft_non_cc": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
        "facility_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/helper_facility_unit_pricing/2026-04-13/1776068486/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/helper_facility_unit_pricing/2026-04-13/1776068486",
        "key": "raw/helper_facility_unit_pricing/2026-04-13/1776068486/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_facility_unit_pricing",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13580377977300230837,
        "service_name": "redshift_unloads",
        "span_id": 14953298338724312237,
        "trace_id": 455943565036512256
    }
}

running: False
schema_name_id: 399
start_time: 2026-04-13 03:21:51
success: True
trace_id: 455943565036512256

Scan 6412742

duration: 0:00:12.130934

exit_message:

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

id: 6412742

payload:

{
    "datatype_dict": {
        "avg_ppsqft_cc": "decimal(5,2)",
        "avg_ppsqft_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_cc_5x5": "decimal(5,2)",
        "avg_ppsqft_non_cc": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
        "facility_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/helper_facility_unit_pricing/2026-04-12/1775984119/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/helper_facility_unit_pricing/2026-04-12/1775984119",
        "key": "raw/helper_facility_unit_pricing/2026-04-12/1775984119/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_facility_unit_pricing",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 16902210299259469435,
        "service_name": "redshift_unloads",
        "span_id": 6251163770407159057,
        "trace_id": 8818770356372465704
    }
}

running: False
schema_name_id: 399
start_time: 2026-04-12 03:55:35
success: True
trace_id: 8818770356372465704

Scan 6412327

duration: 0:00:12.005316

exit_message:

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

id: 6412327

payload:

{
    "datatype_dict": {
        "avg_ppsqft_cc": "decimal(5,2)",
        "avg_ppsqft_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_cc_5x5": "decimal(5,2)",
        "avg_ppsqft_non_cc": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
        "facility_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/helper_facility_unit_pricing/2026-04-11/1775895629/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/helper_facility_unit_pricing/2026-04-11/1775895629",
        "key": "raw/helper_facility_unit_pricing/2026-04-11/1775895629/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_facility_unit_pricing",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13181885934580862826,
        "service_name": "redshift_unloads",
        "span_id": 16916642127232260890,
        "trace_id": 3921127629796492810
    }
}

running: False
schema_name_id: 399
start_time: 2026-04-11 03:20:50
success: True
trace_id: 3921127629796492810

Scan 6411833

duration: 0:00:14.722349

exit_message:

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

id: 6411833

payload:

{
    "datatype_dict": {
        "avg_ppsqft_cc": "decimal(5,2)",
        "avg_ppsqft_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_cc_5x5": "decimal(5,2)",
        "avg_ppsqft_non_cc": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
        "facility_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/helper_facility_unit_pricing/2026-04-10/1775809118/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/helper_facility_unit_pricing/2026-04-10/1775809118",
        "key": "raw/helper_facility_unit_pricing/2026-04-10/1775809118/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_facility_unit_pricing",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 16873071156257839971,
        "service_name": "redshift_unloads",
        "span_id": 7741107153050038331,
        "trace_id": 18186360827048860789
    }
}

running: False
schema_name_id: 399
start_time: 2026-04-10 03:18:48
success: True
trace_id: 18186360827048860789

Scan 6411320

duration: 0:00:14.772365

exit_message:

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

id: 6411320

payload:

{
    "datatype_dict": {
        "avg_ppsqft_cc": "decimal(5,2)",
        "avg_ppsqft_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_cc_5x5": "decimal(5,2)",
        "avg_ppsqft_non_cc": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
        "facility_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/helper_facility_unit_pricing/2026-04-09/1775724549/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/helper_facility_unit_pricing/2026-04-09/1775724549",
        "key": "raw/helper_facility_unit_pricing/2026-04-09/1775724549/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_facility_unit_pricing",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 11474814834508240523,
        "service_name": "redshift_unloads",
        "span_id": 15782084679189692499,
        "trace_id": 837982423898389099
    }
}

running: False
schema_name_id: 399
start_time: 2026-04-09 03:49:32
success: True
trace_id: 837982423898389099

Scan 6410854

duration: 0:00:12.166935

exit_message:

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

id: 6410854

payload:

{
    "datatype_dict": {
        "avg_ppsqft_cc": "decimal(5,2)",
        "avg_ppsqft_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_cc_5x5": "decimal(5,2)",
        "avg_ppsqft_non_cc": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
        "facility_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/helper_facility_unit_pricing/2026-04-08/1775638530/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/helper_facility_unit_pricing/2026-04-08/1775638530",
        "key": "raw/helper_facility_unit_pricing/2026-04-08/1775638530/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_facility_unit_pricing",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 9779788318610201085,
        "service_name": "redshift_unloads",
        "span_id": 13528161215231851808,
        "trace_id": 3735564649019860004
    }
}

running: False
schema_name_id: 399
start_time: 2026-04-08 03:55:45
success: True
trace_id: 3735564649019860004

Scan 6410341

duration: 0:00:12.180602

exit_message:

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

id: 6410341

payload:

{
    "datatype_dict": {
        "avg_ppsqft_cc": "decimal(5,2)",
        "avg_ppsqft_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_cc_5x5": "decimal(5,2)",
        "avg_ppsqft_non_cc": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
        "facility_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/helper_facility_unit_pricing/2026-04-07/1775551266/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/helper_facility_unit_pricing/2026-04-07/1775551266",
        "key": "raw/helper_facility_unit_pricing/2026-04-07/1775551266/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_facility_unit_pricing",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 2475292381573363136,
        "service_name": "redshift_unloads",
        "span_id": 14564309131789587383,
        "trace_id": 12371198596988633109
    }
}

running: False
schema_name_id: 399
start_time: 2026-04-07 03:41:14
success: True
trace_id: 12371198596988633109

Scan 6409784

duration: 0:00:12.143637

exit_message:

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

id: 6409784

payload:

{
    "datatype_dict": {
        "avg_ppsqft_cc": "decimal(5,2)",
        "avg_ppsqft_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_cc_5x5": "decimal(5,2)",
        "avg_ppsqft_non_cc": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
        "facility_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/helper_facility_unit_pricing/2026-04-06/1775465177/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/helper_facility_unit_pricing/2026-04-06/1775465177",
        "key": "raw/helper_facility_unit_pricing/2026-04-06/1775465177/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_facility_unit_pricing",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 11201075203841321728,
        "service_name": "redshift_unloads",
        "span_id": 14971428474757388790,
        "trace_id": 6513960833397166502
    }
}

running: False
schema_name_id: 399
start_time: 2026-04-06 03:46:31
success: True
trace_id: 6513960833397166502

Scan 6409418

duration: 0:00:14.629839

exit_message:

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

id: 6409418

payload:

{
    "datatype_dict": {
        "avg_ppsqft_cc": "decimal(5,2)",
        "avg_ppsqft_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_cc_5x5": "decimal(5,2)",
        "avg_ppsqft_non_cc": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
        "facility_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/helper_facility_unit_pricing/2026-04-05/1775379839/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/helper_facility_unit_pricing/2026-04-05/1775379839",
        "key": "raw/helper_facility_unit_pricing/2026-04-05/1775379839/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_facility_unit_pricing",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8840915127086348251,
        "service_name": "redshift_unloads",
        "span_id": 3722757027799617930,
        "trace_id": 2725738061043814252
    }
}

running: False
schema_name_id: 399
start_time: 2026-04-05 04:04:34
success: True
trace_id: 2725738061043814252

Scan 6409024

duration: 0:00:12.307593

exit_message:

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

id: 6409024

payload:

{
    "datatype_dict": {
        "avg_ppsqft_cc": "decimal(5,2)",
        "avg_ppsqft_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_cc_5x5": "decimal(5,2)",
        "avg_ppsqft_non_cc": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
        "facility_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/helper_facility_unit_pricing/2026-04-04/1775291909/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/helper_facility_unit_pricing/2026-04-04/1775291909",
        "key": "raw/helper_facility_unit_pricing/2026-04-04/1775291909/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_facility_unit_pricing",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 2029548460905114104,
        "service_name": "redshift_unloads",
        "span_id": 17034079642307953770,
        "trace_id": 2580891179325076751
    }
}

running: False
schema_name_id: 399
start_time: 2026-04-04 03:39:01
success: True
trace_id: 2580891179325076751

Scan 6408529

duration: 0:00:11.997156

exit_message:

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

id: 6408529

payload:

{
    "datatype_dict": {
        "avg_ppsqft_cc": "decimal(5,2)",
        "avg_ppsqft_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_cc_5x5": "decimal(5,2)",
        "avg_ppsqft_non_cc": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
        "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
        "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
        "facility_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/helper_facility_unit_pricing/2026-04-03/1775205872/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/helper_facility_unit_pricing/2026-04-03/1775205872",
        "key": "raw/helper_facility_unit_pricing/2026-04-03/1775205872/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_facility_unit_pricing",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 6599599438144046951,
        "service_name": "redshift_unloads",
        "span_id": 1329808604113273510,
        "trace_id": 5201779821597363826
    }
}

running: False
schema_name_id: 399
start_time: 2026-04-03 03:44:41
success: True
trace_id: 5201779821597363826

Partitions:

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

Schema:

attributes:

{
    "_origin": "string",
    "avg_ppsqft_cc": "decimal(5,2)",
    "avg_ppsqft_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_cc_5x5": "decimal(5,2)",
    "avg_ppsqft_non_cc": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
    "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
    "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
    "facility_key": "int"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_facility_unit_pricing`\n(\n `facility_key`  int , `avg_ppsqft_non_cc_5x5`  decimal(5,2) , `avg_ppsqft_non_cc_5x10`  decimal(5,2) , `avg_ppsqft_non_cc_5x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x10`  decimal(5,2) , `avg_ppsqft_non_cc_10x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x20`  decimal(5,2) , `avg_ppsqft_non_cc_10x25`  decimal(5,2) , `avg_ppsqft_non_cc_10x30`  decimal(5,2) , `avg_ppsqft_non_cc`  decimal(5,2) , `avg_ppsqft_cc_5x5`  decimal(5,2) , `avg_ppsqft_cc_5x10`  decimal(5,2) , `avg_ppsqft_cc_5x15`  decimal(5,2) , `avg_ppsqft_cc_10x10`  decimal(5,2) , `avg_ppsqft_cc_10x15`  decimal(5,2) , `avg_ppsqft_cc_10x20`  decimal(5,2) , `avg_ppsqft_cc_10x25`  decimal(5,2) , `avg_ppsqft_cc_10x30`  decimal(5,2) , `avg_ppsqft_cc`  decimal(5,2) , `_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/helper_facility_unit_pricing/2026-04-17/1776415507'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_facility_unit_pricing`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_facility_unit_pricing"
}

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-02-21 00:02:33",
        "disabled": false,
        "format": "raw",
        "id": 399,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_redshift",
            "table": "analytics_helper_facility_unit_pricing"
        },
        "type": "redshift"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "_origin": "string",
            "avg_ppsqft_cc": "decimal(5,2)",
            "avg_ppsqft_cc_10x10": "decimal(5,2)",
            "avg_ppsqft_cc_10x15": "decimal(5,2)",
            "avg_ppsqft_cc_10x20": "decimal(5,2)",
            "avg_ppsqft_cc_10x25": "decimal(5,2)",
            "avg_ppsqft_cc_10x30": "decimal(5,2)",
            "avg_ppsqft_cc_5x10": "decimal(5,2)",
            "avg_ppsqft_cc_5x15": "decimal(5,2)",
            "avg_ppsqft_cc_5x5": "decimal(5,2)",
            "avg_ppsqft_non_cc": "decimal(5,2)",
            "avg_ppsqft_non_cc_10x10": "decimal(5,2)",
            "avg_ppsqft_non_cc_10x15": "decimal(5,2)",
            "avg_ppsqft_non_cc_10x20": "decimal(5,2)",
            "avg_ppsqft_non_cc_10x25": "decimal(5,2)",
            "avg_ppsqft_non_cc_10x30": "decimal(5,2)",
            "avg_ppsqft_non_cc_5x10": "decimal(5,2)",
            "avg_ppsqft_non_cc_5x15": "decimal(5,2)",
            "avg_ppsqft_non_cc_5x5": "decimal(5,2)",
            "facility_key": "int"
        },
        "created": "2026-04-17 03:45:19",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_facility_unit_pricing`\n(\n `facility_key`  int , `avg_ppsqft_non_cc_5x5`  decimal(5,2) , `avg_ppsqft_non_cc_5x10`  decimal(5,2) , `avg_ppsqft_non_cc_5x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x10`  decimal(5,2) , `avg_ppsqft_non_cc_10x15`  decimal(5,2) , `avg_ppsqft_non_cc_10x20`  decimal(5,2) , `avg_ppsqft_non_cc_10x25`  decimal(5,2) , `avg_ppsqft_non_cc_10x30`  decimal(5,2) , `avg_ppsqft_non_cc`  decimal(5,2) , `avg_ppsqft_cc_5x5`  decimal(5,2) , `avg_ppsqft_cc_5x10`  decimal(5,2) , `avg_ppsqft_cc_5x15`  decimal(5,2) , `avg_ppsqft_cc_10x10`  decimal(5,2) , `avg_ppsqft_cc_10x15`  decimal(5,2) , `avg_ppsqft_cc_10x20`  decimal(5,2) , `avg_ppsqft_cc_10x25`  decimal(5,2) , `avg_ppsqft_cc_10x30`  decimal(5,2) , `avg_ppsqft_cc`  decimal(5,2) , `_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/helper_facility_unit_pricing/2026-04-17/1776415507'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_facility_unit_pricing`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_facility_unit_pricing"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}