Schema Info

Schema Name: sfdl_prod_redshift.analytics_helper_reservation_attribution

created: 2018-02-28 10:51:05
disabled: False
format: raw
id: 249
is_partitioned: False
is_schema_datatyped: True

name:

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

type: redshift

Schema Versions: 15

Version 1717869

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

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/helper_reservation_attribution/2026-04-17/1776414024
id: 1717869
processed: 1

raw_data:

{
    "_origin": "3",
    "reservation_key": "0",
    "site_key": "1",
    "traffic_source_key": "2"
}

schema_attributes:

{
    "_origin": "string",
    "reservation_key": "varchar(32)",
    "site_key": "int",
    "traffic_source_key": "int"
}

schema_name_id: 249
schema_scan_id: 162167917
updated: 2026-04-17 03:20:56

Version 1716641

created: 2026-04-16 04:00:22

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/helper_reservation_attribution/2026-04-16/1776329923
id: 1716641
processed: 1

raw_data:

{
    "_origin": "3",
    "reservation_key": "0",
    "site_key": "1",
    "traffic_source_key": "2"
}

schema_attributes:

{
    "_origin": "string",
    "reservation_key": "varchar(32)",
    "site_key": "int",
    "traffic_source_key": "int"
}

schema_name_id: 249
schema_scan_id: 162113046
updated: 2026-04-16 04:00:34

Version 1715414

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

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/helper_reservation_attribution/2026-04-15/1776241857
id: 1715414
processed: 1

raw_data:

{
    "_origin": "3",
    "reservation_key": "0",
    "site_key": "1",
    "traffic_source_key": "2"
}

schema_attributes:

{
    "_origin": "string",
    "reservation_key": "varchar(32)",
    "site_key": "int",
    "traffic_source_key": "int"
}

schema_name_id: 249
schema_scan_id: 162056264
updated: 2026-04-15 03:31:27

Version 1714280

created: 2026-04-14 04:02:52

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/helper_reservation_attribution/2026-04-14/1776157324
id: 1714280
processed: 1

raw_data:

{
    "_origin": "3",
    "reservation_key": "0",
    "site_key": "1",
    "traffic_source_key": "2"
}

schema_attributes:

{
    "_origin": "string",
    "reservation_key": "varchar(32)",
    "site_key": "int",
    "traffic_source_key": "int"
}

schema_name_id: 249
schema_scan_id: 162001917
updated: 2026-04-14 04:03:03

Version 1713007

created: 2026-04-13 03:43:41

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/helper_reservation_attribution/2026-04-13/1776069795
id: 1713007
processed: 1

raw_data:

{
    "_origin": "3",
    "reservation_key": "0",
    "site_key": "1",
    "traffic_source_key": "2"
}

schema_attributes:

{
    "_origin": "string",
    "reservation_key": "varchar(32)",
    "site_key": "int",
    "traffic_source_key": "int"
}

schema_name_id: 249
schema_scan_id: 161942954
updated: 2026-04-13 03:43:55

Version 1711858

created: 2026-04-12 04:02:08

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/helper_reservation_attribution/2026-04-12/1775984382
id: 1711858
processed: 1

raw_data:

{
    "_origin": "3",
    "reservation_key": "0",
    "site_key": "1",
    "traffic_source_key": "2"
}

schema_attributes:

{
    "_origin": "string",
    "reservation_key": "varchar(32)",
    "site_key": "int",
    "traffic_source_key": "int"
}

schema_name_id: 249
schema_scan_id: 161894799
updated: 2026-04-12 04:02:20

Version 1710600

created: 2026-04-11 03:36:19

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/helper_reservation_attribution/2026-04-11/1775896554
id: 1710600
processed: 1

raw_data:

{
    "_origin": "3",
    "reservation_key": "0",
    "site_key": "1",
    "traffic_source_key": "2"
}

schema_attributes:

{
    "_origin": "string",
    "reservation_key": "varchar(32)",
    "site_key": "int",
    "traffic_source_key": "int"
}

schema_name_id: 249
schema_scan_id: 161841434
updated: 2026-04-11 03:36:30

Version 1709459

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

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/helper_reservation_attribution/2026-04-10/1775811407
id: 1709459
processed: 1

raw_data:

{
    "_origin": "3",
    "reservation_key": "0",
    "site_key": "1",
    "traffic_source_key": "2"
}

schema_attributes:

{
    "_origin": "string",
    "reservation_key": "varchar(32)",
    "site_key": "int",
    "traffic_source_key": "int"
}

schema_name_id: 249
schema_scan_id: 161786716
updated: 2026-04-10 03:58:02

Version 1708331

created: 2026-04-09 03:46:15

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/helper_reservation_attribution/2026-04-09/1775724347
id: 1708331
processed: 1

raw_data:

{
    "_origin": "3",
    "reservation_key": "0",
    "site_key": "1",
    "traffic_source_key": "2"
}

schema_attributes:

{
    "_origin": "string",
    "reservation_key": "varchar(32)",
    "site_key": "int",
    "traffic_source_key": "int"
}

schema_name_id: 249
schema_scan_id: 161730692
updated: 2026-04-09 03:46:26

Version 1707133

created: 2026-04-08 04:01:37

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/helper_reservation_attribution/2026-04-08/1775638776
id: 1707133
processed: 1

raw_data:

{
    "_origin": "3",
    "reservation_key": "0",
    "site_key": "1",
    "traffic_source_key": "2"
}

schema_attributes:

{
    "_origin": "string",
    "reservation_key": "varchar(32)",
    "site_key": "int",
    "traffic_source_key": "int"
}

schema_name_id: 249
schema_scan_id: 161676852
updated: 2026-04-08 04:01:48

Version 1705939

created: 2026-04-07 03:50:31

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/helper_reservation_attribution/2026-04-07/1775551814
id: 1705939
processed: 1

raw_data:

{
    "_origin": "3",
    "reservation_key": "0",
    "site_key": "1",
    "traffic_source_key": "2"
}

schema_attributes:

{
    "_origin": "string",
    "reservation_key": "varchar(32)",
    "site_key": "int",
    "traffic_source_key": "int"
}

schema_name_id: 249
schema_scan_id: 161619809
updated: 2026-04-07 03:50:42

Version 1704702

created: 2026-04-06 03:52:56

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/helper_reservation_attribution/2026-04-06/1775465558
id: 1704702
processed: 1

raw_data:

{
    "_origin": "3",
    "reservation_key": "0",
    "site_key": "1",
    "traffic_source_key": "2"
}

schema_attributes:

{
    "_origin": "string",
    "reservation_key": "varchar(32)",
    "site_key": "int",
    "traffic_source_key": "int"
}

schema_name_id: 249
schema_scan_id: 161561952
updated: 2026-04-06 03:53:07

Version 1703490

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

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/helper_reservation_attribution/2026-04-05/1775378870
id: 1703490
processed: 1

raw_data:

{
    "_origin": "3",
    "reservation_key": "0",
    "site_key": "1",
    "traffic_source_key": "2"
}

schema_attributes:

{
    "_origin": "string",
    "reservation_key": "varchar(32)",
    "site_key": "int",
    "traffic_source_key": "int"
}

schema_name_id: 249
schema_scan_id: 161515142
updated: 2026-04-05 03:48:23

Version 1702339

created: 2026-04-04 03:35:53

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/helper_reservation_attribution/2026-04-04/1775291735
id: 1702339
processed: 1

raw_data:

{
    "_origin": "3",
    "reservation_key": "0",
    "site_key": "1",
    "traffic_source_key": "2"
}

schema_attributes:

{
    "_origin": "string",
    "reservation_key": "varchar(32)",
    "site_key": "int",
    "traffic_source_key": "int"
}

schema_name_id: 249
schema_scan_id: 161460712
updated: 2026-04-04 03:36:07

Version 1701157

created: 2026-04-03 03:51:52

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/helper_reservation_attribution/2026-04-03/1775206289
id: 1701157
processed: 1

raw_data:

{
    "_origin": "3",
    "reservation_key": "0",
    "site_key": "1",
    "traffic_source_key": "2"
}

schema_attributes:

{
    "_origin": "string",
    "reservation_key": "varchar(32)",
    "site_key": "int",
    "traffic_source_key": "int"
}

schema_name_id: 249
schema_scan_id: 161402348
updated: 2026-04-03 03:52:03

Schema Scans: 15

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

Scan 162167917

duration: 0:00:11.663500

exit_message:

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

id: 162167917

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "reservation_key": "varchar(32)",
        "site_key": "int",
        "traffic_source_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/helper_reservation_attribution/2026-04-17/1776414024/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/helper_reservation_attribution/2026-04-17/1776414024",
        "key": "raw/helper_reservation_attribution/2026-04-17/1776414024/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_helper_reservation_attribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 17759887989515954980,
        "service_name": "redshift_unloads",
        "span_id": 14976708488088869200,
        "trace_id": 8948238248411078882
    }
}

running: False
schema_name_id: 249
start_time: 2026-04-17 03:20:45
success: True
trace_id: 8948238248411078882

Scan 162113046

duration: 0:00:11.758502

exit_message:

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

id: 162113046

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "reservation_key": "varchar(32)",
        "site_key": "int",
        "traffic_source_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/helper_reservation_attribution/2026-04-16/1776329923/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/helper_reservation_attribution/2026-04-16/1776329923",
        "key": "raw/helper_reservation_attribution/2026-04-16/1776329923/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_helper_reservation_attribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15981561449401123293,
        "service_name": "redshift_unloads",
        "span_id": 8706886215156913221,
        "trace_id": 13516584222264157738
    }
}

running: False
schema_name_id: 249
start_time: 2026-04-16 04:00:22
success: True
trace_id: 13516584222264157738

Scan 162056264

duration: 0:00:14.166821

exit_message:

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

id: 162056264

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "reservation_key": "varchar(32)",
        "site_key": "int",
        "traffic_source_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/helper_reservation_attribution/2026-04-15/1776241857/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/helper_reservation_attribution/2026-04-15/1776241857",
        "key": "raw/helper_reservation_attribution/2026-04-15/1776241857/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_helper_reservation_attribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 17931072353522531430,
        "service_name": "redshift_unloads",
        "span_id": 13340939183308797549,
        "trace_id": 3998499781721101690
    }
}

running: False
schema_name_id: 249
start_time: 2026-04-15 03:31:13
success: True
trace_id: 3998499781721101690

Scan 162001917

duration: 0:00:11.559859

exit_message:

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

id: 162001917

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "reservation_key": "varchar(32)",
        "site_key": "int",
        "traffic_source_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/helper_reservation_attribution/2026-04-14/1776157324/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/helper_reservation_attribution/2026-04-14/1776157324",
        "key": "raw/helper_reservation_attribution/2026-04-14/1776157324/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_helper_reservation_attribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 657277686139153245,
        "service_name": "redshift_unloads",
        "span_id": 9367360312379789762,
        "trace_id": 10025704476526332224
    }
}

running: False
schema_name_id: 249
start_time: 2026-04-14 04:02:51
success: True
trace_id: 10025704476526332224

Scan 161942954

duration: 0:00:14.208828

exit_message:

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

id: 161942954

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "reservation_key": "varchar(32)",
        "site_key": "int",
        "traffic_source_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/helper_reservation_attribution/2026-04-13/1776069795/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/helper_reservation_attribution/2026-04-13/1776069795",
        "key": "raw/helper_reservation_attribution/2026-04-13/1776069795/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_helper_reservation_attribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 1237862395718334817,
        "service_name": "redshift_unloads",
        "span_id": 16923271463562335305,
        "trace_id": 2372404507637962781
    }
}

running: False
schema_name_id: 249
start_time: 2026-04-13 03:43:40
success: True
trace_id: 2372404507637962781

Scan 161894799

duration: 0:00:11.593969

exit_message:

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

id: 161894799

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "reservation_key": "varchar(32)",
        "site_key": "int",
        "traffic_source_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/helper_reservation_attribution/2026-04-12/1775984382/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/helper_reservation_attribution/2026-04-12/1775984382",
        "key": "raw/helper_reservation_attribution/2026-04-12/1775984382/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_helper_reservation_attribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 2753918671619731892,
        "service_name": "redshift_unloads",
        "span_id": 15733280943395396802,
        "trace_id": 6864312096888000619
    }
}

running: False
schema_name_id: 249
start_time: 2026-04-12 04:02:08
success: True
trace_id: 6864312096888000619

Scan 161841434

duration: 0:00:11.754748

exit_message:

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

id: 161841434

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "reservation_key": "varchar(32)",
        "site_key": "int",
        "traffic_source_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/helper_reservation_attribution/2026-04-11/1775896554/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/helper_reservation_attribution/2026-04-11/1775896554",
        "key": "raw/helper_reservation_attribution/2026-04-11/1775896554/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_helper_reservation_attribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3150121358895852923,
        "service_name": "redshift_unloads",
        "span_id": 14169514872032467948,
        "trace_id": 11540118380821973445
    }
}

running: False
schema_name_id: 249
start_time: 2026-04-11 03:36:18
success: True
trace_id: 11540118380821973445

Scan 161786716

duration: 0:00:14.359401

exit_message:

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

id: 161786716

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "reservation_key": "varchar(32)",
        "site_key": "int",
        "traffic_source_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/helper_reservation_attribution/2026-04-10/1775811407/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/helper_reservation_attribution/2026-04-10/1775811407",
        "key": "raw/helper_reservation_attribution/2026-04-10/1775811407/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_helper_reservation_attribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 12246271761709754515,
        "service_name": "redshift_unloads",
        "span_id": 15178497218847421167,
        "trace_id": 3008007601852059008
    }
}

running: False
schema_name_id: 249
start_time: 2026-04-10 03:57:48
success: True
trace_id: 3008007601852059008

Scan 161730692

duration: 0:00:11.642734

exit_message:

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

id: 161730692

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "reservation_key": "varchar(32)",
        "site_key": "int",
        "traffic_source_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/helper_reservation_attribution/2026-04-09/1775724347/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/helper_reservation_attribution/2026-04-09/1775724347",
        "key": "raw/helper_reservation_attribution/2026-04-09/1775724347/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_helper_reservation_attribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 16975486776399719910,
        "service_name": "redshift_unloads",
        "span_id": 16616662563755533562,
        "trace_id": 3727017558938535699
    }
}

running: False
schema_name_id: 249
start_time: 2026-04-09 03:46:15
success: True
trace_id: 3727017558938535699

Scan 161676852

duration: 0:00:11.566488

exit_message:

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

id: 161676852

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "reservation_key": "varchar(32)",
        "site_key": "int",
        "traffic_source_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/helper_reservation_attribution/2026-04-08/1775638776/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/helper_reservation_attribution/2026-04-08/1775638776",
        "key": "raw/helper_reservation_attribution/2026-04-08/1775638776/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_helper_reservation_attribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15755928475593958009,
        "service_name": "redshift_unloads",
        "span_id": 6668047894407954886,
        "trace_id": 3731385088664144741
    }
}

running: False
schema_name_id: 249
start_time: 2026-04-08 04:01:37
success: True
trace_id: 3731385088664144741

Scan 161619809

duration: 0:00:11.665885

exit_message:

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

id: 161619809

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "reservation_key": "varchar(32)",
        "site_key": "int",
        "traffic_source_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/helper_reservation_attribution/2026-04-07/1775551814/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/helper_reservation_attribution/2026-04-07/1775551814",
        "key": "raw/helper_reservation_attribution/2026-04-07/1775551814/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_helper_reservation_attribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 9968161598273470317,
        "service_name": "redshift_unloads",
        "span_id": 15456519620678053568,
        "trace_id": 870907272264767445
    }
}

running: False
schema_name_id: 249
start_time: 2026-04-07 03:50:31
success: True
trace_id: 870907272264767445

Scan 161561952

duration: 0:00:11.641883

exit_message:

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

id: 161561952

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "reservation_key": "varchar(32)",
        "site_key": "int",
        "traffic_source_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/helper_reservation_attribution/2026-04-06/1775465558/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/helper_reservation_attribution/2026-04-06/1775465558",
        "key": "raw/helper_reservation_attribution/2026-04-06/1775465558/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_helper_reservation_attribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 4820931041919891378,
        "service_name": "redshift_unloads",
        "span_id": 16698521891094344279,
        "trace_id": 4686619226848128078
    }
}

running: False
schema_name_id: 249
start_time: 2026-04-06 03:52:56
success: True
trace_id: 4686619226848128078

Scan 161515142

duration: 0:00:14.185687

exit_message:

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

id: 161515142

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "reservation_key": "varchar(32)",
        "site_key": "int",
        "traffic_source_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/helper_reservation_attribution/2026-04-05/1775378870/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/helper_reservation_attribution/2026-04-05/1775378870",
        "key": "raw/helper_reservation_attribution/2026-04-05/1775378870/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_helper_reservation_attribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15265662145596166267,
        "service_name": "redshift_unloads",
        "span_id": 9294947859805127337,
        "trace_id": 13891486058425815836
    }
}

running: False
schema_name_id: 249
start_time: 2026-04-05 03:48:09
success: True
trace_id: 13891486058425815836

Scan 161460712

duration: 0:00:14.103095

exit_message:

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

id: 161460712

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "reservation_key": "varchar(32)",
        "site_key": "int",
        "traffic_source_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/helper_reservation_attribution/2026-04-04/1775291735/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/helper_reservation_attribution/2026-04-04/1775291735",
        "key": "raw/helper_reservation_attribution/2026-04-04/1775291735/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_helper_reservation_attribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 1021910112494287407,
        "service_name": "redshift_unloads",
        "span_id": 7767406543571199852,
        "trace_id": 9149025846475568031
    }
}

running: False
schema_name_id: 249
start_time: 2026-04-04 03:35:53
success: True
trace_id: 9149025846475568031

Scan 161402348

duration: 0:00:11.589995

exit_message:

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

id: 161402348

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "reservation_key": "varchar(32)",
        "site_key": "int",
        "traffic_source_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/helper_reservation_attribution/2026-04-03/1775206289/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/helper_reservation_attribution/2026-04-03/1775206289",
        "key": "raw/helper_reservation_attribution/2026-04-03/1775206289/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_helper_reservation_attribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 14532704593174728756,
        "service_name": "redshift_unloads",
        "span_id": 8201544713233344799,
        "trace_id": 13594325289408567639
    }
}

running: False
schema_name_id: 249
start_time: 2026-04-03 03:51:51
success: True
trace_id: 13594325289408567639

Partitions:

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

Schema:

attributes:

{
    "_origin": "string",
    "reservation_key": "varchar(32)",
    "site_key": "int",
    "traffic_source_key": "int"
}

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

ddl:

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

Server:

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

Raw:

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