Schema Info

Schema Name: sfdl_stage_redshift.analytics_helper_reservation_attribution

created: 2018-02-20 23:57:08
disabled: False
format: raw
id: 383
is_partitioned: False
is_schema_datatyped: True

name:

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

type: redshift

Schema Versions: 15

Version 906646

created: 2026-04-17 03:49:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_reservation_attribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/helper_reservation_attribution/2026-04-17/1776415751'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_reservation_attribution"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_reservation_attribution/2026-04-17/1776415751
id: 906646
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: 383
schema_scan_id: 6415226
updated: 2026-04-17 03:50:07

Version 906397

created: 2026-04-16 03:55:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_reservation_attribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/helper_reservation_attribution/2026-04-16/1776329718'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_reservation_attribution"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_reservation_attribution/2026-04-16/1776329718
id: 906397
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: 383
schema_scan_id: 6414647
updated: 2026-04-16 03:56:06

Version 906208

created: 2026-04-15 03:52:27

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_reservation_attribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/helper_reservation_attribution/2026-04-15/1776243115'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_reservation_attribution"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_reservation_attribution/2026-04-15/1776243115
id: 906208
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: 383
schema_scan_id: 6414184
updated: 2026-04-15 03:52:40

Version 905997

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_reservation_attribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/helper_reservation_attribution/2026-04-14/1776156859'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_reservation_attribution"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_reservation_attribution/2026-04-14/1776156859
id: 905997
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: 383
schema_scan_id: 6413683
updated: 2026-04-14 03:54:54

Version 905774

created: 2026-04-13 03:34:03

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_reservation_attribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/helper_reservation_attribution/2026-04-13/1776069224'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_reservation_attribution"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_reservation_attribution/2026-04-13/1776069224
id: 905774
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: 383
schema_scan_id: 6413130
updated: 2026-04-13 03:34:14

Version 905580

created: 2026-04-12 03:58:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_reservation_attribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/helper_reservation_attribution/2026-04-12/1775984288'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_reservation_attribution"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_reservation_attribution/2026-04-12/1775984288
id: 905580
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: 383
schema_scan_id: 6412744
updated: 2026-04-12 03:58:43

Version 905366

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_reservation_attribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/helper_reservation_attribution/2026-04-11/1775896285'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_reservation_attribution"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_reservation_attribution/2026-04-11/1775896285
id: 905366
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: 383
schema_scan_id: 6412351
updated: 2026-04-11 03:31:59

Version 905157

created: 2026-04-10 03:47:01

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_reservation_attribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/helper_reservation_attribution/2026-04-10/1775810801'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_reservation_attribution"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_reservation_attribution/2026-04-10/1775810801
id: 905157
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: 383
schema_scan_id: 6411862
updated: 2026-04-10 03:47:13

Version 904945

created: 2026-04-09 03:59:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_reservation_attribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/helper_reservation_attribution/2026-04-09/1775725169'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_reservation_attribution"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_reservation_attribution/2026-04-09/1775725169
id: 904945
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: 383
schema_scan_id: 6411348
updated: 2026-04-09 04:00:02

Version 904733

created: 2026-04-08 03:56:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_reservation_attribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/helper_reservation_attribution/2026-04-08/1775638572'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_reservation_attribution"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_reservation_attribution/2026-04-08/1775638572
id: 904733
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: 383
schema_scan_id: 6410856
updated: 2026-04-08 03:56:47

Version 904517

created: 2026-04-07 03:46:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_reservation_attribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/helper_reservation_attribution/2026-04-07/1775551580'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_reservation_attribution"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_reservation_attribution/2026-04-07/1775551580
id: 904517
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: 383
schema_scan_id: 6410343
updated: 2026-04-07 03:47:02

Version 904304

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_reservation_attribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/helper_reservation_attribution/2026-04-06/1775465736'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_reservation_attribution"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_reservation_attribution/2026-04-06/1775465736
id: 904304
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: 383
schema_scan_id: 6409798
updated: 2026-04-06 03:56:13

Version 904076

created: 2026-04-05 03:26:11

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_reservation_attribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/helper_reservation_attribution/2026-04-05/1775377550'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_reservation_attribution"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_reservation_attribution/2026-04-05/1775377550
id: 904076
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: 383
schema_scan_id: 6409383
updated: 2026-04-05 03:26:23

Version 903898

created: 2026-04-04 03:39:16

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_reservation_attribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/helper_reservation_attribution/2026-04-04/1775291917'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_reservation_attribution"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_reservation_attribution/2026-04-04/1775291917
id: 903898
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: 383
schema_scan_id: 6409027
updated: 2026-04-04 03:39:30

Version 903685

created: 2026-04-03 03:50:09

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_reservation_attribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/helper_reservation_attribution/2026-04-03/1775206190'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_reservation_attribution"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_reservation_attribution/2026-04-03/1775206190
id: 903685
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: 383
schema_scan_id: 6408539
updated: 2026-04-03 03:50:23

Schema Scans: 15

Last at 2026-04-17 03:49:53

Scan 6415226

duration: 0:00:14.407223

exit_message:

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

id: 6415226

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-stage",
            "key": "meta/helper_reservation_attribution/2026-04-17/1776415751/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_reservation_attribution/2026-04-17/1776415751",
        "key": "raw/helper_reservation_attribution/2026-04-17/1776415751/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_reservation_attribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15215868691704342204,
        "service_name": "redshift_unloads",
        "span_id": 17796582004863294127,
        "trace_id": 10998809657986244729
    }
}

running: False
schema_name_id: 383
start_time: 2026-04-17 03:49:53
success: True
trace_id: 10998809657986244729

Scan 6414647

duration: 0:00:14.242314

exit_message:

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

id: 6414647

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-stage",
            "key": "meta/helper_reservation_attribution/2026-04-16/1776329718/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_reservation_attribution/2026-04-16/1776329718",
        "key": "raw/helper_reservation_attribution/2026-04-16/1776329718/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_reservation_attribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 12733256028549696619,
        "service_name": "redshift_unloads",
        "span_id": 4351600770096270262,
        "trace_id": 15691940985208965166
    }
}

running: False
schema_name_id: 383
start_time: 2026-04-16 03:55:52
success: True
trace_id: 15691940985208965166

Scan 6414184

duration: 0:00:14.185488

exit_message:

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

id: 6414184

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-stage",
            "key": "meta/helper_reservation_attribution/2026-04-15/1776243115/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_reservation_attribution/2026-04-15/1776243115",
        "key": "raw/helper_reservation_attribution/2026-04-15/1776243115/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_reservation_attribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 14069129037533090951,
        "service_name": "redshift_unloads",
        "span_id": 5136718142977206320,
        "trace_id": 14221181280999196865
    }
}

running: False
schema_name_id: 383
start_time: 2026-04-15 03:52:26
success: True
trace_id: 14221181280999196865

Scan 6413683

duration: 0:00:14.180743

exit_message:

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

id: 6413683

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-stage",
            "key": "meta/helper_reservation_attribution/2026-04-14/1776156859/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_reservation_attribution/2026-04-14/1776156859",
        "key": "raw/helper_reservation_attribution/2026-04-14/1776156859/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_reservation_attribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 17974650975415357052,
        "service_name": "redshift_unloads",
        "span_id": 9679959168064384432,
        "trace_id": 1550800209349145998
    }
}

running: False
schema_name_id: 383
start_time: 2026-04-14 03:54:40
success: True
trace_id: 1550800209349145998

Scan 6413130

duration: 0:00:11.888552

exit_message:

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

id: 6413130

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-stage",
            "key": "meta/helper_reservation_attribution/2026-04-13/1776069224/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_reservation_attribution/2026-04-13/1776069224",
        "key": "raw/helper_reservation_attribution/2026-04-13/1776069224/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_reservation_attribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8365521043290039122,
        "service_name": "redshift_unloads",
        "span_id": 5864455496111025970,
        "trace_id": 3857246598501049461
    }
}

running: False
schema_name_id: 383
start_time: 2026-04-13 03:34:02
success: True
trace_id: 3857246598501049461

Scan 6412744

duration: 0:00:11.553773

exit_message:

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

id: 6412744

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-stage",
            "key": "meta/helper_reservation_attribution/2026-04-12/1775984288/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_reservation_attribution/2026-04-12/1775984288",
        "key": "raw/helper_reservation_attribution/2026-04-12/1775984288/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_reservation_attribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 4113168856182963564,
        "service_name": "redshift_unloads",
        "span_id": 9324774889257501625,
        "trace_id": 154857752871071839
    }
}

running: False
schema_name_id: 383
start_time: 2026-04-12 03:58:31
success: True
trace_id: 154857752871071839

Scan 6412351

duration: 0:00:11.711431

exit_message:

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

id: 6412351

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-stage",
            "key": "meta/helper_reservation_attribution/2026-04-11/1775896285/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_reservation_attribution/2026-04-11/1775896285",
        "key": "raw/helper_reservation_attribution/2026-04-11/1775896285/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_reservation_attribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 10117974237540118601,
        "service_name": "redshift_unloads",
        "span_id": 3523633014881982246,
        "trace_id": 8717067122147783697
    }
}

running: False
schema_name_id: 383
start_time: 2026-04-11 03:31:47
success: True
trace_id: 8717067122147783697

Scan 6411862

duration: 0:00:11.749174

exit_message:

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

id: 6411862

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-stage",
            "key": "meta/helper_reservation_attribution/2026-04-10/1775810801/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_reservation_attribution/2026-04-10/1775810801",
        "key": "raw/helper_reservation_attribution/2026-04-10/1775810801/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_reservation_attribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 4050507022700807114,
        "service_name": "redshift_unloads",
        "span_id": 4961087686505628388,
        "trace_id": 8379435196910589167
    }
}

running: False
schema_name_id: 383
start_time: 2026-04-10 03:47:01
success: True
trace_id: 8379435196910589167

Scan 6411348

duration: 0:00:15.306622

exit_message:

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

id: 6411348

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-stage",
            "key": "meta/helper_reservation_attribution/2026-04-09/1775725169/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_reservation_attribution/2026-04-09/1775725169",
        "key": "raw/helper_reservation_attribution/2026-04-09/1775725169/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_reservation_attribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 10530814237289493121,
        "service_name": "redshift_unloads",
        "span_id": 7906394655744628540,
        "trace_id": 14353289302185023385
    }
}

running: False
schema_name_id: 383
start_time: 2026-04-09 03:59:47
success: True
trace_id: 14353289302185023385

Scan 6410856

duration: 0:00:14.268037

exit_message:

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

id: 6410856

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-stage",
            "key": "meta/helper_reservation_attribution/2026-04-08/1775638572/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_reservation_attribution/2026-04-08/1775638572",
        "key": "raw/helper_reservation_attribution/2026-04-08/1775638572/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_reservation_attribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13828645122562326031,
        "service_name": "redshift_unloads",
        "span_id": 874585428244483269,
        "trace_id": 4547196205051747286
    }
}

running: False
schema_name_id: 383
start_time: 2026-04-08 03:56:33
success: True
trace_id: 4547196205051747286

Scan 6410343

duration: 0:00:11.683647

exit_message:

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

id: 6410343

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-stage",
            "key": "meta/helper_reservation_attribution/2026-04-07/1775551580/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_reservation_attribution/2026-04-07/1775551580",
        "key": "raw/helper_reservation_attribution/2026-04-07/1775551580/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_reservation_attribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8241851270382974076,
        "service_name": "redshift_unloads",
        "span_id": 12750165587091192606,
        "trace_id": 15270012592015941023
    }
}

running: False
schema_name_id: 383
start_time: 2026-04-07 03:46:50
success: True
trace_id: 15270012592015941023

Scan 6409798

duration: 0:00:11.638605

exit_message:

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

id: 6409798

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-stage",
            "key": "meta/helper_reservation_attribution/2026-04-06/1775465736/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_reservation_attribution/2026-04-06/1775465736",
        "key": "raw/helper_reservation_attribution/2026-04-06/1775465736/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_reservation_attribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13387907405566349905,
        "service_name": "redshift_unloads",
        "span_id": 4733509633561687677,
        "trace_id": 11233221939784990924
    }
}

running: False
schema_name_id: 383
start_time: 2026-04-06 03:56:02
success: True
trace_id: 11233221939784990924

Scan 6409383

duration: 0:00:11.704714

exit_message:

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

id: 6409383

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-stage",
            "key": "meta/helper_reservation_attribution/2026-04-05/1775377550/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_reservation_attribution/2026-04-05/1775377550",
        "key": "raw/helper_reservation_attribution/2026-04-05/1775377550/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_reservation_attribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13883812449019455124,
        "service_name": "redshift_unloads",
        "span_id": 7849005010639098615,
        "trace_id": 7336046144348942598
    }
}

running: False
schema_name_id: 383
start_time: 2026-04-05 03:26:11
success: True
trace_id: 7336046144348942598

Scan 6409027

duration: 0:00:14.193528

exit_message:

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

id: 6409027

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-stage",
            "key": "meta/helper_reservation_attribution/2026-04-04/1775291917/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_reservation_attribution/2026-04-04/1775291917",
        "key": "raw/helper_reservation_attribution/2026-04-04/1775291917/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_reservation_attribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 16644352001820206785,
        "service_name": "redshift_unloads",
        "span_id": 6468673698689229608,
        "trace_id": 5606965064091768363
    }
}

running: False
schema_name_id: 383
start_time: 2026-04-04 03:39:16
success: True
trace_id: 5606965064091768363

Scan 6408539

duration: 0:00:14.362041

exit_message:

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

id: 6408539

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-stage",
            "key": "meta/helper_reservation_attribution/2026-04-03/1775206190/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_reservation_attribution/2026-04-03/1775206190",
        "key": "raw/helper_reservation_attribution/2026-04-03/1775206190/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_reservation_attribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 12124284492134514646,
        "service_name": "redshift_unloads",
        "span_id": 14700066700518589362,
        "trace_id": 62085682809891989
    }
}

running: False
schema_name_id: 383
start_time: 2026-04-03 03:50:08
success: True
trace_id: 62085682809891989

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:49:53

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_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-stage/raw/helper_reservation_attribution/2026-04-17/1776415751'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_reservation_attribution`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_reservation_attribution"
}

Server:

hostname: schemamanager-5c55c886bf-h2ts4
name: schema_manager
process_start: 2025-10-21 13:03:27
sf_env: stage
version: 2112174301

Raw:

{
    "name": {
        "created": "2018-02-20 23:57:08",
        "disabled": false,
        "format": "raw",
        "id": 383,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_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:49:53",
        "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_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-stage/raw/helper_reservation_attribution/2026-04-17/1776415751'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_reservation_attribution`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_reservation_attribution"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}