Schema Info

Schema Name: sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution

created: 2018-05-08 15:02:51
disabled: False
format: raw
id: 420
is_partitioned: False
is_schema_datatyped: True

name:

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

type: redshift

Schema Versions: 15

Version 1717846

created: 2026-04-17 03:18:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution`\n(\n `visitor_key`  bigint , `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-prod/raw/reference_paid_media_mobile_site_reattribution/2026-04-17/1776413903'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_paid_media_mobile_site_reattribution/2026-04-17/1776413903
id: 1717846
processed: 1

raw_data:

{
    "_origin": "2",
    "site_key": "1",
    "visitor_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "site_key": "int",
    "visitor_key": "bigint"
}

schema_name_id: 420
schema_scan_id: 162167892
updated: 2026-04-17 03:18:48

Version 1716623

created: 2026-04-16 03:53:37

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution`\n(\n `visitor_key`  bigint , `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-prod/raw/reference_paid_media_mobile_site_reattribution/2026-04-16/1776329605'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_paid_media_mobile_site_reattribution/2026-04-16/1776329605
id: 1716623
processed: 1

raw_data:

{
    "_origin": "2",
    "site_key": "1",
    "visitor_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "site_key": "int",
    "visitor_key": "bigint"
}

schema_name_id: 420
schema_scan_id: 162112247
updated: 2026-04-16 03:53:48

Version 1715585

created: 2026-04-15 04:02:16

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution`\n(\n `visitor_key`  bigint , `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-prod/raw/reference_paid_media_mobile_site_reattribution/2026-04-15/1776243666'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_paid_media_mobile_site_reattribution/2026-04-15/1776243666
id: 1715585
processed: 1

raw_data:

{
    "_origin": "2",
    "site_key": "1",
    "visitor_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "site_key": "int",
    "visitor_key": "bigint"
}

schema_name_id: 420
schema_scan_id: 162057594
updated: 2026-04-15 04:02:30

Version 1714231

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution`\n(\n `visitor_key`  bigint , `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-prod/raw/reference_paid_media_mobile_site_reattribution/2026-04-14/1776155751'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_paid_media_mobile_site_reattribution/2026-04-14/1776155751
id: 1714231
processed: 1

raw_data:

{
    "_origin": "2",
    "site_key": "1",
    "visitor_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "site_key": "int",
    "visitor_key": "bigint"
}

schema_name_id: 420
schema_scan_id: 162000786
updated: 2026-04-14 03:36:11

Version 1713013

created: 2026-04-13 03:47:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution`\n(\n `visitor_key`  bigint , `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-prod/raw/reference_paid_media_mobile_site_reattribution/2026-04-13/1776070061'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_paid_media_mobile_site_reattribution/2026-04-13/1776070061
id: 1713013
processed: 1

raw_data:

{
    "_origin": "2",
    "site_key": "1",
    "visitor_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "site_key": "int",
    "visitor_key": "bigint"
}

schema_name_id: 420
schema_scan_id: 161942970
updated: 2026-04-13 03:48:05

Version 1711849

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution`\n(\n `visitor_key`  bigint , `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-prod/raw/reference_paid_media_mobile_site_reattribution/2026-04-12/1775984181'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_paid_media_mobile_site_reattribution/2026-04-12/1775984181
id: 1711849
processed: 1

raw_data:

{
    "_origin": "2",
    "site_key": "1",
    "visitor_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "site_key": "int",
    "visitor_key": "bigint"
}

schema_name_id: 420
schema_scan_id: 161893933
updated: 2026-04-12 03:56:46

Version 1710652

created: 2026-04-11 04:02:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution`\n(\n `visitor_key`  bigint , `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-prod/raw/reference_paid_media_mobile_site_reattribution/2026-04-11/1775898143'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_paid_media_mobile_site_reattribution/2026-04-11/1775898143
id: 1710652
processed: 1

raw_data:

{
    "_origin": "2",
    "site_key": "1",
    "visitor_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "site_key": "int",
    "visitor_key": "bigint"
}

schema_name_id: 420
schema_scan_id: 161842654
updated: 2026-04-11 04:02:45

Version 1709484

created: 2026-04-10 04:06:01

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution`\n(\n `visitor_key`  bigint , `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-prod/raw/reference_paid_media_mobile_site_reattribution/2026-04-10/1775811952'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_paid_media_mobile_site_reattribution/2026-04-10/1775811952
id: 1709484
processed: 1

raw_data:

{
    "_origin": "2",
    "site_key": "1",
    "visitor_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "site_key": "int",
    "visitor_key": "bigint"
}

schema_name_id: 420
schema_scan_id: 161787373
updated: 2026-04-10 04:06:15

Version 1708316

created: 2026-04-09 03:30:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution`\n(\n `visitor_key`  bigint , `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-prod/raw/reference_paid_media_mobile_site_reattribution/2026-04-09/1775723408'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_paid_media_mobile_site_reattribution/2026-04-09/1775723408
id: 1708316
processed: 1

raw_data:

{
    "_origin": "2",
    "site_key": "1",
    "visitor_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "site_key": "int",
    "visitor_key": "bigint"
}

schema_name_id: 420
schema_scan_id: 161730634
updated: 2026-04-09 03:30:31

Version 1707115

created: 2026-04-08 03:36:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution`\n(\n `visitor_key`  bigint , `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-prod/raw/reference_paid_media_mobile_site_reattribution/2026-04-08/1775637362'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_paid_media_mobile_site_reattribution/2026-04-08/1775637362
id: 1707115
processed: 1

raw_data:

{
    "_origin": "2",
    "site_key": "1",
    "visitor_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "site_key": "int",
    "visitor_key": "bigint"
}

schema_name_id: 420
schema_scan_id: 161675824
updated: 2026-04-08 03:36:29

Version 1705916

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution`\n(\n `visitor_key`  bigint , `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-prod/raw/reference_paid_media_mobile_site_reattribution/2026-04-07/1775550763'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_paid_media_mobile_site_reattribution/2026-04-07/1775550763
id: 1705916
processed: 1

raw_data:

{
    "_origin": "2",
    "site_key": "1",
    "visitor_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "site_key": "int",
    "visitor_key": "bigint"
}

schema_name_id: 420
schema_scan_id: 161619681
updated: 2026-04-07 03:33:19

Version 1704688

created: 2026-04-06 03:40:30

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution`\n(\n `visitor_key`  bigint , `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-prod/raw/reference_paid_media_mobile_site_reattribution/2026-04-06/1775464822'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_paid_media_mobile_site_reattribution/2026-04-06/1775464822
id: 1704688
processed: 1

raw_data:

{
    "_origin": "2",
    "site_key": "1",
    "visitor_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "site_key": "int",
    "visitor_key": "bigint"
}

schema_name_id: 420
schema_scan_id: 161561883
updated: 2026-04-06 03:40:44

Version 1703508

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution`\n(\n `visitor_key`  bigint , `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-prod/raw/reference_paid_media_mobile_site_reattribution/2026-04-05/1775379460'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_paid_media_mobile_site_reattribution/2026-04-05/1775379460
id: 1703508
processed: 1

raw_data:

{
    "_origin": "2",
    "site_key": "1",
    "visitor_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "site_key": "int",
    "visitor_key": "bigint"
}

schema_name_id: 420
schema_scan_id: 161515770
updated: 2026-04-05 03:58:24

Version 1702315

created: 2026-04-04 03:25:05

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution`\n(\n `visitor_key`  bigint , `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-prod/raw/reference_paid_media_mobile_site_reattribution/2026-04-04/1775291086'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_paid_media_mobile_site_reattribution/2026-04-04/1775291086
id: 1702315
processed: 1

raw_data:

{
    "_origin": "2",
    "site_key": "1",
    "visitor_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "site_key": "int",
    "visitor_key": "bigint"
}

schema_name_id: 420
schema_scan_id: 161460674
updated: 2026-04-04 03:25:16

Version 1701142

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution`\n(\n `visitor_key`  bigint , `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-prod/raw/reference_paid_media_mobile_site_reattribution/2026-04-03/1775205415'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_paid_media_mobile_site_reattribution/2026-04-03/1775205415
id: 1701142
processed: 1

raw_data:

{
    "_origin": "2",
    "site_key": "1",
    "visitor_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "site_key": "int",
    "visitor_key": "bigint"
}

schema_name_id: 420
schema_scan_id: 161402170
updated: 2026-04-03 03:37:14

Schema Scans: 15

Last at 2026-04-17 03:18:34

Scan 162167892

duration: 0:00:14.140386

exit_message:

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

id: 162167892

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "site_key": "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_mobile_site_reattribution/2026-04-17/1776413903/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_mobile_site_reattribution/2026-04-17/1776413903",
        "key": "raw/reference_paid_media_mobile_site_reattribution/2026-04-17/1776413903/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 2960178055546767752,
        "service_name": "redshift_unloads",
        "span_id": 15504218005333888142,
        "trace_id": 17205299956280238954
    }
}

running: False
schema_name_id: 420
start_time: 2026-04-17 03:18:34
success: True
trace_id: 17205299956280238954

Scan 162112247

duration: 0:00:11.774491

exit_message:

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

id: 162112247

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "site_key": "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_mobile_site_reattribution/2026-04-16/1776329605/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_mobile_site_reattribution/2026-04-16/1776329605",
        "key": "raw/reference_paid_media_mobile_site_reattribution/2026-04-16/1776329605/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13973356137748612426,
        "service_name": "redshift_unloads",
        "span_id": 16380973607747680995,
        "trace_id": 1126475687409784617
    }
}

running: False
schema_name_id: 420
start_time: 2026-04-16 03:53:37
success: True
trace_id: 1126475687409784617

Scan 162057594

duration: 0:00:14.212401

exit_message:

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

id: 162057594

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "site_key": "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_mobile_site_reattribution/2026-04-15/1776243666/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_mobile_site_reattribution/2026-04-15/1776243666",
        "key": "raw/reference_paid_media_mobile_site_reattribution/2026-04-15/1776243666/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 9684894800411665365,
        "service_name": "redshift_unloads",
        "span_id": 11440919466246608937,
        "trace_id": 1125172246328417152
    }
}

running: False
schema_name_id: 420
start_time: 2026-04-15 04:02:16
success: True
trace_id: 1125172246328417152

Scan 162000786

duration: 0:00:11.565704

exit_message:

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

id: 162000786

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "site_key": "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_mobile_site_reattribution/2026-04-14/1776155751/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_mobile_site_reattribution/2026-04-14/1776155751",
        "key": "raw/reference_paid_media_mobile_site_reattribution/2026-04-14/1776155751/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3456873326010110005,
        "service_name": "redshift_unloads",
        "span_id": 9855384559214762638,
        "trace_id": 9453011176779609070
    }
}

running: False
schema_name_id: 420
start_time: 2026-04-14 03:36:00
success: True
trace_id: 9453011176779609070

Scan 161942970

duration: 0:00:14.162913

exit_message:

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

id: 161942970

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "site_key": "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_mobile_site_reattribution/2026-04-13/1776070061/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_mobile_site_reattribution/2026-04-13/1776070061",
        "key": "raw/reference_paid_media_mobile_site_reattribution/2026-04-13/1776070061/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13391163427959983596,
        "service_name": "redshift_unloads",
        "span_id": 13947176497696260698,
        "trace_id": 7363014335756192595
    }
}

running: False
schema_name_id: 420
start_time: 2026-04-13 03:47:51
success: True
trace_id: 7363014335756192595

Scan 161893933

duration: 0:00:14.134035

exit_message:

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

id: 161893933

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "site_key": "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_mobile_site_reattribution/2026-04-12/1775984181/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_mobile_site_reattribution/2026-04-12/1775984181",
        "key": "raw/reference_paid_media_mobile_site_reattribution/2026-04-12/1775984181/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 7771672925135184963,
        "service_name": "redshift_unloads",
        "span_id": 14842070409897921787,
        "trace_id": 5605210495471178067
    }
}

running: False
schema_name_id: 420
start_time: 2026-04-12 03:56:32
success: True
trace_id: 5605210495471178067

Scan 161842654

duration: 0:00:11.642024

exit_message:

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

id: 161842654

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "site_key": "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_mobile_site_reattribution/2026-04-11/1775898143/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_mobile_site_reattribution/2026-04-11/1775898143",
        "key": "raw/reference_paid_media_mobile_site_reattribution/2026-04-11/1775898143/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 7462286878069919101,
        "service_name": "redshift_unloads",
        "span_id": 11504925290303052484,
        "trace_id": 2916121312101132890
    }
}

running: False
schema_name_id: 420
start_time: 2026-04-11 04:02:33
success: True
trace_id: 2916121312101132890

Scan 161787373

duration: 0:00:14.264684

exit_message:

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

id: 161787373

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "site_key": "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_mobile_site_reattribution/2026-04-10/1775811952/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_mobile_site_reattribution/2026-04-10/1775811952",
        "key": "raw/reference_paid_media_mobile_site_reattribution/2026-04-10/1775811952/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8052871025153500253,
        "service_name": "redshift_unloads",
        "span_id": 864723470643725845,
        "trace_id": 11992317387821996801
    }
}

running: False
schema_name_id: 420
start_time: 2026-04-10 04:06:01
success: True
trace_id: 11992317387821996801

Scan 161730634

duration: 0:00:11.554295

exit_message:

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

id: 161730634

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "site_key": "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_mobile_site_reattribution/2026-04-09/1775723408/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_mobile_site_reattribution/2026-04-09/1775723408",
        "key": "raw/reference_paid_media_mobile_site_reattribution/2026-04-09/1775723408/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 9455697693938445627,
        "service_name": "redshift_unloads",
        "span_id": 12910516655267564817,
        "trace_id": 636081814107938884
    }
}

running: False
schema_name_id: 420
start_time: 2026-04-09 03:30:20
success: True
trace_id: 636081814107938884

Scan 161675824

duration: 0:00:14.223079

exit_message:

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

id: 161675824

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "site_key": "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_mobile_site_reattribution/2026-04-08/1775637362/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_mobile_site_reattribution/2026-04-08/1775637362",
        "key": "raw/reference_paid_media_mobile_site_reattribution/2026-04-08/1775637362/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8768395505481927292,
        "service_name": "redshift_unloads",
        "span_id": 9084705555615423717,
        "trace_id": 11888932291303430078
    }
}

running: False
schema_name_id: 420
start_time: 2026-04-08 03:36:15
success: True
trace_id: 11888932291303430078

Scan 161619681

duration: 0:00:14.094544

exit_message:

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

id: 161619681

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "site_key": "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_mobile_site_reattribution/2026-04-07/1775550763/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_mobile_site_reattribution/2026-04-07/1775550763",
        "key": "raw/reference_paid_media_mobile_site_reattribution/2026-04-07/1775550763/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3360434234685708605,
        "service_name": "redshift_unloads",
        "span_id": 12457372431194842416,
        "trace_id": 8511434524632572623
    }
}

running: False
schema_name_id: 420
start_time: 2026-04-07 03:33:05
success: True
trace_id: 8511434524632572623

Scan 161561883

duration: 0:00:14.174821

exit_message:

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

id: 161561883

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "site_key": "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_mobile_site_reattribution/2026-04-06/1775464822/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_mobile_site_reattribution/2026-04-06/1775464822",
        "key": "raw/reference_paid_media_mobile_site_reattribution/2026-04-06/1775464822/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 1952818038905210174,
        "service_name": "redshift_unloads",
        "span_id": 6558916401118128627,
        "trace_id": 13172433559546025632
    }
}

running: False
schema_name_id: 420
start_time: 2026-04-06 03:40:30
success: True
trace_id: 13172433559546025632

Scan 161515770

duration: 0:00:14.113928

exit_message:

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

id: 161515770

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "site_key": "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_mobile_site_reattribution/2026-04-05/1775379460/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_mobile_site_reattribution/2026-04-05/1775379460",
        "key": "raw/reference_paid_media_mobile_site_reattribution/2026-04-05/1775379460/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 14088645068714423101,
        "service_name": "redshift_unloads",
        "span_id": 13432602418019284021,
        "trace_id": 7592281301924359263
    }
}

running: False
schema_name_id: 420
start_time: 2026-04-05 03:58:10
success: True
trace_id: 7592281301924359263

Scan 161460674

duration: 0:00:11.669297

exit_message:

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

id: 161460674

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "site_key": "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_mobile_site_reattribution/2026-04-04/1775291086/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_mobile_site_reattribution/2026-04-04/1775291086",
        "key": "raw/reference_paid_media_mobile_site_reattribution/2026-04-04/1775291086/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 16982269110047180259,
        "service_name": "redshift_unloads",
        "span_id": 10264658269703841004,
        "trace_id": 9129145738774964389
    }
}

running: False
schema_name_id: 420
start_time: 2026-04-04 03:25:04
success: True
trace_id: 9129145738774964389

Scan 161402170

duration: 0:00:11.556825

exit_message:

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

id: 161402170

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "site_key": "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_mobile_site_reattribution/2026-04-03/1775205415/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_mobile_site_reattribution/2026-04-03/1775205415",
        "key": "raw/reference_paid_media_mobile_site_reattribution/2026-04-03/1775205415/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 7671060180409818434,
        "service_name": "redshift_unloads",
        "span_id": 3669242279531068472,
        "trace_id": 11167448998544902515
    }
}

running: False
schema_name_id: 420
start_time: 2026-04-03 03:37:03
success: True
trace_id: 11167448998544902515

Partitions:

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

Schema:

attributes:

{
    "_origin": "string",
    "site_key": "int",
    "visitor_key": "bigint"
}

created: 2026-04-17 03:18:34

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_mobile_site_reattribution`\n(\n `visitor_key`  bigint , `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-prod/raw/reference_paid_media_mobile_site_reattribution/2026-04-17/1776413903'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_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:02:51",
        "disabled": false,
        "format": "raw",
        "id": 420,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_redshift",
            "table": "analytics_reference_paid_media_mobile_site_reattribution"
        },
        "type": "redshift"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "_origin": "string",
            "site_key": "int",
            "visitor_key": "bigint"
        },
        "created": "2026-04-17 03:18:34",
        "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_mobile_site_reattribution`\n(\n `visitor_key`  bigint , `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-prod/raw/reference_paid_media_mobile_site_reattribution/2026-04-17/1776413903'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_paid_media_mobile_site_reattribution"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}