Schema Info

Schema Name: sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs

created: 2018-11-15 19:10:34
disabled: False
format: raw
id: 664
is_partitioned: False
is_schema_datatyped: True

name:

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

type: redshift

Schema Versions: 15

Version 906682

created: 2026-04-17 07:57:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs`\n(\n `latest_search_time`  timestamp , `latest_search_key`  bigint , `location_key`  bigint , `facility_key`  bigint , `distance`  double , `_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_search_location_key_facility_key_pairs/2026-04-17/1776414151'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_search_location_key_facility_key_pairs/2026-04-17/1776414151
id: 906682
processed: 1

raw_data:

{
    "_origin": "5",
    "distance": "4",
    "facility_key": "3",
    "latest_search_key": "1",
    "latest_search_time": "0",
    "location_key": "2"
}

schema_attributes:

{
    "_origin": "string",
    "distance": "double",
    "facility_key": "bigint",
    "latest_search_key": "bigint",
    "latest_search_time": "timestamp",
    "location_key": "bigint"
}

schema_name_id: 664
schema_scan_id: 6415302
updated: 2026-04-17 07:57:53

Version 906464

created: 2026-04-16 08:08:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs`\n(\n `latest_search_time`  timestamp , `latest_search_key`  bigint , `location_key`  bigint , `facility_key`  bigint , `distance`  double , `_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_search_location_key_facility_key_pairs/2026-04-16/1776328751'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_search_location_key_facility_key_pairs/2026-04-16/1776328751
id: 906464
processed: 1

raw_data:

{
    "_origin": "5",
    "distance": "4",
    "facility_key": "3",
    "latest_search_key": "1",
    "latest_search_time": "0",
    "location_key": "2"
}

schema_attributes:

{
    "_origin": "string",
    "distance": "double",
    "facility_key": "bigint",
    "latest_search_key": "bigint",
    "latest_search_time": "timestamp",
    "location_key": "bigint"
}

schema_name_id: 664
schema_scan_id: 6414759
updated: 2026-04-16 08:08:46

Version 906251

created: 2026-04-15 08:05:09

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs`\n(\n `latest_search_time`  timestamp , `latest_search_key`  bigint , `location_key`  bigint , `facility_key`  bigint , `distance`  double , `_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_search_location_key_facility_key_pairs/2026-04-15/1776241878'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_search_location_key_facility_key_pairs/2026-04-15/1776241878
id: 906251
processed: 1

raw_data:

{
    "_origin": "5",
    "distance": "4",
    "facility_key": "3",
    "latest_search_key": "1",
    "latest_search_time": "0",
    "location_key": "2"
}

schema_attributes:

{
    "_origin": "string",
    "distance": "double",
    "facility_key": "bigint",
    "latest_search_key": "bigint",
    "latest_search_time": "timestamp",
    "location_key": "bigint"
}

schema_name_id: 664
schema_scan_id: 6414268
updated: 2026-04-15 08:05:21

Version 906038

created: 2026-04-14 07:59:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs`\n(\n `latest_search_time`  timestamp , `latest_search_key`  bigint , `location_key`  bigint , `facility_key`  bigint , `distance`  double , `_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_search_location_key_facility_key_pairs/2026-04-14/1776155604'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_search_location_key_facility_key_pairs/2026-04-14/1776155604
id: 906038
processed: 1

raw_data:

{
    "_origin": "5",
    "distance": "4",
    "facility_key": "3",
    "latest_search_key": "1",
    "latest_search_time": "0",
    "location_key": "2"
}

schema_attributes:

{
    "_origin": "string",
    "distance": "double",
    "facility_key": "bigint",
    "latest_search_key": "bigint",
    "latest_search_time": "timestamp",
    "location_key": "bigint"
}

schema_name_id: 664
schema_scan_id: 6413772
updated: 2026-04-14 07:59:25

Version 905822

created: 2026-04-13 08:07:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs`\n(\n `latest_search_time`  timestamp , `latest_search_key`  bigint , `location_key`  bigint , `facility_key`  bigint , `distance`  double , `_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_search_location_key_facility_key_pairs/2026-04-13/1776068733'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_search_location_key_facility_key_pairs/2026-04-13/1776068733
id: 905822
processed: 1

raw_data:

{
    "_origin": "5",
    "distance": "4",
    "facility_key": "3",
    "latest_search_key": "1",
    "latest_search_time": "0",
    "location_key": "2"
}

schema_attributes:

{
    "_origin": "string",
    "distance": "double",
    "facility_key": "bigint",
    "latest_search_key": "bigint",
    "latest_search_time": "timestamp",
    "location_key": "bigint"
}

schema_name_id: 664
schema_scan_id: 6413221
updated: 2026-04-13 08:07:16

Version 905618

created: 2026-04-12 08:00:13

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs`\n(\n `latest_search_time`  timestamp , `latest_search_key`  bigint , `location_key`  bigint , `facility_key`  bigint , `distance`  double , `_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_search_location_key_facility_key_pairs/2026-04-12/1775982940'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_search_location_key_facility_key_pairs/2026-04-12/1775982940
id: 905618
processed: 1

raw_data:

{
    "_origin": "5",
    "distance": "4",
    "facility_key": "3",
    "latest_search_key": "1",
    "latest_search_time": "0",
    "location_key": "2"
}

schema_attributes:

{
    "_origin": "string",
    "distance": "double",
    "facility_key": "bigint",
    "latest_search_key": "bigint",
    "latest_search_time": "timestamp",
    "location_key": "bigint"
}

schema_name_id: 664
schema_scan_id: 6412802
updated: 2026-04-12 08:00:26

Version 905416

created: 2026-04-11 07:55:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs`\n(\n `latest_search_time`  timestamp , `latest_search_key`  bigint , `location_key`  bigint , `facility_key`  bigint , `distance`  double , `_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_search_location_key_facility_key_pairs/2026-04-11/1775895617'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_search_location_key_facility_key_pairs/2026-04-11/1775895617
id: 905416
processed: 1

raw_data:

{
    "_origin": "5",
    "distance": "4",
    "facility_key": "3",
    "latest_search_key": "1",
    "latest_search_time": "0",
    "location_key": "2"
}

schema_attributes:

{
    "_origin": "string",
    "distance": "double",
    "facility_key": "bigint",
    "latest_search_key": "bigint",
    "latest_search_time": "timestamp",
    "location_key": "bigint"
}

schema_name_id: 664
schema_scan_id: 6412422
updated: 2026-04-11 07:55:32

Version 905204

created: 2026-04-10 07:54:26

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs`\n(\n `latest_search_time`  timestamp , `latest_search_key`  bigint , `location_key`  bigint , `facility_key`  bigint , `distance`  double , `_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_search_location_key_facility_key_pairs/2026-04-10/1775809122'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_search_location_key_facility_key_pairs/2026-04-10/1775809122
id: 905204
processed: 1

raw_data:

{
    "_origin": "5",
    "distance": "4",
    "facility_key": "3",
    "latest_search_key": "1",
    "latest_search_time": "0",
    "location_key": "2"
}

schema_attributes:

{
    "_origin": "string",
    "distance": "double",
    "facility_key": "bigint",
    "latest_search_key": "bigint",
    "latest_search_time": "timestamp",
    "location_key": "bigint"
}

schema_name_id: 664
schema_scan_id: 6411952
updated: 2026-04-10 07:54:40

Version 904990

created: 2026-04-09 07:57:11

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs`\n(\n `latest_search_time`  timestamp , `latest_search_key`  bigint , `location_key`  bigint , `facility_key`  bigint , `distance`  double , `_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_search_location_key_facility_key_pairs/2026-04-09/1775723860'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_search_location_key_facility_key_pairs/2026-04-09/1775723860
id: 904990
processed: 1

raw_data:

{
    "_origin": "5",
    "distance": "4",
    "facility_key": "3",
    "latest_search_key": "1",
    "latest_search_time": "0",
    "location_key": "2"
}

schema_attributes:

{
    "_origin": "string",
    "distance": "double",
    "facility_key": "bigint",
    "latest_search_key": "bigint",
    "latest_search_time": "timestamp",
    "location_key": "bigint"
}

schema_name_id: 664
schema_scan_id: 6411439
updated: 2026-04-09 07:57:25

Version 904776

created: 2026-04-08 07:54:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs`\n(\n `latest_search_time`  timestamp , `latest_search_key`  bigint , `location_key`  bigint , `facility_key`  bigint , `distance`  double , `_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_search_location_key_facility_key_pairs/2026-04-08/1775636859'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_search_location_key_facility_key_pairs/2026-04-08/1775636859
id: 904776
processed: 1

raw_data:

{
    "_origin": "5",
    "distance": "4",
    "facility_key": "3",
    "latest_search_key": "1",
    "latest_search_time": "0",
    "location_key": "2"
}

schema_attributes:

{
    "_origin": "string",
    "distance": "double",
    "facility_key": "bigint",
    "latest_search_key": "bigint",
    "latest_search_time": "timestamp",
    "location_key": "bigint"
}

schema_name_id: 664
schema_scan_id: 6410935
updated: 2026-04-08 07:55:12

Version 904562

created: 2026-04-07 07:59:01

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs`\n(\n `latest_search_time`  timestamp , `latest_search_key`  bigint , `location_key`  bigint , `facility_key`  bigint , `distance`  double , `_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_search_location_key_facility_key_pairs/2026-04-07/1775550588'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_search_location_key_facility_key_pairs/2026-04-07/1775550588
id: 904562
processed: 1

raw_data:

{
    "_origin": "5",
    "distance": "4",
    "facility_key": "3",
    "latest_search_key": "1",
    "latest_search_time": "0",
    "location_key": "2"
}

schema_attributes:

{
    "_origin": "string",
    "distance": "double",
    "facility_key": "bigint",
    "latest_search_key": "bigint",
    "latest_search_time": "timestamp",
    "location_key": "bigint"
}

schema_name_id: 664
schema_scan_id: 6410427
updated: 2026-04-07 07:59:15

Version 904348

created: 2026-04-06 08:07:11

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs`\n(\n `latest_search_time`  timestamp , `latest_search_key`  bigint , `location_key`  bigint , `facility_key`  bigint , `distance`  double , `_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_search_location_key_facility_key_pairs/2026-04-06/1775464193'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_search_location_key_facility_key_pairs/2026-04-06/1775464193
id: 904348
processed: 1

raw_data:

{
    "_origin": "5",
    "distance": "4",
    "facility_key": "3",
    "latest_search_key": "1",
    "latest_search_time": "0",
    "location_key": "2"
}

schema_attributes:

{
    "_origin": "string",
    "distance": "double",
    "facility_key": "bigint",
    "latest_search_key": "bigint",
    "latest_search_time": "timestamp",
    "location_key": "bigint"
}

schema_name_id: 664
schema_scan_id: 6409885
updated: 2026-04-06 08:07:22

Version 904144

created: 2026-04-05 08:07:05

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs`\n(\n `latest_search_time`  timestamp , `latest_search_key`  bigint , `location_key`  bigint , `facility_key`  bigint , `distance`  double , `_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_search_location_key_facility_key_pairs/2026-04-05/1775377469'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_search_location_key_facility_key_pairs/2026-04-05/1775377469
id: 904144
processed: 1

raw_data:

{
    "_origin": "5",
    "distance": "4",
    "facility_key": "3",
    "latest_search_key": "1",
    "latest_search_time": "0",
    "location_key": "2"
}

schema_attributes:

{
    "_origin": "string",
    "distance": "double",
    "facility_key": "bigint",
    "latest_search_key": "bigint",
    "latest_search_time": "timestamp",
    "location_key": "bigint"
}

schema_name_id: 664
schema_scan_id: 6409476
updated: 2026-04-05 08:07:16

Version 903942

created: 2026-04-04 07:55:05

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs`\n(\n `latest_search_time`  timestamp , `latest_search_key`  bigint , `location_key`  bigint , `facility_key`  bigint , `distance`  double , `_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_search_location_key_facility_key_pairs/2026-04-04/1775291088'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_search_location_key_facility_key_pairs/2026-04-04/1775291088
id: 903942
processed: 1

raw_data:

{
    "_origin": "5",
    "distance": "4",
    "facility_key": "3",
    "latest_search_key": "1",
    "latest_search_time": "0",
    "location_key": "2"
}

schema_attributes:

{
    "_origin": "string",
    "distance": "double",
    "facility_key": "bigint",
    "latest_search_key": "bigint",
    "latest_search_time": "timestamp",
    "location_key": "bigint"
}

schema_name_id: 664
schema_scan_id: 6409093
updated: 2026-04-04 07:55:19

Version 903730

created: 2026-04-03 07:59:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs`\n(\n `latest_search_time`  timestamp , `latest_search_key`  bigint , `location_key`  bigint , `facility_key`  bigint , `distance`  double , `_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_search_location_key_facility_key_pairs/2026-04-03/1775205318'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_search_location_key_facility_key_pairs/2026-04-03/1775205318
id: 903730
processed: 1

raw_data:

{
    "_origin": "5",
    "distance": "4",
    "facility_key": "3",
    "latest_search_key": "1",
    "latest_search_time": "0",
    "location_key": "2"
}

schema_attributes:

{
    "_origin": "string",
    "distance": "double",
    "facility_key": "bigint",
    "latest_search_key": "bigint",
    "latest_search_time": "timestamp",
    "location_key": "bigint"
}

schema_name_id: 664
schema_scan_id: 6408622
updated: 2026-04-03 07:59:29

Schema Scans: 15

Last at 2026-04-17 07:57:38

Scan 6415302

duration: 0:00:14.303476

exit_message:

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

id: 6415302

payload:

{
    "datatype_dict": {
        "distance": "double",
        "facility_key": "bigint",
        "latest_search_key": "bigint",
        "latest_search_time": "timestamp",
        "location_key": "bigint",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/helper_search_location_key_facility_key_pairs/2026-04-17/1776414151/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_search_location_key_facility_key_pairs/2026-04-17/1776414151",
        "key": "raw/helper_search_location_key_facility_key_pairs/2026-04-17/1776414151/0007_part_03.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 12509098483261787127,
        "service_name": "redshift_unloads",
        "span_id": 8614200639408042821,
        "trace_id": 8518501806189451802
    }
}

running: False
schema_name_id: 664
start_time: 2026-04-17 07:57:38
success: True
trace_id: 8518501806189451802

Scan 6414759

duration: 0:00:14.210760

exit_message:

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

id: 6414759

payload:

{
    "datatype_dict": {
        "distance": "double",
        "facility_key": "bigint",
        "latest_search_key": "bigint",
        "latest_search_time": "timestamp",
        "location_key": "bigint",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/helper_search_location_key_facility_key_pairs/2026-04-16/1776328751/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_search_location_key_facility_key_pairs/2026-04-16/1776328751",
        "key": "raw/helper_search_location_key_facility_key_pairs/2026-04-16/1776328751/0007_part_03.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 12126847031854682731,
        "service_name": "redshift_unloads",
        "span_id": 9082271334740132746,
        "trace_id": 17924569933730968952
    }
}

running: False
schema_name_id: 664
start_time: 2026-04-16 08:08:32
success: True
trace_id: 17924569933730968952

Scan 6414268

duration: 0:00:11.827949

exit_message:

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

id: 6414268

payload:

{
    "datatype_dict": {
        "distance": "double",
        "facility_key": "bigint",
        "latest_search_key": "bigint",
        "latest_search_time": "timestamp",
        "location_key": "bigint",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/helper_search_location_key_facility_key_pairs/2026-04-15/1776241878/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_search_location_key_facility_key_pairs/2026-04-15/1776241878",
        "key": "raw/helper_search_location_key_facility_key_pairs/2026-04-15/1776241878/0007_part_03.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 14574663099505935470,
        "service_name": "redshift_unloads",
        "span_id": 8659243797301674469,
        "trace_id": 18253615084113572420
    }
}

running: False
schema_name_id: 664
start_time: 2026-04-15 08:05:09
success: True
trace_id: 18253615084113572420

Scan 6413772

duration: 0:00:14.300910

exit_message:

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

id: 6413772

payload:

{
    "datatype_dict": {
        "distance": "double",
        "facility_key": "bigint",
        "latest_search_key": "bigint",
        "latest_search_time": "timestamp",
        "location_key": "bigint",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/helper_search_location_key_facility_key_pairs/2026-04-14/1776155604/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_search_location_key_facility_key_pairs/2026-04-14/1776155604",
        "key": "raw/helper_search_location_key_facility_key_pairs/2026-04-14/1776155604/0007_part_03.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 14248764368237198290,
        "service_name": "redshift_unloads",
        "span_id": 1481661924399433308,
        "trace_id": 4115676727788060183
    }
}

running: False
schema_name_id: 664
start_time: 2026-04-14 07:59:11
success: True
trace_id: 4115676727788060183

Scan 6413221

duration: 0:00:11.821307

exit_message:

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

id: 6413221

payload:

{
    "datatype_dict": {
        "distance": "double",
        "facility_key": "bigint",
        "latest_search_key": "bigint",
        "latest_search_time": "timestamp",
        "location_key": "bigint",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/helper_search_location_key_facility_key_pairs/2026-04-13/1776068733/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_search_location_key_facility_key_pairs/2026-04-13/1776068733",
        "key": "raw/helper_search_location_key_facility_key_pairs/2026-04-13/1776068733/0007_part_03.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 16872113485208894436,
        "service_name": "redshift_unloads",
        "span_id": 11363218985118970317,
        "trace_id": 5646583779416284974
    }
}

running: False
schema_name_id: 664
start_time: 2026-04-13 08:07:04
success: True
trace_id: 5646583779416284974

Scan 6412802

duration: 0:00:14.185733

exit_message:

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

id: 6412802

payload:

{
    "datatype_dict": {
        "distance": "double",
        "facility_key": "bigint",
        "latest_search_key": "bigint",
        "latest_search_time": "timestamp",
        "location_key": "bigint",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/helper_search_location_key_facility_key_pairs/2026-04-12/1775982940/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_search_location_key_facility_key_pairs/2026-04-12/1775982940",
        "key": "raw/helper_search_location_key_facility_key_pairs/2026-04-12/1775982940/0007_part_03.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 7907971706628629779,
        "service_name": "redshift_unloads",
        "span_id": 10495449817607912841,
        "trace_id": 6131915435034321811
    }
}

running: False
schema_name_id: 664
start_time: 2026-04-12 08:00:12
success: True
trace_id: 6131915435034321811

Scan 6412422

duration: 0:00:14.388054

exit_message:

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

id: 6412422

payload:

{
    "datatype_dict": {
        "distance": "double",
        "facility_key": "bigint",
        "latest_search_key": "bigint",
        "latest_search_time": "timestamp",
        "location_key": "bigint",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/helper_search_location_key_facility_key_pairs/2026-04-11/1775895617/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_search_location_key_facility_key_pairs/2026-04-11/1775895617",
        "key": "raw/helper_search_location_key_facility_key_pairs/2026-04-11/1775895617/0007_part_03.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 4920024872172078184,
        "service_name": "redshift_unloads",
        "span_id": 6176257823789153892,
        "trace_id": 9382052471102252039
    }
}

running: False
schema_name_id: 664
start_time: 2026-04-11 07:55:18
success: True
trace_id: 9382052471102252039

Scan 6411952

duration: 0:00:14.256902

exit_message:

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

id: 6411952

payload:

{
    "datatype_dict": {
        "distance": "double",
        "facility_key": "bigint",
        "latest_search_key": "bigint",
        "latest_search_time": "timestamp",
        "location_key": "bigint",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/helper_search_location_key_facility_key_pairs/2026-04-10/1775809122/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_search_location_key_facility_key_pairs/2026-04-10/1775809122",
        "key": "raw/helper_search_location_key_facility_key_pairs/2026-04-10/1775809122/0007_part_03.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 9502059083845376602,
        "service_name": "redshift_unloads",
        "span_id": 15076992697674202444,
        "trace_id": 1170068612403022984
    }
}

running: False
schema_name_id: 664
start_time: 2026-04-10 07:54:26
success: True
trace_id: 1170068612403022984

Scan 6411439

duration: 0:00:14.334400

exit_message:

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

id: 6411439

payload:

{
    "datatype_dict": {
        "distance": "double",
        "facility_key": "bigint",
        "latest_search_key": "bigint",
        "latest_search_time": "timestamp",
        "location_key": "bigint",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/helper_search_location_key_facility_key_pairs/2026-04-09/1775723860/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_search_location_key_facility_key_pairs/2026-04-09/1775723860",
        "key": "raw/helper_search_location_key_facility_key_pairs/2026-04-09/1775723860/0007_part_03.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 165001052529916521,
        "service_name": "redshift_unloads",
        "span_id": 13955539492435358840,
        "trace_id": 9430804411124737455
    }
}

running: False
schema_name_id: 664
start_time: 2026-04-09 07:57:11
success: True
trace_id: 9430804411124737455

Scan 6410935

duration: 0:00:14.420226

exit_message:

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

id: 6410935

payload:

{
    "datatype_dict": {
        "distance": "double",
        "facility_key": "bigint",
        "latest_search_key": "bigint",
        "latest_search_time": "timestamp",
        "location_key": "bigint",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/helper_search_location_key_facility_key_pairs/2026-04-08/1775636859/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_search_location_key_facility_key_pairs/2026-04-08/1775636859",
        "key": "raw/helper_search_location_key_facility_key_pairs/2026-04-08/1775636859/0007_part_03.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3530515227946536657,
        "service_name": "redshift_unloads",
        "span_id": 850552931964902416,
        "trace_id": 5257118403493681858
    }
}

running: False
schema_name_id: 664
start_time: 2026-04-08 07:54:58
success: True
trace_id: 5257118403493681858

Scan 6410427

duration: 0:00:14.556530

exit_message:

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

id: 6410427

payload:

{
    "datatype_dict": {
        "distance": "double",
        "facility_key": "bigint",
        "latest_search_key": "bigint",
        "latest_search_time": "timestamp",
        "location_key": "bigint",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/helper_search_location_key_facility_key_pairs/2026-04-07/1775550588/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_search_location_key_facility_key_pairs/2026-04-07/1775550588",
        "key": "raw/helper_search_location_key_facility_key_pairs/2026-04-07/1775550588/0007_part_03.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8254294211589247485,
        "service_name": "redshift_unloads",
        "span_id": 1691187388867462188,
        "trace_id": 5029854813054932413
    }
}

running: False
schema_name_id: 664
start_time: 2026-04-07 07:59:00
success: True
trace_id: 5029854813054932413

Scan 6409885

duration: 0:00:11.704415

exit_message:

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

id: 6409885

payload:

{
    "datatype_dict": {
        "distance": "double",
        "facility_key": "bigint",
        "latest_search_key": "bigint",
        "latest_search_time": "timestamp",
        "location_key": "bigint",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/helper_search_location_key_facility_key_pairs/2026-04-06/1775464193/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_search_location_key_facility_key_pairs/2026-04-06/1775464193",
        "key": "raw/helper_search_location_key_facility_key_pairs/2026-04-06/1775464193/0007_part_03.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 2647646039805874655,
        "service_name": "redshift_unloads",
        "span_id": 12282653384390225692,
        "trace_id": 1788963859271692609
    }
}

running: False
schema_name_id: 664
start_time: 2026-04-06 08:07:10
success: True
trace_id: 1788963859271692609

Scan 6409476

duration: 0:00:11.759320

exit_message:

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

id: 6409476

payload:

{
    "datatype_dict": {
        "distance": "double",
        "facility_key": "bigint",
        "latest_search_key": "bigint",
        "latest_search_time": "timestamp",
        "location_key": "bigint",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/helper_search_location_key_facility_key_pairs/2026-04-05/1775377469/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_search_location_key_facility_key_pairs/2026-04-05/1775377469",
        "key": "raw/helper_search_location_key_facility_key_pairs/2026-04-05/1775377469/0007_part_03.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3512997387524390663,
        "service_name": "redshift_unloads",
        "span_id": 15146517176670594143,
        "trace_id": 10812340880520274393
    }
}

running: False
schema_name_id: 664
start_time: 2026-04-05 08:07:05
success: True
trace_id: 10812340880520274393

Scan 6409093

duration: 0:00:14.437357

exit_message:

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

id: 6409093

payload:

{
    "datatype_dict": {
        "distance": "double",
        "facility_key": "bigint",
        "latest_search_key": "bigint",
        "latest_search_time": "timestamp",
        "location_key": "bigint",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/helper_search_location_key_facility_key_pairs/2026-04-04/1775291088/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_search_location_key_facility_key_pairs/2026-04-04/1775291088",
        "key": "raw/helper_search_location_key_facility_key_pairs/2026-04-04/1775291088/0007_part_03.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3123248481343423486,
        "service_name": "redshift_unloads",
        "span_id": 15101275188561004484,
        "trace_id": 13211232079554432718
    }
}

running: False
schema_name_id: 664
start_time: 2026-04-04 07:55:04
success: True
trace_id: 13211232079554432718

Scan 6408622

duration: 0:00:11.850001

exit_message:

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

id: 6408622

payload:

{
    "datatype_dict": {
        "distance": "double",
        "facility_key": "bigint",
        "latest_search_key": "bigint",
        "latest_search_time": "timestamp",
        "location_key": "bigint",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/helper_search_location_key_facility_key_pairs/2026-04-03/1775205318/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_search_location_key_facility_key_pairs/2026-04-03/1775205318",
        "key": "raw/helper_search_location_key_facility_key_pairs/2026-04-03/1775205318/0007_part_03.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3741096145008229804,
        "service_name": "redshift_unloads",
        "span_id": 18439568650394271246,
        "trace_id": 1084632626145924459
    }
}

running: False
schema_name_id: 664
start_time: 2026-04-03 07:59:17
success: True
trace_id: 1084632626145924459

Partitions:

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

Schema:

attributes:

{
    "_origin": "string",
    "distance": "double",
    "facility_key": "bigint",
    "latest_search_key": "bigint",
    "latest_search_time": "timestamp",
    "location_key": "bigint"
}

created: 2026-04-17 07:57:39

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_search_location_key_facility_key_pairs`\n(\n `latest_search_time`  timestamp , `latest_search_key`  bigint , `location_key`  bigint , `facility_key`  bigint , `distance`  double , `_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_search_location_key_facility_key_pairs/2026-04-17/1776414151'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs"
}

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-11-15 19:10:34",
        "disabled": false,
        "format": "raw",
        "id": 664,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_redshift",
            "table": "analytics_helper_search_location_key_facility_key_pairs"
        },
        "type": "redshift"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "_origin": "string",
            "distance": "double",
            "facility_key": "bigint",
            "latest_search_key": "bigint",
            "latest_search_time": "timestamp",
            "location_key": "bigint"
        },
        "created": "2026-04-17 07:57:39",
        "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_search_location_key_facility_key_pairs`\n(\n `latest_search_time`  timestamp , `latest_search_key`  bigint , `location_key`  bigint , `facility_key`  bigint , `distance`  double , `_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_search_location_key_facility_key_pairs/2026-04-17/1776414151'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_search_location_key_facility_key_pairs"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}