Schema Info

Schema Name: sfdl_prod_redshift.analytics_reference_dim_agent_roster

created: 2018-05-08 14:20:55
disabled: False
format: raw
id: 416
is_partitioned: False
is_schema_datatyped: True

name:

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

type: redshift

Schema Versions: 15

Version 1717882

created: 2026-04-17 03:32:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_agent_roster`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_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/reference_dim_agent_roster/2026-04-17/1776414742'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_agent_roster"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_agent_roster/2026-04-17/1776414742
id: 1717882
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: 416
schema_scan_id: 162167995
updated: 2026-04-17 03:32:54

Version 1716643

created: 2026-04-16 04:01:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_agent_roster`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_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/reference_dim_agent_roster/2026-04-16/1776329942'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_agent_roster"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_agent_roster/2026-04-16/1776329942
id: 1716643
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: 416
schema_scan_id: 162113231
updated: 2026-04-16 04:01:39

Version 1715434

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_agent_roster`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_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/reference_dim_agent_roster/2026-04-15/1776242069'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_agent_roster"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_agent_roster/2026-04-15/1776242069
id: 1715434
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: 416
schema_scan_id: 162056287
updated: 2026-04-15 03:34:50

Version 1714239

created: 2026-04-14 03:38:31

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_agent_roster`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_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/reference_dim_agent_roster/2026-04-14/1776155904'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_agent_roster"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_agent_roster/2026-04-14/1776155904
id: 1714239
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: 416
schema_scan_id: 162000806
updated: 2026-04-14 03:38:45

Version 1712994

created: 2026-04-13 03:37:07

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_agent_roster`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_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/reference_dim_agent_roster/2026-04-13/1776069412'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_agent_roster"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_agent_roster/2026-04-13/1776069412
id: 1712994
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: 416
schema_scan_id: 161942923
updated: 2026-04-13 03:37:21

Version 1711815

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_agent_roster`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_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/reference_dim_agent_roster/2026-04-12/1775983590'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_agent_roster"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_agent_roster/2026-04-12/1775983590
id: 1711815
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: 416
schema_scan_id: 161893622
updated: 2026-04-12 03:46:48

Version 1710638

created: 2026-04-11 03:57:30

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_agent_roster`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_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/reference_dim_agent_roster/2026-04-11/1775897819'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_agent_roster"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_agent_roster/2026-04-11/1775897819
id: 1710638
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: 416
schema_scan_id: 161841926
updated: 2026-04-11 03:57:41

Version 1709478

created: 2026-04-10 04:04:55

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_agent_roster`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_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/reference_dim_agent_roster/2026-04-10/1775811888'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_agent_roster"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_agent_roster/2026-04-10/1775811888
id: 1709478
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: 416
schema_scan_id: 161787366
updated: 2026-04-10 04:05:06

Version 1708300

created: 2026-04-09 03:28:31

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_agent_roster`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_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/reference_dim_agent_roster/2026-04-09/1775723298'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_agent_roster"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_agent_roster/2026-04-09/1775723298
id: 1708300
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: 416
schema_scan_id: 161730617
updated: 2026-04-09 03:28:45

Version 1707094

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_agent_roster`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_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/reference_dim_agent_roster/2026-04-08/1775636496'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_agent_roster"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_agent_roster/2026-04-08/1775636496
id: 1707094
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: 416
schema_scan_id: 161675792
updated: 2026-04-08 03:22:07

Version 1705934

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_agent_roster`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_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/reference_dim_agent_roster/2026-04-07/1775551793'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_agent_roster"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_agent_roster/2026-04-07/1775551793
id: 1705934
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: 416
schema_scan_id: 161619804
updated: 2026-04-07 03:50:12

Version 1704723

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_agent_roster`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_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/reference_dim_agent_roster/2026-04-06/1775466046'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_agent_roster"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_agent_roster/2026-04-06/1775466046
id: 1704723
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: 416
schema_scan_id: 161562905
updated: 2026-04-06 04:01:18

Version 1703484

created: 2026-04-05 03:42:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_agent_roster`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_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/reference_dim_agent_roster/2026-04-05/1775378567'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_agent_roster"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_agent_roster/2026-04-05/1775378567
id: 1703484
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: 416
schema_scan_id: 161515102
updated: 2026-04-05 03:43:11

Version 1702361

created: 2026-04-04 03:56:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_agent_roster`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_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/reference_dim_agent_roster/2026-04-04/1775292992'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_agent_roster"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_agent_roster/2026-04-04/1775292992
id: 1702361
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: 416
schema_scan_id: 161461093
updated: 2026-04-04 03:57:01

Version 1701123

created: 2026-04-03 03:34:16

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_agent_roster`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_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/reference_dim_agent_roster/2026-04-03/1775205248'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_agent_roster"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_agent_roster/2026-04-03/1775205248
id: 1701123
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: 416
schema_scan_id: 161402148
updated: 2026-04-03 03:34:28

Schema Scans: 15

Last at 2026-04-17 03:32:40

Scan 162167995

duration: 0:00:14.230369

exit_message:

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

id: 162167995

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/reference_dim_agent_roster/2026-04-17/1776414742/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_agent_roster/2026-04-17/1776414742",
        "key": "raw/reference_dim_agent_roster/2026-04-17/1776414742/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_agent_roster",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 17434046950763580417,
        "service_name": "redshift_unloads",
        "span_id": 11046148972081036593,
        "trace_id": 13061339386426354628
    }
}

running: False
schema_name_id: 416
start_time: 2026-04-17 03:32:40
success: True
trace_id: 13061339386426354628

Scan 162113231

duration: 0:00:14.199610

exit_message:

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

id: 162113231

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/reference_dim_agent_roster/2026-04-16/1776329942/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_agent_roster/2026-04-16/1776329942",
        "key": "raw/reference_dim_agent_roster/2026-04-16/1776329942/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_agent_roster",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 10977614504168444326,
        "service_name": "redshift_unloads",
        "span_id": 13370577867581474453,
        "trace_id": 2201119250376795978
    }
}

running: False
schema_name_id: 416
start_time: 2026-04-16 04:01:25
success: True
trace_id: 2201119250376795978

Scan 162056287

duration: 0:00:14.219304

exit_message:

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

id: 162056287

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/reference_dim_agent_roster/2026-04-15/1776242069/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_agent_roster/2026-04-15/1776242069",
        "key": "raw/reference_dim_agent_roster/2026-04-15/1776242069/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_agent_roster",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 6557835528838054064,
        "service_name": "redshift_unloads",
        "span_id": 18389112810635155350,
        "trace_id": 12425610576079648937
    }
}

running: False
schema_name_id: 416
start_time: 2026-04-15 03:34:36
success: True
trace_id: 12425610576079648937

Scan 162000806

duration: 0:00:14.215797

exit_message:

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

id: 162000806

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/reference_dim_agent_roster/2026-04-14/1776155904/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_agent_roster/2026-04-14/1776155904",
        "key": "raw/reference_dim_agent_roster/2026-04-14/1776155904/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_agent_roster",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 5723225892892880598,
        "service_name": "redshift_unloads",
        "span_id": 5780571981238283488,
        "trace_id": 14229912986612218274
    }
}

running: False
schema_name_id: 416
start_time: 2026-04-14 03:38:31
success: True
trace_id: 14229912986612218274

Scan 161942923

duration: 0:00:14.206897

exit_message:

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

id: 161942923

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/reference_dim_agent_roster/2026-04-13/1776069412/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_agent_roster/2026-04-13/1776069412",
        "key": "raw/reference_dim_agent_roster/2026-04-13/1776069412/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_agent_roster",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13407611956538360572,
        "service_name": "redshift_unloads",
        "span_id": 16317882488121884058,
        "trace_id": 5615342236129297774
    }
}

running: False
schema_name_id: 416
start_time: 2026-04-13 03:37:07
success: True
trace_id: 5615342236129297774

Scan 161893622

duration: 0:00:11.619786

exit_message:

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

id: 161893622

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/reference_dim_agent_roster/2026-04-12/1775983590/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_agent_roster/2026-04-12/1775983590",
        "key": "raw/reference_dim_agent_roster/2026-04-12/1775983590/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_agent_roster",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15670441181262118977,
        "service_name": "redshift_unloads",
        "span_id": 7488451277129100053,
        "trace_id": 17664749114093448787
    }
}

running: False
schema_name_id: 416
start_time: 2026-04-12 03:46:36
success: True
trace_id: 17664749114093448787

Scan 161841926

duration: 0:00:11.583572

exit_message:

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

id: 161841926

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/reference_dim_agent_roster/2026-04-11/1775897819/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_agent_roster/2026-04-11/1775897819",
        "key": "raw/reference_dim_agent_roster/2026-04-11/1775897819/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_agent_roster",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 10079742820865505454,
        "service_name": "redshift_unloads",
        "span_id": 18122133504594342664,
        "trace_id": 12057928525721685606
    }
}

running: False
schema_name_id: 416
start_time: 2026-04-11 03:57:30
success: True
trace_id: 12057928525721685606

Scan 161787366

duration: 0:00:11.721551

exit_message:

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

id: 161787366

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/reference_dim_agent_roster/2026-04-10/1775811888/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_agent_roster/2026-04-10/1775811888",
        "key": "raw/reference_dim_agent_roster/2026-04-10/1775811888/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_agent_roster",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13652309635971840560,
        "service_name": "redshift_unloads",
        "span_id": 4471420098844038120,
        "trace_id": 939601879084587960
    }
}

running: False
schema_name_id: 416
start_time: 2026-04-10 04:04:55
success: True
trace_id: 939601879084587960

Scan 161730617

duration: 0:00:14.280033

exit_message:

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

id: 161730617

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/reference_dim_agent_roster/2026-04-09/1775723298/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_agent_roster/2026-04-09/1775723298",
        "key": "raw/reference_dim_agent_roster/2026-04-09/1775723298/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_agent_roster",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 6955484381156703058,
        "service_name": "redshift_unloads",
        "span_id": 13899933787567927709,
        "trace_id": 8969790281847718030
    }
}

running: False
schema_name_id: 416
start_time: 2026-04-09 03:28:30
success: True
trace_id: 8969790281847718030

Scan 161675792

duration: 0:00:14.208536

exit_message:

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

id: 161675792

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/reference_dim_agent_roster/2026-04-08/1775636496/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_agent_roster/2026-04-08/1775636496",
        "key": "raw/reference_dim_agent_roster/2026-04-08/1775636496/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_agent_roster",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 4000974613800576093,
        "service_name": "redshift_unloads",
        "span_id": 14772651182966150191,
        "trace_id": 10279435031403230650
    }
}

running: False
schema_name_id: 416
start_time: 2026-04-08 03:21:53
success: True
trace_id: 10279435031403230650

Scan 161619804

duration: 0:00:11.729026

exit_message:

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

id: 161619804

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/reference_dim_agent_roster/2026-04-07/1775551793/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_agent_roster/2026-04-07/1775551793",
        "key": "raw/reference_dim_agent_roster/2026-04-07/1775551793/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_agent_roster",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 11633083056416487376,
        "service_name": "redshift_unloads",
        "span_id": 11591082882456014779,
        "trace_id": 1178762326894908206
    }
}

running: False
schema_name_id: 416
start_time: 2026-04-07 03:50:00
success: True
trace_id: 1178762326894908206

Scan 161562905

duration: 0:00:14.283555

exit_message:

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

id: 161562905

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/reference_dim_agent_roster/2026-04-06/1775466046/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_agent_roster/2026-04-06/1775466046",
        "key": "raw/reference_dim_agent_roster/2026-04-06/1775466046/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_agent_roster",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 11768168448541916481,
        "service_name": "redshift_unloads",
        "span_id": 12205522366896304946,
        "trace_id": 7293807072085314547
    }
}

running: False
schema_name_id: 416
start_time: 2026-04-06 04:01:03
success: True
trace_id: 7293807072085314547

Scan 161515102

duration: 0:00:14.295452

exit_message:

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

id: 161515102

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/reference_dim_agent_roster/2026-04-05/1775378567/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_agent_roster/2026-04-05/1775378567",
        "key": "raw/reference_dim_agent_roster/2026-04-05/1775378567/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_agent_roster",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 5974654703112706290,
        "service_name": "redshift_unloads",
        "span_id": 6035684343269492462,
        "trace_id": 11221544189978242695
    }
}

running: False
schema_name_id: 416
start_time: 2026-04-05 03:42:56
success: True
trace_id: 11221544189978242695

Scan 161461093

duration: 0:00:14.219451

exit_message:

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

id: 161461093

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/reference_dim_agent_roster/2026-04-04/1775292992/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_agent_roster/2026-04-04/1775292992",
        "key": "raw/reference_dim_agent_roster/2026-04-04/1775292992/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_agent_roster",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 1286105570401916723,
        "service_name": "redshift_unloads",
        "span_id": 5736712284648676197,
        "trace_id": 14023077223759235616
    }
}

running: False
schema_name_id: 416
start_time: 2026-04-04 03:56:47
success: True
trace_id: 14023077223759235616

Scan 161402148

duration: 0:00:11.675990

exit_message:

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

id: 161402148

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/reference_dim_agent_roster/2026-04-03/1775205248/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_agent_roster/2026-04-03/1775205248",
        "key": "raw/reference_dim_agent_roster/2026-04-03/1775205248/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_agent_roster",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 9616405627496405551,
        "service_name": "redshift_unloads",
        "span_id": 3403131754314772792,
        "trace_id": 1833121090571831597
    }
}

running: False
schema_name_id: 416
start_time: 2026-04-03 03:34:16
success: True
trace_id: 1833121090571831597

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:32:40

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_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/reference_dim_agent_roster/2026-04-17/1776414742'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_agent_roster`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_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-05-08 14:20:55",
        "disabled": false,
        "format": "raw",
        "id": 416,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_redshift",
            "table": "analytics_reference_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:32:40",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_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/reference_dim_agent_roster/2026-04-17/1776414742'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_agent_roster`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_agent_roster"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}