Schema Info

Schema Name: sfdl_stage_redshift.analytics_dwh_dim_site

created: 2018-02-21 00:01:38
disabled: False
format: raw
id: 395
is_partitioned: False
is_schema_datatyped: True

name:

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

type: redshift

Schema Versions: 15

Version 906650

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_site`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/dwh_dim_site/2026-04-17/1776415804'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_site"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_site/2026-04-17/1776415804
id: 906650
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: 395
schema_scan_id: 6415230
updated: 2026-04-17 03:50:25

Version 906423

created: 2026-04-16 04:00:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_site`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/dwh_dim_site/2026-04-16/1776330026'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_site"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_site/2026-04-16/1776330026
id: 906423
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: 395
schema_scan_id: 6414673
updated: 2026-04-16 04:01:02

Version 906213

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_site`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/dwh_dim_site/2026-04-15/1776243168'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_site"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_site/2026-04-15/1776243168
id: 906213
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: 395
schema_scan_id: 6414189
updated: 2026-04-15 03:53:22

Version 906002

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_site`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/dwh_dim_site/2026-04-14/1776156907'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_site"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_site/2026-04-14/1776156907
id: 906002
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: 395
schema_scan_id: 6413688
updated: 2026-04-14 03:55:41

Version 905779

created: 2026-04-13 03:34:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_site`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/dwh_dim_site/2026-04-13/1776069275'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_site"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_site/2026-04-13/1776069275
id: 905779
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: 395
schema_scan_id: 6413135
updated: 2026-04-13 03:35:02

Version 905558

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_site`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/dwh_dim_site/2026-04-12/1775983060'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_site"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_site/2026-04-12/1775983060
id: 905558
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: 395
schema_scan_id: 6412721
updated: 2026-04-12 03:37:58

Version 905387

created: 2026-04-11 03:48:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_site`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/dwh_dim_site/2026-04-11/1775897324'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_site"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_site/2026-04-11/1775897324
id: 905387
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: 395
schema_scan_id: 6412372
updated: 2026-04-11 03:49:02

Version 905159

created: 2026-04-10 03:54:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_site`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/dwh_dim_site/2026-04-10/1775811269'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_site"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_site/2026-04-10/1775811269
id: 905159
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: 395
schema_scan_id: 6411864
updated: 2026-04-10 03:54:57

Version 904953

created: 2026-04-09 04:00:30

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_site`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/dwh_dim_site/2026-04-09/1775725212'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_site"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_site/2026-04-09/1775725212
id: 904953
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: 395
schema_scan_id: 6411356
updated: 2026-04-09 04:00:41

Version 904736

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_site`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/dwh_dim_site/2026-04-08/1775638617'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_site"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_site/2026-04-08/1775638617
id: 904736
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: 395
schema_scan_id: 6410859
updated: 2026-04-08 03:57:18

Version 904523

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_site`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/dwh_dim_site/2026-04-07/1775551651'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_site"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_site/2026-04-07/1775551651
id: 904523
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: 395
schema_scan_id: 6410349
updated: 2026-04-07 03:48:01

Version 904306

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_site`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/dwh_dim_site/2026-04-06/1775465765'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_site"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_site/2026-04-06/1775465765
id: 904306
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: 395
schema_scan_id: 6409800
updated: 2026-04-06 03:56:25

Version 904115

created: 2026-04-05 04:04:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_site`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/dwh_dim_site/2026-04-05/1775379862'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_site"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_site/2026-04-05/1775379862
id: 904115
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: 395
schema_scan_id: 6409423
updated: 2026-04-05 04:05:06

Version 903900

created: 2026-04-04 03:39:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_site`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/dwh_dim_site/2026-04-04/1775291952'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_site"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_site/2026-04-04/1775291952
id: 903900
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: 395
schema_scan_id: 6409029
updated: 2026-04-04 03:39:32

Version 903687

created: 2026-04-03 03:50:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_site`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/dwh_dim_site/2026-04-03/1775206215'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_site"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_site/2026-04-03/1775206215
id: 903687
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: 395
schema_scan_id: 6408541
updated: 2026-04-03 03:50:33

Schema Scans: 15

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

Scan 6415230

duration: 0:00:11.697483

exit_message:

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

id: 6415230

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-stage",
            "key": "meta/dwh_dim_site/2026-04-17/1776415804/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/2026-04-17/1776415804",
        "key": "raw/dwh_dim_site/2026-04-17/1776415804/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 9550875660387890153,
        "service_name": "redshift_unloads",
        "span_id": 9715767420011459258,
        "trace_id": 6861361818351656112
    }
}

running: False
schema_name_id: 395
start_time: 2026-04-17 03:50:14
success: True
trace_id: 6861361818351656112

Scan 6414673

duration: 0:00:14.483846

exit_message:

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

id: 6414673

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-stage",
            "key": "meta/dwh_dim_site/2026-04-16/1776330026/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/2026-04-16/1776330026",
        "key": "raw/dwh_dim_site/2026-04-16/1776330026/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 6671889245409835350,
        "service_name": "redshift_unloads",
        "span_id": 5430157117199807527,
        "trace_id": 3270914183174784545
    }
}

running: False
schema_name_id: 395
start_time: 2026-04-16 04:00:47
success: True
trace_id: 3270914183174784545

Scan 6414189

duration: 0:00:14.195754

exit_message:

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

id: 6414189

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-stage",
            "key": "meta/dwh_dim_site/2026-04-15/1776243168/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/2026-04-15/1776243168",
        "key": "raw/dwh_dim_site/2026-04-15/1776243168/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 10226139268736407952,
        "service_name": "redshift_unloads",
        "span_id": 10241733678403857725,
        "trace_id": 14855517161606368040
    }
}

running: False
schema_name_id: 395
start_time: 2026-04-15 03:53:08
success: True
trace_id: 14855517161606368040

Scan 6413688

duration: 0:00:14.344765

exit_message:

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

id: 6413688

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-stage",
            "key": "meta/dwh_dim_site/2026-04-14/1776156907/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/2026-04-14/1776156907",
        "key": "raw/dwh_dim_site/2026-04-14/1776156907/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 6797018452749060413,
        "service_name": "redshift_unloads",
        "span_id": 4865819207381148465,
        "trace_id": 5728031359929500887
    }
}

running: False
schema_name_id: 395
start_time: 2026-04-14 03:55:27
success: True
trace_id: 5728031359929500887

Scan 6413135

duration: 0:00:14.258356

exit_message:

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

id: 6413135

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-stage",
            "key": "meta/dwh_dim_site/2026-04-13/1776069275/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/2026-04-13/1776069275",
        "key": "raw/dwh_dim_site/2026-04-13/1776069275/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 5775679641587723539,
        "service_name": "redshift_unloads",
        "span_id": 10662964694205095183,
        "trace_id": 6339443697922974345
    }
}

running: False
schema_name_id: 395
start_time: 2026-04-13 03:34:48
success: True
trace_id: 6339443697922974345

Scan 6412721

duration: 0:00:11.610657

exit_message:

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

id: 6412721

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-stage",
            "key": "meta/dwh_dim_site/2026-04-12/1775983060/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/2026-04-12/1775983060",
        "key": "raw/dwh_dim_site/2026-04-12/1775983060/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 6684829371877894856,
        "service_name": "redshift_unloads",
        "span_id": 4612750562751979850,
        "trace_id": 6913922674361390724
    }
}

running: False
schema_name_id: 395
start_time: 2026-04-12 03:37:47
success: True
trace_id: 6913922674361390724

Scan 6412372

duration: 0:00:11.744848

exit_message:

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

id: 6412372

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-stage",
            "key": "meta/dwh_dim_site/2026-04-11/1775897324/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/2026-04-11/1775897324",
        "key": "raw/dwh_dim_site/2026-04-11/1775897324/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 17107703017652430529,
        "service_name": "redshift_unloads",
        "span_id": 11567551608195079726,
        "trace_id": 1811937211905680162
    }
}

running: False
schema_name_id: 395
start_time: 2026-04-11 03:48:51
success: True
trace_id: 1811937211905680162

Scan 6411864

duration: 0:00:14.394189

exit_message:

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

id: 6411864

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-stage",
            "key": "meta/dwh_dim_site/2026-04-10/1775811269/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/2026-04-10/1775811269",
        "key": "raw/dwh_dim_site/2026-04-10/1775811269/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 17189220572716616296,
        "service_name": "redshift_unloads",
        "span_id": 2576104120156757709,
        "trace_id": 12484390674317318591
    }
}

running: False
schema_name_id: 395
start_time: 2026-04-10 03:54:43
success: True
trace_id: 12484390674317318591

Scan 6411356

duration: 0:00:11.810580

exit_message:

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

id: 6411356

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-stage",
            "key": "meta/dwh_dim_site/2026-04-09/1775725212/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/2026-04-09/1775725212",
        "key": "raw/dwh_dim_site/2026-04-09/1775725212/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 9696795261370382106,
        "service_name": "redshift_unloads",
        "span_id": 12404025749668547148,
        "trace_id": 3561559987606217968
    }
}

running: False
schema_name_id: 395
start_time: 2026-04-09 04:00:30
success: True
trace_id: 3561559987606217968

Scan 6410859

duration: 0:00:14.223320

exit_message:

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

id: 6410859

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-stage",
            "key": "meta/dwh_dim_site/2026-04-08/1775638617/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/2026-04-08/1775638617",
        "key": "raw/dwh_dim_site/2026-04-08/1775638617/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 4761305197326180882,
        "service_name": "redshift_unloads",
        "span_id": 2381043097638436827,
        "trace_id": 10055792314308752342
    }
}

running: False
schema_name_id: 395
start_time: 2026-04-08 03:57:03
success: True
trace_id: 10055792314308752342

Scan 6410349

duration: 0:00:14.186932

exit_message:

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

id: 6410349

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-stage",
            "key": "meta/dwh_dim_site/2026-04-07/1775551651/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/2026-04-07/1775551651",
        "key": "raw/dwh_dim_site/2026-04-07/1775551651/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13572526278054205110,
        "service_name": "redshift_unloads",
        "span_id": 14936011908068505603,
        "trace_id": 14612927434422181015
    }
}

running: False
schema_name_id: 395
start_time: 2026-04-07 03:47:47
success: True
trace_id: 14612927434422181015

Scan 6409800

duration: 0:00:11.715399

exit_message:

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

id: 6409800

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-stage",
            "key": "meta/dwh_dim_site/2026-04-06/1775465765/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/2026-04-06/1775465765",
        "key": "raw/dwh_dim_site/2026-04-06/1775465765/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 16788665078557518704,
        "service_name": "redshift_unloads",
        "span_id": 15774887063869603940,
        "trace_id": 26457275812639702
    }
}

running: False
schema_name_id: 395
start_time: 2026-04-06 03:56:13
success: True
trace_id: 26457275812639702

Scan 6409423

duration: 0:00:14.262646

exit_message:

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

id: 6409423

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-stage",
            "key": "meta/dwh_dim_site/2026-04-05/1775379862/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/2026-04-05/1775379862",
        "key": "raw/dwh_dim_site/2026-04-05/1775379862/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 11934188471434090025,
        "service_name": "redshift_unloads",
        "span_id": 8120301465765209662,
        "trace_id": 59411950079005836
    }
}

running: False
schema_name_id: 395
start_time: 2026-04-05 04:04:52
success: True
trace_id: 59411950079005836

Scan 6409029

duration: 0:00:11.715265

exit_message:

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

id: 6409029

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-stage",
            "key": "meta/dwh_dim_site/2026-04-04/1775291952/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/2026-04-04/1775291952",
        "key": "raw/dwh_dim_site/2026-04-04/1775291952/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 2216701349641015514,
        "service_name": "redshift_unloads",
        "span_id": 3703307484502113822,
        "trace_id": 8844160714872565913
    }
}

running: False
schema_name_id: 395
start_time: 2026-04-04 03:39:21
success: True
trace_id: 8844160714872565913

Scan 6408541

duration: 0:00:11.742957

exit_message:

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

id: 6408541

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-stage",
            "key": "meta/dwh_dim_site/2026-04-03/1775206215/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/2026-04-03/1775206215",
        "key": "raw/dwh_dim_site/2026-04-03/1775206215/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_site",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 12642609434329745919,
        "service_name": "redshift_unloads",
        "span_id": 11659950186856321038,
        "trace_id": 9165551498644749930
    }
}

running: False
schema_name_id: 395
start_time: 2026-04-03 03:50:21
success: True
trace_id: 9165551498644749930

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:50:14

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`\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-stage/raw/dwh_dim_site/2026-04-17/1776415804'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_site`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_site"
}

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-21 00:01:38",
        "disabled": false,
        "format": "raw",
        "id": 395,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_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:50:14",
        "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`\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-stage/raw/dwh_dim_site/2026-04-17/1776415804'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_site`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_site"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}