Schema Info

Schema Name: sfdl_stage_redshift.analytics_dwh_dim_site_content

created: 2018-02-20 23:56:41
disabled: False
format: raw
id: 381
is_partitioned: False
is_schema_datatyped: True

name:

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

type: redshift

Schema Versions: 15

Version 906651

created: 2026-04-17 03:50:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_site_content`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_site_content`\n(\n `audit_id`  bigint , `site_content_key`  int , `content_template_key`  int , `location_id`  int , `site_key`  int , `uri`  varchar(128) , `title`  varchar(255) , `publish`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_site_content/2026-04-17/1776415809'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_site_content"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_site_content/2026-04-17/1776415809
id: 906651
processed: 1

raw_data:

{
    "_origin": "8",
    "audit_id": "0",
    "content_template_key": "2",
    "location_id": "3",
    "publish": "7",
    "site_content_key": "1",
    "site_key": "4",
    "title": "6",
    "uri": "5"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "content_template_key": "int",
    "location_id": "int",
    "publish": "int",
    "site_content_key": "int",
    "site_key": "int",
    "title": "varchar(255)",
    "uri": "varchar(128)"
}

schema_name_id: 381
schema_scan_id: 6415231
updated: 2026-04-17 03:50:37

Version 906424

created: 2026-04-16 04:00:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_site_content`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_site_content`\n(\n `audit_id`  bigint , `site_content_key`  int , `content_template_key`  int , `location_id`  int , `site_key`  int , `uri`  varchar(128) , `title`  varchar(255) , `publish`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_site_content/2026-04-16/1776330029'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_site_content"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_site_content/2026-04-16/1776330029
id: 906424
processed: 1

raw_data:

{
    "_origin": "8",
    "audit_id": "0",
    "content_template_key": "2",
    "location_id": "3",
    "publish": "7",
    "site_content_key": "1",
    "site_key": "4",
    "title": "6",
    "uri": "5"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "content_template_key": "int",
    "location_id": "int",
    "publish": "int",
    "site_content_key": "int",
    "site_key": "int",
    "title": "varchar(255)",
    "uri": "varchar(128)"
}

schema_name_id: 381
schema_scan_id: 6414674
updated: 2026-04-16 04:01:02

Version 906214

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_site_content`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_site_content`\n(\n `audit_id`  bigint , `site_content_key`  int , `content_template_key`  int , `location_id`  int , `site_key`  int , `uri`  varchar(128) , `title`  varchar(255) , `publish`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_site_content/2026-04-15/1776243173'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_site_content"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_site_content/2026-04-15/1776243173
id: 906214
processed: 1

raw_data:

{
    "_origin": "8",
    "audit_id": "0",
    "content_template_key": "2",
    "location_id": "3",
    "publish": "7",
    "site_content_key": "1",
    "site_key": "4",
    "title": "6",
    "uri": "5"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "content_template_key": "int",
    "location_id": "int",
    "publish": "int",
    "site_content_key": "int",
    "site_key": "int",
    "title": "varchar(255)",
    "uri": "varchar(128)"
}

schema_name_id: 381
schema_scan_id: 6414190
updated: 2026-04-15 03:53:26

Version 906003

created: 2026-04-14 03:55:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_site_content`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_site_content`\n(\n `audit_id`  bigint , `site_content_key`  int , `content_template_key`  int , `location_id`  int , `site_key`  int , `uri`  varchar(128) , `title`  varchar(255) , `publish`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_site_content/2026-04-14/1776156916'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_site_content"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_site_content/2026-04-14/1776156916
id: 906003
processed: 1

raw_data:

{
    "_origin": "8",
    "audit_id": "0",
    "content_template_key": "2",
    "location_id": "3",
    "publish": "7",
    "site_content_key": "1",
    "site_key": "4",
    "title": "6",
    "uri": "5"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "content_template_key": "int",
    "location_id": "int",
    "publish": "int",
    "site_content_key": "int",
    "site_key": "int",
    "title": "varchar(255)",
    "uri": "varchar(128)"
}

schema_name_id: 381
schema_scan_id: 6413689
updated: 2026-04-14 03:55:48

Version 905781

created: 2026-04-13 03:35:00

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_site_content`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_site_content`\n(\n `audit_id`  bigint , `site_content_key`  int , `content_template_key`  int , `location_id`  int , `site_key`  int , `uri`  varchar(128) , `title`  varchar(255) , `publish`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_site_content/2026-04-13/1776069279'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_site_content"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_site_content/2026-04-13/1776069279
id: 905781
processed: 1

raw_data:

{
    "_origin": "8",
    "audit_id": "0",
    "content_template_key": "2",
    "location_id": "3",
    "publish": "7",
    "site_content_key": "1",
    "site_key": "4",
    "title": "6",
    "uri": "5"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "content_template_key": "int",
    "location_id": "int",
    "publish": "int",
    "site_content_key": "int",
    "site_key": "int",
    "title": "varchar(255)",
    "uri": "varchar(128)"
}

schema_name_id: 381
schema_scan_id: 6413137
updated: 2026-04-13 03:35:14

Version 905557

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_site_content`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_site_content`\n(\n `audit_id`  bigint , `site_content_key`  int , `content_template_key`  int , `location_id`  int , `site_key`  int , `uri`  varchar(128) , `title`  varchar(255) , `publish`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_site_content/2026-04-12/1775983045'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_site_content"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_site_content/2026-04-12/1775983045
id: 905557
processed: 1

raw_data:

{
    "_origin": "8",
    "audit_id": "0",
    "content_template_key": "2",
    "location_id": "3",
    "publish": "7",
    "site_content_key": "1",
    "site_key": "4",
    "title": "6",
    "uri": "5"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "content_template_key": "int",
    "location_id": "int",
    "publish": "int",
    "site_content_key": "int",
    "site_key": "int",
    "title": "varchar(255)",
    "uri": "varchar(128)"
}

schema_name_id: 381
schema_scan_id: 6412720
updated: 2026-04-12 03:37:59

Version 905368

created: 2026-04-11 03:32:06

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_site_content`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_site_content`\n(\n `audit_id`  bigint , `site_content_key`  int , `content_template_key`  int , `location_id`  int , `site_key`  int , `uri`  varchar(128) , `title`  varchar(255) , `publish`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_site_content/2026-04-11/1775896308'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_site_content"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_site_content/2026-04-11/1775896308
id: 905368
processed: 1

raw_data:

{
    "_origin": "8",
    "audit_id": "0",
    "content_template_key": "2",
    "location_id": "3",
    "publish": "7",
    "site_content_key": "1",
    "site_key": "4",
    "title": "6",
    "uri": "5"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "content_template_key": "int",
    "location_id": "int",
    "publish": "int",
    "site_content_key": "int",
    "site_key": "int",
    "title": "varchar(255)",
    "uri": "varchar(128)"
}

schema_name_id: 381
schema_scan_id: 6412353
updated: 2026-04-11 03:32:20

Version 905143

created: 2026-04-10 03:24:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_site_content`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_site_content`\n(\n `audit_id`  bigint , `site_content_key`  int , `content_template_key`  int , `location_id`  int , `site_key`  int , `uri`  varchar(128) , `title`  varchar(255) , `publish`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_site_content/2026-04-10/1775809452'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_site_content"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_site_content/2026-04-10/1775809452
id: 905143
processed: 1

raw_data:

{
    "_origin": "8",
    "audit_id": "0",
    "content_template_key": "2",
    "location_id": "3",
    "publish": "7",
    "site_content_key": "1",
    "site_key": "4",
    "title": "6",
    "uri": "5"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "content_template_key": "int",
    "location_id": "int",
    "publish": "int",
    "site_content_key": "int",
    "site_key": "int",
    "title": "varchar(255)",
    "uri": "varchar(128)"
}

schema_name_id: 381
schema_scan_id: 6411847
updated: 2026-04-10 03:24:43

Version 904951

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_site_content`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_site_content`\n(\n `audit_id`  bigint , `site_content_key`  int , `content_template_key`  int , `location_id`  int , `site_key`  int , `uri`  varchar(128) , `title`  varchar(255) , `publish`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_site_content/2026-04-09/1775725183'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_site_content"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_site_content/2026-04-09/1775725183
id: 904951
processed: 1

raw_data:

{
    "_origin": "8",
    "audit_id": "0",
    "content_template_key": "2",
    "location_id": "3",
    "publish": "7",
    "site_content_key": "1",
    "site_key": "4",
    "title": "6",
    "uri": "5"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "content_template_key": "int",
    "location_id": "int",
    "publish": "int",
    "site_content_key": "int",
    "site_key": "int",
    "title": "varchar(255)",
    "uri": "varchar(128)"
}

schema_name_id: 381
schema_scan_id: 6411353
updated: 2026-04-09 04:00:30

Version 904738

created: 2026-04-08 03:57:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_site_content`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_site_content`\n(\n `audit_id`  bigint , `site_content_key`  int , `content_template_key`  int , `location_id`  int , `site_key`  int , `uri`  varchar(128) , `title`  varchar(255) , `publish`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_site_content/2026-04-08/1775638621'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_site_content"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_site_content/2026-04-08/1775638621
id: 904738
processed: 1

raw_data:

{
    "_origin": "8",
    "audit_id": "0",
    "content_template_key": "2",
    "location_id": "3",
    "publish": "7",
    "site_content_key": "1",
    "site_key": "4",
    "title": "6",
    "uri": "5"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "content_template_key": "int",
    "location_id": "int",
    "publish": "int",
    "site_content_key": "int",
    "site_key": "int",
    "title": "varchar(255)",
    "uri": "varchar(128)"
}

schema_name_id: 381
schema_scan_id: 6410861
updated: 2026-04-08 03:57:44

Version 904524

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_site_content`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_site_content`\n(\n `audit_id`  bigint , `site_content_key`  int , `content_template_key`  int , `location_id`  int , `site_key`  int , `uri`  varchar(128) , `title`  varchar(255) , `publish`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_site_content/2026-04-07/1775551655'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_site_content"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_site_content/2026-04-07/1775551655
id: 904524
processed: 1

raw_data:

{
    "_origin": "8",
    "audit_id": "0",
    "content_template_key": "2",
    "location_id": "3",
    "publish": "7",
    "site_content_key": "1",
    "site_key": "4",
    "title": "6",
    "uri": "5"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "content_template_key": "int",
    "location_id": "int",
    "publish": "int",
    "site_content_key": "int",
    "site_key": "int",
    "title": "varchar(255)",
    "uri": "varchar(128)"
}

schema_name_id: 381
schema_scan_id: 6410350
updated: 2026-04-07 03:48:07

Version 904308

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_site_content`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_site_content`\n(\n `audit_id`  bigint , `site_content_key`  int , `content_template_key`  int , `location_id`  int , `site_key`  int , `uri`  varchar(128) , `title`  varchar(255) , `publish`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_site_content/2026-04-06/1775465769'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_site_content"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_site_content/2026-04-06/1775465769
id: 904308
processed: 1

raw_data:

{
    "_origin": "8",
    "audit_id": "0",
    "content_template_key": "2",
    "location_id": "3",
    "publish": "7",
    "site_content_key": "1",
    "site_key": "4",
    "title": "6",
    "uri": "5"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "content_template_key": "int",
    "location_id": "int",
    "publish": "int",
    "site_content_key": "int",
    "site_key": "int",
    "title": "varchar(255)",
    "uri": "varchar(128)"
}

schema_name_id: 381
schema_scan_id: 6409802
updated: 2026-04-06 03:56:36

Version 904113

created: 2026-04-05 04:04:45

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_site_content`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_site_content`\n(\n `audit_id`  bigint , `site_content_key`  int , `content_template_key`  int , `location_id`  int , `site_key`  int , `uri`  varchar(128) , `title`  varchar(255) , `publish`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_site_content/2026-04-05/1775379864'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_site_content"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_site_content/2026-04-05/1775379864
id: 904113
processed: 1

raw_data:

{
    "_origin": "8",
    "audit_id": "0",
    "content_template_key": "2",
    "location_id": "3",
    "publish": "7",
    "site_content_key": "1",
    "site_key": "4",
    "title": "6",
    "uri": "5"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "content_template_key": "int",
    "location_id": "int",
    "publish": "int",
    "site_content_key": "int",
    "site_key": "int",
    "title": "varchar(255)",
    "uri": "varchar(128)"
}

schema_name_id: 381
schema_scan_id: 6409421
updated: 2026-04-05 04:04:59

Version 903902

created: 2026-04-04 03:39:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_site_content`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_site_content`\n(\n `audit_id`  bigint , `site_content_key`  int , `content_template_key`  int , `location_id`  int , `site_key`  int , `uri`  varchar(128) , `title`  varchar(255) , `publish`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_site_content/2026-04-04/1775291956'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_site_content"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_site_content/2026-04-04/1775291956
id: 903902
processed: 1

raw_data:

{
    "_origin": "8",
    "audit_id": "0",
    "content_template_key": "2",
    "location_id": "3",
    "publish": "7",
    "site_content_key": "1",
    "site_key": "4",
    "title": "6",
    "uri": "5"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "content_template_key": "int",
    "location_id": "int",
    "publish": "int",
    "site_content_key": "int",
    "site_key": "int",
    "title": "varchar(255)",
    "uri": "varchar(128)"
}

schema_name_id: 381
schema_scan_id: 6409031
updated: 2026-04-04 03:39:44

Version 903688

created: 2026-04-03 03:50:38

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_site_content`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_site_content`\n(\n `audit_id`  bigint , `site_content_key`  int , `content_template_key`  int , `location_id`  int , `site_key`  int , `uri`  varchar(128) , `title`  varchar(255) , `publish`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_site_content/2026-04-03/1775206219'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_site_content"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_site_content/2026-04-03/1775206219
id: 903688
processed: 1

raw_data:

{
    "_origin": "8",
    "audit_id": "0",
    "content_template_key": "2",
    "location_id": "3",
    "publish": "7",
    "site_content_key": "1",
    "site_key": "4",
    "title": "6",
    "uri": "5"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "content_template_key": "int",
    "location_id": "int",
    "publish": "int",
    "site_content_key": "int",
    "site_key": "int",
    "title": "varchar(255)",
    "uri": "varchar(128)"
}

schema_name_id: 381
schema_scan_id: 6408542
updated: 2026-04-03 03:50:52

Schema Scans: 15

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

Scan 6415231

duration: 0:00:11.919780

exit_message:

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

id: 6415231

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "content_template_key": "int",
        "location_id": "int",
        "origin_key": "varchar",
        "publish": "int",
        "site_content_key": "int",
        "site_key": "int",
        "title": "varchar(255)",
        "uri": "varchar(128)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_site_content/2026-04-17/1776415809/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_site_content/2026-04-17/1776415809",
        "key": "raw/dwh_dim_site_content/2026-04-17/1776415809/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_site_content",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3309194144997787692,
        "service_name": "redshift_unloads",
        "span_id": 11247478648895418002,
        "trace_id": 13309333097044804879
    }
}

running: False
schema_name_id: 381
start_time: 2026-04-17 03:50:25
success: True
trace_id: 13309333097044804879

Scan 6414674

duration: 0:00:11.894535

exit_message:

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

id: 6414674

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "content_template_key": "int",
        "location_id": "int",
        "origin_key": "varchar",
        "publish": "int",
        "site_content_key": "int",
        "site_key": "int",
        "title": "varchar(255)",
        "uri": "varchar(128)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_site_content/2026-04-16/1776330029/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_site_content/2026-04-16/1776330029",
        "key": "raw/dwh_dim_site_content/2026-04-16/1776330029/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_site_content",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13557908950777617798,
        "service_name": "redshift_unloads",
        "span_id": 476219576083176268,
        "trace_id": 11661799351698467309
    }
}

running: False
schema_name_id: 381
start_time: 2026-04-16 04:00:50
success: True
trace_id: 11661799351698467309

Scan 6414190

duration: 0:00:14.251501

exit_message:

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

id: 6414190

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "content_template_key": "int",
        "location_id": "int",
        "origin_key": "varchar",
        "publish": "int",
        "site_content_key": "int",
        "site_key": "int",
        "title": "varchar(255)",
        "uri": "varchar(128)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_site_content/2026-04-15/1776243173/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_site_content/2026-04-15/1776243173",
        "key": "raw/dwh_dim_site_content/2026-04-15/1776243173/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_site_content",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 6536145970456781527,
        "service_name": "redshift_unloads",
        "span_id": 9657759585641369405,
        "trace_id": 8107214150988422972
    }
}

running: False
schema_name_id: 381
start_time: 2026-04-15 03:53:12
success: True
trace_id: 8107214150988422972

Scan 6413689

duration: 0:00:14.309327

exit_message:

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

id: 6413689

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "content_template_key": "int",
        "location_id": "int",
        "origin_key": "varchar",
        "publish": "int",
        "site_content_key": "int",
        "site_key": "int",
        "title": "varchar(255)",
        "uri": "varchar(128)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_site_content/2026-04-14/1776156916/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_site_content/2026-04-14/1776156916",
        "key": "raw/dwh_dim_site_content/2026-04-14/1776156916/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_site_content",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 10192441804095838629,
        "service_name": "redshift_unloads",
        "span_id": 254283843734251975,
        "trace_id": 8298938599353013125
    }
}

running: False
schema_name_id: 381
start_time: 2026-04-14 03:55:34
success: True
trace_id: 8298938599353013125

Scan 6413137

duration: 0:00:14.446540

exit_message:

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

id: 6413137

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "content_template_key": "int",
        "location_id": "int",
        "origin_key": "varchar",
        "publish": "int",
        "site_content_key": "int",
        "site_key": "int",
        "title": "varchar(255)",
        "uri": "varchar(128)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_site_content/2026-04-13/1776069279/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_site_content/2026-04-13/1776069279",
        "key": "raw/dwh_dim_site_content/2026-04-13/1776069279/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_site_content",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 7991555850417250530,
        "service_name": "redshift_unloads",
        "span_id": 940232192831916559,
        "trace_id": 16638170962097332738
    }
}

running: False
schema_name_id: 381
start_time: 2026-04-13 03:35:00
success: True
trace_id: 16638170962097332738

Scan 6412720

duration: 0:00:14.303527

exit_message:

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

id: 6412720

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "content_template_key": "int",
        "location_id": "int",
        "origin_key": "varchar",
        "publish": "int",
        "site_content_key": "int",
        "site_key": "int",
        "title": "varchar(255)",
        "uri": "varchar(128)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_site_content/2026-04-12/1775983045/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_site_content/2026-04-12/1775983045",
        "key": "raw/dwh_dim_site_content/2026-04-12/1775983045/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_site_content",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 10794231675076986574,
        "service_name": "redshift_unloads",
        "span_id": 4289632444795242787,
        "trace_id": 5021566092152154771
    }
}

running: False
schema_name_id: 381
start_time: 2026-04-12 03:37:45
success: True
trace_id: 5021566092152154771

Scan 6412353

duration: 0:00:14.414127

exit_message:

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

id: 6412353

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "content_template_key": "int",
        "location_id": "int",
        "origin_key": "varchar",
        "publish": "int",
        "site_content_key": "int",
        "site_key": "int",
        "title": "varchar(255)",
        "uri": "varchar(128)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_site_content/2026-04-11/1775896308/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_site_content/2026-04-11/1775896308",
        "key": "raw/dwh_dim_site_content/2026-04-11/1775896308/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_site_content",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 2555335284807786699,
        "service_name": "redshift_unloads",
        "span_id": 5291192305172843993,
        "trace_id": 1835933543350263201
    }
}

running: False
schema_name_id: 381
start_time: 2026-04-11 03:32:06
success: True
trace_id: 1835933543350263201

Scan 6411847

duration: 0:00:11.763979

exit_message:

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

id: 6411847

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "content_template_key": "int",
        "location_id": "int",
        "origin_key": "varchar",
        "publish": "int",
        "site_content_key": "int",
        "site_key": "int",
        "title": "varchar(255)",
        "uri": "varchar(128)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_site_content/2026-04-10/1775809452/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_site_content/2026-04-10/1775809452",
        "key": "raw/dwh_dim_site_content/2026-04-10/1775809452/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_site_content",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13330626450976747655,
        "service_name": "redshift_unloads",
        "span_id": 1727545729730169174,
        "trace_id": 1955264590054487682
    }
}

running: False
schema_name_id: 381
start_time: 2026-04-10 03:24:31
success: True
trace_id: 1955264590054487682

Scan 6411353

duration: 0:00:11.890002

exit_message:

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

id: 6411353

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "content_template_key": "int",
        "location_id": "int",
        "origin_key": "varchar",
        "publish": "int",
        "site_content_key": "int",
        "site_key": "int",
        "title": "varchar(255)",
        "uri": "varchar(128)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_site_content/2026-04-09/1775725183/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_site_content/2026-04-09/1775725183",
        "key": "raw/dwh_dim_site_content/2026-04-09/1775725183/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_site_content",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3479082910757096617,
        "service_name": "redshift_unloads",
        "span_id": 1306597451706868475,
        "trace_id": 8964945005419564694
    }
}

running: False
schema_name_id: 381
start_time: 2026-04-09 04:00:18
success: True
trace_id: 8964945005419564694

Scan 6410861

duration: 0:00:11.708319

exit_message:

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

id: 6410861

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "content_template_key": "int",
        "location_id": "int",
        "origin_key": "varchar",
        "publish": "int",
        "site_content_key": "int",
        "site_key": "int",
        "title": "varchar(255)",
        "uri": "varchar(128)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_site_content/2026-04-08/1775638621/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_site_content/2026-04-08/1775638621",
        "key": "raw/dwh_dim_site_content/2026-04-08/1775638621/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_site_content",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 4807162049584666006,
        "service_name": "redshift_unloads",
        "span_id": 17359188367095030026,
        "trace_id": 2906279207419489946
    }
}

running: False
schema_name_id: 381
start_time: 2026-04-08 03:57:32
success: True
trace_id: 2906279207419489946

Scan 6410350

duration: 0:00:14.324721

exit_message:

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

id: 6410350

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "content_template_key": "int",
        "location_id": "int",
        "origin_key": "varchar",
        "publish": "int",
        "site_content_key": "int",
        "site_key": "int",
        "title": "varchar(255)",
        "uri": "varchar(128)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_site_content/2026-04-07/1775551655/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_site_content/2026-04-07/1775551655",
        "key": "raw/dwh_dim_site_content/2026-04-07/1775551655/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_site_content",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 9980546938600050174,
        "service_name": "redshift_unloads",
        "span_id": 15859997311071956035,
        "trace_id": 1403747379351221358
    }
}

running: False
schema_name_id: 381
start_time: 2026-04-07 03:47:52
success: True
trace_id: 1403747379351221358

Scan 6409802

duration: 0:00:11.803162

exit_message:

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

id: 6409802

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "content_template_key": "int",
        "location_id": "int",
        "origin_key": "varchar",
        "publish": "int",
        "site_content_key": "int",
        "site_key": "int",
        "title": "varchar(255)",
        "uri": "varchar(128)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_site_content/2026-04-06/1775465769/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_site_content/2026-04-06/1775465769",
        "key": "raw/dwh_dim_site_content/2026-04-06/1775465769/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_site_content",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 14824620040936133218,
        "service_name": "redshift_unloads",
        "span_id": 2358420025160860238,
        "trace_id": 6810923728737807603
    }
}

running: False
schema_name_id: 381
start_time: 2026-04-06 03:56:24
success: True
trace_id: 6810923728737807603

Scan 6409421

duration: 0:00:14.417977

exit_message:

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

id: 6409421

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "content_template_key": "int",
        "location_id": "int",
        "origin_key": "varchar",
        "publish": "int",
        "site_content_key": "int",
        "site_key": "int",
        "title": "varchar(255)",
        "uri": "varchar(128)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_site_content/2026-04-05/1775379864/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_site_content/2026-04-05/1775379864",
        "key": "raw/dwh_dim_site_content/2026-04-05/1775379864/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_site_content",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15720123660358672351,
        "service_name": "redshift_unloads",
        "span_id": 12300075192392276758,
        "trace_id": 661649925184192407
    }
}

running: False
schema_name_id: 381
start_time: 2026-04-05 04:04:44
success: True
trace_id: 661649925184192407

Scan 6409031

duration: 0:00:11.916446

exit_message:

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

id: 6409031

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "content_template_key": "int",
        "location_id": "int",
        "origin_key": "varchar",
        "publish": "int",
        "site_content_key": "int",
        "site_key": "int",
        "title": "varchar(255)",
        "uri": "varchar(128)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_site_content/2026-04-04/1775291956/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_site_content/2026-04-04/1775291956",
        "key": "raw/dwh_dim_site_content/2026-04-04/1775291956/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_site_content",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 7272309773383891380,
        "service_name": "redshift_unloads",
        "span_id": 11592007022411302,
        "trace_id": 2925808263592379991
    }
}

running: False
schema_name_id: 381
start_time: 2026-04-04 03:39:32
success: True
trace_id: 2925808263592379991

Scan 6408542

duration: 0:00:14.302697

exit_message:

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

id: 6408542

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "content_template_key": "int",
        "location_id": "int",
        "origin_key": "varchar",
        "publish": "int",
        "site_content_key": "int",
        "site_key": "int",
        "title": "varchar(255)",
        "uri": "varchar(128)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_site_content/2026-04-03/1775206219/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_site_content/2026-04-03/1775206219",
        "key": "raw/dwh_dim_site_content/2026-04-03/1775206219/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_site_content",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 16885984134129613320,
        "service_name": "redshift_unloads",
        "span_id": 12324709912124051565,
        "trace_id": 329247079888937673
    }
}

running: False
schema_name_id: 381
start_time: 2026-04-03 03:50:38
success: True
trace_id: 329247079888937673

Partitions:

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

Schema:

attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "content_template_key": "int",
    "location_id": "int",
    "publish": "int",
    "site_content_key": "int",
    "site_key": "int",
    "title": "varchar(255)",
    "uri": "varchar(128)"
}

created: 2026-04-17 03:50:25

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_site_content`\n(\n `audit_id`  bigint , `site_content_key`  int , `content_template_key`  int , `location_id`  int , `site_key`  int , `uri`  varchar(128) , `title`  varchar(255) , `publish`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_site_content/2026-04-17/1776415809'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_site_content`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_site_content"
}

Server:

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

Raw:

{
    "name": {
        "created": "2018-02-20 23:56:41",
        "disabled": false,
        "format": "raw",
        "id": 381,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_redshift",
            "table": "analytics_dwh_dim_site_content"
        },
        "type": "redshift"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "_origin": "string",
            "audit_id": "bigint",
            "content_template_key": "int",
            "location_id": "int",
            "publish": "int",
            "site_content_key": "int",
            "site_key": "int",
            "title": "varchar(255)",
            "uri": "varchar(128)"
        },
        "created": "2026-04-17 03:50:25",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_site_content`\n(\n `audit_id`  bigint , `site_content_key`  int , `content_template_key`  int , `location_id`  int , `site_key`  int , `uri`  varchar(128) , `title`  varchar(255) , `publish`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_dim_site_content/2026-04-17/1776415809'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_site_content`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_site_content"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}