Schema Info

Schema Name: sfdl_prod_redshift.analytics_helper_landing_page

created: 2018-02-28 10:52:13
disabled: False
format: raw
id: 251
is_partitioned: False
is_schema_datatyped: True

name:

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

type: redshift

Schema Versions: 15

Version 1717888

created: 2026-04-17 03:35:10

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/helper_landing_page/2026-04-17/1776414682
id: 1717888
processed: 1

raw_data:

{
    "_origin": "3",
    "day_key": "0",
    "page_view_key": "2",
    "visitor_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "day_key": "int",
    "page_view_key": "bigint",
    "visitor_key": "bigint"
}

schema_name_id: 251
schema_scan_id: 162168001
updated: 2026-04-17 03:35:21

Version 1716656

created: 2026-04-16 04:09:07

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/helper_landing_page/2026-04-16/1776330278
id: 1716656
processed: 1

raw_data:

{
    "_origin": "3",
    "day_key": "0",
    "page_view_key": "2",
    "visitor_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "day_key": "int",
    "page_view_key": "bigint",
    "visitor_key": "bigint"
}

schema_name_id: 251
schema_scan_id: 162113311
updated: 2026-04-16 04:09:21

Version 1715415

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

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/helper_landing_page/2026-04-15/1776241670
id: 1715415
processed: 1

raw_data:

{
    "_origin": "3",
    "day_key": "0",
    "page_view_key": "2",
    "visitor_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "day_key": "int",
    "page_view_key": "bigint",
    "visitor_key": "bigint"
}

schema_name_id: 251
schema_scan_id: 162056265
updated: 2026-04-15 03:31:39

Version 1714277

created: 2026-04-14 04:02:40

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/helper_landing_page/2026-04-14/1776157105
id: 1714277
processed: 1

raw_data:

{
    "_origin": "3",
    "day_key": "0",
    "page_view_key": "2",
    "visitor_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "day_key": "int",
    "page_view_key": "bigint",
    "visitor_key": "bigint"
}

schema_name_id: 251
schema_scan_id: 162001914
updated: 2026-04-14 04:02:51

Version 1713008

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

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/helper_landing_page/2026-04-13/1776069572
id: 1713008
processed: 1

raw_data:

{
    "_origin": "3",
    "day_key": "0",
    "page_view_key": "2",
    "visitor_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "day_key": "int",
    "page_view_key": "bigint",
    "visitor_key": "bigint"
}

schema_name_id: 251
schema_scan_id: 161942955
updated: 2026-04-13 03:44:04

Version 1711812

created: 2026-04-12 03:46:17

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/helper_landing_page/2026-04-12/1775983282
id: 1711812
processed: 1

raw_data:

{
    "_origin": "3",
    "day_key": "0",
    "page_view_key": "2",
    "visitor_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "day_key": "int",
    "page_view_key": "bigint",
    "visitor_key": "bigint"
}

schema_name_id: 251
schema_scan_id: 161893618
updated: 2026-04-12 03:46:28

Version 1710641

created: 2026-04-11 04:01:02

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/helper_landing_page/2026-04-11/1775897758
id: 1710641
processed: 1

raw_data:

{
    "_origin": "3",
    "day_key": "0",
    "page_view_key": "2",
    "visitor_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "day_key": "int",
    "page_view_key": "bigint",
    "visitor_key": "bigint"
}

schema_name_id: 251
schema_scan_id: 161842565
updated: 2026-04-11 04:01:16

Version 1709462

created: 2026-04-10 04:02:16

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/helper_landing_page/2026-04-10/1775811423
id: 1709462
processed: 1

raw_data:

{
    "_origin": "3",
    "day_key": "0",
    "page_view_key": "2",
    "visitor_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "day_key": "int",
    "page_view_key": "bigint",
    "visitor_key": "bigint"
}

schema_name_id: 251
schema_scan_id: 161787346
updated: 2026-04-10 04:02:30

Version 1708322

created: 2026-04-09 03:34:10

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/helper_landing_page/2026-04-09/1775723407
id: 1708322
processed: 1

raw_data:

{
    "_origin": "3",
    "day_key": "0",
    "page_view_key": "2",
    "visitor_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "day_key": "int",
    "page_view_key": "bigint",
    "visitor_key": "bigint"
}

schema_name_id: 251
schema_scan_id: 161730643
updated: 2026-04-09 03:34:21

Version 1707143

created: 2026-04-08 04:02:49

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/helper_landing_page/2026-04-08/1775638562
id: 1707143
processed: 1

raw_data:

{
    "_origin": "3",
    "day_key": "0",
    "page_view_key": "2",
    "visitor_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "day_key": "int",
    "page_view_key": "bigint",
    "visitor_key": "bigint"
}

schema_name_id: 251
schema_scan_id: 161676975
updated: 2026-04-08 04:03:03

Version 1705931

created: 2026-04-07 03:45:21

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/helper_landing_page/2026-04-07/1775551225
id: 1705931
processed: 1

raw_data:

{
    "_origin": "3",
    "day_key": "0",
    "page_view_key": "2",
    "visitor_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "day_key": "int",
    "page_view_key": "bigint",
    "visitor_key": "bigint"
}

schema_name_id: 251
schema_scan_id: 161619747
updated: 2026-04-07 03:45:35

Version 1704739

created: 2026-04-06 04:07:11

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/helper_landing_page/2026-04-06/1775466148
id: 1704739
processed: 1

raw_data:

{
    "_origin": "3",
    "day_key": "0",
    "page_view_key": "2",
    "visitor_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "day_key": "int",
    "page_view_key": "bigint",
    "visitor_key": "bigint"
}

schema_name_id: 251
schema_scan_id: 161562953
updated: 2026-04-06 04:07:22

Version 1703489

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

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/helper_landing_page/2026-04-05/1775378583
id: 1703489
processed: 1

raw_data:

{
    "_origin": "3",
    "day_key": "0",
    "page_view_key": "2",
    "visitor_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "day_key": "int",
    "page_view_key": "bigint",
    "visitor_key": "bigint"
}

schema_name_id: 251
schema_scan_id: 161515138
updated: 2026-04-05 03:48:17

Version 1702355

created: 2026-04-04 03:46:16

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/helper_landing_page/2026-04-04/1775292099
id: 1702355
processed: 1

raw_data:

{
    "_origin": "3",
    "day_key": "0",
    "page_view_key": "2",
    "visitor_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "day_key": "int",
    "page_view_key": "bigint",
    "visitor_key": "bigint"
}

schema_name_id: 251
schema_scan_id: 161460740
updated: 2026-04-04 03:46:28

Version 1701148

created: 2026-04-03 03:38:36

ddl:

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

hive_path: s3://sfdl-redshift-analytics-prod/raw/helper_landing_page/2026-04-03/1775205295
id: 1701148
processed: 1

raw_data:

{
    "_origin": "3",
    "day_key": "0",
    "page_view_key": "2",
    "visitor_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "day_key": "int",
    "page_view_key": "bigint",
    "visitor_key": "bigint"
}

schema_name_id: 251
schema_scan_id: 161402180
updated: 2026-04-03 03:38:50

Schema Scans: 15

Last at 2026-04-17 03:35:10

Scan 162168001

duration: 0:00:11.660367

exit_message:

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

id: 162168001

payload:

{
    "datatype_dict": {
        "day_key": "int",
        "origin_key": "varchar",
        "page_view_key": "bigint",
        "visitor_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/helper_landing_page/2026-04-17/1776414682/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/helper_landing_page/2026-04-17/1776414682",
        "key": "raw/helper_landing_page/2026-04-17/1776414682/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_helper_landing_page",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8449986192125337698,
        "service_name": "redshift_unloads",
        "span_id": 1442601857233279556,
        "trace_id": 15337485028040036342
    }
}

running: False
schema_name_id: 251
start_time: 2026-04-17 03:35:10
success: True
trace_id: 15337485028040036342

Scan 162113311

duration: 0:00:14.243568

exit_message:

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

id: 162113311

payload:

{
    "datatype_dict": {
        "day_key": "int",
        "origin_key": "varchar",
        "page_view_key": "bigint",
        "visitor_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/helper_landing_page/2026-04-16/1776330278/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/helper_landing_page/2026-04-16/1776330278",
        "key": "raw/helper_landing_page/2026-04-16/1776330278/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_helper_landing_page",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3593851654251070826,
        "service_name": "redshift_unloads",
        "span_id": 18265408610009133058,
        "trace_id": 8141988895444281826
    }
}

running: False
schema_name_id: 251
start_time: 2026-04-16 04:09:07
success: True
trace_id: 8141988895444281826

Scan 162056265

duration: 0:00:14.182454

exit_message:

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

id: 162056265

payload:

{
    "datatype_dict": {
        "day_key": "int",
        "origin_key": "varchar",
        "page_view_key": "bigint",
        "visitor_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/helper_landing_page/2026-04-15/1776241670/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/helper_landing_page/2026-04-15/1776241670",
        "key": "raw/helper_landing_page/2026-04-15/1776241670/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_helper_landing_page",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 12287724312923093959,
        "service_name": "redshift_unloads",
        "span_id": 1153952035873042142,
        "trace_id": 3644848223599419845
    }
}

running: False
schema_name_id: 251
start_time: 2026-04-15 03:31:25
success: True
trace_id: 3644848223599419845

Scan 162001914

duration: 0:00:11.640869

exit_message:

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

id: 162001914

payload:

{
    "datatype_dict": {
        "day_key": "int",
        "origin_key": "varchar",
        "page_view_key": "bigint",
        "visitor_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/helper_landing_page/2026-04-14/1776157105/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/helper_landing_page/2026-04-14/1776157105",
        "key": "raw/helper_landing_page/2026-04-14/1776157105/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_helper_landing_page",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 537776846122809608,
        "service_name": "redshift_unloads",
        "span_id": 6697616993404524014,
        "trace_id": 13009843312444652987
    }
}

running: False
schema_name_id: 251
start_time: 2026-04-14 04:02:40
success: True
trace_id: 13009843312444652987

Scan 161942955

duration: 0:00:14.124798

exit_message:

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

id: 161942955

payload:

{
    "datatype_dict": {
        "day_key": "int",
        "origin_key": "varchar",
        "page_view_key": "bigint",
        "visitor_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/helper_landing_page/2026-04-13/1776069572/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/helper_landing_page/2026-04-13/1776069572",
        "key": "raw/helper_landing_page/2026-04-13/1776069572/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_helper_landing_page",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 10864493473951064577,
        "service_name": "redshift_unloads",
        "span_id": 14210185634342620292,
        "trace_id": 7677768207654712813
    }
}

running: False
schema_name_id: 251
start_time: 2026-04-13 03:43:49
success: True
trace_id: 7677768207654712813

Scan 161893618

duration: 0:00:11.656399

exit_message:

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

id: 161893618

payload:

{
    "datatype_dict": {
        "day_key": "int",
        "origin_key": "varchar",
        "page_view_key": "bigint",
        "visitor_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/helper_landing_page/2026-04-12/1775983282/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/helper_landing_page/2026-04-12/1775983282",
        "key": "raw/helper_landing_page/2026-04-12/1775983282/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_helper_landing_page",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 6647929209132611156,
        "service_name": "redshift_unloads",
        "span_id": 1852084574734358249,
        "trace_id": 10938870554301241018
    }
}

running: False
schema_name_id: 251
start_time: 2026-04-12 03:46:16
success: True
trace_id: 10938870554301241018

Scan 161842565

duration: 0:00:14.462724

exit_message:

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

id: 161842565

payload:

{
    "datatype_dict": {
        "day_key": "int",
        "origin_key": "varchar",
        "page_view_key": "bigint",
        "visitor_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/helper_landing_page/2026-04-11/1775897758/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/helper_landing_page/2026-04-11/1775897758",
        "key": "raw/helper_landing_page/2026-04-11/1775897758/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_helper_landing_page",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 14556198262450039244,
        "service_name": "redshift_unloads",
        "span_id": 18011098650969812952,
        "trace_id": 2392760043662085689
    }
}

running: False
schema_name_id: 251
start_time: 2026-04-11 04:01:01
success: True
trace_id: 2392760043662085689

Scan 161787346

duration: 0:00:14.363122

exit_message:

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

id: 161787346

payload:

{
    "datatype_dict": {
        "day_key": "int",
        "origin_key": "varchar",
        "page_view_key": "bigint",
        "visitor_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/helper_landing_page/2026-04-10/1775811423/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/helper_landing_page/2026-04-10/1775811423",
        "key": "raw/helper_landing_page/2026-04-10/1775811423/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_helper_landing_page",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 1626785371607975101,
        "service_name": "redshift_unloads",
        "span_id": 3646201752115880254,
        "trace_id": 12433919129908843052
    }
}

running: False
schema_name_id: 251
start_time: 2026-04-10 04:02:15
success: True
trace_id: 12433919129908843052

Scan 161730643

duration: 0:00:11.645169

exit_message:

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

id: 161730643

payload:

{
    "datatype_dict": {
        "day_key": "int",
        "origin_key": "varchar",
        "page_view_key": "bigint",
        "visitor_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/helper_landing_page/2026-04-09/1775723407/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/helper_landing_page/2026-04-09/1775723407",
        "key": "raw/helper_landing_page/2026-04-09/1775723407/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_helper_landing_page",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 10632741442682500724,
        "service_name": "redshift_unloads",
        "span_id": 2665910034228367708,
        "trace_id": 12719350828134274957
    }
}

running: False
schema_name_id: 251
start_time: 2026-04-09 03:34:10
success: True
trace_id: 12719350828134274957

Scan 161676975

duration: 0:00:14.109010

exit_message:

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

id: 161676975

payload:

{
    "datatype_dict": {
        "day_key": "int",
        "origin_key": "varchar",
        "page_view_key": "bigint",
        "visitor_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/helper_landing_page/2026-04-08/1775638562/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/helper_landing_page/2026-04-08/1775638562",
        "key": "raw/helper_landing_page/2026-04-08/1775638562/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_helper_landing_page",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 10404262450504708728,
        "service_name": "redshift_unloads",
        "span_id": 8610949462648345899,
        "trace_id": 12795804004677177218
    }
}

running: False
schema_name_id: 251
start_time: 2026-04-08 04:02:49
success: True
trace_id: 12795804004677177218

Scan 161619747

duration: 0:00:14.273389

exit_message:

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

id: 161619747

payload:

{
    "datatype_dict": {
        "day_key": "int",
        "origin_key": "varchar",
        "page_view_key": "bigint",
        "visitor_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/helper_landing_page/2026-04-07/1775551225/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/helper_landing_page/2026-04-07/1775551225",
        "key": "raw/helper_landing_page/2026-04-07/1775551225/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_helper_landing_page",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15902304293978270356,
        "service_name": "redshift_unloads",
        "span_id": 1650978490435861915,
        "trace_id": 5753255373120654233
    }
}

running: False
schema_name_id: 251
start_time: 2026-04-07 03:45:20
success: True
trace_id: 5753255373120654233

Scan 161562953

duration: 0:00:11.597330

exit_message:

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

id: 161562953

payload:

{
    "datatype_dict": {
        "day_key": "int",
        "origin_key": "varchar",
        "page_view_key": "bigint",
        "visitor_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/helper_landing_page/2026-04-06/1775466148/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/helper_landing_page/2026-04-06/1775466148",
        "key": "raw/helper_landing_page/2026-04-06/1775466148/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_helper_landing_page",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 5891927555016577269,
        "service_name": "redshift_unloads",
        "span_id": 10808002660964330762,
        "trace_id": 7823161161639163948
    }
}

running: False
schema_name_id: 251
start_time: 2026-04-06 04:07:10
success: True
trace_id: 7823161161639163948

Scan 161515138

duration: 0:00:11.614104

exit_message:

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

id: 161515138

payload:

{
    "datatype_dict": {
        "day_key": "int",
        "origin_key": "varchar",
        "page_view_key": "bigint",
        "visitor_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/helper_landing_page/2026-04-05/1775378583/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/helper_landing_page/2026-04-05/1775378583",
        "key": "raw/helper_landing_page/2026-04-05/1775378583/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_helper_landing_page",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 10410860481373189424,
        "service_name": "redshift_unloads",
        "span_id": 14563583271930672581,
        "trace_id": 1553860954743539367
    }
}

running: False
schema_name_id: 251
start_time: 2026-04-05 03:48:05
success: True
trace_id: 1553860954743539367

Scan 161460740

duration: 0:00:11.861099

exit_message:

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

id: 161460740

payload:

{
    "datatype_dict": {
        "day_key": "int",
        "origin_key": "varchar",
        "page_view_key": "bigint",
        "visitor_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/helper_landing_page/2026-04-04/1775292099/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/helper_landing_page/2026-04-04/1775292099",
        "key": "raw/helper_landing_page/2026-04-04/1775292099/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_helper_landing_page",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 2029234560817974198,
        "service_name": "redshift_unloads",
        "span_id": 1624281616508297794,
        "trace_id": 124443508165035283
    }
}

running: False
schema_name_id: 251
start_time: 2026-04-04 03:46:16
success: True
trace_id: 124443508165035283

Scan 161402180

duration: 0:00:14.204751

exit_message:

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

id: 161402180

payload:

{
    "datatype_dict": {
        "day_key": "int",
        "origin_key": "varchar",
        "page_view_key": "bigint",
        "visitor_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/helper_landing_page/2026-04-03/1775205295/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/helper_landing_page/2026-04-03/1775205295",
        "key": "raw/helper_landing_page/2026-04-03/1775205295/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_helper_landing_page",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 12665220474522124303,
        "service_name": "redshift_unloads",
        "span_id": 13734521619946201155,
        "trace_id": 6077000771228879613
    }
}

running: False
schema_name_id: 251
start_time: 2026-04-03 03:38:36
success: True
trace_id: 6077000771228879613

Partitions:

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

Schema:

attributes:

{
    "_origin": "string",
    "day_key": "int",
    "page_view_key": "bigint",
    "visitor_key": "bigint"
}

created: 2026-04-17 03:35:10

ddl:

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

Server:

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

Raw:

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