Schema Info

Schema Name: sfdl_stage_redshift.analytics_helper_facility_first_last

created: 2018-02-20 23:56:54
disabled: False
format: raw
id: 382
is_partitioned: False
is_schema_datatyped: True

name:

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

type: redshift

Schema Versions: 15

Version 906607

created: 2026-04-17 03:22:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_facility_first_last`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_facility_first_last`\n(\n `facility_key`  int , `facility_date_live_key`  int , `last_hide_timestamp`  timestamp , `first_bid_change_timestamp`  timestamp , `last_bid_change_timestamp`  timestamp , `first_impression_timestamp`  timestamp , `_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_first_last/2026-04-17/1776414147'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_facility_first_last"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_facility_first_last/2026-04-17/1776414147
id: 906607
processed: 1

raw_data:

{
    "_origin": "6",
    "facility_date_live_key": "1",
    "facility_key": "0",
    "first_bid_change_timestamp": "3",
    "first_impression_timestamp": "5",
    "last_bid_change_timestamp": "4",
    "last_hide_timestamp": "2"
}

schema_attributes:

{
    "_origin": "string",
    "facility_date_live_key": "int",
    "facility_key": "int",
    "first_bid_change_timestamp": "timestamp",
    "first_impression_timestamp": "timestamp",
    "last_bid_change_timestamp": "timestamp",
    "last_hide_timestamp": "timestamp"
}

schema_name_id: 382
schema_scan_id: 6415186
updated: 2026-04-17 03:22:57

Version 906388

created: 2026-04-16 03:47:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_facility_first_last`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_facility_first_last`\n(\n `facility_key`  int , `facility_date_live_key`  int , `last_hide_timestamp`  timestamp , `first_bid_change_timestamp`  timestamp , `last_bid_change_timestamp`  timestamp , `first_impression_timestamp`  timestamp , `_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_first_last/2026-04-16/1776329231'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_facility_first_last"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_facility_first_last/2026-04-16/1776329231
id: 906388
processed: 1

raw_data:

{
    "_origin": "6",
    "facility_date_live_key": "1",
    "facility_key": "0",
    "first_bid_change_timestamp": "3",
    "first_impression_timestamp": "5",
    "last_bid_change_timestamp": "4",
    "last_hide_timestamp": "2"
}

schema_attributes:

{
    "_origin": "string",
    "facility_date_live_key": "int",
    "facility_key": "int",
    "first_bid_change_timestamp": "timestamp",
    "first_impression_timestamp": "timestamp",
    "last_bid_change_timestamp": "timestamp",
    "last_hide_timestamp": "timestamp"
}

schema_name_id: 382
schema_scan_id: 6414638
updated: 2026-04-16 03:47:38

Version 906205

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_facility_first_last`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_facility_first_last`\n(\n `facility_key`  int , `facility_date_live_key`  int , `last_hide_timestamp`  timestamp , `first_bid_change_timestamp`  timestamp , `last_bid_change_timestamp`  timestamp , `first_impression_timestamp`  timestamp , `_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_first_last/2026-04-15/1776242807'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_facility_first_last"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_facility_first_last/2026-04-15/1776242807
id: 906205
processed: 1

raw_data:

{
    "_origin": "6",
    "facility_date_live_key": "1",
    "facility_key": "0",
    "first_bid_change_timestamp": "3",
    "first_impression_timestamp": "5",
    "last_bid_change_timestamp": "4",
    "last_hide_timestamp": "2"
}

schema_attributes:

{
    "_origin": "string",
    "facility_date_live_key": "int",
    "facility_key": "int",
    "first_bid_change_timestamp": "timestamp",
    "first_impression_timestamp": "timestamp",
    "last_bid_change_timestamp": "timestamp",
    "last_hide_timestamp": "timestamp"
}

schema_name_id: 382
schema_scan_id: 6414181
updated: 2026-04-15 03:47:26

Version 905996

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_facility_first_last`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_facility_first_last`\n(\n `facility_key`  int , `facility_date_live_key`  int , `last_hide_timestamp`  timestamp , `first_bid_change_timestamp`  timestamp , `last_bid_change_timestamp`  timestamp , `first_impression_timestamp`  timestamp , `_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_first_last/2026-04-14/1776156849'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_facility_first_last"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_facility_first_last/2026-04-14/1776156849
id: 905996
processed: 1

raw_data:

{
    "_origin": "6",
    "facility_date_live_key": "1",
    "facility_key": "0",
    "first_bid_change_timestamp": "3",
    "first_impression_timestamp": "5",
    "last_bid_change_timestamp": "4",
    "last_hide_timestamp": "2"
}

schema_attributes:

{
    "_origin": "string",
    "facility_date_live_key": "int",
    "facility_key": "int",
    "first_bid_change_timestamp": "timestamp",
    "first_impression_timestamp": "timestamp",
    "last_bid_change_timestamp": "timestamp",
    "last_hide_timestamp": "timestamp"
}

schema_name_id: 382
schema_scan_id: 6413682
updated: 2026-04-14 03:54:53

Version 905745

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_facility_first_last`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_facility_first_last`\n(\n `facility_key`  int , `facility_date_live_key`  int , `last_hide_timestamp`  timestamp , `first_bid_change_timestamp`  timestamp , `last_bid_change_timestamp`  timestamp , `first_impression_timestamp`  timestamp , `_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_first_last/2026-04-13/1776068482'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_facility_first_last"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_facility_first_last/2026-04-13/1776068482
id: 905745
processed: 1

raw_data:

{
    "_origin": "6",
    "facility_date_live_key": "1",
    "facility_key": "0",
    "first_bid_change_timestamp": "3",
    "first_impression_timestamp": "5",
    "last_bid_change_timestamp": "4",
    "last_hide_timestamp": "2"
}

schema_attributes:

{
    "_origin": "string",
    "facility_date_live_key": "int",
    "facility_key": "int",
    "first_bid_change_timestamp": "timestamp",
    "first_impression_timestamp": "timestamp",
    "last_bid_change_timestamp": "timestamp",
    "last_hide_timestamp": "timestamp"
}

schema_name_id: 382
schema_scan_id: 6413099
updated: 2026-04-13 03:21:44

Version 905573

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_facility_first_last`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_facility_first_last`\n(\n `facility_key`  int , `facility_date_live_key`  int , `last_hide_timestamp`  timestamp , `first_bid_change_timestamp`  timestamp , `last_bid_change_timestamp`  timestamp , `first_impression_timestamp`  timestamp , `_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_first_last/2026-04-12/1775984087'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_facility_first_last"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_facility_first_last/2026-04-12/1775984087
id: 905573
processed: 1

raw_data:

{
    "_origin": "6",
    "facility_date_live_key": "1",
    "facility_key": "0",
    "first_bid_change_timestamp": "3",
    "first_impression_timestamp": "5",
    "last_bid_change_timestamp": "4",
    "last_hide_timestamp": "2"
}

schema_attributes:

{
    "_origin": "string",
    "facility_date_live_key": "int",
    "facility_key": "int",
    "first_bid_change_timestamp": "timestamp",
    "first_impression_timestamp": "timestamp",
    "last_bid_change_timestamp": "timestamp",
    "last_hide_timestamp": "timestamp"
}

schema_name_id: 382
schema_scan_id: 6412737
updated: 2026-04-12 03:55:34

Version 905367

created: 2026-04-11 03:31:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_facility_first_last`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_facility_first_last`\n(\n `facility_key`  int , `facility_date_live_key`  int , `last_hide_timestamp`  timestamp , `first_bid_change_timestamp`  timestamp , `last_bid_change_timestamp`  timestamp , `first_impression_timestamp`  timestamp , `_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_first_last/2026-04-11/1775896303'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_facility_first_last"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_facility_first_last/2026-04-11/1775896303
id: 905367
processed: 1

raw_data:

{
    "_origin": "6",
    "facility_date_live_key": "1",
    "facility_key": "0",
    "first_bid_change_timestamp": "3",
    "first_impression_timestamp": "5",
    "last_bid_change_timestamp": "4",
    "last_hide_timestamp": "2"
}

schema_attributes:

{
    "_origin": "string",
    "facility_date_live_key": "int",
    "facility_key": "int",
    "first_bid_change_timestamp": "timestamp",
    "first_impression_timestamp": "timestamp",
    "last_bid_change_timestamp": "timestamp",
    "last_hide_timestamp": "timestamp"
}

schema_name_id: 382
schema_scan_id: 6412352
updated: 2026-04-11 03:32:06

Version 905166

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_facility_first_last`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_facility_first_last`\n(\n `facility_key`  int , `facility_date_live_key`  int , `last_hide_timestamp`  timestamp , `first_bid_change_timestamp`  timestamp , `last_bid_change_timestamp`  timestamp , `first_impression_timestamp`  timestamp , `_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_first_last/2026-04-10/1775811338'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_facility_first_last"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_facility_first_last/2026-04-10/1775811338
id: 905166
processed: 1

raw_data:

{
    "_origin": "6",
    "facility_date_live_key": "1",
    "facility_key": "0",
    "first_bid_change_timestamp": "3",
    "first_impression_timestamp": "5",
    "last_bid_change_timestamp": "4",
    "last_hide_timestamp": "2"
}

schema_attributes:

{
    "_origin": "string",
    "facility_date_live_key": "int",
    "facility_key": "int",
    "first_bid_change_timestamp": "timestamp",
    "first_impression_timestamp": "timestamp",
    "last_bid_change_timestamp": "timestamp",
    "last_hide_timestamp": "timestamp"
}

schema_name_id: 382
schema_scan_id: 6411871
updated: 2026-04-10 03:56:02

Version 904917

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_facility_first_last`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_facility_first_last`\n(\n `facility_key`  int , `facility_date_live_key`  int , `last_hide_timestamp`  timestamp , `first_bid_change_timestamp`  timestamp , `last_bid_change_timestamp`  timestamp , `first_impression_timestamp`  timestamp , `_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_first_last/2026-04-09/1775724544'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_facility_first_last"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_facility_first_last/2026-04-09/1775724544
id: 904917
processed: 1

raw_data:

{
    "_origin": "6",
    "facility_date_live_key": "1",
    "facility_key": "0",
    "first_bid_change_timestamp": "3",
    "first_impression_timestamp": "5",
    "last_bid_change_timestamp": "4",
    "last_hide_timestamp": "2"
}

schema_attributes:

{
    "_origin": "string",
    "facility_date_live_key": "int",
    "facility_key": "int",
    "first_bid_change_timestamp": "timestamp",
    "first_impression_timestamp": "timestamp",
    "last_bid_change_timestamp": "timestamp",
    "last_hide_timestamp": "timestamp"
}

schema_name_id: 382
schema_scan_id: 6411319
updated: 2026-04-09 03:49:45

Version 904730

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_facility_first_last`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_facility_first_last`\n(\n `facility_key`  int , `facility_date_live_key`  int , `last_hide_timestamp`  timestamp , `first_bid_change_timestamp`  timestamp , `last_bid_change_timestamp`  timestamp , `first_impression_timestamp`  timestamp , `_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_first_last/2026-04-08/1775638524'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_facility_first_last"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_facility_first_last/2026-04-08/1775638524
id: 904730
processed: 1

raw_data:

{
    "_origin": "6",
    "facility_date_live_key": "1",
    "facility_key": "0",
    "first_bid_change_timestamp": "3",
    "first_impression_timestamp": "5",
    "last_bid_change_timestamp": "4",
    "last_hide_timestamp": "2"
}

schema_attributes:

{
    "_origin": "string",
    "facility_date_live_key": "int",
    "facility_key": "int",
    "first_bid_change_timestamp": "timestamp",
    "first_impression_timestamp": "timestamp",
    "last_bid_change_timestamp": "timestamp",
    "last_hide_timestamp": "timestamp"
}

schema_name_id: 382
schema_scan_id: 6410852
updated: 2026-04-08 03:55:44

Version 904508

created: 2026-04-07 03:34:17

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_facility_first_last`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_facility_first_last`\n(\n `facility_key`  int , `facility_date_live_key`  int , `last_hide_timestamp`  timestamp , `first_bid_change_timestamp`  timestamp , `last_bid_change_timestamp`  timestamp , `first_impression_timestamp`  timestamp , `_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_first_last/2026-04-07/1775550843'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_facility_first_last"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_facility_first_last/2026-04-07/1775550843
id: 904508
processed: 1

raw_data:

{
    "_origin": "6",
    "facility_date_live_key": "1",
    "facility_key": "0",
    "first_bid_change_timestamp": "3",
    "first_impression_timestamp": "5",
    "last_bid_change_timestamp": "4",
    "last_hide_timestamp": "2"
}

schema_attributes:

{
    "_origin": "string",
    "facility_date_live_key": "int",
    "facility_key": "int",
    "first_bid_change_timestamp": "timestamp",
    "first_impression_timestamp": "timestamp",
    "last_bid_change_timestamp": "timestamp",
    "last_hide_timestamp": "timestamp"
}

schema_name_id: 382
schema_scan_id: 6410331
updated: 2026-04-07 03:34:30

Version 904284

created: 2026-04-06 03:45:07

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_facility_first_last`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_facility_first_last`\n(\n `facility_key`  int , `facility_date_live_key`  int , `last_hide_timestamp`  timestamp , `first_bid_change_timestamp`  timestamp , `last_bid_change_timestamp`  timestamp , `first_impression_timestamp`  timestamp , `_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_first_last/2026-04-06/1775465096'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_facility_first_last"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_facility_first_last/2026-04-06/1775465096
id: 904284
processed: 1

raw_data:

{
    "_origin": "6",
    "facility_date_live_key": "1",
    "facility_key": "0",
    "first_bid_change_timestamp": "3",
    "first_impression_timestamp": "5",
    "last_bid_change_timestamp": "4",
    "last_hide_timestamp": "2"
}

schema_attributes:

{
    "_origin": "string",
    "facility_date_live_key": "int",
    "facility_key": "int",
    "first_bid_change_timestamp": "timestamp",
    "first_impression_timestamp": "timestamp",
    "last_bid_change_timestamp": "timestamp",
    "last_hide_timestamp": "timestamp"
}

schema_name_id: 382
schema_scan_id: 6409778
updated: 2026-04-06 03:45:18

Version 904107

created: 2026-04-05 04:04:26

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_facility_first_last`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_facility_first_last`\n(\n `facility_key`  int , `facility_date_live_key`  int , `last_hide_timestamp`  timestamp , `first_bid_change_timestamp`  timestamp , `last_bid_change_timestamp`  timestamp , `first_impression_timestamp`  timestamp , `_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_first_last/2026-04-05/1775379833'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_facility_first_last"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_facility_first_last/2026-04-05/1775379833
id: 904107
processed: 1

raw_data:

{
    "_origin": "6",
    "facility_date_live_key": "1",
    "facility_key": "0",
    "first_bid_change_timestamp": "3",
    "first_impression_timestamp": "5",
    "last_bid_change_timestamp": "4",
    "last_hide_timestamp": "2"
}

schema_attributes:

{
    "_origin": "string",
    "facility_date_live_key": "int",
    "facility_key": "int",
    "first_bid_change_timestamp": "timestamp",
    "first_impression_timestamp": "timestamp",
    "last_bid_change_timestamp": "timestamp",
    "last_hide_timestamp": "timestamp"
}

schema_name_id: 382
schema_scan_id: 6409415
updated: 2026-04-05 04:04:37

Version 903892

created: 2026-04-04 03:24:31

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_facility_first_last`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_facility_first_last`\n(\n `facility_key`  int , `facility_date_live_key`  int , `last_hide_timestamp`  timestamp , `first_bid_change_timestamp`  timestamp , `last_bid_change_timestamp`  timestamp , `first_impression_timestamp`  timestamp , `_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_first_last/2026-04-04/1775291061'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_facility_first_last"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_facility_first_last/2026-04-04/1775291061
id: 903892
processed: 1

raw_data:

{
    "_origin": "6",
    "facility_date_live_key": "1",
    "facility_key": "0",
    "first_bid_change_timestamp": "3",
    "first_impression_timestamp": "5",
    "last_bid_change_timestamp": "4",
    "last_hide_timestamp": "2"
}

schema_attributes:

{
    "_origin": "string",
    "facility_date_live_key": "int",
    "facility_key": "int",
    "first_bid_change_timestamp": "timestamp",
    "first_impression_timestamp": "timestamp",
    "last_bid_change_timestamp": "timestamp",
    "last_hide_timestamp": "timestamp"
}

schema_name_id: 382
schema_scan_id: 6409021
updated: 2026-04-04 03:24:45

Version 903657

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_facility_first_last`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_facility_first_last`\n(\n `facility_key`  int , `facility_date_live_key`  int , `last_hide_timestamp`  timestamp , `first_bid_change_timestamp`  timestamp , `last_bid_change_timestamp`  timestamp , `first_impression_timestamp`  timestamp , `_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_first_last/2026-04-03/1775205227'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_facility_first_last"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_facility_first_last/2026-04-03/1775205227
id: 903657
processed: 1

raw_data:

{
    "_origin": "6",
    "facility_date_live_key": "1",
    "facility_key": "0",
    "first_bid_change_timestamp": "3",
    "first_impression_timestamp": "5",
    "last_bid_change_timestamp": "4",
    "last_hide_timestamp": "2"
}

schema_attributes:

{
    "_origin": "string",
    "facility_date_live_key": "int",
    "facility_key": "int",
    "first_bid_change_timestamp": "timestamp",
    "first_impression_timestamp": "timestamp",
    "last_bid_change_timestamp": "timestamp",
    "last_hide_timestamp": "timestamp"
}

schema_name_id: 382
schema_scan_id: 6408509
updated: 2026-04-03 03:34:13

Schema Scans: 15

Last at 2026-04-17 03:22:42

Scan 6415186

duration: 0:00:14.332639

exit_message:

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

id: 6415186

payload:

{
    "datatype_dict": {
        "facility_date_live_key": "int",
        "facility_key": "int",
        "first_bid_change_timestamp": "timestamp",
        "first_impression_timestamp": "timestamp",
        "last_bid_change_timestamp": "timestamp",
        "last_hide_timestamp": "timestamp",
        "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_first_last/2026-04-17/1776414147/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_first_last/2026-04-17/1776414147",
        "key": "raw/helper_facility_first_last/2026-04-17/1776414147/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_facility_first_last",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 11916677253769657828,
        "service_name": "redshift_unloads",
        "span_id": 15205493533760473400,
        "trace_id": 2234771564274392398
    }
}

running: False
schema_name_id: 382
start_time: 2026-04-17 03:22:42
success: True
trace_id: 2234771564274392398

Scan 6414638

duration: 0:00:14.341346

exit_message:

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

id: 6414638

payload:

{
    "datatype_dict": {
        "facility_date_live_key": "int",
        "facility_key": "int",
        "first_bid_change_timestamp": "timestamp",
        "first_impression_timestamp": "timestamp",
        "last_bid_change_timestamp": "timestamp",
        "last_hide_timestamp": "timestamp",
        "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_first_last/2026-04-16/1776329231/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_first_last/2026-04-16/1776329231",
        "key": "raw/helper_facility_first_last/2026-04-16/1776329231/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_facility_first_last",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 17228264328774461258,
        "service_name": "redshift_unloads",
        "span_id": 7526449090912103488,
        "trace_id": 6597015324856431259
    }
}

running: False
schema_name_id: 382
start_time: 2026-04-16 03:47:24
success: True
trace_id: 6597015324856431259

Scan 6414181

duration: 0:00:11.666622

exit_message:

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

id: 6414181

payload:

{
    "datatype_dict": {
        "facility_date_live_key": "int",
        "facility_key": "int",
        "first_bid_change_timestamp": "timestamp",
        "first_impression_timestamp": "timestamp",
        "last_bid_change_timestamp": "timestamp",
        "last_hide_timestamp": "timestamp",
        "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_first_last/2026-04-15/1776242807/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_first_last/2026-04-15/1776242807",
        "key": "raw/helper_facility_first_last/2026-04-15/1776242807/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_facility_first_last",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 9234922091406747611,
        "service_name": "redshift_unloads",
        "span_id": 564203616124513942,
        "trace_id": 3971292332130243145
    }
}

running: False
schema_name_id: 382
start_time: 2026-04-15 03:47:14
success: True
trace_id: 3971292332130243145

Scan 6413682

duration: 0:00:14.233454

exit_message:

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

id: 6413682

payload:

{
    "datatype_dict": {
        "facility_date_live_key": "int",
        "facility_key": "int",
        "first_bid_change_timestamp": "timestamp",
        "first_impression_timestamp": "timestamp",
        "last_bid_change_timestamp": "timestamp",
        "last_hide_timestamp": "timestamp",
        "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_first_last/2026-04-14/1776156849/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_first_last/2026-04-14/1776156849",
        "key": "raw/helper_facility_first_last/2026-04-14/1776156849/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_facility_first_last",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 877340337749980071,
        "service_name": "redshift_unloads",
        "span_id": 17750197593962593971,
        "trace_id": 142914767683764063
    }
}

running: False
schema_name_id: 382
start_time: 2026-04-14 03:54:39
success: True
trace_id: 142914767683764063

Scan 6413099

duration: 0:00:11.945212

exit_message:

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

id: 6413099

payload:

{
    "datatype_dict": {
        "facility_date_live_key": "int",
        "facility_key": "int",
        "first_bid_change_timestamp": "timestamp",
        "first_impression_timestamp": "timestamp",
        "last_bid_change_timestamp": "timestamp",
        "last_hide_timestamp": "timestamp",
        "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_first_last/2026-04-13/1776068482/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_first_last/2026-04-13/1776068482",
        "key": "raw/helper_facility_first_last/2026-04-13/1776068482/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_facility_first_last",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15905722538412540352,
        "service_name": "redshift_unloads",
        "span_id": 10264280358451711045,
        "trace_id": 884516509894235379
    }
}

running: False
schema_name_id: 382
start_time: 2026-04-13 03:21:33
success: True
trace_id: 884516509894235379

Scan 6412737

duration: 0:00:14.213236

exit_message:

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

id: 6412737

payload:

{
    "datatype_dict": {
        "facility_date_live_key": "int",
        "facility_key": "int",
        "first_bid_change_timestamp": "timestamp",
        "first_impression_timestamp": "timestamp",
        "last_bid_change_timestamp": "timestamp",
        "last_hide_timestamp": "timestamp",
        "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_first_last/2026-04-12/1775984087/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_first_last/2026-04-12/1775984087",
        "key": "raw/helper_facility_first_last/2026-04-12/1775984087/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_facility_first_last",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15996720717616726007,
        "service_name": "redshift_unloads",
        "span_id": 17116579387806056265,
        "trace_id": 11507107433614782260
    }
}

running: False
schema_name_id: 382
start_time: 2026-04-12 03:55:20
success: True
trace_id: 11507107433614782260

Scan 6412352

duration: 0:00:14.501265

exit_message:

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

id: 6412352

payload:

{
    "datatype_dict": {
        "facility_date_live_key": "int",
        "facility_key": "int",
        "first_bid_change_timestamp": "timestamp",
        "first_impression_timestamp": "timestamp",
        "last_bid_change_timestamp": "timestamp",
        "last_hide_timestamp": "timestamp",
        "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_first_last/2026-04-11/1775896303/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_first_last/2026-04-11/1775896303",
        "key": "raw/helper_facility_first_last/2026-04-11/1775896303/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_facility_first_last",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3023989385475518639,
        "service_name": "redshift_unloads",
        "span_id": 3131087202747464542,
        "trace_id": 9866787090228610675
    }
}

running: False
schema_name_id: 382
start_time: 2026-04-11 03:31:51
success: True
trace_id: 9866787090228610675

Scan 6411871

duration: 0:00:14.332021

exit_message:

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

id: 6411871

payload:

{
    "datatype_dict": {
        "facility_date_live_key": "int",
        "facility_key": "int",
        "first_bid_change_timestamp": "timestamp",
        "first_impression_timestamp": "timestamp",
        "last_bid_change_timestamp": "timestamp",
        "last_hide_timestamp": "timestamp",
        "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_first_last/2026-04-10/1775811338/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_first_last/2026-04-10/1775811338",
        "key": "raw/helper_facility_first_last/2026-04-10/1775811338/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_facility_first_last",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 5634401992703595922,
        "service_name": "redshift_unloads",
        "span_id": 8296013059231663352,
        "trace_id": 5500800977714307827
    }
}

running: False
schema_name_id: 382
start_time: 2026-04-10 03:55:48
success: True
trace_id: 5500800977714307827

Scan 6411319

duration: 0:00:14.415806

exit_message:

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

id: 6411319

payload:

{
    "datatype_dict": {
        "facility_date_live_key": "int",
        "facility_key": "int",
        "first_bid_change_timestamp": "timestamp",
        "first_impression_timestamp": "timestamp",
        "last_bid_change_timestamp": "timestamp",
        "last_hide_timestamp": "timestamp",
        "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_first_last/2026-04-09/1775724544/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_first_last/2026-04-09/1775724544",
        "key": "raw/helper_facility_first_last/2026-04-09/1775724544/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_facility_first_last",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 7950241166607430721,
        "service_name": "redshift_unloads",
        "span_id": 17268054429870765100,
        "trace_id": 16439105265299124576
    }
}

running: False
schema_name_id: 382
start_time: 2026-04-09 03:49:31
success: True
trace_id: 16439105265299124576

Scan 6410852

duration: 0:00:11.748289

exit_message:

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

id: 6410852

payload:

{
    "datatype_dict": {
        "facility_date_live_key": "int",
        "facility_key": "int",
        "first_bid_change_timestamp": "timestamp",
        "first_impression_timestamp": "timestamp",
        "last_bid_change_timestamp": "timestamp",
        "last_hide_timestamp": "timestamp",
        "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_first_last/2026-04-08/1775638524/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_first_last/2026-04-08/1775638524",
        "key": "raw/helper_facility_first_last/2026-04-08/1775638524/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_facility_first_last",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 760811849432279023,
        "service_name": "redshift_unloads",
        "span_id": 7074157235047704483,
        "trace_id": 6741218466075651543
    }
}

running: False
schema_name_id: 382
start_time: 2026-04-08 03:55:32
success: True
trace_id: 6741218466075651543

Scan 6410331

duration: 0:00:14.271568

exit_message:

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

id: 6410331

payload:

{
    "datatype_dict": {
        "facility_date_live_key": "int",
        "facility_key": "int",
        "first_bid_change_timestamp": "timestamp",
        "first_impression_timestamp": "timestamp",
        "last_bid_change_timestamp": "timestamp",
        "last_hide_timestamp": "timestamp",
        "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_first_last/2026-04-07/1775550843/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_first_last/2026-04-07/1775550843",
        "key": "raw/helper_facility_first_last/2026-04-07/1775550843/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_facility_first_last",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 4315001690704824479,
        "service_name": "redshift_unloads",
        "span_id": 15829316846136954810,
        "trace_id": 6718471779135706063
    }
}

running: False
schema_name_id: 382
start_time: 2026-04-07 03:34:16
success: True
trace_id: 6718471779135706063

Scan 6409778

duration: 0:00:11.876582

exit_message:

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

id: 6409778

payload:

{
    "datatype_dict": {
        "facility_date_live_key": "int",
        "facility_key": "int",
        "first_bid_change_timestamp": "timestamp",
        "first_impression_timestamp": "timestamp",
        "last_bid_change_timestamp": "timestamp",
        "last_hide_timestamp": "timestamp",
        "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_first_last/2026-04-06/1775465096/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_first_last/2026-04-06/1775465096",
        "key": "raw/helper_facility_first_last/2026-04-06/1775465096/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_facility_first_last",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 7345047531149523687,
        "service_name": "redshift_unloads",
        "span_id": 7319297369589779823,
        "trace_id": 7614361875805691397
    }
}

running: False
schema_name_id: 382
start_time: 2026-04-06 03:45:06
success: True
trace_id: 7614361875805691397

Scan 6409415

duration: 0:00:11.770657

exit_message:

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

id: 6409415

payload:

{
    "datatype_dict": {
        "facility_date_live_key": "int",
        "facility_key": "int",
        "first_bid_change_timestamp": "timestamp",
        "first_impression_timestamp": "timestamp",
        "last_bid_change_timestamp": "timestamp",
        "last_hide_timestamp": "timestamp",
        "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_first_last/2026-04-05/1775379833/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_first_last/2026-04-05/1775379833",
        "key": "raw/helper_facility_first_last/2026-04-05/1775379833/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_facility_first_last",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 6063967196570998353,
        "service_name": "redshift_unloads",
        "span_id": 12565467084057047672,
        "trace_id": 4139769042732026505
    }
}

running: False
schema_name_id: 382
start_time: 2026-04-05 04:04:26
success: True
trace_id: 4139769042732026505

Scan 6409021

duration: 0:00:14.320958

exit_message:

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

id: 6409021

payload:

{
    "datatype_dict": {
        "facility_date_live_key": "int",
        "facility_key": "int",
        "first_bid_change_timestamp": "timestamp",
        "first_impression_timestamp": "timestamp",
        "last_bid_change_timestamp": "timestamp",
        "last_hide_timestamp": "timestamp",
        "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_first_last/2026-04-04/1775291061/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_first_last/2026-04-04/1775291061",
        "key": "raw/helper_facility_first_last/2026-04-04/1775291061/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_facility_first_last",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15674058707030873743,
        "service_name": "redshift_unloads",
        "span_id": 11394887411992257628,
        "trace_id": 17337020528058362424
    }
}

running: False
schema_name_id: 382
start_time: 2026-04-04 03:24:30
success: True
trace_id: 17337020528058362424

Scan 6408509

duration: 0:00:12.177528

exit_message:

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

id: 6408509

payload:

{
    "datatype_dict": {
        "facility_date_live_key": "int",
        "facility_key": "int",
        "first_bid_change_timestamp": "timestamp",
        "first_impression_timestamp": "timestamp",
        "last_bid_change_timestamp": "timestamp",
        "last_hide_timestamp": "timestamp",
        "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_first_last/2026-04-03/1775205227/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_first_last/2026-04-03/1775205227",
        "key": "raw/helper_facility_first_last/2026-04-03/1775205227/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_facility_first_last",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 11356941255072342444,
        "service_name": "redshift_unloads",
        "span_id": 7557301134529564475,
        "trace_id": 1376515671925907281
    }
}

running: False
schema_name_id: 382
start_time: 2026-04-03 03:34:01
success: True
trace_id: 1376515671925907281

Partitions:

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

Schema:

attributes:

{
    "_origin": "string",
    "facility_date_live_key": "int",
    "facility_key": "int",
    "first_bid_change_timestamp": "timestamp",
    "first_impression_timestamp": "timestamp",
    "last_bid_change_timestamp": "timestamp",
    "last_hide_timestamp": "timestamp"
}

created: 2026-04-17 03:22:43

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_first_last`\n(\n `facility_key`  int , `facility_date_live_key`  int , `last_hide_timestamp`  timestamp , `first_bid_change_timestamp`  timestamp , `last_bid_change_timestamp`  timestamp , `first_impression_timestamp`  timestamp , `_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_first_last/2026-04-17/1776414147'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_facility_first_last`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_facility_first_last"
}

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-20 23:56:54",
        "disabled": false,
        "format": "raw",
        "id": 382,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_redshift",
            "table": "analytics_helper_facility_first_last"
        },
        "type": "redshift"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "_origin": "string",
            "facility_date_live_key": "int",
            "facility_key": "int",
            "first_bid_change_timestamp": "timestamp",
            "first_impression_timestamp": "timestamp",
            "last_bid_change_timestamp": "timestamp",
            "last_hide_timestamp": "timestamp"
        },
        "created": "2026-04-17 03:22:43",
        "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_first_last`\n(\n `facility_key`  int , `facility_date_live_key`  int , `last_hide_timestamp`  timestamp , `first_bid_change_timestamp`  timestamp , `last_bid_change_timestamp`  timestamp , `first_impression_timestamp`  timestamp , `_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_first_last/2026-04-17/1776414147'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_facility_first_last`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_facility_first_last"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}