Schema Info

Schema Name: sfdl_prod_redshift.analytics_dwh_dim_content_template

created: 2018-02-28 10:54:59
disabled: False
format: raw
id: 266
is_partitioned: False
is_schema_datatyped: True

name:

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

type: redshift

Schema Versions: 15

Version 1717863

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_content_template`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_content_template`\n(\n `audit_id`  bigint , `content_template_key`  int , `template`  varchar(64) , `label`  varchar(64) , `_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/dwh_dim_content_template/2026-04-17/1776413972'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_content_template"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_content_template/2026-04-17/1776413972
id: 1717863
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "content_template_key": "1",
    "label": "3",
    "template": "2"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "content_template_key": "int",
    "label": "varchar(64)",
    "template": "varchar(64)"
}

schema_name_id: 266
schema_scan_id: 162167909
updated: 2026-04-17 03:20:08

Version 1716637

created: 2026-04-16 03:59:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_content_template`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_content_template`\n(\n `audit_id`  bigint , `content_template_key`  int , `template`  varchar(64) , `label`  varchar(64) , `_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/dwh_dim_content_template/2026-04-16/1776329884'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_content_template"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_content_template/2026-04-16/1776329884
id: 1716637
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "content_template_key": "1",
    "label": "3",
    "template": "2"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "content_template_key": "int",
    "label": "varchar(64)",
    "template": "varchar(64)"
}

schema_name_id: 266
schema_scan_id: 162112924
updated: 2026-04-16 03:59:44

Version 1715432

created: 2026-04-15 03:34:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_content_template`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_content_template`\n(\n `audit_id`  bigint , `content_template_key`  int , `template`  varchar(64) , `label`  varchar(64) , `_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/dwh_dim_content_template/2026-04-15/1776242054'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_content_template"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_content_template/2026-04-15/1776242054
id: 1715432
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "content_template_key": "1",
    "label": "3",
    "template": "2"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "content_template_key": "int",
    "label": "varchar(64)",
    "template": "varchar(64)"
}

schema_name_id: 266
schema_scan_id: 162056285
updated: 2026-04-15 03:34:35

Version 1714287

created: 2026-04-14 04:03:30

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_content_template`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_content_template`\n(\n `audit_id`  bigint , `content_template_key`  int , `template`  varchar(64) , `label`  varchar(64) , `_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/dwh_dim_content_template/2026-04-14/1776157400'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_content_template"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_content_template/2026-04-14/1776157400
id: 1714287
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "content_template_key": "1",
    "label": "3",
    "template": "2"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "content_template_key": "int",
    "label": "varchar(64)",
    "template": "varchar(64)"
}

schema_name_id: 266
schema_scan_id: 162001926
updated: 2026-04-14 04:03:44

Version 1713030

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_content_template`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_content_template`\n(\n `audit_id`  bigint , `content_template_key`  int , `template`  varchar(64) , `label`  varchar(64) , `_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/dwh_dim_content_template/2026-04-13/1776070506'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_content_template"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_content_template/2026-04-13/1776070506
id: 1713030
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "content_template_key": "1",
    "label": "3",
    "template": "2"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "content_template_key": "int",
    "label": "varchar(64)",
    "template": "varchar(64)"
}

schema_name_id: 266
schema_scan_id: 161943133
updated: 2026-04-13 03:55:31

Version 1711828

created: 2026-04-12 03:50:30

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_content_template`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_content_template`\n(\n `audit_id`  bigint , `content_template_key`  int , `template`  varchar(64) , `label`  varchar(64) , `_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/dwh_dim_content_template/2026-04-12/1775983801'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_content_template"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_content_template/2026-04-12/1775983801
id: 1711828
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "content_template_key": "1",
    "label": "3",
    "template": "2"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "content_template_key": "int",
    "label": "varchar(64)",
    "template": "varchar(64)"
}

schema_name_id: 266
schema_scan_id: 161893650
updated: 2026-04-12 03:50:41

Version 1710609

created: 2026-04-11 03:40:38

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_content_template`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_content_template`\n(\n `audit_id`  bigint , `content_template_key`  int , `template`  varchar(64) , `label`  varchar(64) , `_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/dwh_dim_content_template/2026-04-11/1775896826'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_content_template"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_content_template/2026-04-11/1775896826
id: 1710609
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "content_template_key": "1",
    "label": "3",
    "template": "2"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "content_template_key": "int",
    "label": "varchar(64)",
    "template": "varchar(64)"
}

schema_name_id: 266
schema_scan_id: 161841444
updated: 2026-04-11 03:40:52

Version 1709454

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_content_template`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_content_template`\n(\n `audit_id`  bigint , `content_template_key`  int , `template`  varchar(64) , `label`  varchar(64) , `_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/dwh_dim_content_template/2026-04-10/1775811361'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_content_template"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_content_template/2026-04-10/1775811361
id: 1709454
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "content_template_key": "1",
    "label": "3",
    "template": "2"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "content_template_key": "int",
    "label": "varchar(64)",
    "template": "varchar(64)"
}

schema_name_id: 266
schema_scan_id: 161786519
updated: 2026-04-10 03:56:38

Version 1708323

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_content_template`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_content_template`\n(\n `audit_id`  bigint , `content_template_key`  int , `template`  varchar(64) , `label`  varchar(64) , `_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/dwh_dim_content_template/2026-04-09/1775723655'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_content_template"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_content_template/2026-04-09/1775723655
id: 1708323
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "content_template_key": "1",
    "label": "3",
    "template": "2"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "content_template_key": "int",
    "label": "varchar(64)",
    "template": "varchar(64)"
}

schema_name_id: 266
schema_scan_id: 161730644
updated: 2026-04-09 03:34:36

Version 1707109

created: 2026-04-08 03:35:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_content_template`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_content_template`\n(\n `audit_id`  bigint , `content_template_key`  int , `template`  varchar(64) , `label`  varchar(64) , `_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/dwh_dim_content_template/2026-04-08/1775637338'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_content_template"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_content_template/2026-04-08/1775637338
id: 1707109
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "content_template_key": "1",
    "label": "3",
    "template": "2"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "content_template_key": "int",
    "label": "varchar(64)",
    "template": "varchar(64)"
}

schema_name_id: 266
schema_scan_id: 161675818
updated: 2026-04-08 03:36:00

Version 1705944

created: 2026-04-07 03:51:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_content_template`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_content_template`\n(\n `audit_id`  bigint , `content_template_key`  int , `template`  varchar(64) , `label`  varchar(64) , `_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/dwh_dim_content_template/2026-04-07/1775551855'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_content_template"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_content_template/2026-04-07/1775551855
id: 1705944
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "content_template_key": "1",
    "label": "3",
    "template": "2"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "content_template_key": "int",
    "label": "varchar(64)",
    "template": "varchar(64)"
}

schema_name_id: 266
schema_scan_id: 161619824
updated: 2026-04-07 03:51:18

Version 1704711

created: 2026-04-06 03:58:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_content_template`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_content_template`\n(\n `audit_id`  bigint , `content_template_key`  int , `template`  varchar(64) , `label`  varchar(64) , `_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/dwh_dim_content_template/2026-04-06/1775465879'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_content_template"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_content_template/2026-04-06/1775465879
id: 1704711
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "content_template_key": "1",
    "label": "3",
    "template": "2"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "content_template_key": "int",
    "label": "varchar(64)",
    "template": "varchar(64)"
}

schema_name_id: 266
schema_scan_id: 161562569
updated: 2026-04-06 03:58:48

Version 1703510

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_content_template`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_content_template`\n(\n `audit_id`  bigint , `content_template_key`  int , `template`  varchar(64) , `label`  varchar(64) , `_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/dwh_dim_content_template/2026-04-05/1775379428'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_content_template"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_content_template/2026-04-05/1775379428
id: 1703510
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "content_template_key": "1",
    "label": "3",
    "template": "2"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "content_template_key": "int",
    "label": "varchar(64)",
    "template": "varchar(64)"
}

schema_name_id: 266
schema_scan_id: 161515805
updated: 2026-04-05 03:58:38

Version 1702331

created: 2026-04-04 03:34:38

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_content_template`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_content_template`\n(\n `audit_id`  bigint , `content_template_key`  int , `template`  varchar(64) , `label`  varchar(64) , `_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/dwh_dim_content_template/2026-04-04/1775291656'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_content_template"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_content_template/2026-04-04/1775291656
id: 1702331
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "content_template_key": "1",
    "label": "3",
    "template": "2"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "content_template_key": "int",
    "label": "varchar(64)",
    "template": "varchar(64)"
}

schema_name_id: 266
schema_scan_id: 161460702
updated: 2026-04-04 03:34:49

Version 1701160

created: 2026-04-03 03:51:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_content_template`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_content_template`\n(\n `audit_id`  bigint , `content_template_key`  int , `template`  varchar(64) , `label`  varchar(64) , `_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/dwh_dim_content_template/2026-04-03/1775206304'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_content_template"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_content_template/2026-04-03/1775206304
id: 1701160
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "content_template_key": "1",
    "label": "3",
    "template": "2"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "content_template_key": "int",
    "label": "varchar(64)",
    "template": "varchar(64)"
}

schema_name_id: 266
schema_scan_id: 161402351
updated: 2026-04-03 03:52:09

Schema Scans: 15

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

Scan 162167909

duration: 0:00:11.839502

exit_message:

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

id: 162167909

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "content_template_key": "int",
        "label": "varchar(64)",
        "origin_key": "varchar",
        "template": "varchar(64)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_content_template/2026-04-17/1776413972/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_content_template/2026-04-17/1776413972",
        "key": "raw/dwh_dim_content_template/2026-04-17/1776413972/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_content_template",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 1529791118337604406,
        "service_name": "redshift_unloads",
        "span_id": 8563872429333004414,
        "trace_id": 8314512710193188975
    }
}

running: False
schema_name_id: 266
start_time: 2026-04-17 03:19:57
success: True
trace_id: 8314512710193188975

Scan 162112924

duration: 0:00:11.694520

exit_message:

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

id: 162112924

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "content_template_key": "int",
        "label": "varchar(64)",
        "origin_key": "varchar",
        "template": "varchar(64)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_content_template/2026-04-16/1776329884/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_content_template/2026-04-16/1776329884",
        "key": "raw/dwh_dim_content_template/2026-04-16/1776329884/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_content_template",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 9834199314425568388,
        "service_name": "redshift_unloads",
        "span_id": 8472406836977773434,
        "trace_id": 9129030704563502062
    }
}

running: False
schema_name_id: 266
start_time: 2026-04-16 03:59:32
success: True
trace_id: 9129030704563502062

Scan 162056285

duration: 0:00:14.098248

exit_message:

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

id: 162056285

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "content_template_key": "int",
        "label": "varchar(64)",
        "origin_key": "varchar",
        "template": "varchar(64)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_content_template/2026-04-15/1776242054/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_content_template/2026-04-15/1776242054",
        "key": "raw/dwh_dim_content_template/2026-04-15/1776242054/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_content_template",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 357414064174563032,
        "service_name": "redshift_unloads",
        "span_id": 13867204802220291175,
        "trace_id": 8340432044753183993
    }
}

running: False
schema_name_id: 266
start_time: 2026-04-15 03:34:21
success: True
trace_id: 8340432044753183993

Scan 162001926

duration: 0:00:14.162690

exit_message:

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

id: 162001926

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "content_template_key": "int",
        "label": "varchar(64)",
        "origin_key": "varchar",
        "template": "varchar(64)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_content_template/2026-04-14/1776157400/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_content_template/2026-04-14/1776157400",
        "key": "raw/dwh_dim_content_template/2026-04-14/1776157400/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_content_template",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15836599222344883560,
        "service_name": "redshift_unloads",
        "span_id": 10154810781657528733,
        "trace_id": 996596888521344649
    }
}

running: False
schema_name_id: 266
start_time: 2026-04-14 04:03:30
success: True
trace_id: 996596888521344649

Scan 161943133

duration: 0:00:11.621096

exit_message:

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

id: 161943133

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "content_template_key": "int",
        "label": "varchar(64)",
        "origin_key": "varchar",
        "template": "varchar(64)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_content_template/2026-04-13/1776070506/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_content_template/2026-04-13/1776070506",
        "key": "raw/dwh_dim_content_template/2026-04-13/1776070506/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_content_template",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 1518489036420209158,
        "service_name": "redshift_unloads",
        "span_id": 9387709784276536569,
        "trace_id": 7765560009042385383
    }
}

running: False
schema_name_id: 266
start_time: 2026-04-13 03:55:19
success: True
trace_id: 7765560009042385383

Scan 161893650

duration: 0:00:11.631289

exit_message:

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

id: 161893650

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "content_template_key": "int",
        "label": "varchar(64)",
        "origin_key": "varchar",
        "template": "varchar(64)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_content_template/2026-04-12/1775983801/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_content_template/2026-04-12/1775983801",
        "key": "raw/dwh_dim_content_template/2026-04-12/1775983801/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_content_template",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 17775160288444968155,
        "service_name": "redshift_unloads",
        "span_id": 8913174234717646287,
        "trace_id": 15146735060111835890
    }
}

running: False
schema_name_id: 266
start_time: 2026-04-12 03:50:29
success: True
trace_id: 15146735060111835890

Scan 161841444

duration: 0:00:14.083494

exit_message:

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

id: 161841444

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "content_template_key": "int",
        "label": "varchar(64)",
        "origin_key": "varchar",
        "template": "varchar(64)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_content_template/2026-04-11/1775896826/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_content_template/2026-04-11/1775896826",
        "key": "raw/dwh_dim_content_template/2026-04-11/1775896826/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_content_template",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13267461528988410922,
        "service_name": "redshift_unloads",
        "span_id": 9698472769533510107,
        "trace_id": 2589462727855188361
    }
}

running: False
schema_name_id: 266
start_time: 2026-04-11 03:40:38
success: True
trace_id: 2589462727855188361

Scan 161786519

duration: 0:00:14.171920

exit_message:

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

id: 161786519

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "content_template_key": "int",
        "label": "varchar(64)",
        "origin_key": "varchar",
        "template": "varchar(64)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_content_template/2026-04-10/1775811361/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_content_template/2026-04-10/1775811361",
        "key": "raw/dwh_dim_content_template/2026-04-10/1775811361/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_content_template",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 16204647427012564424,
        "service_name": "redshift_unloads",
        "span_id": 1091813987061615484,
        "trace_id": 5286224539017966614
    }
}

running: False
schema_name_id: 266
start_time: 2026-04-10 03:56:24
success: True
trace_id: 5286224539017966614

Scan 161730644

duration: 0:00:14.142682

exit_message:

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

id: 161730644

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "content_template_key": "int",
        "label": "varchar(64)",
        "origin_key": "varchar",
        "template": "varchar(64)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_content_template/2026-04-09/1775723655/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_content_template/2026-04-09/1775723655",
        "key": "raw/dwh_dim_content_template/2026-04-09/1775723655/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_content_template",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3217676667353561155,
        "service_name": "redshift_unloads",
        "span_id": 16029421003553769001,
        "trace_id": 13756357245633813125
    }
}

running: False
schema_name_id: 266
start_time: 2026-04-09 03:34:22
success: True
trace_id: 13756357245633813125

Scan 161675818

duration: 0:00:14.101052

exit_message:

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

id: 161675818

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "content_template_key": "int",
        "label": "varchar(64)",
        "origin_key": "varchar",
        "template": "varchar(64)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_content_template/2026-04-08/1775637338/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_content_template/2026-04-08/1775637338",
        "key": "raw/dwh_dim_content_template/2026-04-08/1775637338/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_content_template",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15555242388070488676,
        "service_name": "redshift_unloads",
        "span_id": 9763465959880958093,
        "trace_id": 6805448967661627120
    }
}

running: False
schema_name_id: 266
start_time: 2026-04-08 03:35:46
success: True
trace_id: 6805448967661627120

Scan 161619824

duration: 0:00:14.181471

exit_message:

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

id: 161619824

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "content_template_key": "int",
        "label": "varchar(64)",
        "origin_key": "varchar",
        "template": "varchar(64)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_content_template/2026-04-07/1775551855/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_content_template/2026-04-07/1775551855",
        "key": "raw/dwh_dim_content_template/2026-04-07/1775551855/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_content_template",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3361778755066493942,
        "service_name": "redshift_unloads",
        "span_id": 3017208172051990857,
        "trace_id": 187372361396398191
    }
}

running: False
schema_name_id: 266
start_time: 2026-04-07 03:51:04
success: True
trace_id: 187372361396398191

Scan 161562569

duration: 0:00:14.183552

exit_message:

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

id: 161562569

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "content_template_key": "int",
        "label": "varchar(64)",
        "origin_key": "varchar",
        "template": "varchar(64)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_content_template/2026-04-06/1775465879/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_content_template/2026-04-06/1775465879",
        "key": "raw/dwh_dim_content_template/2026-04-06/1775465879/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_content_template",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 674323541005004140,
        "service_name": "redshift_unloads",
        "span_id": 3822387753392568773,
        "trace_id": 13823756006719744925
    }
}

running: False
schema_name_id: 266
start_time: 2026-04-06 03:58:34
success: True
trace_id: 13823756006719744925

Scan 161515805

duration: 0:00:11.708924

exit_message:

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

id: 161515805

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "content_template_key": "int",
        "label": "varchar(64)",
        "origin_key": "varchar",
        "template": "varchar(64)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_content_template/2026-04-05/1775379428/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_content_template/2026-04-05/1775379428",
        "key": "raw/dwh_dim_content_template/2026-04-05/1775379428/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_content_template",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 1158782580318596861,
        "service_name": "redshift_unloads",
        "span_id": 7718676102933465378,
        "trace_id": 7129988253411392040
    }
}

running: False
schema_name_id: 266
start_time: 2026-04-05 03:58:26
success: True
trace_id: 7129988253411392040

Scan 161460702

duration: 0:00:11.650914

exit_message:

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

id: 161460702

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "content_template_key": "int",
        "label": "varchar(64)",
        "origin_key": "varchar",
        "template": "varchar(64)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_content_template/2026-04-04/1775291656/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_content_template/2026-04-04/1775291656",
        "key": "raw/dwh_dim_content_template/2026-04-04/1775291656/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_content_template",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 11598224489339241472,
        "service_name": "redshift_unloads",
        "span_id": 6790885905387675657,
        "trace_id": 213147176377747899
    }
}

running: False
schema_name_id: 266
start_time: 2026-04-04 03:34:38
success: True
trace_id: 213147176377747899

Scan 161402351

duration: 0:00:11.692802

exit_message:

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

id: 161402351

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "content_template_key": "int",
        "label": "varchar(64)",
        "origin_key": "varchar",
        "template": "varchar(64)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_content_template/2026-04-03/1775206304/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_content_template/2026-04-03/1775206304",
        "key": "raw/dwh_dim_content_template/2026-04-03/1775206304/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_content_template",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 5974288620386732288,
        "service_name": "redshift_unloads",
        "span_id": 14404836218848101700,
        "trace_id": 1587619070229965509
    }
}

running: False
schema_name_id: 266
start_time: 2026-04-03 03:51:57
success: True
trace_id: 1587619070229965509

Partitions:

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

Schema:

attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "content_template_key": "int",
    "label": "varchar(64)",
    "template": "varchar(64)"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_content_template`\n(\n `audit_id`  bigint , `content_template_key`  int , `template`  varchar(64) , `label`  varchar(64) , `_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/dwh_dim_content_template/2026-04-17/1776413972'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_content_template`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_content_template"
}

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:54:59",
        "disabled": false,
        "format": "raw",
        "id": 266,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_redshift",
            "table": "analytics_dwh_dim_content_template"
        },
        "type": "redshift"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "_origin": "string",
            "audit_id": "bigint",
            "content_template_key": "int",
            "label": "varchar(64)",
            "template": "varchar(64)"
        },
        "created": "2026-04-17 03:19:57",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_content_template`\n(\n `audit_id`  bigint , `content_template_key`  int , `template`  varchar(64) , `label`  varchar(64) , `_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/dwh_dim_content_template/2026-04-17/1776413972'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_content_template`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_content_template"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}