Schema Info

Schema Name: sfdl_prod_redshift.analytics_dwh_dim_agent_roster

created: 2018-10-19 15:16:39
disabled: False
format: raw
id: 559
is_partitioned: False
is_schema_datatyped: True

name:

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

type: redshift

Schema Versions: 15

Version 1717866

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_agent_roster`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_agent_roster`\n(\n `audit_id`  bigint , `user_key`  int , `agent_team_name`  varchar(200) , `agent_start_day`  date , `agent_office`  varchar(30) , `agent_no`  varchar(30) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_agent_roster/2026-04-17/1776413984'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_agent_roster"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_agent_roster/2026-04-17/1776413984
id: 1717866
processed: 1

raw_data:

{
    "_origin": "6",
    "agent_no": "5",
    "agent_office": "4",
    "agent_start_day": "3",
    "agent_team_name": "2",
    "audit_id": "0",
    "user_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "agent_no": "varchar(30)",
    "agent_office": "varchar(30)",
    "agent_start_day": "date",
    "agent_team_name": "varchar(200)",
    "audit_id": "bigint",
    "user_key": "int"
}

schema_name_id: 559
schema_scan_id: 162167912
updated: 2026-04-17 03:20:13

Version 1716661

created: 2026-04-16 04:09:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_agent_roster`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_agent_roster`\n(\n `audit_id`  bigint , `user_key`  int , `agent_team_name`  varchar(200) , `agent_start_day`  date , `agent_office`  varchar(30) , `agent_no`  varchar(30) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_agent_roster/2026-04-16/1776330564'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_agent_roster"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_agent_roster/2026-04-16/1776330564
id: 1716661
processed: 1

raw_data:

{
    "_origin": "6",
    "agent_no": "5",
    "agent_office": "4",
    "agent_start_day": "3",
    "agent_team_name": "2",
    "audit_id": "0",
    "user_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "agent_no": "varchar(30)",
    "agent_office": "varchar(30)",
    "agent_start_day": "date",
    "agent_team_name": "varchar(200)",
    "audit_id": "bigint",
    "user_key": "int"
}

schema_name_id: 559
schema_scan_id: 162113317
updated: 2026-04-16 04:09:50

Version 1715422

created: 2026-04-15 03:32:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_agent_roster`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_agent_roster`\n(\n `audit_id`  bigint , `user_key`  int , `agent_team_name`  varchar(200) , `agent_start_day`  date , `agent_office`  varchar(30) , `agent_no`  varchar(30) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_agent_roster/2026-04-15/1776241931'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_agent_roster"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_agent_roster/2026-04-15/1776241931
id: 1715422
processed: 1

raw_data:

{
    "_origin": "6",
    "agent_no": "5",
    "agent_office": "4",
    "agent_start_day": "3",
    "agent_team_name": "2",
    "audit_id": "0",
    "user_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "agent_no": "varchar(30)",
    "agent_office": "varchar(30)",
    "agent_start_day": "date",
    "agent_team_name": "varchar(200)",
    "audit_id": "bigint",
    "user_key": "int"
}

schema_name_id: 559
schema_scan_id: 162056272
updated: 2026-04-15 03:32:46

Version 1714249

created: 2026-04-14 03:41:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_agent_roster`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_agent_roster`\n(\n `audit_id`  bigint , `user_key`  int , `agent_team_name`  varchar(200) , `agent_start_day`  date , `agent_office`  varchar(30) , `agent_no`  varchar(30) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_agent_roster/2026-04-14/1776156086'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_agent_roster"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_agent_roster/2026-04-14/1776156086
id: 1714249
processed: 1

raw_data:

{
    "_origin": "6",
    "agent_no": "5",
    "agent_office": "4",
    "agent_start_day": "3",
    "agent_team_name": "2",
    "audit_id": "0",
    "user_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "agent_no": "varchar(30)",
    "agent_office": "varchar(30)",
    "agent_start_day": "date",
    "agent_team_name": "varchar(200)",
    "audit_id": "bigint",
    "user_key": "int"
}

schema_name_id: 559
schema_scan_id: 162000817
updated: 2026-04-14 03:41:47

Version 1713004

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_agent_roster`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_agent_roster`\n(\n `audit_id`  bigint , `user_key`  int , `agent_team_name`  varchar(200) , `agent_start_day`  date , `agent_office`  varchar(30) , `agent_no`  varchar(30) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_agent_roster/2026-04-13/1776069555'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_agent_roster"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_agent_roster/2026-04-13/1776069555
id: 1713004
processed: 1

raw_data:

{
    "_origin": "6",
    "agent_no": "5",
    "agent_office": "4",
    "agent_start_day": "3",
    "agent_team_name": "2",
    "audit_id": "0",
    "user_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "agent_no": "varchar(30)",
    "agent_office": "varchar(30)",
    "agent_start_day": "date",
    "agent_team_name": "varchar(200)",
    "audit_id": "bigint",
    "user_key": "int"
}

schema_name_id: 559
schema_scan_id: 161942939
updated: 2026-04-13 03:39:35

Version 1711811

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_agent_roster`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_agent_roster`\n(\n `audit_id`  bigint , `user_key`  int , `agent_team_name`  varchar(200) , `agent_start_day`  date , `agent_office`  varchar(30) , `agent_no`  varchar(30) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_agent_roster/2026-04-12/1775983548'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_agent_roster"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_agent_roster/2026-04-12/1775983548
id: 1711811
processed: 1

raw_data:

{
    "_origin": "6",
    "agent_no": "5",
    "agent_office": "4",
    "agent_start_day": "3",
    "agent_team_name": "2",
    "audit_id": "0",
    "user_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "agent_no": "varchar(30)",
    "agent_office": "varchar(30)",
    "agent_start_day": "date",
    "agent_team_name": "varchar(200)",
    "audit_id": "bigint",
    "user_key": "int"
}

schema_name_id: 559
schema_scan_id: 161893610
updated: 2026-04-12 03:46:07

Version 1710629

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_agent_roster`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_agent_roster`\n(\n `audit_id`  bigint , `user_key`  int , `agent_team_name`  varchar(200) , `agent_start_day`  date , `agent_office`  varchar(30) , `agent_no`  varchar(30) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_agent_roster/2026-04-11/1775897188'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_agent_roster"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_agent_roster/2026-04-11/1775897188
id: 1710629
processed: 1

raw_data:

{
    "_origin": "6",
    "agent_no": "5",
    "agent_office": "4",
    "agent_start_day": "3",
    "agent_team_name": "2",
    "audit_id": "0",
    "user_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "agent_no": "varchar(30)",
    "agent_office": "varchar(30)",
    "agent_start_day": "date",
    "agent_team_name": "varchar(200)",
    "audit_id": "bigint",
    "user_key": "int"
}

schema_name_id: 559
schema_scan_id: 161841488
updated: 2026-04-11 03:46:49

Version 1709465

created: 2026-04-10 04:02:30

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_agent_roster`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_agent_roster`\n(\n `audit_id`  bigint , `user_key`  int , `agent_team_name`  varchar(200) , `agent_start_day`  date , `agent_office`  varchar(30) , `agent_no`  varchar(30) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_agent_roster/2026-04-10/1775811739'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_agent_roster"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_agent_roster/2026-04-10/1775811739
id: 1709465
processed: 1

raw_data:

{
    "_origin": "6",
    "agent_no": "5",
    "agent_office": "4",
    "agent_start_day": "3",
    "agent_team_name": "2",
    "audit_id": "0",
    "user_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "agent_no": "varchar(30)",
    "agent_office": "varchar(30)",
    "agent_start_day": "date",
    "agent_team_name": "varchar(200)",
    "audit_id": "bigint",
    "user_key": "int"
}

schema_name_id: 559
schema_scan_id: 161787349
updated: 2026-04-10 04:02:42

Version 1708309

created: 2026-04-09 03:29:56

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_agent_roster`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_agent_roster`\n(\n `audit_id`  bigint , `user_key`  int , `agent_team_name`  varchar(200) , `agent_start_day`  date , `agent_office`  varchar(30) , `agent_no`  varchar(30) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_agent_roster/2026-04-09/1775723380'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_agent_roster"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_agent_roster/2026-04-09/1775723380
id: 1708309
processed: 1

raw_data:

{
    "_origin": "6",
    "agent_no": "5",
    "agent_office": "4",
    "agent_start_day": "3",
    "agent_team_name": "2",
    "audit_id": "0",
    "user_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "agent_no": "varchar(30)",
    "agent_office": "varchar(30)",
    "agent_start_day": "date",
    "agent_team_name": "varchar(200)",
    "audit_id": "bigint",
    "user_key": "int"
}

schema_name_id: 559
schema_scan_id: 161730627
updated: 2026-04-09 03:30:09

Version 1707150

created: 2026-04-08 04:06:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_agent_roster`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_agent_roster`\n(\n `audit_id`  bigint , `user_key`  int , `agent_team_name`  varchar(200) , `agent_start_day`  date , `agent_office`  varchar(30) , `agent_no`  varchar(30) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_agent_roster/2026-04-08/1775639167'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_agent_roster"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_agent_roster/2026-04-08/1775639167
id: 1707150
processed: 1

raw_data:

{
    "_origin": "6",
    "agent_no": "5",
    "agent_office": "4",
    "agent_start_day": "3",
    "agent_team_name": "2",
    "audit_id": "0",
    "user_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "agent_no": "varchar(30)",
    "agent_office": "varchar(30)",
    "agent_start_day": "date",
    "agent_team_name": "varchar(200)",
    "audit_id": "bigint",
    "user_key": "int"
}

schema_name_id: 559
schema_scan_id: 161677007
updated: 2026-04-08 04:06:33

Version 1705957

created: 2026-04-07 03:55:03

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_agent_roster`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_agent_roster`\n(\n `audit_id`  bigint , `user_key`  int , `agent_team_name`  varchar(200) , `agent_start_day`  date , `agent_office`  varchar(30) , `agent_no`  varchar(30) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_agent_roster/2026-04-07/1775552076'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_agent_roster"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_agent_roster/2026-04-07/1775552076
id: 1705957
processed: 1

raw_data:

{
    "_origin": "6",
    "agent_no": "5",
    "agent_office": "4",
    "agent_start_day": "3",
    "agent_team_name": "2",
    "audit_id": "0",
    "user_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "agent_no": "varchar(30)",
    "agent_office": "varchar(30)",
    "agent_start_day": "date",
    "agent_team_name": "varchar(200)",
    "audit_id": "bigint",
    "user_key": "int"
}

schema_name_id: 559
schema_scan_id: 161619886
updated: 2026-04-07 03:55:16

Version 1704690

created: 2026-04-06 03:40:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_agent_roster`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_agent_roster`\n(\n `audit_id`  bigint , `user_key`  int , `agent_team_name`  varchar(200) , `agent_start_day`  date , `agent_office`  varchar(30) , `agent_no`  varchar(30) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_agent_roster/2026-04-06/1775464837'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_agent_roster"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_agent_roster/2026-04-06/1775464837
id: 1704690
processed: 1

raw_data:

{
    "_origin": "6",
    "agent_no": "5",
    "agent_office": "4",
    "agent_start_day": "3",
    "agent_team_name": "2",
    "audit_id": "0",
    "user_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "agent_no": "varchar(30)",
    "agent_office": "varchar(30)",
    "agent_start_day": "date",
    "agent_team_name": "varchar(200)",
    "audit_id": "bigint",
    "user_key": "int"
}

schema_name_id: 559
schema_scan_id: 161561885
updated: 2026-04-06 03:41:05

Version 1703522

created: 2026-04-05 04:04:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_agent_roster`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_agent_roster`\n(\n `audit_id`  bigint , `user_key`  int , `agent_team_name`  varchar(200) , `agent_start_day`  date , `agent_office`  varchar(30) , `agent_no`  varchar(30) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_agent_roster/2026-04-05/1775379853'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_agent_roster"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_agent_roster/2026-04-05/1775379853
id: 1703522
processed: 1

raw_data:

{
    "_origin": "6",
    "agent_no": "5",
    "agent_office": "4",
    "agent_start_day": "3",
    "agent_team_name": "2",
    "audit_id": "0",
    "user_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "agent_no": "varchar(30)",
    "agent_office": "varchar(30)",
    "agent_start_day": "date",
    "agent_team_name": "varchar(200)",
    "audit_id": "bigint",
    "user_key": "int"
}

schema_name_id: 559
schema_scan_id: 161516205
updated: 2026-04-05 04:04:36

Version 1702332

created: 2026-04-04 03:34:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_agent_roster`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_agent_roster`\n(\n `audit_id`  bigint , `user_key`  int , `agent_team_name`  varchar(200) , `agent_start_day`  date , `agent_office`  varchar(30) , `agent_no`  varchar(30) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_agent_roster/2026-04-04/1775291675'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_agent_roster"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_agent_roster/2026-04-04/1775291675
id: 1702332
processed: 1

raw_data:

{
    "_origin": "6",
    "agent_no": "5",
    "agent_office": "4",
    "agent_start_day": "3",
    "agent_team_name": "2",
    "audit_id": "0",
    "user_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "agent_no": "varchar(30)",
    "agent_office": "varchar(30)",
    "agent_start_day": "date",
    "agent_team_name": "varchar(200)",
    "audit_id": "bigint",
    "user_key": "int"
}

schema_name_id: 559
schema_scan_id: 161460703
updated: 2026-04-04 03:34:54

Version 1701134

created: 2026-04-03 03:35:27

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_agent_roster`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_agent_roster`\n(\n `audit_id`  bigint , `user_key`  int , `agent_team_name`  varchar(200) , `agent_start_day`  date , `agent_office`  varchar(30) , `agent_no`  varchar(30) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_agent_roster/2026-04-03/1775205313'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_agent_roster"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_agent_roster/2026-04-03/1775205313
id: 1701134
processed: 1

raw_data:

{
    "_origin": "6",
    "agent_no": "5",
    "agent_office": "4",
    "agent_start_day": "3",
    "agent_team_name": "2",
    "audit_id": "0",
    "user_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "agent_no": "varchar(30)",
    "agent_office": "varchar(30)",
    "agent_start_day": "date",
    "agent_team_name": "varchar(200)",
    "audit_id": "bigint",
    "user_key": "int"
}

schema_name_id: 559
schema_scan_id: 161402161
updated: 2026-04-03 03:35:38

Schema Scans: 15

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

Scan 162167912

duration: 0:00:14.292191

exit_message:

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

id: 162167912

payload:

{
    "datatype_dict": {
        "agent_no": "varchar(30)",
        "agent_office": "varchar(30)",
        "agent_start_day": "date",
        "agent_team_name": "varchar(200)",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "user_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_agent_roster/2026-04-17/1776413984/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_agent_roster/2026-04-17/1776413984",
        "key": "raw/dwh_dim_agent_roster/2026-04-17/1776413984/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_agent_roster",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 12521521386455282144,
        "service_name": "redshift_unloads",
        "span_id": 2260885815181172895,
        "trace_id": 4576364257108033921
    }
}

running: False
schema_name_id: 559
start_time: 2026-04-17 03:19:58
success: True
trace_id: 4576364257108033921

Scan 162113317

duration: 0:00:14.201963

exit_message:

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

id: 162113317

payload:

{
    "datatype_dict": {
        "agent_no": "varchar(30)",
        "agent_office": "varchar(30)",
        "agent_start_day": "date",
        "agent_team_name": "varchar(200)",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "user_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_agent_roster/2026-04-16/1776330564/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_agent_roster/2026-04-16/1776330564",
        "key": "raw/dwh_dim_agent_roster/2026-04-16/1776330564/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_agent_roster",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15501634064086537135,
        "service_name": "redshift_unloads",
        "span_id": 3032328796974765920,
        "trace_id": 7693035875815873577
    }
}

running: False
schema_name_id: 559
start_time: 2026-04-16 04:09:36
success: True
trace_id: 7693035875815873577

Scan 162056272

duration: 0:00:11.664327

exit_message:

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

id: 162056272

payload:

{
    "datatype_dict": {
        "agent_no": "varchar(30)",
        "agent_office": "varchar(30)",
        "agent_start_day": "date",
        "agent_team_name": "varchar(200)",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "user_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_agent_roster/2026-04-15/1776241931/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_agent_roster/2026-04-15/1776241931",
        "key": "raw/dwh_dim_agent_roster/2026-04-15/1776241931/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_agent_roster",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 6786397239080651273,
        "service_name": "redshift_unloads",
        "span_id": 16984325189908023653,
        "trace_id": 17102094437475730215
    }
}

running: False
schema_name_id: 559
start_time: 2026-04-15 03:32:35
success: True
trace_id: 17102094437475730215

Scan 162000817

duration: 0:00:14.207441

exit_message:

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

id: 162000817

payload:

{
    "datatype_dict": {
        "agent_no": "varchar(30)",
        "agent_office": "varchar(30)",
        "agent_start_day": "date",
        "agent_team_name": "varchar(200)",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "user_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_agent_roster/2026-04-14/1776156086/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_agent_roster/2026-04-14/1776156086",
        "key": "raw/dwh_dim_agent_roster/2026-04-14/1776156086/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_agent_roster",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 6530280423908056464,
        "service_name": "redshift_unloads",
        "span_id": 14684399656699581514,
        "trace_id": 6990996499530758031
    }
}

running: False
schema_name_id: 559
start_time: 2026-04-14 03:41:33
success: True
trace_id: 6990996499530758031

Scan 161942939

duration: 0:00:14.160226

exit_message:

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

id: 161942939

payload:

{
    "datatype_dict": {
        "agent_no": "varchar(30)",
        "agent_office": "varchar(30)",
        "agent_start_day": "date",
        "agent_team_name": "varchar(200)",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "user_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_agent_roster/2026-04-13/1776069555/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_agent_roster/2026-04-13/1776069555",
        "key": "raw/dwh_dim_agent_roster/2026-04-13/1776069555/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_agent_roster",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8410722125543922173,
        "service_name": "redshift_unloads",
        "span_id": 3952106817529363153,
        "trace_id": 6519624473965584355
    }
}

running: False
schema_name_id: 559
start_time: 2026-04-13 03:39:21
success: True
trace_id: 6519624473965584355

Scan 161893610

duration: 0:00:11.679731

exit_message:

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

id: 161893610

payload:

{
    "datatype_dict": {
        "agent_no": "varchar(30)",
        "agent_office": "varchar(30)",
        "agent_start_day": "date",
        "agent_team_name": "varchar(200)",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "user_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_agent_roster/2026-04-12/1775983548/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_agent_roster/2026-04-12/1775983548",
        "key": "raw/dwh_dim_agent_roster/2026-04-12/1775983548/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_agent_roster",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8507296703964288663,
        "service_name": "redshift_unloads",
        "span_id": 6004531550301089535,
        "trace_id": 7633705595799958316
    }
}

running: False
schema_name_id: 559
start_time: 2026-04-12 03:45:56
success: True
trace_id: 7633705595799958316

Scan 161841488

duration: 0:00:14.117225

exit_message:

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

id: 161841488

payload:

{
    "datatype_dict": {
        "agent_no": "varchar(30)",
        "agent_office": "varchar(30)",
        "agent_start_day": "date",
        "agent_team_name": "varchar(200)",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "user_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_agent_roster/2026-04-11/1775897188/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_agent_roster/2026-04-11/1775897188",
        "key": "raw/dwh_dim_agent_roster/2026-04-11/1775897188/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_agent_roster",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 16581832269486807957,
        "service_name": "redshift_unloads",
        "span_id": 5852677082722165811,
        "trace_id": 1201863367403475512
    }
}

running: False
schema_name_id: 559
start_time: 2026-04-11 03:46:35
success: True
trace_id: 1201863367403475512

Scan 161787349

duration: 0:00:11.832127

exit_message:

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

id: 161787349

payload:

{
    "datatype_dict": {
        "agent_no": "varchar(30)",
        "agent_office": "varchar(30)",
        "agent_start_day": "date",
        "agent_team_name": "varchar(200)",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "user_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_agent_roster/2026-04-10/1775811739/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_agent_roster/2026-04-10/1775811739",
        "key": "raw/dwh_dim_agent_roster/2026-04-10/1775811739/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_agent_roster",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 4423843175789325574,
        "service_name": "redshift_unloads",
        "span_id": 12453759987948617968,
        "trace_id": 14894009035939569473
    }
}

running: False
schema_name_id: 559
start_time: 2026-04-10 04:02:30
success: True
trace_id: 14894009035939569473

Scan 161730627

duration: 0:00:14.295639

exit_message:

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

id: 161730627

payload:

{
    "datatype_dict": {
        "agent_no": "varchar(30)",
        "agent_office": "varchar(30)",
        "agent_start_day": "date",
        "agent_team_name": "varchar(200)",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "user_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_agent_roster/2026-04-09/1775723380/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_agent_roster/2026-04-09/1775723380",
        "key": "raw/dwh_dim_agent_roster/2026-04-09/1775723380/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_agent_roster",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 11306792840855936992,
        "service_name": "redshift_unloads",
        "span_id": 1605880869795923535,
        "trace_id": 5549804017943943767
    }
}

running: False
schema_name_id: 559
start_time: 2026-04-09 03:29:55
success: True
trace_id: 5549804017943943767

Scan 161677007

duration: 0:00:14.409173

exit_message:

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

id: 161677007

payload:

{
    "datatype_dict": {
        "agent_no": "varchar(30)",
        "agent_office": "varchar(30)",
        "agent_start_day": "date",
        "agent_team_name": "varchar(200)",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "user_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_agent_roster/2026-04-08/1775639167/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_agent_roster/2026-04-08/1775639167",
        "key": "raw/dwh_dim_agent_roster/2026-04-08/1775639167/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_agent_roster",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 6895252805573058471,
        "service_name": "redshift_unloads",
        "span_id": 7244839498292057053,
        "trace_id": 11503837097714228924
    }
}

running: False
schema_name_id: 559
start_time: 2026-04-08 04:06:18
success: True
trace_id: 11503837097714228924

Scan 161619886

duration: 0:00:14.264470

exit_message:

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

id: 161619886

payload:

{
    "datatype_dict": {
        "agent_no": "varchar(30)",
        "agent_office": "varchar(30)",
        "agent_start_day": "date",
        "agent_team_name": "varchar(200)",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "user_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_agent_roster/2026-04-07/1775552076/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_agent_roster/2026-04-07/1775552076",
        "key": "raw/dwh_dim_agent_roster/2026-04-07/1775552076/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_agent_roster",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 14962194458781696579,
        "service_name": "redshift_unloads",
        "span_id": 11417209437959097026,
        "trace_id": 12471578138444751423
    }
}

running: False
schema_name_id: 559
start_time: 2026-04-07 03:55:02
success: True
trace_id: 12471578138444751423

Scan 161561885

duration: 0:00:11.739297

exit_message:

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

id: 161561885

payload:

{
    "datatype_dict": {
        "agent_no": "varchar(30)",
        "agent_office": "varchar(30)",
        "agent_start_day": "date",
        "agent_team_name": "varchar(200)",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "user_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_agent_roster/2026-04-06/1775464837/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_agent_roster/2026-04-06/1775464837",
        "key": "raw/dwh_dim_agent_roster/2026-04-06/1775464837/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_agent_roster",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 14589373310090588918,
        "service_name": "redshift_unloads",
        "span_id": 1825080008441365828,
        "trace_id": 4531941715755156393
    }
}

running: False
schema_name_id: 559
start_time: 2026-04-06 03:40:54
success: True
trace_id: 4531941715755156393

Scan 161516205

duration: 0:00:11.815755

exit_message:

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

id: 161516205

payload:

{
    "datatype_dict": {
        "agent_no": "varchar(30)",
        "agent_office": "varchar(30)",
        "agent_start_day": "date",
        "agent_team_name": "varchar(200)",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "user_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_agent_roster/2026-04-05/1775379853/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_agent_roster/2026-04-05/1775379853",
        "key": "raw/dwh_dim_agent_roster/2026-04-05/1775379853/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_agent_roster",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 1148831814894153140,
        "service_name": "redshift_unloads",
        "span_id": 9459454277289374570,
        "trace_id": 2629993882899867495
    }
}

running: False
schema_name_id: 559
start_time: 2026-04-05 04:04:25
success: True
trace_id: 2629993882899867495

Scan 161460703

duration: 0:00:11.719369

exit_message:

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

id: 161460703

payload:

{
    "datatype_dict": {
        "agent_no": "varchar(30)",
        "agent_office": "varchar(30)",
        "agent_start_day": "date",
        "agent_team_name": "varchar(200)",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "user_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_agent_roster/2026-04-04/1775291675/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_agent_roster/2026-04-04/1775291675",
        "key": "raw/dwh_dim_agent_roster/2026-04-04/1775291675/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_agent_roster",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13301470087530140531,
        "service_name": "redshift_unloads",
        "span_id": 17230407695176641591,
        "trace_id": 6047451152056646456
    }
}

running: False
schema_name_id: 559
start_time: 2026-04-04 03:34:43
success: True
trace_id: 6047451152056646456

Scan 161402161

duration: 0:00:11.668893

exit_message:

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

id: 161402161

payload:

{
    "datatype_dict": {
        "agent_no": "varchar(30)",
        "agent_office": "varchar(30)",
        "agent_start_day": "date",
        "agent_team_name": "varchar(200)",
        "audit_id": "bigint",
        "origin_key": "varchar",
        "user_key": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_agent_roster/2026-04-03/1775205313/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_agent_roster/2026-04-03/1775205313",
        "key": "raw/dwh_dim_agent_roster/2026-04-03/1775205313/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_agent_roster",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13279645377887918535,
        "service_name": "redshift_unloads",
        "span_id": 3239054298994259123,
        "trace_id": 5066005345884128346
    }
}

running: False
schema_name_id: 559
start_time: 2026-04-03 03:35:27
success: True
trace_id: 5066005345884128346

Partitions:

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

Schema:

attributes:

{
    "_origin": "string",
    "agent_no": "varchar(30)",
    "agent_office": "varchar(30)",
    "agent_start_day": "date",
    "agent_team_name": "varchar(200)",
    "audit_id": "bigint",
    "user_key": "int"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_agent_roster`\n(\n `audit_id`  bigint , `user_key`  int , `agent_team_name`  varchar(200) , `agent_start_day`  date , `agent_office`  varchar(30) , `agent_no`  varchar(30) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_agent_roster/2026-04-17/1776413984'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_agent_roster`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_agent_roster"
}

Server:

hostname: schemamanager-5475496c57-7dpqb
name: schema_manager
process_start: 2026-01-09 11:27:47
sf_env: prod
version: 2112174301

Raw:

{
    "name": {
        "created": "2018-10-19 15:16:39",
        "disabled": false,
        "format": "raw",
        "id": 559,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_redshift",
            "table": "analytics_dwh_dim_agent_roster"
        },
        "type": "redshift"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "_origin": "string",
            "agent_no": "varchar(30)",
            "agent_office": "varchar(30)",
            "agent_start_day": "date",
            "agent_team_name": "varchar(200)",
            "audit_id": "bigint",
            "user_key": "int"
        },
        "created": "2026-04-17 03:19:59",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_agent_roster`\n(\n `audit_id`  bigint , `user_key`  int , `agent_team_name`  varchar(200) , `agent_start_day`  date , `agent_office`  varchar(30) , `agent_no`  varchar(30) , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-prod/raw/dwh_dim_agent_roster/2026-04-17/1776413984'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_agent_roster`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_agent_roster"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}