Schema Info

Schema Name: sfdl_stage_redshift.analytics_helper_call_attribution

created: 2018-02-20 23:59:29
disabled: False
format: raw
id: 390
is_partitioned: False
is_schema_datatyped: True

name:

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

type: redshift

Schema Versions: 15

Version 906645

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_call_attribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_call_attribution`\n(\n `call_key`  bigint , `traffic_source_key`  int , `site_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_call_attribution/2026-04-17/1776415768'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_call_attribution"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_call_attribution/2026-04-17/1776415768
id: 906645
processed: 1

raw_data:

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

schema_attributes:

{
    "_origin": "string",
    "call_key": "bigint",
    "site_key": "int",
    "traffic_source_key": "int"
}

schema_name_id: 390
schema_scan_id: 6415225
updated: 2026-04-17 03:50:04

Version 906426

created: 2026-04-16 04:00:55

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_call_attribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_call_attribution`\n(\n `call_key`  bigint , `traffic_source_key`  int , `site_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_call_attribution/2026-04-16/1776330018'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_call_attribution"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_call_attribution/2026-04-16/1776330018
id: 906426
processed: 1

raw_data:

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

schema_attributes:

{
    "_origin": "string",
    "call_key": "bigint",
    "site_key": "int",
    "traffic_source_key": "int"
}

schema_name_id: 390
schema_scan_id: 6414676
updated: 2026-04-16 04:01:06

Version 906209

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_call_attribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_call_attribution`\n(\n `call_key`  bigint , `traffic_source_key`  int , `site_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_call_attribution/2026-04-15/1776243131'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_call_attribution"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_call_attribution/2026-04-15/1776243131
id: 906209
processed: 1

raw_data:

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

schema_attributes:

{
    "_origin": "string",
    "call_key": "bigint",
    "site_key": "int",
    "traffic_source_key": "int"
}

schema_name_id: 390
schema_scan_id: 6414185
updated: 2026-04-15 03:52:45

Version 905999

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_call_attribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_call_attribution`\n(\n `call_key`  bigint , `traffic_source_key`  int , `site_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_call_attribution/2026-04-14/1776156879'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_call_attribution"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_call_attribution/2026-04-14/1776156879
id: 905999
processed: 1

raw_data:

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

schema_attributes:

{
    "_origin": "string",
    "call_key": "bigint",
    "site_key": "int",
    "traffic_source_key": "int"
}

schema_name_id: 390
schema_scan_id: 6413685
updated: 2026-04-14 03:55:11

Version 905775

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_call_attribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_call_attribution`\n(\n `call_key`  bigint , `traffic_source_key`  int , `site_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_call_attribution/2026-04-13/1776069239'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_call_attribution"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_call_attribution/2026-04-13/1776069239
id: 905775
processed: 1

raw_data:

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

schema_attributes:

{
    "_origin": "string",
    "call_key": "bigint",
    "site_key": "int",
    "traffic_source_key": "int"
}

schema_name_id: 390
schema_scan_id: 6413131
updated: 2026-04-13 03:34:41

Version 905547

created: 2026-04-12 03:36:07

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_call_attribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_call_attribution`\n(\n `call_key`  bigint , `traffic_source_key`  int , `site_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_call_attribution/2026-04-12/1775982938'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_call_attribution"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_call_attribution/2026-04-12/1775982938
id: 905547
processed: 1

raw_data:

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

schema_attributes:

{
    "_origin": "string",
    "call_key": "bigint",
    "site_key": "int",
    "traffic_source_key": "int"
}

schema_name_id: 390
schema_scan_id: 6412709
updated: 2026-04-12 03:36:18

Version 905357

created: 2026-04-11 03:25:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_call_attribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_call_attribution`\n(\n `call_key`  bigint , `traffic_source_key`  int , `site_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_call_attribution/2026-04-11/1775895934'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_call_attribution"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_call_attribution/2026-04-11/1775895934
id: 905357
processed: 1

raw_data:

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

schema_attributes:

{
    "_origin": "string",
    "call_key": "bigint",
    "site_key": "int",
    "traffic_source_key": "int"
}

schema_name_id: 390
schema_scan_id: 6412342
updated: 2026-04-11 03:26:08

Version 905180

created: 2026-04-10 04:00:31

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_call_attribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_call_attribution`\n(\n `call_key`  bigint , `traffic_source_key`  int , `site_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_call_attribution/2026-04-10/1775811612'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_call_attribution"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_call_attribution/2026-04-10/1775811612
id: 905180
processed: 1

raw_data:

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

schema_attributes:

{
    "_origin": "string",
    "call_key": "bigint",
    "site_key": "int",
    "traffic_source_key": "int"
}

schema_name_id: 390
schema_scan_id: 6411885
updated: 2026-04-10 04:00:42

Version 904950

created: 2026-04-09 04:00:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_call_attribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_call_attribution`\n(\n `call_key`  bigint , `traffic_source_key`  int , `site_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_call_attribution/2026-04-09/1775725198'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_call_attribution"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_call_attribution/2026-04-09/1775725198
id: 904950
processed: 1

raw_data:

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

schema_attributes:

{
    "_origin": "string",
    "call_key": "bigint",
    "site_key": "int",
    "traffic_source_key": "int"
}

schema_name_id: 390
schema_scan_id: 6411354
updated: 2026-04-09 04:00:30

Version 904701

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_call_attribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_call_attribution`\n(\n `call_key`  bigint , `traffic_source_key`  int , `site_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_call_attribution/2026-04-08/1775637049'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_call_attribution"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_call_attribution/2026-04-08/1775637049
id: 904701
processed: 1

raw_data:

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

schema_attributes:

{
    "_origin": "string",
    "call_key": "bigint",
    "site_key": "int",
    "traffic_source_key": "int"
}

schema_name_id: 390
schema_scan_id: 6410822
updated: 2026-04-08 03:31:25

Version 904519

created: 2026-04-07 03:47:05

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_call_attribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_call_attribution`\n(\n `call_key`  bigint , `traffic_source_key`  int , `site_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_call_attribution/2026-04-07/1775551603'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_call_attribution"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_call_attribution/2026-04-07/1775551603
id: 904519
processed: 1

raw_data:

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

schema_attributes:

{
    "_origin": "string",
    "call_key": "bigint",
    "site_key": "int",
    "traffic_source_key": "int"
}

schema_name_id: 390
schema_scan_id: 6410345
updated: 2026-04-07 03:47:19

Version 904292

created: 2026-04-06 03:46:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_call_attribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_call_attribution`\n(\n `call_key`  bigint , `traffic_source_key`  int , `site_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_call_attribution/2026-04-06/1775465197'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_call_attribution"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_call_attribution/2026-04-06/1775465197
id: 904292
processed: 1

raw_data:

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

schema_attributes:

{
    "_origin": "string",
    "call_key": "bigint",
    "site_key": "int",
    "traffic_source_key": "int"
}

schema_name_id: 390
schema_scan_id: 6409786
updated: 2026-04-06 03:47:06

Version 904090

created: 2026-04-05 03:33:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_call_attribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_call_attribution`\n(\n `call_key`  bigint , `traffic_source_key`  int , `site_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_call_attribution/2026-04-05/1775377966'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_call_attribution"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_call_attribution/2026-04-05/1775377966
id: 904090
processed: 1

raw_data:

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

schema_attributes:

{
    "_origin": "string",
    "call_key": "bigint",
    "site_key": "int",
    "traffic_source_key": "int"
}

schema_name_id: 390
schema_scan_id: 6409398
updated: 2026-04-05 03:33:32

Version 903889

created: 2026-04-04 03:24:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_call_attribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_call_attribution`\n(\n `call_key`  bigint , `traffic_source_key`  int , `site_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_call_attribution/2026-04-04/1775291041'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_call_attribution"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_call_attribution/2026-04-04/1775291041
id: 903889
processed: 1

raw_data:

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

schema_attributes:

{
    "_origin": "string",
    "call_key": "bigint",
    "site_key": "int",
    "traffic_source_key": "int"
}

schema_name_id: 390
schema_scan_id: 6409018
updated: 2026-04-04 03:24:30

Version 903681

created: 2026-04-03 03:45:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_call_attribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_helper_call_attribution`\n(\n `call_key`  bigint , `traffic_source_key`  int , `site_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_call_attribution/2026-04-03/1775205904'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_call_attribution"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/helper_call_attribution/2026-04-03/1775205904
id: 903681
processed: 1

raw_data:

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

schema_attributes:

{
    "_origin": "string",
    "call_key": "bigint",
    "site_key": "int",
    "traffic_source_key": "int"
}

schema_name_id: 390
schema_scan_id: 6408535
updated: 2026-04-03 03:45:33

Schema Scans: 15

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

Scan 6415225

duration: 0:00:14.194761

exit_message:

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

id: 6415225

payload:

{
    "datatype_dict": {
        "call_key": "bigint",
        "origin_key": "varchar",
        "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_call_attribution/2026-04-17/1776415768/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_call_attribution/2026-04-17/1776415768",
        "key": "raw/helper_call_attribution/2026-04-17/1776415768/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_call_attribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 4512634077613633190,
        "service_name": "redshift_unloads",
        "span_id": 7059314882208266659,
        "trace_id": 5532898443617349221
    }
}

running: False
schema_name_id: 390
start_time: 2026-04-17 03:49:50
success: True
trace_id: 5532898443617349221

Scan 6414676

duration: 0:00:11.743115

exit_message:

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

id: 6414676

payload:

{
    "datatype_dict": {
        "call_key": "bigint",
        "origin_key": "varchar",
        "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_call_attribution/2026-04-16/1776330018/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_call_attribution/2026-04-16/1776330018",
        "key": "raw/helper_call_attribution/2026-04-16/1776330018/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_call_attribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 16618657475026222681,
        "service_name": "redshift_unloads",
        "span_id": 12348344053716869580,
        "trace_id": 15822378940752077498
    }
}

running: False
schema_name_id: 390
start_time: 2026-04-16 04:00:55
success: True
trace_id: 15822378940752077498

Scan 6414185

duration: 0:00:14.277703

exit_message:

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

id: 6414185

payload:

{
    "datatype_dict": {
        "call_key": "bigint",
        "origin_key": "varchar",
        "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_call_attribution/2026-04-15/1776243131/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_call_attribution/2026-04-15/1776243131",
        "key": "raw/helper_call_attribution/2026-04-15/1776243131/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_call_attribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13222686784732497257,
        "service_name": "redshift_unloads",
        "span_id": 8473711297129077193,
        "trace_id": 12034530955338352536
    }
}

running: False
schema_name_id: 390
start_time: 2026-04-15 03:52:30
success: True
trace_id: 12034530955338352536

Scan 6413685

duration: 0:00:14.171123

exit_message:

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

id: 6413685

payload:

{
    "datatype_dict": {
        "call_key": "bigint",
        "origin_key": "varchar",
        "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_call_attribution/2026-04-14/1776156879/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_call_attribution/2026-04-14/1776156879",
        "key": "raw/helper_call_attribution/2026-04-14/1776156879/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_call_attribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 2868071995907978252,
        "service_name": "redshift_unloads",
        "span_id": 15495208868875153703,
        "trace_id": 11258178865578006046
    }
}

running: False
schema_name_id: 390
start_time: 2026-04-14 03:54:57
success: True
trace_id: 11258178865578006046

Scan 6413131

duration: 0:00:11.778343

exit_message:

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

id: 6413131

payload:

{
    "datatype_dict": {
        "call_key": "bigint",
        "origin_key": "varchar",
        "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_call_attribution/2026-04-13/1776069239/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_call_attribution/2026-04-13/1776069239",
        "key": "raw/helper_call_attribution/2026-04-13/1776069239/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_call_attribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 5597511127704015287,
        "service_name": "redshift_unloads",
        "span_id": 4735545686158239505,
        "trace_id": 2179969027356568303
    }
}

running: False
schema_name_id: 390
start_time: 2026-04-13 03:34:29
success: True
trace_id: 2179969027356568303

Scan 6412709

duration: 0:00:11.575041

exit_message:

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

id: 6412709

payload:

{
    "datatype_dict": {
        "call_key": "bigint",
        "origin_key": "varchar",
        "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_call_attribution/2026-04-12/1775982938/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_call_attribution/2026-04-12/1775982938",
        "key": "raw/helper_call_attribution/2026-04-12/1775982938/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_call_attribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 16295568628478317216,
        "service_name": "redshift_unloads",
        "span_id": 15553865255415423839,
        "trace_id": 5997574753050096006
    }
}

running: False
schema_name_id: 390
start_time: 2026-04-12 03:36:07
success: True
trace_id: 5997574753050096006

Scan 6412342

duration: 0:00:14.209694

exit_message:

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

id: 6412342

payload:

{
    "datatype_dict": {
        "call_key": "bigint",
        "origin_key": "varchar",
        "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_call_attribution/2026-04-11/1775895934/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_call_attribution/2026-04-11/1775895934",
        "key": "raw/helper_call_attribution/2026-04-11/1775895934/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_call_attribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 2666535561025772049,
        "service_name": "redshift_unloads",
        "span_id": 9799517596429142331,
        "trace_id": 5735357716603071318
    }
}

running: False
schema_name_id: 390
start_time: 2026-04-11 03:25:54
success: True
trace_id: 5735357716603071318

Scan 6411885

duration: 0:00:11.668712

exit_message:

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

id: 6411885

payload:

{
    "datatype_dict": {
        "call_key": "bigint",
        "origin_key": "varchar",
        "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_call_attribution/2026-04-10/1775811612/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_call_attribution/2026-04-10/1775811612",
        "key": "raw/helper_call_attribution/2026-04-10/1775811612/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_call_attribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 11916408624298447137,
        "service_name": "redshift_unloads",
        "span_id": 7345654090693687216,
        "trace_id": 11296299804352716817
    }
}

running: False
schema_name_id: 390
start_time: 2026-04-10 04:00:31
success: True
trace_id: 11296299804352716817

Scan 6411354

duration: 0:00:11.702550

exit_message:

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

id: 6411354

payload:

{
    "datatype_dict": {
        "call_key": "bigint",
        "origin_key": "varchar",
        "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_call_attribution/2026-04-09/1775725198/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_call_attribution/2026-04-09/1775725198",
        "key": "raw/helper_call_attribution/2026-04-09/1775725198/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_call_attribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 7981829942930357949,
        "service_name": "redshift_unloads",
        "span_id": 17453325147666291177,
        "trace_id": 6108523473114929439
    }
}

running: False
schema_name_id: 390
start_time: 2026-04-09 04:00:18
success: True
trace_id: 6108523473114929439

Scan 6410822

duration: 0:00:14.183768

exit_message:

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

id: 6410822

payload:

{
    "datatype_dict": {
        "call_key": "bigint",
        "origin_key": "varchar",
        "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_call_attribution/2026-04-08/1775637049/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_call_attribution/2026-04-08/1775637049",
        "key": "raw/helper_call_attribution/2026-04-08/1775637049/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_call_attribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 14155581034754686372,
        "service_name": "redshift_unloads",
        "span_id": 12337550090565961239,
        "trace_id": 12626962459477432270
    }
}

running: False
schema_name_id: 390
start_time: 2026-04-08 03:31:10
success: True
trace_id: 12626962459477432270

Scan 6410345

duration: 0:00:14.354598

exit_message:

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

id: 6410345

payload:

{
    "datatype_dict": {
        "call_key": "bigint",
        "origin_key": "varchar",
        "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_call_attribution/2026-04-07/1775551603/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_call_attribution/2026-04-07/1775551603",
        "key": "raw/helper_call_attribution/2026-04-07/1775551603/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_call_attribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 6141276424538628672,
        "service_name": "redshift_unloads",
        "span_id": 8763745702193530613,
        "trace_id": 13756037987781438699
    }
}

running: False
schema_name_id: 390
start_time: 2026-04-07 03:47:05
success: True
trace_id: 13756037987781438699

Scan 6409786

duration: 0:00:11.616120

exit_message:

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

id: 6409786

payload:

{
    "datatype_dict": {
        "call_key": "bigint",
        "origin_key": "varchar",
        "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_call_attribution/2026-04-06/1775465197/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_call_attribution/2026-04-06/1775465197",
        "key": "raw/helper_call_attribution/2026-04-06/1775465197/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_call_attribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 6499268173881389513,
        "service_name": "redshift_unloads",
        "span_id": 1556435644945500947,
        "trace_id": 6593903832006857193
    }
}

running: False
schema_name_id: 390
start_time: 2026-04-06 03:46:54
success: True
trace_id: 6593903832006857193

Scan 6409398

duration: 0:00:14.219227

exit_message:

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

id: 6409398

payload:

{
    "datatype_dict": {
        "call_key": "bigint",
        "origin_key": "varchar",
        "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_call_attribution/2026-04-05/1775377966/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_call_attribution/2026-04-05/1775377966",
        "key": "raw/helper_call_attribution/2026-04-05/1775377966/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_call_attribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 5683469885643491840,
        "service_name": "redshift_unloads",
        "span_id": 2105332693395284928,
        "trace_id": 12765319129928323408
    }
}

running: False
schema_name_id: 390
start_time: 2026-04-05 03:33:18
success: True
trace_id: 12765319129928323408

Scan 6409018

duration: 0:00:11.702737

exit_message:

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

id: 6409018

payload:

{
    "datatype_dict": {
        "call_key": "bigint",
        "origin_key": "varchar",
        "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_call_attribution/2026-04-04/1775291041/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_call_attribution/2026-04-04/1775291041",
        "key": "raw/helper_call_attribution/2026-04-04/1775291041/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_call_attribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15293629319528508217,
        "service_name": "redshift_unloads",
        "span_id": 5528686396607571777,
        "trace_id": 5767288395789282929
    }
}

running: False
schema_name_id: 390
start_time: 2026-04-04 03:24:18
success: True
trace_id: 5767288395789282929

Scan 6408535

duration: 0:00:11.609915

exit_message:

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

id: 6408535

payload:

{
    "datatype_dict": {
        "call_key": "bigint",
        "origin_key": "varchar",
        "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_call_attribution/2026-04-03/1775205904/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_call_attribution/2026-04-03/1775205904",
        "key": "raw/helper_call_attribution/2026-04-03/1775205904/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_helper_call_attribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 5889081374086764497,
        "service_name": "redshift_unloads",
        "span_id": 16614419071443312498,
        "trace_id": 15696137627720111956
    }
}

running: False
schema_name_id: 390
start_time: 2026-04-03 03:45:21
success: True
trace_id: 15696137627720111956

Partitions:

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

Schema:

attributes:

{
    "_origin": "string",
    "call_key": "bigint",
    "site_key": "int",
    "traffic_source_key": "int"
}

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

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_call_attribution`\n(\n `call_key`  bigint , `traffic_source_key`  int , `site_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_call_attribution/2026-04-17/1776415768'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_call_attribution`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_call_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:59:29",
        "disabled": false,
        "format": "raw",
        "id": 390,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_redshift",
            "table": "analytics_helper_call_attribution"
        },
        "type": "redshift"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "_origin": "string",
            "call_key": "bigint",
            "site_key": "int",
            "traffic_source_key": "int"
        },
        "created": "2026-04-17 03:49:51",
        "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_call_attribution`\n(\n `call_key`  bigint , `traffic_source_key`  int , `site_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_call_attribution/2026-04-17/1776415768'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_helper_call_attribution`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_helper_call_attribution"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}