Schema Info

Schema Name: sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution

created: 2018-05-08 15:03:53
disabled: False
format: raw
id: 422
is_partitioned: False
is_schema_datatyped: True

name:

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

type: redshift

Schema Versions: 15

Version 1717854

created: 2026-04-17 03:19:31

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution`\n(\n `visitor_key`  bigint , `proposed_new_stid`  int , `proposed_new_tsid`  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/reference_paid_media_visit_reattribution/2026-04-17/1776413911'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_paid_media_visit_reattribution/2026-04-17/1776413911
id: 1717854
processed: 1

raw_data:

{
    "_origin": "3",
    "proposed_new_stid": "1",
    "proposed_new_tsid": "2",
    "visitor_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "proposed_new_stid": "int",
    "proposed_new_tsid": "int",
    "visitor_key": "bigint"
}

schema_name_id: 422
schema_scan_id: 162167900
updated: 2026-04-17 03:19:42

Version 1716626

created: 2026-04-16 03:54:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution`\n(\n `visitor_key`  bigint , `proposed_new_stid`  int , `proposed_new_tsid`  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/reference_paid_media_visit_reattribution/2026-04-16/1776329618'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_paid_media_visit_reattribution/2026-04-16/1776329618
id: 1716626
processed: 1

raw_data:

{
    "_origin": "3",
    "proposed_new_stid": "1",
    "proposed_new_tsid": "2",
    "visitor_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "proposed_new_stid": "int",
    "proposed_new_tsid": "int",
    "visitor_key": "bigint"
}

schema_name_id: 422
schema_scan_id: 162112285
updated: 2026-04-16 03:54:33

Version 1715408

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution`\n(\n `visitor_key`  bigint , `proposed_new_stid`  int , `proposed_new_tsid`  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/reference_paid_media_visit_reattribution/2026-04-15/1776241638'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_paid_media_visit_reattribution/2026-04-15/1776241638
id: 1715408
processed: 1

raw_data:

{
    "_origin": "3",
    "proposed_new_stid": "1",
    "proposed_new_tsid": "2",
    "visitor_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "proposed_new_stid": "int",
    "proposed_new_tsid": "int",
    "visitor_key": "bigint"
}

schema_name_id: 422
schema_scan_id: 162056252
updated: 2026-04-15 03:28:07

Version 1714234

created: 2026-04-14 03:36:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution`\n(\n `visitor_key`  bigint , `proposed_new_stid`  int , `proposed_new_tsid`  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/reference_paid_media_visit_reattribution/2026-04-14/1776155772'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_paid_media_visit_reattribution/2026-04-14/1776155772
id: 1714234
processed: 1

raw_data:

{
    "_origin": "3",
    "proposed_new_stid": "1",
    "proposed_new_tsid": "2",
    "visitor_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "proposed_new_stid": "int",
    "proposed_new_tsid": "int",
    "visitor_key": "bigint"
}

schema_name_id: 422
schema_scan_id: 162000790
updated: 2026-04-14 03:37:04

Version 1713015

created: 2026-04-13 03:49:24

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution`\n(\n `visitor_key`  bigint , `proposed_new_stid`  int , `proposed_new_tsid`  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/reference_paid_media_visit_reattribution/2026-04-13/1776070126'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_paid_media_visit_reattribution/2026-04-13/1776070126
id: 1713015
processed: 1

raw_data:

{
    "_origin": "3",
    "proposed_new_stid": "1",
    "proposed_new_tsid": "2",
    "visitor_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "proposed_new_stid": "int",
    "proposed_new_tsid": "int",
    "visitor_key": "bigint"
}

schema_name_id: 422
schema_scan_id: 161942997
updated: 2026-04-13 03:49:35

Version 1711839

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution`\n(\n `visitor_key`  bigint , `proposed_new_stid`  int , `proposed_new_tsid`  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/reference_paid_media_visit_reattribution/2026-04-12/1775984052'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_paid_media_visit_reattribution/2026-04-12/1775984052
id: 1711839
processed: 1

raw_data:

{
    "_origin": "3",
    "proposed_new_stid": "1",
    "proposed_new_tsid": "2",
    "visitor_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "proposed_new_stid": "int",
    "proposed_new_tsid": "int",
    "visitor_key": "bigint"
}

schema_name_id: 422
schema_scan_id: 161893765
updated: 2026-04-12 03:55:24

Version 1710646

created: 2026-04-11 04:02:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution`\n(\n `visitor_key`  bigint , `proposed_new_stid`  int , `proposed_new_tsid`  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/reference_paid_media_visit_reattribution/2026-04-11/1775898054'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_paid_media_visit_reattribution/2026-04-11/1775898054
id: 1710646
processed: 1

raw_data:

{
    "_origin": "3",
    "proposed_new_stid": "1",
    "proposed_new_tsid": "2",
    "visitor_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "proposed_new_stid": "int",
    "proposed_new_tsid": "int",
    "visitor_key": "bigint"
}

schema_name_id: 422
schema_scan_id: 161842638
updated: 2026-04-11 04:02:23

Version 1709466

created: 2026-04-10 04:03:11

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution`\n(\n `visitor_key`  bigint , `proposed_new_stid`  int , `proposed_new_tsid`  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/reference_paid_media_visit_reattribution/2026-04-10/1775811743'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_paid_media_visit_reattribution/2026-04-10/1775811743
id: 1709466
processed: 1

raw_data:

{
    "_origin": "3",
    "proposed_new_stid": "1",
    "proposed_new_tsid": "2",
    "visitor_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "proposed_new_stid": "int",
    "proposed_new_tsid": "int",
    "visitor_key": "bigint"
}

schema_name_id: 422
schema_scan_id: 161787350
updated: 2026-04-10 04:03:25

Version 1708294

created: 2026-04-09 03:28:07

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution`\n(\n `visitor_key`  bigint , `proposed_new_stid`  int , `proposed_new_tsid`  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/reference_paid_media_visit_reattribution/2026-04-09/1775723243'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_paid_media_visit_reattribution/2026-04-09/1775723243
id: 1708294
processed: 1

raw_data:

{
    "_origin": "3",
    "proposed_new_stid": "1",
    "proposed_new_tsid": "2",
    "visitor_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "proposed_new_stid": "int",
    "proposed_new_tsid": "int",
    "visitor_key": "bigint"
}

schema_name_id: 422
schema_scan_id: 161730611
updated: 2026-04-09 03:28:18

Version 1707089

created: 2026-04-08 03:21:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution`\n(\n `visitor_key`  bigint , `proposed_new_stid`  int , `proposed_new_tsid`  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/reference_paid_media_visit_reattribution/2026-04-08/1775636444'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_paid_media_visit_reattribution/2026-04-08/1775636444
id: 1707089
processed: 1

raw_data:

{
    "_origin": "3",
    "proposed_new_stid": "1",
    "proposed_new_tsid": "2",
    "visitor_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "proposed_new_stid": "int",
    "proposed_new_tsid": "int",
    "visitor_key": "bigint"
}

schema_name_id: 422
schema_scan_id: 161675786
updated: 2026-04-08 03:21:39

Version 1705918

created: 2026-04-07 03:33:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution`\n(\n `visitor_key`  bigint , `proposed_new_stid`  int , `proposed_new_tsid`  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/reference_paid_media_visit_reattribution/2026-04-07/1775550778'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_paid_media_visit_reattribution/2026-04-07/1775550778
id: 1705918
processed: 1

raw_data:

{
    "_origin": "3",
    "proposed_new_stid": "1",
    "proposed_new_tsid": "2",
    "visitor_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "proposed_new_stid": "int",
    "proposed_new_tsid": "int",
    "visitor_key": "bigint"
}

schema_name_id: 422
schema_scan_id: 161619683
updated: 2026-04-07 03:33:57

Version 1704719

created: 2026-04-06 04:00:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution`\n(\n `visitor_key`  bigint , `proposed_new_stid`  int , `proposed_new_tsid`  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/reference_paid_media_visit_reattribution/2026-04-06/1775465938'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_paid_media_visit_reattribution/2026-04-06/1775465938
id: 1704719
processed: 1

raw_data:

{
    "_origin": "3",
    "proposed_new_stid": "1",
    "proposed_new_tsid": "2",
    "visitor_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "proposed_new_stid": "int",
    "proposed_new_tsid": "int",
    "visitor_key": "bigint"
}

schema_name_id: 422
schema_scan_id: 161562858
updated: 2026-04-06 04:00:34

Version 1703473

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution`\n(\n `visitor_key`  bigint , `proposed_new_stid`  int , `proposed_new_tsid`  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/reference_paid_media_visit_reattribution/2026-04-05/1775377952'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_paid_media_visit_reattribution/2026-04-05/1775377952
id: 1703473
processed: 1

raw_data:

{
    "_origin": "3",
    "proposed_new_stid": "1",
    "proposed_new_tsid": "2",
    "visitor_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "proposed_new_stid": "int",
    "proposed_new_tsid": "int",
    "visitor_key": "bigint"
}

schema_name_id: 422
schema_scan_id: 161515086
updated: 2026-04-05 03:33:30

Version 1702366

created: 2026-04-04 04:02:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution`\n(\n `visitor_key`  bigint , `proposed_new_stid`  int , `proposed_new_tsid`  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/reference_paid_media_visit_reattribution/2026-04-04/1775293315'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_paid_media_visit_reattribution/2026-04-04/1775293315
id: 1702366
processed: 1

raw_data:

{
    "_origin": "3",
    "proposed_new_stid": "1",
    "proposed_new_tsid": "2",
    "visitor_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "proposed_new_stid": "int",
    "proposed_new_tsid": "int",
    "visitor_key": "bigint"
}

schema_name_id: 422
schema_scan_id: 161461931
updated: 2026-04-04 04:02:50

Version 1701140

created: 2026-04-03 03:36:37

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution`\n(\n `visitor_key`  bigint , `proposed_new_stid`  int , `proposed_new_tsid`  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/reference_paid_media_visit_reattribution/2026-04-03/1775205352'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_paid_media_visit_reattribution/2026-04-03/1775205352
id: 1701140
processed: 1

raw_data:

{
    "_origin": "3",
    "proposed_new_stid": "1",
    "proposed_new_tsid": "2",
    "visitor_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "proposed_new_stid": "int",
    "proposed_new_tsid": "int",
    "visitor_key": "bigint"
}

schema_name_id: 422
schema_scan_id: 161402168
updated: 2026-04-03 03:36:48

Schema Scans: 15

Last at 2026-04-17 03:19:31

Scan 162167900

duration: 0:00:11.606046

exit_message:

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

id: 162167900

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "proposed_new_stid": "int",
        "proposed_new_tsid": "int",
        "visitor_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_paid_media_visit_reattribution/2026-04-17/1776413911/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_paid_media_visit_reattribution/2026-04-17/1776413911",
        "key": "raw/reference_paid_media_visit_reattribution/2026-04-17/1776413911/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 11970465800325152381,
        "service_name": "redshift_unloads",
        "span_id": 11816402917190554277,
        "trace_id": 229074535520601050
    }
}

running: False
schema_name_id: 422
start_time: 2026-04-17 03:19:31
success: True
trace_id: 229074535520601050

Scan 162112285

duration: 0:00:14.104757

exit_message:

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

id: 162112285

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "proposed_new_stid": "int",
        "proposed_new_tsid": "int",
        "visitor_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_paid_media_visit_reattribution/2026-04-16/1776329618/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_paid_media_visit_reattribution/2026-04-16/1776329618",
        "key": "raw/reference_paid_media_visit_reattribution/2026-04-16/1776329618/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 325299888790514116,
        "service_name": "redshift_unloads",
        "span_id": 17609850100103370438,
        "trace_id": 11234359431853656955
    }
}

running: False
schema_name_id: 422
start_time: 2026-04-16 03:54:19
success: True
trace_id: 11234359431853656955

Scan 162056252

duration: 0:00:14.193476

exit_message:

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

id: 162056252

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "proposed_new_stid": "int",
        "proposed_new_tsid": "int",
        "visitor_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_paid_media_visit_reattribution/2026-04-15/1776241638/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_paid_media_visit_reattribution/2026-04-15/1776241638",
        "key": "raw/reference_paid_media_visit_reattribution/2026-04-15/1776241638/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8125394037540086267,
        "service_name": "redshift_unloads",
        "span_id": 3901444302775629282,
        "trace_id": 12113119133399866504
    }
}

running: False
schema_name_id: 422
start_time: 2026-04-15 03:27:53
success: True
trace_id: 12113119133399866504

Scan 162000790

duration: 0:00:14.159653

exit_message:

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

id: 162000790

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "proposed_new_stid": "int",
        "proposed_new_tsid": "int",
        "visitor_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_paid_media_visit_reattribution/2026-04-14/1776155772/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_paid_media_visit_reattribution/2026-04-14/1776155772",
        "key": "raw/reference_paid_media_visit_reattribution/2026-04-14/1776155772/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 9985711503912192552,
        "service_name": "redshift_unloads",
        "span_id": 10303106302594007138,
        "trace_id": 5514726535021318045
    }
}

running: False
schema_name_id: 422
start_time: 2026-04-14 03:36:49
success: True
trace_id: 5514726535021318045

Scan 161942997

duration: 0:00:11.672882

exit_message:

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

id: 161942997

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "proposed_new_stid": "int",
        "proposed_new_tsid": "int",
        "visitor_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_paid_media_visit_reattribution/2026-04-13/1776070126/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_paid_media_visit_reattribution/2026-04-13/1776070126",
        "key": "raw/reference_paid_media_visit_reattribution/2026-04-13/1776070126/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13314723244069849822,
        "service_name": "redshift_unloads",
        "span_id": 17506121199646669115,
        "trace_id": 9544923809213397723
    }
}

running: False
schema_name_id: 422
start_time: 2026-04-13 03:49:23
success: True
trace_id: 9544923809213397723

Scan 161893765

duration: 0:00:11.502680

exit_message:

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

id: 161893765

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "proposed_new_stid": "int",
        "proposed_new_tsid": "int",
        "visitor_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_paid_media_visit_reattribution/2026-04-12/1775984052/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_paid_media_visit_reattribution/2026-04-12/1775984052",
        "key": "raw/reference_paid_media_visit_reattribution/2026-04-12/1775984052/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 10720022704472155157,
        "service_name": "redshift_unloads",
        "span_id": 7711563652002515968,
        "trace_id": 17567683955917091917
    }
}

running: False
schema_name_id: 422
start_time: 2026-04-12 03:55:13
success: True
trace_id: 17567683955917091917

Scan 161842638

duration: 0:00:11.656008

exit_message:

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

id: 161842638

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "proposed_new_stid": "int",
        "proposed_new_tsid": "int",
        "visitor_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_paid_media_visit_reattribution/2026-04-11/1775898054/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_paid_media_visit_reattribution/2026-04-11/1775898054",
        "key": "raw/reference_paid_media_visit_reattribution/2026-04-11/1775898054/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15089278961858219680,
        "service_name": "redshift_unloads",
        "span_id": 12036456457875414982,
        "trace_id": 1418725207393792360
    }
}

running: False
schema_name_id: 422
start_time: 2026-04-11 04:02:11
success: True
trace_id: 1418725207393792360

Scan 161787350

duration: 0:00:14.219923

exit_message:

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

id: 161787350

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "proposed_new_stid": "int",
        "proposed_new_tsid": "int",
        "visitor_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_paid_media_visit_reattribution/2026-04-10/1775811743/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_paid_media_visit_reattribution/2026-04-10/1775811743",
        "key": "raw/reference_paid_media_visit_reattribution/2026-04-10/1775811743/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 4498246523320635909,
        "service_name": "redshift_unloads",
        "span_id": 3906673560636500481,
        "trace_id": 14537500302514682253
    }
}

running: False
schema_name_id: 422
start_time: 2026-04-10 04:03:11
success: True
trace_id: 14537500302514682253

Scan 161730611

duration: 0:00:11.700492

exit_message:

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

id: 161730611

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "proposed_new_stid": "int",
        "proposed_new_tsid": "int",
        "visitor_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_paid_media_visit_reattribution/2026-04-09/1775723243/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_paid_media_visit_reattribution/2026-04-09/1775723243",
        "key": "raw/reference_paid_media_visit_reattribution/2026-04-09/1775723243/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 7278802969709468955,
        "service_name": "redshift_unloads",
        "span_id": 8373054193074184984,
        "trace_id": 5674352243885294549
    }
}

running: False
schema_name_id: 422
start_time: 2026-04-09 03:28:07
success: True
trace_id: 5674352243885294549

Scan 161675786

duration: 0:00:14.148275

exit_message:

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

id: 161675786

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "proposed_new_stid": "int",
        "proposed_new_tsid": "int",
        "visitor_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_paid_media_visit_reattribution/2026-04-08/1775636444/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_paid_media_visit_reattribution/2026-04-08/1775636444",
        "key": "raw/reference_paid_media_visit_reattribution/2026-04-08/1775636444/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 7309548619362027846,
        "service_name": "redshift_unloads",
        "span_id": 10516039036422383727,
        "trace_id": 4379805869350967476
    }
}

running: False
schema_name_id: 422
start_time: 2026-04-08 03:21:25
success: True
trace_id: 4379805869350967476

Scan 161619683

duration: 0:00:14.110225

exit_message:

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

id: 161619683

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "proposed_new_stid": "int",
        "proposed_new_tsid": "int",
        "visitor_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_paid_media_visit_reattribution/2026-04-07/1775550778/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_paid_media_visit_reattribution/2026-04-07/1775550778",
        "key": "raw/reference_paid_media_visit_reattribution/2026-04-07/1775550778/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3078948384688656211,
        "service_name": "redshift_unloads",
        "span_id": 4497620337915906284,
        "trace_id": 16881004616627651681
    }
}

running: False
schema_name_id: 422
start_time: 2026-04-07 03:33:43
success: True
trace_id: 16881004616627651681

Scan 161562858

duration: 0:00:14.215969

exit_message:

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

id: 161562858

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "proposed_new_stid": "int",
        "proposed_new_tsid": "int",
        "visitor_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_paid_media_visit_reattribution/2026-04-06/1775465938/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_paid_media_visit_reattribution/2026-04-06/1775465938",
        "key": "raw/reference_paid_media_visit_reattribution/2026-04-06/1775465938/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 14886959885536565920,
        "service_name": "redshift_unloads",
        "span_id": 5557751409093220072,
        "trace_id": 14028345780692120818
    }
}

running: False
schema_name_id: 422
start_time: 2026-04-06 04:00:19
success: True
trace_id: 14028345780692120818

Scan 161515086

duration: 0:00:11.631310

exit_message:

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

id: 161515086

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "proposed_new_stid": "int",
        "proposed_new_tsid": "int",
        "visitor_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_paid_media_visit_reattribution/2026-04-05/1775377952/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_paid_media_visit_reattribution/2026-04-05/1775377952",
        "key": "raw/reference_paid_media_visit_reattribution/2026-04-05/1775377952/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 14962364777126004307,
        "service_name": "redshift_unloads",
        "span_id": 8119273214796978773,
        "trace_id": 1760503558396949195
    }
}

running: False
schema_name_id: 422
start_time: 2026-04-05 03:33:18
success: True
trace_id: 1760503558396949195

Scan 161461931

duration: 0:00:11.707250

exit_message:

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

id: 161461931

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "proposed_new_stid": "int",
        "proposed_new_tsid": "int",
        "visitor_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_paid_media_visit_reattribution/2026-04-04/1775293315/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_paid_media_visit_reattribution/2026-04-04/1775293315",
        "key": "raw/reference_paid_media_visit_reattribution/2026-04-04/1775293315/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 14161722756729467916,
        "service_name": "redshift_unloads",
        "span_id": 25654704049600437,
        "trace_id": 16909797579196944050
    }
}

running: False
schema_name_id: 422
start_time: 2026-04-04 04:02:39
success: True
trace_id: 16909797579196944050

Scan 161402168

duration: 0:00:11.588152

exit_message:

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

id: 161402168

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "proposed_new_stid": "int",
        "proposed_new_tsid": "int",
        "visitor_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_paid_media_visit_reattribution/2026-04-03/1775205352/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_paid_media_visit_reattribution/2026-04-03/1775205352",
        "key": "raw/reference_paid_media_visit_reattribution/2026-04-03/1775205352/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 16619382833373986801,
        "service_name": "redshift_unloads",
        "span_id": 12340835147728749596,
        "trace_id": 15694428534530191819
    }
}

running: False
schema_name_id: 422
start_time: 2026-04-03 03:36:36
success: True
trace_id: 15694428534530191819

Partitions:

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

Schema:

attributes:

{
    "_origin": "string",
    "proposed_new_stid": "int",
    "proposed_new_tsid": "int",
    "visitor_key": "bigint"
}

created: 2026-04-17 03:19:31

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution`\n(\n `visitor_key`  bigint , `proposed_new_stid`  int , `proposed_new_tsid`  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/reference_paid_media_visit_reattribution/2026-04-17/1776413911'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution"
}

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-05-08 15:03:53",
        "disabled": false,
        "format": "raw",
        "id": 422,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_redshift",
            "table": "analytics_reference_paid_media_visit_reattribution"
        },
        "type": "redshift"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "_origin": "string",
            "proposed_new_stid": "int",
            "proposed_new_tsid": "int",
            "visitor_key": "bigint"
        },
        "created": "2026-04-17 03:19:31",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution`\n(\n `visitor_key`  bigint , `proposed_new_stid`  int , `proposed_new_tsid`  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/reference_paid_media_visit_reattribution/2026-04-17/1776413911'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_paid_media_visit_reattribution"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}