Schema Info

Schema Name: sfdl_stage_redshift.analytics_reference_dim_partner_group

created: 2018-05-09 11:00:16
disabled: False
format: raw
id: 527
is_partitioned: False
is_schema_datatyped: True

name:

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

type: redshift

Schema Versions: 15

Version 906640

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_partner_group`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_dim_partner_group`\n(\n `audit_id`  bigint , `site_key`  int , `site_channel_type`  varchar(25) , `site_type`  varchar(25) , `partner_group`  varchar(25) , `active`  varchar(25) , `site_group`  varchar(25) , `_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/reference_dim_partner_group/2026-04-17/1776415498'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_partner_group"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_partner_group/2026-04-17/1776415498
id: 906640
processed: 1

raw_data:

{
    "_origin": "7",
    "active": "5",
    "audit_id": "0",
    "partner_group": "4",
    "site_channel_type": "2",
    "site_group": "6",
    "site_key": "1",
    "site_type": "3"
}

schema_attributes:

{
    "_origin": "string",
    "active": "varchar(25)",
    "audit_id": "bigint",
    "partner_group": "varchar(25)",
    "site_channel_type": "varchar(25)",
    "site_group": "varchar(25)",
    "site_key": "int",
    "site_type": "varchar(25)"
}

schema_name_id: 527
schema_scan_id: 6415220
updated: 2026-04-17 03:45:26

Version 906419

created: 2026-04-16 04:00:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_partner_group`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_dim_partner_group`\n(\n `audit_id`  bigint , `site_key`  int , `site_channel_type`  varchar(25) , `site_type`  varchar(25) , `partner_group`  varchar(25) , `active`  varchar(25) , `site_group`  varchar(25) , `_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/reference_dim_partner_group/2026-04-16/1776330008'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_partner_group"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_partner_group/2026-04-16/1776330008
id: 906419
processed: 1

raw_data:

{
    "_origin": "7",
    "active": "5",
    "audit_id": "0",
    "partner_group": "4",
    "site_channel_type": "2",
    "site_group": "6",
    "site_key": "1",
    "site_type": "3"
}

schema_attributes:

{
    "_origin": "string",
    "active": "varchar(25)",
    "audit_id": "bigint",
    "partner_group": "varchar(25)",
    "site_channel_type": "varchar(25)",
    "site_group": "varchar(25)",
    "site_key": "int",
    "site_type": "varchar(25)"
}

schema_name_id: 527
schema_scan_id: 6414669
updated: 2026-04-16 04:00:47

Version 906179

created: 2026-04-15 03:42:30

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_partner_group`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_dim_partner_group`\n(\n `audit_id`  bigint , `site_key`  int , `site_channel_type`  varchar(25) , `site_type`  varchar(25) , `partner_group`  varchar(25) , `active`  varchar(25) , `site_group`  varchar(25) , `_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/reference_dim_partner_group/2026-04-15/1776242532'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_partner_group"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_partner_group/2026-04-15/1776242532
id: 906179
processed: 1

raw_data:

{
    "_origin": "7",
    "active": "5",
    "audit_id": "0",
    "partner_group": "4",
    "site_channel_type": "2",
    "site_group": "6",
    "site_key": "1",
    "site_type": "3"
}

schema_attributes:

{
    "_origin": "string",
    "active": "varchar(25)",
    "audit_id": "bigint",
    "partner_group": "varchar(25)",
    "site_channel_type": "varchar(25)",
    "site_group": "varchar(25)",
    "site_key": "int",
    "site_type": "varchar(25)"
}

schema_name_id: 527
schema_scan_id: 6414155
updated: 2026-04-15 03:42:41

Version 905989

created: 2026-04-14 03:53:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_partner_group`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_dim_partner_group`\n(\n `audit_id`  bigint , `site_key`  int , `site_channel_type`  varchar(25) , `site_type`  varchar(25) , `partner_group`  varchar(25) , `active`  varchar(25) , `site_group`  varchar(25) , `_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/reference_dim_partner_group/2026-04-14/1776156795'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_partner_group"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_partner_group/2026-04-14/1776156795
id: 905989
processed: 1

raw_data:

{
    "_origin": "7",
    "active": "5",
    "audit_id": "0",
    "partner_group": "4",
    "site_channel_type": "2",
    "site_group": "6",
    "site_key": "1",
    "site_type": "3"
}

schema_attributes:

{
    "_origin": "string",
    "active": "varchar(25)",
    "audit_id": "bigint",
    "partner_group": "varchar(25)",
    "site_channel_type": "varchar(25)",
    "site_group": "varchar(25)",
    "site_key": "int",
    "site_type": "varchar(25)"
}

schema_name_id: 527
schema_scan_id: 6413675
updated: 2026-04-14 03:53:36

Version 905748

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_partner_group`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_dim_partner_group`\n(\n `audit_id`  bigint , `site_key`  int , `site_channel_type`  varchar(25) , `site_type`  varchar(25) , `partner_group`  varchar(25) , `active`  varchar(25) , `site_group`  varchar(25) , `_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/reference_dim_partner_group/2026-04-13/1776068496'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_partner_group"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_partner_group/2026-04-13/1776068496
id: 905748
processed: 1

raw_data:

{
    "_origin": "7",
    "active": "5",
    "audit_id": "0",
    "partner_group": "4",
    "site_channel_type": "2",
    "site_group": "6",
    "site_key": "1",
    "site_type": "3"
}

schema_attributes:

{
    "_origin": "string",
    "active": "varchar(25)",
    "audit_id": "bigint",
    "partner_group": "varchar(25)",
    "site_channel_type": "varchar(25)",
    "site_group": "varchar(25)",
    "site_key": "int",
    "site_type": "varchar(25)"
}

schema_name_id: 527
schema_scan_id: 6413103
updated: 2026-04-13 03:22:14

Version 905563

created: 2026-04-12 03:38:27

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_partner_group`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_dim_partner_group`\n(\n `audit_id`  bigint , `site_key`  int , `site_channel_type`  varchar(25) , `site_type`  varchar(25) , `partner_group`  varchar(25) , `active`  varchar(25) , `site_group`  varchar(25) , `_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/reference_dim_partner_group/2026-04-12/1775983084'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_partner_group"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_partner_group/2026-04-12/1775983084
id: 905563
processed: 1

raw_data:

{
    "_origin": "7",
    "active": "5",
    "audit_id": "0",
    "partner_group": "4",
    "site_channel_type": "2",
    "site_group": "6",
    "site_key": "1",
    "site_type": "3"
}

schema_attributes:

{
    "_origin": "string",
    "active": "varchar(25)",
    "audit_id": "bigint",
    "partner_group": "varchar(25)",
    "site_channel_type": "varchar(25)",
    "site_group": "varchar(25)",
    "site_key": "int",
    "site_type": "varchar(25)"
}

schema_name_id: 527
schema_scan_id: 6412726
updated: 2026-04-12 03:38:41

Version 905348

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_partner_group`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_dim_partner_group`\n(\n `audit_id`  bigint , `site_key`  int , `site_channel_type`  varchar(25) , `site_type`  varchar(25) , `partner_group`  varchar(25) , `active`  varchar(25) , `site_group`  varchar(25) , `_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/reference_dim_partner_group/2026-04-11/1775895644'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_partner_group"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_partner_group/2026-04-11/1775895644
id: 905348
processed: 1

raw_data:

{
    "_origin": "7",
    "active": "5",
    "audit_id": "0",
    "partner_group": "4",
    "site_channel_type": "2",
    "site_group": "6",
    "site_key": "1",
    "site_type": "3"
}

schema_attributes:

{
    "_origin": "string",
    "active": "varchar(25)",
    "audit_id": "bigint",
    "partner_group": "varchar(25)",
    "site_channel_type": "varchar(25)",
    "site_group": "varchar(25)",
    "site_key": "int",
    "site_type": "varchar(25)"
}

schema_name_id: 527
schema_scan_id: 6412332
updated: 2026-04-11 03:21:27

Version 905174

created: 2026-04-10 03:59:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_partner_group`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_dim_partner_group`\n(\n `audit_id`  bigint , `site_key`  int , `site_channel_type`  varchar(25) , `site_type`  varchar(25) , `partner_group`  varchar(25) , `active`  varchar(25) , `site_group`  varchar(25) , `_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/reference_dim_partner_group/2026-04-10/1775811582'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_partner_group"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_partner_group/2026-04-10/1775811582
id: 905174
processed: 1

raw_data:

{
    "_origin": "7",
    "active": "5",
    "audit_id": "0",
    "partner_group": "4",
    "site_channel_type": "2",
    "site_group": "6",
    "site_key": "1",
    "site_type": "3"
}

schema_attributes:

{
    "_origin": "string",
    "active": "varchar(25)",
    "audit_id": "bigint",
    "partner_group": "varchar(25)",
    "site_channel_type": "varchar(25)",
    "site_group": "varchar(25)",
    "site_key": "int",
    "site_type": "varchar(25)"
}

schema_name_id: 527
schema_scan_id: 6411879
updated: 2026-04-10 04:00:03

Version 904962

created: 2026-04-09 04:01:26

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_partner_group`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_dim_partner_group`\n(\n `audit_id`  bigint , `site_key`  int , `site_channel_type`  varchar(25) , `site_type`  varchar(25) , `partner_group`  varchar(25) , `active`  varchar(25) , `site_group`  varchar(25) , `_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/reference_dim_partner_group/2026-04-09/1775725275'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_partner_group"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_partner_group/2026-04-09/1775725275
id: 904962
processed: 1

raw_data:

{
    "_origin": "7",
    "active": "5",
    "audit_id": "0",
    "partner_group": "4",
    "site_channel_type": "2",
    "site_group": "6",
    "site_key": "1",
    "site_type": "3"
}

schema_attributes:

{
    "_origin": "string",
    "active": "varchar(25)",
    "audit_id": "bigint",
    "partner_group": "varchar(25)",
    "site_channel_type": "varchar(25)",
    "site_group": "varchar(25)",
    "site_key": "int",
    "site_type": "varchar(25)"
}

schema_name_id: 527
schema_scan_id: 6411365
updated: 2026-04-09 04:01:38

Version 904702

created: 2026-04-08 03:31:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_partner_group`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_dim_partner_group`\n(\n `audit_id`  bigint , `site_key`  int , `site_channel_type`  varchar(25) , `site_type`  varchar(25) , `partner_group`  varchar(25) , `active`  varchar(25) , `site_group`  varchar(25) , `_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/reference_dim_partner_group/2026-04-08/1775637070'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_partner_group"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_partner_group/2026-04-08/1775637070
id: 904702
processed: 1

raw_data:

{
    "_origin": "7",
    "active": "5",
    "audit_id": "0",
    "partner_group": "4",
    "site_channel_type": "2",
    "site_group": "6",
    "site_key": "1",
    "site_type": "3"
}

schema_attributes:

{
    "_origin": "string",
    "active": "varchar(25)",
    "audit_id": "bigint",
    "partner_group": "varchar(25)",
    "site_channel_type": "varchar(25)",
    "site_group": "varchar(25)",
    "site_key": "int",
    "site_type": "varchar(25)"
}

schema_name_id: 527
schema_scan_id: 6410823
updated: 2026-04-08 03:31:29

Version 904498

created: 2026-04-07 03:33:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_partner_group`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_dim_partner_group`\n(\n `audit_id`  bigint , `site_key`  int , `site_channel_type`  varchar(25) , `site_type`  varchar(25) , `partner_group`  varchar(25) , `active`  varchar(25) , `site_group`  varchar(25) , `_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/reference_dim_partner_group/2026-04-07/1775550775'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_partner_group"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_partner_group/2026-04-07/1775550775
id: 904498
processed: 1

raw_data:

{
    "_origin": "7",
    "active": "5",
    "audit_id": "0",
    "partner_group": "4",
    "site_channel_type": "2",
    "site_group": "6",
    "site_key": "1",
    "site_type": "3"
}

schema_attributes:

{
    "_origin": "string",
    "active": "varchar(25)",
    "audit_id": "bigint",
    "partner_group": "varchar(25)",
    "site_channel_type": "varchar(25)",
    "site_group": "varchar(25)",
    "site_key": "int",
    "site_type": "varchar(25)"
}

schema_name_id: 527
schema_scan_id: 6410320
updated: 2026-04-07 03:33:53

Version 904274

created: 2026-04-06 03:44:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_partner_group`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_dim_partner_group`\n(\n `audit_id`  bigint , `site_key`  int , `site_channel_type`  varchar(25) , `site_type`  varchar(25) , `partner_group`  varchar(25) , `active`  varchar(25) , `site_group`  varchar(25) , `_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/reference_dim_partner_group/2026-04-06/1775465031'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_partner_group"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_partner_group/2026-04-06/1775465031
id: 904274
processed: 1

raw_data:

{
    "_origin": "7",
    "active": "5",
    "audit_id": "0",
    "partner_group": "4",
    "site_channel_type": "2",
    "site_group": "6",
    "site_key": "1",
    "site_type": "3"
}

schema_attributes:

{
    "_origin": "string",
    "active": "varchar(25)",
    "audit_id": "bigint",
    "partner_group": "varchar(25)",
    "site_channel_type": "varchar(25)",
    "site_group": "varchar(25)",
    "site_key": "int",
    "site_type": "varchar(25)"
}

schema_name_id: 527
schema_scan_id: 6409768
updated: 2026-04-06 03:44:25

Version 904077

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_partner_group`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_dim_partner_group`\n(\n `audit_id`  bigint , `site_key`  int , `site_channel_type`  varchar(25) , `site_type`  varchar(25) , `partner_group`  varchar(25) , `active`  varchar(25) , `site_group`  varchar(25) , `_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/reference_dim_partner_group/2026-04-05/1775377565'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_partner_group"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_partner_group/2026-04-05/1775377565
id: 904077
processed: 1

raw_data:

{
    "_origin": "7",
    "active": "5",
    "audit_id": "0",
    "partner_group": "4",
    "site_channel_type": "2",
    "site_group": "6",
    "site_key": "1",
    "site_type": "3"
}

schema_attributes:

{
    "_origin": "string",
    "active": "varchar(25)",
    "audit_id": "bigint",
    "partner_group": "varchar(25)",
    "site_channel_type": "varchar(25)",
    "site_group": "varchar(25)",
    "site_key": "int",
    "site_type": "varchar(25)"
}

schema_name_id: 527
schema_scan_id: 6409384
updated: 2026-04-05 03:26:25

Version 903870

created: 2026-04-04 03:22:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_partner_group`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_dim_partner_group`\n(\n `audit_id`  bigint , `site_key`  int , `site_channel_type`  varchar(25) , `site_type`  varchar(25) , `partner_group`  varchar(25) , `active`  varchar(25) , `site_group`  varchar(25) , `_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/reference_dim_partner_group/2026-04-04/1775290951'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_partner_group"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_partner_group/2026-04-04/1775290951
id: 903870
processed: 1

raw_data:

{
    "_origin": "7",
    "active": "5",
    "audit_id": "0",
    "partner_group": "4",
    "site_channel_type": "2",
    "site_group": "6",
    "site_key": "1",
    "site_type": "3"
}

schema_attributes:

{
    "_origin": "string",
    "active": "varchar(25)",
    "audit_id": "bigint",
    "partner_group": "varchar(25)",
    "site_channel_type": "varchar(25)",
    "site_group": "varchar(25)",
    "site_key": "int",
    "site_type": "varchar(25)"
}

schema_name_id: 527
schema_scan_id: 6408999
updated: 2026-04-04 03:22:56

Version 903659

created: 2026-04-03 03:43:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_partner_group`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_dim_partner_group`\n(\n `audit_id`  bigint , `site_key`  int , `site_channel_type`  varchar(25) , `site_type`  varchar(25) , `partner_group`  varchar(25) , `active`  varchar(25) , `site_group`  varchar(25) , `_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/reference_dim_partner_group/2026-04-03/1775205816'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_partner_group"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_partner_group/2026-04-03/1775205816
id: 903659
processed: 1

raw_data:

{
    "_origin": "7",
    "active": "5",
    "audit_id": "0",
    "partner_group": "4",
    "site_channel_type": "2",
    "site_group": "6",
    "site_key": "1",
    "site_type": "3"
}

schema_attributes:

{
    "_origin": "string",
    "active": "varchar(25)",
    "audit_id": "bigint",
    "partner_group": "varchar(25)",
    "site_channel_type": "varchar(25)",
    "site_group": "varchar(25)",
    "site_key": "int",
    "site_type": "varchar(25)"
}

schema_name_id: 527
schema_scan_id: 6408513
updated: 2026-04-03 03:44:03

Schema Scans: 15

Last at 2026-04-17 03:45:12

Scan 6415220

duration: 0:00:14.352949

exit_message:

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

id: 6415220

payload:

{
    "datatype_dict": {
        "active": "varchar(25)",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "partner_group": "varchar(25)",
        "site_channel_type": "varchar(25)",
        "site_group": "varchar(25)",
        "site_key": "int",
        "site_type": "varchar(25)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_dim_partner_group/2026-04-17/1776415498/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_partner_group/2026-04-17/1776415498",
        "key": "raw/reference_dim_partner_group/2026-04-17/1776415498/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_partner_group",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8258644107707055914,
        "service_name": "redshift_unloads",
        "span_id": 10692091802974926203,
        "trace_id": 15402994705052259600
    }
}

running: False
schema_name_id: 527
start_time: 2026-04-17 03:45:12
success: True
trace_id: 15402994705052259600

Scan 6414669

duration: 0:00:14.434401

exit_message:

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

id: 6414669

payload:

{
    "datatype_dict": {
        "active": "varchar(25)",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "partner_group": "varchar(25)",
        "site_channel_type": "varchar(25)",
        "site_group": "varchar(25)",
        "site_key": "int",
        "site_type": "varchar(25)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_dim_partner_group/2026-04-16/1776330008/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_partner_group/2026-04-16/1776330008",
        "key": "raw/reference_dim_partner_group/2026-04-16/1776330008/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_partner_group",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15626950362572666994,
        "service_name": "redshift_unloads",
        "span_id": 14841713975759369886,
        "trace_id": 15917746469576753654
    }
}

running: False
schema_name_id: 527
start_time: 2026-04-16 04:00:33
success: True
trace_id: 15917746469576753654

Scan 6414155

duration: 0:00:11.706834

exit_message:

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

id: 6414155

payload:

{
    "datatype_dict": {
        "active": "varchar(25)",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "partner_group": "varchar(25)",
        "site_channel_type": "varchar(25)",
        "site_group": "varchar(25)",
        "site_key": "int",
        "site_type": "varchar(25)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_dim_partner_group/2026-04-15/1776242532/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_partner_group/2026-04-15/1776242532",
        "key": "raw/reference_dim_partner_group/2026-04-15/1776242532/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_partner_group",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 1208144946934229516,
        "service_name": "redshift_unloads",
        "span_id": 13673904909135159028,
        "trace_id": 6297912541944770274
    }
}

running: False
schema_name_id: 527
start_time: 2026-04-15 03:42:30
success: True
trace_id: 6297912541944770274

Scan 6413675

duration: 0:00:11.721615

exit_message:

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

id: 6413675

payload:

{
    "datatype_dict": {
        "active": "varchar(25)",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "partner_group": "varchar(25)",
        "site_channel_type": "varchar(25)",
        "site_group": "varchar(25)",
        "site_key": "int",
        "site_type": "varchar(25)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_dim_partner_group/2026-04-14/1776156795/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_partner_group/2026-04-14/1776156795",
        "key": "raw/reference_dim_partner_group/2026-04-14/1776156795/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_partner_group",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 9691970354815216726,
        "service_name": "redshift_unloads",
        "span_id": 9566043138158062792,
        "trace_id": 15752774413273758528
    }
}

running: False
schema_name_id: 527
start_time: 2026-04-14 03:53:24
success: True
trace_id: 15752774413273758528

Scan 6413103

duration: 0:00:14.284862

exit_message:

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

id: 6413103

payload:

{
    "datatype_dict": {
        "active": "varchar(25)",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "partner_group": "varchar(25)",
        "site_channel_type": "varchar(25)",
        "site_group": "varchar(25)",
        "site_key": "int",
        "site_type": "varchar(25)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_dim_partner_group/2026-04-13/1776068496/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_partner_group/2026-04-13/1776068496",
        "key": "raw/reference_dim_partner_group/2026-04-13/1776068496/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_partner_group",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 314673693766910170,
        "service_name": "redshift_unloads",
        "span_id": 8034834895856156435,
        "trace_id": 5255513851807644444
    }
}

running: False
schema_name_id: 527
start_time: 2026-04-13 03:22:00
success: True
trace_id: 5255513851807644444

Scan 6412726

duration: 0:00:14.878018

exit_message:

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

id: 6412726

payload:

{
    "datatype_dict": {
        "active": "varchar(25)",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "partner_group": "varchar(25)",
        "site_channel_type": "varchar(25)",
        "site_group": "varchar(25)",
        "site_key": "int",
        "site_type": "varchar(25)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_dim_partner_group/2026-04-12/1775983084/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_partner_group/2026-04-12/1775983084",
        "key": "raw/reference_dim_partner_group/2026-04-12/1775983084/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_partner_group",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 836456180055078715,
        "service_name": "redshift_unloads",
        "span_id": 8993809901989905758,
        "trace_id": 16258713698850491745
    }
}

running: False
schema_name_id: 527
start_time: 2026-04-12 03:38:26
success: True
trace_id: 16258713698850491745

Scan 6412332

duration: 0:00:14.388776

exit_message:

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

id: 6412332

payload:

{
    "datatype_dict": {
        "active": "varchar(25)",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "partner_group": "varchar(25)",
        "site_channel_type": "varchar(25)",
        "site_group": "varchar(25)",
        "site_key": "int",
        "site_type": "varchar(25)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_dim_partner_group/2026-04-11/1775895644/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_partner_group/2026-04-11/1775895644",
        "key": "raw/reference_dim_partner_group/2026-04-11/1775895644/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_partner_group",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 2183466130880765305,
        "service_name": "redshift_unloads",
        "span_id": 14739054721066034129,
        "trace_id": 16366642423533310534
    }
}

running: False
schema_name_id: 527
start_time: 2026-04-11 03:21:13
success: True
trace_id: 16366642423533310534

Scan 6411879

duration: 0:00:11.787433

exit_message:

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

id: 6411879

payload:

{
    "datatype_dict": {
        "active": "varchar(25)",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "partner_group": "varchar(25)",
        "site_channel_type": "varchar(25)",
        "site_group": "varchar(25)",
        "site_key": "int",
        "site_type": "varchar(25)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_dim_partner_group/2026-04-10/1775811582/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_partner_group/2026-04-10/1775811582",
        "key": "raw/reference_dim_partner_group/2026-04-10/1775811582/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_partner_group",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 7845025164658919206,
        "service_name": "redshift_unloads",
        "span_id": 14334419155574007677,
        "trace_id": 8856974102054263477
    }
}

running: False
schema_name_id: 527
start_time: 2026-04-10 03:59:51
success: True
trace_id: 8856974102054263477

Scan 6411365

duration: 0:00:11.930076

exit_message:

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

id: 6411365

payload:

{
    "datatype_dict": {
        "active": "varchar(25)",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "partner_group": "varchar(25)",
        "site_channel_type": "varchar(25)",
        "site_group": "varchar(25)",
        "site_key": "int",
        "site_type": "varchar(25)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_dim_partner_group/2026-04-09/1775725275/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_partner_group/2026-04-09/1775725275",
        "key": "raw/reference_dim_partner_group/2026-04-09/1775725275/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_partner_group",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 98839558480592261,
        "service_name": "redshift_unloads",
        "span_id": 7266525643928929551,
        "trace_id": 8304834197174238694
    }
}

running: False
schema_name_id: 527
start_time: 2026-04-09 04:01:26
success: True
trace_id: 8304834197174238694

Scan 6410823

duration: 0:00:11.707894

exit_message:

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

id: 6410823

payload:

{
    "datatype_dict": {
        "active": "varchar(25)",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "partner_group": "varchar(25)",
        "site_channel_type": "varchar(25)",
        "site_group": "varchar(25)",
        "site_key": "int",
        "site_type": "varchar(25)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_dim_partner_group/2026-04-08/1775637070/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_partner_group/2026-04-08/1775637070",
        "key": "raw/reference_dim_partner_group/2026-04-08/1775637070/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_partner_group",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 10201766011996805437,
        "service_name": "redshift_unloads",
        "span_id": 2639147498705783535,
        "trace_id": 16185086740646935991
    }
}

running: False
schema_name_id: 527
start_time: 2026-04-08 03:31:18
success: True
trace_id: 16185086740646935991

Scan 6410320

duration: 0:00:11.813726

exit_message:

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

id: 6410320

payload:

{
    "datatype_dict": {
        "active": "varchar(25)",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "partner_group": "varchar(25)",
        "site_channel_type": "varchar(25)",
        "site_group": "varchar(25)",
        "site_key": "int",
        "site_type": "varchar(25)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_dim_partner_group/2026-04-07/1775550775/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_partner_group/2026-04-07/1775550775",
        "key": "raw/reference_dim_partner_group/2026-04-07/1775550775/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_partner_group",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 14643425304928856191,
        "service_name": "redshift_unloads",
        "span_id": 16344176923391432409,
        "trace_id": 14001380698310464356
    }
}

running: False
schema_name_id: 527
start_time: 2026-04-07 03:33:41
success: True
trace_id: 14001380698310464356

Scan 6409768

duration: 0:00:14.378773

exit_message:

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

id: 6409768

payload:

{
    "datatype_dict": {
        "active": "varchar(25)",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "partner_group": "varchar(25)",
        "site_channel_type": "varchar(25)",
        "site_group": "varchar(25)",
        "site_key": "int",
        "site_type": "varchar(25)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_dim_partner_group/2026-04-06/1775465031/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_partner_group/2026-04-06/1775465031",
        "key": "raw/reference_dim_partner_group/2026-04-06/1775465031/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_partner_group",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13874146927831047092,
        "service_name": "redshift_unloads",
        "span_id": 8591920787664533120,
        "trace_id": 18286546962982359994
    }
}

running: False
schema_name_id: 527
start_time: 2026-04-06 03:44:11
success: True
trace_id: 18286546962982359994

Scan 6409384

duration: 0:00:11.781407

exit_message:

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

id: 6409384

payload:

{
    "datatype_dict": {
        "active": "varchar(25)",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "partner_group": "varchar(25)",
        "site_channel_type": "varchar(25)",
        "site_group": "varchar(25)",
        "site_key": "int",
        "site_type": "varchar(25)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_dim_partner_group/2026-04-05/1775377565/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_partner_group/2026-04-05/1775377565",
        "key": "raw/reference_dim_partner_group/2026-04-05/1775377565/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_partner_group",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 2337687569128291672,
        "service_name": "redshift_unloads",
        "span_id": 17670525957880990470,
        "trace_id": 3696458994948981388
    }
}

running: False
schema_name_id: 527
start_time: 2026-04-05 03:26:13
success: True
trace_id: 3696458994948981388

Scan 6408999

duration: 0:00:11.712987

exit_message:

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

id: 6408999

payload:

{
    "datatype_dict": {
        "active": "varchar(25)",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "partner_group": "varchar(25)",
        "site_channel_type": "varchar(25)",
        "site_group": "varchar(25)",
        "site_key": "int",
        "site_type": "varchar(25)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_dim_partner_group/2026-04-04/1775290951/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_partner_group/2026-04-04/1775290951",
        "key": "raw/reference_dim_partner_group/2026-04-04/1775290951/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_partner_group",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 6037847592154012220,
        "service_name": "redshift_unloads",
        "span_id": 7285777850377217642,
        "trace_id": 4572433178099298771
    }
}

running: False
schema_name_id: 527
start_time: 2026-04-04 03:22:44
success: True
trace_id: 4572433178099298771

Scan 6408513

duration: 0:00:14.332380

exit_message:

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

id: 6408513

payload:

{
    "datatype_dict": {
        "active": "varchar(25)",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "partner_group": "varchar(25)",
        "site_channel_type": "varchar(25)",
        "site_group": "varchar(25)",
        "site_key": "int",
        "site_type": "varchar(25)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_dim_partner_group/2026-04-03/1775205816/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_partner_group/2026-04-03/1775205816",
        "key": "raw/reference_dim_partner_group/2026-04-03/1775205816/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_partner_group",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 819217652879831940,
        "service_name": "redshift_unloads",
        "span_id": 17542711546209245318,
        "trace_id": 17105680104156978191
    }
}

running: False
schema_name_id: 527
start_time: 2026-04-03 03:43:48
success: True
trace_id: 17105680104156978191

Partitions:

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

Schema:

attributes:

{
    "_origin": "string",
    "active": "varchar(25)",
    "audit_id": "bigint",
    "partner_group": "varchar(25)",
    "site_channel_type": "varchar(25)",
    "site_group": "varchar(25)",
    "site_key": "int",
    "site_type": "varchar(25)"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_dim_partner_group`\n(\n `audit_id`  bigint , `site_key`  int , `site_channel_type`  varchar(25) , `site_type`  varchar(25) , `partner_group`  varchar(25) , `active`  varchar(25) , `site_group`  varchar(25) , `_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/reference_dim_partner_group/2026-04-17/1776415498'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_partner_group`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_partner_group"
}

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-05-09 11:00:16",
        "disabled": false,
        "format": "raw",
        "id": 527,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_redshift",
            "table": "analytics_reference_dim_partner_group"
        },
        "type": "redshift"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "_origin": "string",
            "active": "varchar(25)",
            "audit_id": "bigint",
            "partner_group": "varchar(25)",
            "site_channel_type": "varchar(25)",
            "site_group": "varchar(25)",
            "site_key": "int",
            "site_type": "varchar(25)"
        },
        "created": "2026-04-17 03:45:12",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_dim_partner_group`\n(\n `audit_id`  bigint , `site_key`  int , `site_channel_type`  varchar(25) , `site_type`  varchar(25) , `partner_group`  varchar(25) , `active`  varchar(25) , `site_group`  varchar(25) , `_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/reference_dim_partner_group/2026-04-17/1776415498'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_partner_group`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_partner_group"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}