Schema Info

Schema Name: sfdl_prod_redshift.analytics_dwh_dim_site

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

name:

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

type: redshift

Schema Versions: 15

Version 1717858

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_site`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_site`\n(\n `audit_id`  bigint , `site_key`  int , `site`  varchar(255) , `site_type`  varchar(32) , `_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_site/2026-04-17/1776413960'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_site"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_site/2026-04-17/1776413960
id: 1717858
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "site": "2",
    "site_key": "1",
    "site_type": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "site": "varchar(255)",
    "site_key": "int",
    "site_type": "varchar(32)"
}

schema_name_id: 263
schema_scan_id: 162167904
updated: 2026-04-17 03:19:56

Version 1716648

created: 2026-04-16 04:05:28

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_site`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_site`\n(\n `audit_id`  bigint , `site_key`  int , `site`  varchar(255) , `site_type`  varchar(32) , `_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_site/2026-04-16/1776330302'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_site"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_site/2026-04-16/1776330302
id: 1716648
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "site": "2",
    "site_key": "1",
    "site_type": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "site": "varchar(255)",
    "site_key": "int",
    "site_type": "varchar(32)"
}

schema_name_id: 263
schema_scan_id: 162113296
updated: 2026-04-16 04:05:42

Version 1715430

created: 2026-04-15 03:33:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_site`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_site`\n(\n `audit_id`  bigint , `site_key`  int , `site`  varchar(255) , `site_type`  varchar(32) , `_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_site/2026-04-15/1776242010'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_site"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_site/2026-04-15/1776242010
id: 1715430
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "site": "2",
    "site_key": "1",
    "site_type": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "site": "varchar(255)",
    "site_key": "int",
    "site_type": "varchar(32)"
}

schema_name_id: 263
schema_scan_id: 162056282
updated: 2026-04-15 03:34:05

Version 1714283

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_site`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_site`\n(\n `audit_id`  bigint , `site_key`  int , `site`  varchar(255) , `site_type`  varchar(32) , `_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_site/2026-04-14/1776157374'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_site"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_site/2026-04-14/1776157374
id: 1714283
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "site": "2",
    "site_key": "1",
    "site_type": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "site": "varchar(255)",
    "site_key": "int",
    "site_type": "varchar(32)"
}

schema_name_id: 263
schema_scan_id: 162001920
updated: 2026-04-14 04:03:14

Version 1713029

created: 2026-04-13 03:54:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_site`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_site`\n(\n `audit_id`  bigint , `site_key`  int , `site`  varchar(255) , `site_type`  varchar(32) , `_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_site/2026-04-13/1776070486'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_site"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_site/2026-04-13/1776070486
id: 1713029
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "site": "2",
    "site_key": "1",
    "site_type": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "site": "varchar(255)",
    "site_key": "int",
    "site_type": "varchar(32)"
}

schema_name_id: 263
schema_scan_id: 161943118
updated: 2026-04-13 03:55:05

Version 1711827

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_site`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_site`\n(\n `audit_id`  bigint , `site_key`  int , `site`  varchar(255) , `site_type`  varchar(32) , `_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_site/2026-04-12/1775983818'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_site"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_site/2026-04-12/1775983818
id: 1711827
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "site": "2",
    "site_key": "1",
    "site_type": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "site": "varchar(255)",
    "site_key": "int",
    "site_type": "varchar(32)"
}

schema_name_id: 263
schema_scan_id: 161893649
updated: 2026-04-12 03:50:42

Version 1710620

created: 2026-04-11 03:42:13

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_site`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_site`\n(\n `audit_id`  bigint , `site_key`  int , `site`  varchar(255) , `site_type`  varchar(32) , `_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_site/2026-04-11/1775896917'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_site"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_site/2026-04-11/1775896917
id: 1710620
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "site": "2",
    "site_key": "1",
    "site_type": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "site": "varchar(255)",
    "site_key": "int",
    "site_type": "varchar(32)"
}

schema_name_id: 263
schema_scan_id: 161841463
updated: 2026-04-11 03:42:24

Version 1709457

created: 2026-04-10 03:57:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_site`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_site`\n(\n `audit_id`  bigint , `site_key`  int , `site`  varchar(255) , `site_type`  varchar(32) , `_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_site/2026-04-10/1775811379'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_site"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_site/2026-04-10/1775811379
id: 1709457
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "site": "2",
    "site_key": "1",
    "site_type": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "site": "varchar(255)",
    "site_key": "int",
    "site_type": "varchar(32)"
}

schema_name_id: 263
schema_scan_id: 161786629
updated: 2026-04-10 03:57:28

Version 1708342

created: 2026-04-09 03:50:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_site`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_site`\n(\n `audit_id`  bigint , `site_key`  int , `site`  varchar(255) , `site_type`  varchar(32) , `_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_site/2026-04-09/1775724626'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_site"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_site/2026-04-09/1775724626
id: 1708342
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "site": "2",
    "site_key": "1",
    "site_type": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "site": "varchar(255)",
    "site_key": "int",
    "site_type": "varchar(32)"
}

schema_name_id: 263
schema_scan_id: 161730719
updated: 2026-04-09 03:50:54

Version 1707105

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_site`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_site`\n(\n `audit_id`  bigint , `site_key`  int , `site`  varchar(255) , `site_type`  varchar(32) , `_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_site/2026-04-08/1775637304'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_site"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_site/2026-04-08/1775637304
id: 1707105
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "site": "2",
    "site_key": "1",
    "site_type": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "site": "varchar(255)",
    "site_key": "int",
    "site_type": "varchar(32)"
}

schema_name_id: 263
schema_scan_id: 161675814
updated: 2026-04-08 03:35:25

Version 1705942

created: 2026-04-07 03:50:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_site`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_site`\n(\n `audit_id`  bigint , `site_key`  int , `site`  varchar(255) , `site_type`  varchar(32) , `_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_site/2026-04-07/1775551838'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_site"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_site/2026-04-07/1775551838
id: 1705942
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "site": "2",
    "site_key": "1",
    "site_type": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "site": "varchar(255)",
    "site_key": "int",
    "site_type": "varchar(32)"
}

schema_name_id: 263
schema_scan_id: 161619812
updated: 2026-04-07 03:51:00

Version 1704724

created: 2026-04-06 04:01:08

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_site`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_site`\n(\n `audit_id`  bigint , `site_key`  int , `site`  varchar(255) , `site_type`  varchar(32) , `_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_site/2026-04-06/1775466049'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_site"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_site/2026-04-06/1775466049
id: 1704724
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "site": "2",
    "site_key": "1",
    "site_type": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "site": "varchar(255)",
    "site_key": "int",
    "site_type": "varchar(32)"
}

schema_name_id: 263
schema_scan_id: 161562911
updated: 2026-04-06 04:01:22

Version 1703498

created: 2026-04-05 03:49:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_site`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_site`\n(\n `audit_id`  bigint , `site_key`  int , `site`  varchar(255) , `site_type`  varchar(32) , `_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_site/2026-04-05/1775378967'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_site"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_site/2026-04-05/1775378967
id: 1703498
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "site": "2",
    "site_key": "1",
    "site_type": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "site": "varchar(255)",
    "site_key": "int",
    "site_type": "varchar(32)"
}

schema_name_id: 263
schema_scan_id: 161515153
updated: 2026-04-05 03:49:48

Version 1702336

created: 2026-04-04 03:34:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_site`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_site`\n(\n `audit_id`  bigint , `site_key`  int , `site`  varchar(255) , `site_type`  varchar(32) , `_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_site/2026-04-04/1775291689'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_site"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_site/2026-04-04/1775291689
id: 1702336
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "site": "2",
    "site_key": "1",
    "site_type": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "site": "varchar(255)",
    "site_key": "int",
    "site_type": "varchar(32)"
}

schema_name_id: 263
schema_scan_id: 161460708
updated: 2026-04-04 03:35:10

Version 1701158

created: 2026-04-03 03:51:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_site`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_site`\n(\n `audit_id`  bigint , `site_key`  int , `site`  varchar(255) , `site_type`  varchar(32) , `_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_site/2026-04-03/1775206296'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_site"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_site/2026-04-03/1775206296
id: 1701158
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "site": "2",
    "site_key": "1",
    "site_type": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "site": "varchar(255)",
    "site_key": "int",
    "site_type": "varchar(32)"
}

schema_name_id: 263
schema_scan_id: 161402349
updated: 2026-04-03 03:52:06

Schema Scans: 15

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

Scan 162167904

duration: 0:00:14.123028

exit_message:

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

id: 162167904

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "site": "varchar(255)",
        "site_key": "int",
        "site_type": "varchar(32)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_site/2026-04-17/1776413960/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_site/2026-04-17/1776413960",
        "key": "raw/dwh_dim_site/2026-04-17/1776413960/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 17112989702172150609,
        "service_name": "redshift_unloads",
        "span_id": 208344732624500423,
        "trace_id": 9408465935295655719
    }
}

running: False
schema_name_id: 263
start_time: 2026-04-17 03:19:42
success: True
trace_id: 9408465935295655719

Scan 162113296

duration: 0:00:14.213078

exit_message:

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

id: 162113296

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "site": "varchar(255)",
        "site_key": "int",
        "site_type": "varchar(32)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_site/2026-04-16/1776330302/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_site/2026-04-16/1776330302",
        "key": "raw/dwh_dim_site/2026-04-16/1776330302/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3495497267809140915,
        "service_name": "redshift_unloads",
        "span_id": 15560212164814804203,
        "trace_id": 10544528850287810845
    }
}

running: False
schema_name_id: 263
start_time: 2026-04-16 04:05:28
success: True
trace_id: 10544528850287810845

Scan 162056282

duration: 0:00:11.691632

exit_message:

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

id: 162056282

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "site": "varchar(255)",
        "site_key": "int",
        "site_type": "varchar(32)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_site/2026-04-15/1776242010/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_site/2026-04-15/1776242010",
        "key": "raw/dwh_dim_site/2026-04-15/1776242010/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 5968480151719915841,
        "service_name": "redshift_unloads",
        "span_id": 6232083110509562025,
        "trace_id": 10054068323945155274
    }
}

running: False
schema_name_id: 263
start_time: 2026-04-15 03:33:53
success: True
trace_id: 10054068323945155274

Scan 162001920

duration: 0:00:11.614197

exit_message:

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

id: 162001920

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "site": "varchar(255)",
        "site_key": "int",
        "site_type": "varchar(32)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_site/2026-04-14/1776157374/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_site/2026-04-14/1776157374",
        "key": "raw/dwh_dim_site/2026-04-14/1776157374/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 11798747911212336081,
        "service_name": "redshift_unloads",
        "span_id": 16930894558404515509,
        "trace_id": 2394442435792090020
    }
}

running: False
schema_name_id: 263
start_time: 2026-04-14 04:03:02
success: True
trace_id: 2394442435792090020

Scan 161943118

duration: 0:00:11.655858

exit_message:

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

id: 161943118

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "site": "varchar(255)",
        "site_key": "int",
        "site_type": "varchar(32)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_site/2026-04-13/1776070486/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_site/2026-04-13/1776070486",
        "key": "raw/dwh_dim_site/2026-04-13/1776070486/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8081032634739957510,
        "service_name": "redshift_unloads",
        "span_id": 4404537852697618038,
        "trace_id": 9744633478525941415
    }
}

running: False
schema_name_id: 263
start_time: 2026-04-13 03:54:53
success: True
trace_id: 9744633478525941415

Scan 161893649

duration: 0:00:14.232938

exit_message:

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

id: 161893649

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "site": "varchar(255)",
        "site_key": "int",
        "site_type": "varchar(32)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_site/2026-04-12/1775983818/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_site/2026-04-12/1775983818",
        "key": "raw/dwh_dim_site/2026-04-12/1775983818/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8826821997793785254,
        "service_name": "redshift_unloads",
        "span_id": 14227652158521533265,
        "trace_id": 11243949532334037491
    }
}

running: False
schema_name_id: 263
start_time: 2026-04-12 03:50:28
success: True
trace_id: 11243949532334037491

Scan 161841463

duration: 0:00:11.630749

exit_message:

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

id: 161841463

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "site": "varchar(255)",
        "site_key": "int",
        "site_type": "varchar(32)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_site/2026-04-11/1775896917/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_site/2026-04-11/1775896917",
        "key": "raw/dwh_dim_site/2026-04-11/1775896917/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15969849638100507583,
        "service_name": "redshift_unloads",
        "span_id": 8776365189377810372,
        "trace_id": 8744134001295610942
    }
}

running: False
schema_name_id: 263
start_time: 2026-04-11 03:42:12
success: True
trace_id: 8744134001295610942

Scan 161786629

duration: 0:00:14.343158

exit_message:

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

id: 161786629

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "site": "varchar(255)",
        "site_key": "int",
        "site_type": "varchar(32)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_site/2026-04-10/1775811379/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_site/2026-04-10/1775811379",
        "key": "raw/dwh_dim_site/2026-04-10/1775811379/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 2323613957272980440,
        "service_name": "redshift_unloads",
        "span_id": 15978423392135155036,
        "trace_id": 4427880135774235740
    }
}

running: False
schema_name_id: 263
start_time: 2026-04-10 03:57:13
success: True
trace_id: 4427880135774235740

Scan 161730719

duration: 0:00:14.217842

exit_message:

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

id: 161730719

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "site": "varchar(255)",
        "site_key": "int",
        "site_type": "varchar(32)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_site/2026-04-09/1775724626/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_site/2026-04-09/1775724626",
        "key": "raw/dwh_dim_site/2026-04-09/1775724626/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 2569710607601007847,
        "service_name": "redshift_unloads",
        "span_id": 1990020494885997903,
        "trace_id": 17376621480133683271
    }
}

running: False
schema_name_id: 263
start_time: 2026-04-09 03:50:40
success: True
trace_id: 17376621480133683271

Scan 161675814

duration: 0:00:11.674409

exit_message:

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

id: 161675814

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "site": "varchar(255)",
        "site_key": "int",
        "site_type": "varchar(32)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_site/2026-04-08/1775637304/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_site/2026-04-08/1775637304",
        "key": "raw/dwh_dim_site/2026-04-08/1775637304/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 11831981188243792814,
        "service_name": "redshift_unloads",
        "span_id": 1351943842185895406,
        "trace_id": 7144473109844561615
    }
}

running: False
schema_name_id: 263
start_time: 2026-04-08 03:35:13
success: True
trace_id: 7144473109844561615

Scan 161619812

duration: 0:00:14.214736

exit_message:

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

id: 161619812

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "site": "varchar(255)",
        "site_key": "int",
        "site_type": "varchar(32)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_site/2026-04-07/1775551838/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_site/2026-04-07/1775551838",
        "key": "raw/dwh_dim_site/2026-04-07/1775551838/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 11976103080463070114,
        "service_name": "redshift_unloads",
        "span_id": 16359877695138794831,
        "trace_id": 13677126035747905230
    }
}

running: False
schema_name_id: 263
start_time: 2026-04-07 03:50:46
success: True
trace_id: 13677126035747905230

Scan 161562911

duration: 0:00:14.082314

exit_message:

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

id: 161562911

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "site": "varchar(255)",
        "site_key": "int",
        "site_type": "varchar(32)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_site/2026-04-06/1775466049/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_site/2026-04-06/1775466049",
        "key": "raw/dwh_dim_site/2026-04-06/1775466049/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 4420963738939295754,
        "service_name": "redshift_unloads",
        "span_id": 11670165059745201970,
        "trace_id": 2415129419350224617
    }
}

running: False
schema_name_id: 263
start_time: 2026-04-06 04:01:08
success: True
trace_id: 2415129419350224617

Scan 161515153

duration: 0:00:14.134004

exit_message:

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

id: 161515153

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "site": "varchar(255)",
        "site_key": "int",
        "site_type": "varchar(32)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_site/2026-04-05/1775378967/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_site/2026-04-05/1775378967",
        "key": "raw/dwh_dim_site/2026-04-05/1775378967/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 6771638324817628853,
        "service_name": "redshift_unloads",
        "span_id": 6050754062426041432,
        "trace_id": 2841699252732476068
    }
}

running: False
schema_name_id: 263
start_time: 2026-04-05 03:49:34
success: True
trace_id: 2841699252732476068

Scan 161460708

duration: 0:00:14.103925

exit_message:

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

id: 161460708

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "site": "varchar(255)",
        "site_key": "int",
        "site_type": "varchar(32)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_site/2026-04-04/1775291689/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_site/2026-04-04/1775291689",
        "key": "raw/dwh_dim_site/2026-04-04/1775291689/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 14660585618493133846,
        "service_name": "redshift_unloads",
        "span_id": 8532301427683489842,
        "trace_id": 18115676710193542602
    }
}

running: False
schema_name_id: 263
start_time: 2026-04-04 03:34:56
success: True
trace_id: 18115676710193542602

Scan 161402349

duration: 0:00:14.148022

exit_message:

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

id: 161402349

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "site": "varchar(255)",
        "site_key": "int",
        "site_type": "varchar(32)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_site/2026-04-03/1775206296/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_site/2026-04-03/1775206296",
        "key": "raw/dwh_dim_site/2026-04-03/1775206296/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 4156287230569529562,
        "service_name": "redshift_unloads",
        "span_id": 9133714271340404790,
        "trace_id": 14666652911521299722
    }
}

running: False
schema_name_id: 263
start_time: 2026-04-03 03:51:52
success: True
trace_id: 14666652911521299722

Partitions:

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

Schema:

attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "site": "varchar(255)",
    "site_key": "int",
    "site_type": "varchar(32)"
}

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

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_site`\n(\n `audit_id`  bigint , `site_key`  int , `site`  varchar(255) , `site_type`  varchar(32) , `_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_site/2026-04-17/1776413960'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_site`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_site"
}

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:30",
        "disabled": false,
        "format": "raw",
        "id": 263,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_redshift",
            "table": "analytics_dwh_dim_site"
        },
        "type": "redshift"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "_origin": "string",
            "audit_id": "bigint",
            "site": "varchar(255)",
            "site_key": "int",
            "site_type": "varchar(32)"
        },
        "created": "2026-04-17 03:19:43",
        "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_site`\n(\n `audit_id`  bigint , `site_key`  int , `site`  varchar(255) , `site_type`  varchar(32) , `_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_site/2026-04-17/1776413960'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_site`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_site"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}