Schema Info

Schema Name: sfdl_prod_redshift.analytics_reference_test_facilities

created: 2018-11-19 15:30:57
disabled: False
format: raw
id: 577
is_partitioned: False
is_schema_datatyped: True

name:

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

type: redshift

Schema Versions: 15

Version 1717896

created: 2026-04-17 03:40:13

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_test_facilities/2026-04-17/1776415201
id: 1717896
processed: 1

raw_data:

{
    "_origin": "1",
    "facility_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "facility_key": "int"
}

schema_name_id: 577
schema_scan_id: 162168013
updated: 2026-04-17 03:40:27

Version 1716671

created: 2026-04-16 04:10:06

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_test_facilities/2026-04-16/1776330596
id: 1716671
processed: 1

raw_data:

{
    "_origin": "1",
    "facility_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "facility_key": "int"
}

schema_name_id: 577
schema_scan_id: 162113328
updated: 2026-04-16 04:10:20

Version 1715433

created: 2026-04-15 03:34:35

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_test_facilities/2026-04-15/1776242058
id: 1715433
processed: 1

raw_data:

{
    "_origin": "1",
    "facility_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "facility_key": "int"
}

schema_name_id: 577
schema_scan_id: 162056286
updated: 2026-04-15 03:34:49

Version 1714267

created: 2026-04-14 03:58:33

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_test_facilities/2026-04-14/1776157069
id: 1714267
processed: 1

raw_data:

{
    "_origin": "1",
    "facility_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "facility_key": "int"
}

schema_name_id: 577
schema_scan_id: 162001431
updated: 2026-04-14 03:58:44

Version 1713025

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

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_test_facilities/2026-04-13/1776070455
id: 1713025
processed: 1

raw_data:

{
    "_origin": "1",
    "facility_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "facility_key": "int"
}

schema_name_id: 577
schema_scan_id: 161943085
updated: 2026-04-13 03:54:33

Version 1711861

created: 2026-04-12 04:07:40

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_test_facilities/2026-04-12/1775984838
id: 1711861
processed: 1

raw_data:

{
    "_origin": "1",
    "facility_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "facility_key": "int"
}

schema_name_id: 577
schema_scan_id: 161894928
updated: 2026-04-12 04:07:54

Version 1710606

created: 2026-04-11 03:40:30

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_test_facilities/2026-04-11/1775896822
id: 1710606
processed: 1

raw_data:

{
    "_origin": "1",
    "facility_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "facility_key": "int"
}

schema_name_id: 577
schema_scan_id: 161841441
updated: 2026-04-11 03:40:41

Version 1709467

created: 2026-04-10 04:03:29

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_test_facilities/2026-04-10/1775811802
id: 1709467
processed: 1

raw_data:

{
    "_origin": "1",
    "facility_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "facility_key": "int"
}

schema_name_id: 577
schema_scan_id: 161787352
updated: 2026-04-10 04:03:46

Version 1708338

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

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_test_facilities/2026-04-09/1775724540
id: 1708338
processed: 1

raw_data:

{
    "_origin": "1",
    "facility_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "facility_key": "int"
}

schema_name_id: 577
schema_scan_id: 161730714
updated: 2026-04-09 03:49:28

Version 1707086

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

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_test_facilities/2026-04-08/1775636426
id: 1707086
processed: 1

raw_data:

{
    "_origin": "1",
    "facility_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "facility_key": "int"
}

schema_name_id: 577
schema_scan_id: 161675783
updated: 2026-04-08 03:20:58

Version 1705928

created: 2026-04-07 03:40:39

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_test_facilities/2026-04-07/1775551226
id: 1705928
processed: 1

raw_data:

{
    "_origin": "1",
    "facility_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "facility_key": "int"
}

schema_name_id: 577
schema_scan_id: 161619721
updated: 2026-04-07 03:40:53

Version 1704734

created: 2026-04-06 04:02:08

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_test_facilities/2026-04-06/1775466121
id: 1704734
processed: 1

raw_data:

{
    "_origin": "1",
    "facility_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "facility_key": "int"
}

schema_name_id: 577
schema_scan_id: 161562940
updated: 2026-04-06 04:02:22

Version 1703506

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

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_test_facilities/2026-04-05/1775379456
id: 1703506
processed: 1

raw_data:

{
    "_origin": "1",
    "facility_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "facility_key": "int"
}

schema_name_id: 577
schema_scan_id: 161515743
updated: 2026-04-05 03:58:11

Version 1702342

created: 2026-04-04 03:36:44

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_test_facilities/2026-04-04/1775291796
id: 1702342
processed: 1

raw_data:

{
    "_origin": "1",
    "facility_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "facility_key": "int"
}

schema_name_id: 577
schema_scan_id: 161460719
updated: 2026-04-04 03:36:58

Version 1701113

created: 2026-04-03 03:33:28

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_test_facilities/2026-04-03/1775205201
id: 1701113
processed: 1

raw_data:

{
    "_origin": "1",
    "facility_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "facility_key": "int"
}

schema_name_id: 577
schema_scan_id: 161402138
updated: 2026-04-03 03:33:39

Schema Scans: 15

Last at 2026-04-17 03:40:13

Scan 162168013

duration: 0:00:14.134907

exit_message:

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

id: 162168013

payload:

{
    "datatype_dict": {
        "facility_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_test_facilities/2026-04-17/1776415201/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_test_facilities/2026-04-17/1776415201",
        "key": "raw/reference_test_facilities/2026-04-17/1776415201/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_test_facilities",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 967577642846816814,
        "service_name": "redshift_unloads",
        "span_id": 562383221070995958,
        "trace_id": 8187634280208934318
    }
}

running: False
schema_name_id: 577
start_time: 2026-04-17 03:40:13
success: True
trace_id: 8187634280208934318

Scan 162113328

duration: 0:00:14.227994

exit_message:

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

id: 162113328

payload:

{
    "datatype_dict": {
        "facility_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_test_facilities/2026-04-16/1776330596/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_test_facilities/2026-04-16/1776330596",
        "key": "raw/reference_test_facilities/2026-04-16/1776330596/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_test_facilities",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 2038777268869848980,
        "service_name": "redshift_unloads",
        "span_id": 7429409034864511524,
        "trace_id": 17167649024979739001
    }
}

running: False
schema_name_id: 577
start_time: 2026-04-16 04:10:06
success: True
trace_id: 17167649024979739001

Scan 162056286

duration: 0:00:14.172637

exit_message:

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

id: 162056286

payload:

{
    "datatype_dict": {
        "facility_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_test_facilities/2026-04-15/1776242058/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_test_facilities/2026-04-15/1776242058",
        "key": "raw/reference_test_facilities/2026-04-15/1776242058/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_test_facilities",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 1469104742951638947,
        "service_name": "redshift_unloads",
        "span_id": 17266403755453959138,
        "trace_id": 11750912198939657492
    }
}

running: False
schema_name_id: 577
start_time: 2026-04-15 03:34:35
success: True
trace_id: 11750912198939657492

Scan 162001431

duration: 0:00:11.616677

exit_message:

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

id: 162001431

payload:

{
    "datatype_dict": {
        "facility_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_test_facilities/2026-04-14/1776157069/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_test_facilities/2026-04-14/1776157069",
        "key": "raw/reference_test_facilities/2026-04-14/1776157069/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_test_facilities",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 11937806260741572324,
        "service_name": "redshift_unloads",
        "span_id": 15576548170519351907,
        "trace_id": 5534530287366560196
    }
}

running: False
schema_name_id: 577
start_time: 2026-04-14 03:58:32
success: True
trace_id: 5534530287366560196

Scan 161943085

duration: 0:00:11.545686

exit_message:

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

id: 161943085

payload:

{
    "datatype_dict": {
        "facility_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_test_facilities/2026-04-13/1776070455/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_test_facilities/2026-04-13/1776070455",
        "key": "raw/reference_test_facilities/2026-04-13/1776070455/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_test_facilities",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 14178793068840520054,
        "service_name": "redshift_unloads",
        "span_id": 14573417721551391554,
        "trace_id": 16539488229755058228
    }
}

running: False
schema_name_id: 577
start_time: 2026-04-13 03:54:21
success: True
trace_id: 16539488229755058228

Scan 161894928

duration: 0:00:14.150495

exit_message:

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

id: 161894928

payload:

{
    "datatype_dict": {
        "facility_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_test_facilities/2026-04-12/1775984838/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_test_facilities/2026-04-12/1775984838",
        "key": "raw/reference_test_facilities/2026-04-12/1775984838/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_test_facilities",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 7893948425824363658,
        "service_name": "redshift_unloads",
        "span_id": 6023671675939796610,
        "trace_id": 11361093261055962731
    }
}

running: False
schema_name_id: 577
start_time: 2026-04-12 04:07:40
success: True
trace_id: 11361093261055962731

Scan 161841441

duration: 0:00:11.548644

exit_message:

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

id: 161841441

payload:

{
    "datatype_dict": {
        "facility_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_test_facilities/2026-04-11/1775896822/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_test_facilities/2026-04-11/1775896822",
        "key": "raw/reference_test_facilities/2026-04-11/1775896822/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_test_facilities",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15627484763880922295,
        "service_name": "redshift_unloads",
        "span_id": 8000146297220269213,
        "trace_id": 12287719383941013551
    }
}

running: False
schema_name_id: 577
start_time: 2026-04-11 03:40:29
success: True
trace_id: 12287719383941013551

Scan 161787352

duration: 0:00:16.684043

exit_message:

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

id: 161787352

payload:

{
    "datatype_dict": {
        "facility_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_test_facilities/2026-04-10/1775811802/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_test_facilities/2026-04-10/1775811802",
        "key": "raw/reference_test_facilities/2026-04-10/1775811802/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_test_facilities",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 5472054839539300801,
        "service_name": "redshift_unloads",
        "span_id": 16314249888201881283,
        "trace_id": 15669760434100383798
    }
}

running: False
schema_name_id: 577
start_time: 2026-04-10 04:03:29
success: True
trace_id: 15669760434100383798

Scan 161730714

duration: 0:00:14.065974

exit_message:

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

id: 161730714

payload:

{
    "datatype_dict": {
        "facility_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_test_facilities/2026-04-09/1775724540/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_test_facilities/2026-04-09/1775724540",
        "key": "raw/reference_test_facilities/2026-04-09/1775724540/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_test_facilities",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 16127412495585428625,
        "service_name": "redshift_unloads",
        "span_id": 7953141790432291376,
        "trace_id": 207777821587406284
    }
}

running: False
schema_name_id: 577
start_time: 2026-04-09 03:49:14
success: True
trace_id: 207777821587406284

Scan 161675783

duration: 0:00:11.643481

exit_message:

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

id: 161675783

payload:

{
    "datatype_dict": {
        "facility_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_test_facilities/2026-04-08/1775636426/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_test_facilities/2026-04-08/1775636426",
        "key": "raw/reference_test_facilities/2026-04-08/1775636426/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_test_facilities",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 5879337088243800729,
        "service_name": "redshift_unloads",
        "span_id": 14975826101902824274,
        "trace_id": 11668784939988752296
    }
}

running: False
schema_name_id: 577
start_time: 2026-04-08 03:20:46
success: True
trace_id: 11668784939988752296

Scan 161619721

duration: 0:00:14.124676

exit_message:

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

id: 161619721

payload:

{
    "datatype_dict": {
        "facility_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_test_facilities/2026-04-07/1775551226/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_test_facilities/2026-04-07/1775551226",
        "key": "raw/reference_test_facilities/2026-04-07/1775551226/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_test_facilities",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15714877373559092067,
        "service_name": "redshift_unloads",
        "span_id": 636376351258378233,
        "trace_id": 6036552408551484058
    }
}

running: False
schema_name_id: 577
start_time: 2026-04-07 03:40:39
success: True
trace_id: 6036552408551484058

Scan 161562940

duration: 0:00:14.158119

exit_message:

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

id: 161562940

payload:

{
    "datatype_dict": {
        "facility_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_test_facilities/2026-04-06/1775466121/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_test_facilities/2026-04-06/1775466121",
        "key": "raw/reference_test_facilities/2026-04-06/1775466121/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_test_facilities",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 4251842266471939268,
        "service_name": "redshift_unloads",
        "span_id": 8134353279515204742,
        "trace_id": 13972655896933226807
    }
}

running: False
schema_name_id: 577
start_time: 2026-04-06 04:02:08
success: True
trace_id: 13972655896933226807

Scan 161515743

duration: 0:00:11.566363

exit_message:

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

id: 161515743

payload:

{
    "datatype_dict": {
        "facility_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_test_facilities/2026-04-05/1775379456/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_test_facilities/2026-04-05/1775379456",
        "key": "raw/reference_test_facilities/2026-04-05/1775379456/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_test_facilities",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 1226432659362387868,
        "service_name": "redshift_unloads",
        "span_id": 2857728191085003261,
        "trace_id": 10149428053419157475
    }
}

running: False
schema_name_id: 577
start_time: 2026-04-05 03:57:59
success: True
trace_id: 10149428053419157475

Scan 161460719

duration: 0:00:14.103771

exit_message:

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

id: 161460719

payload:

{
    "datatype_dict": {
        "facility_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_test_facilities/2026-04-04/1775291796/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_test_facilities/2026-04-04/1775291796",
        "key": "raw/reference_test_facilities/2026-04-04/1775291796/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_test_facilities",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8009257345132769198,
        "service_name": "redshift_unloads",
        "span_id": 7022568004086121881,
        "trace_id": 8692867400473948993
    }
}

running: False
schema_name_id: 577
start_time: 2026-04-04 03:36:44
success: True
trace_id: 8692867400473948993

Scan 161402138

duration: 0:00:11.537779

exit_message:

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

id: 161402138

payload:

{
    "datatype_dict": {
        "facility_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_test_facilities/2026-04-03/1775205201/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_test_facilities/2026-04-03/1775205201",
        "key": "raw/reference_test_facilities/2026-04-03/1775205201/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_test_facilities",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 6245418220992551814,
        "service_name": "redshift_unloads",
        "span_id": 459013112083813125,
        "trace_id": 1030381289790159703
    }
}

running: False
schema_name_id: 577
start_time: 2026-04-03 03:33:28
success: True
trace_id: 1030381289790159703

Partitions:

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

Schema:

attributes:

{
    "_origin": "string",
    "facility_key": "int"
}

created: 2026-04-17 03:40:13

ddl:

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

Server:

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

Raw:

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