Schema Info

Schema Name: sfdl_prod_redshift.analytics_reference_dim_call_disposition

created: 2018-05-08 15:04:04
disabled: False
format: raw
id: 423
is_partitioned: False
is_schema_datatyped: True

name:

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

type: redshift

Schema Versions: 15

Version 1717844

created: 2026-04-17 03:18:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_call_disposition`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_call_disposition`\n(\n `audit_id`  bigint , `disposition_reason_key`  int , `calltype`  varchar(25) , `sales_outcome`  varchar(25) , `disposition_reason`  varchar(300) , `is_active`  int , `_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_call_disposition/2026-04-17/1776413895'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_call_disposition"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_call_disposition/2026-04-17/1776413895
id: 1717844
processed: 1

raw_data:

{
    "_origin": "6",
    "audit_id": "0",
    "calltype": "2",
    "disposition_reason": "4",
    "disposition_reason_key": "1",
    "is_active": "5",
    "sales_outcome": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "calltype": "varchar(25)",
    "disposition_reason": "varchar(300)",
    "disposition_reason_key": "int",
    "is_active": "int",
    "sales_outcome": "varchar(25)"
}

schema_name_id: 423
schema_scan_id: 162167890
updated: 2026-04-17 03:18:34

Version 1716613

created: 2026-04-16 03:38:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_call_disposition`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_call_disposition`\n(\n `audit_id`  bigint , `disposition_reason_key`  int , `calltype`  varchar(25) , `sales_outcome`  varchar(25) , `disposition_reason`  varchar(300) , `is_active`  int , `_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_call_disposition/2026-04-16/1776328707'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_call_disposition"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_call_disposition/2026-04-16/1776328707
id: 1716613
processed: 1

raw_data:

{
    "_origin": "6",
    "audit_id": "0",
    "calltype": "2",
    "disposition_reason": "4",
    "disposition_reason_key": "1",
    "is_active": "5",
    "sales_outcome": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "calltype": "varchar(25)",
    "disposition_reason": "varchar(300)",
    "disposition_reason_key": "int",
    "is_active": "int",
    "sales_outcome": "varchar(25)"
}

schema_name_id: 423
schema_scan_id: 162112153
updated: 2026-04-16 03:38:54

Version 1715579

created: 2026-04-15 04:01:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_call_disposition`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_call_disposition`\n(\n `audit_id`  bigint , `disposition_reason_key`  int , `calltype`  varchar(25) , `sales_outcome`  varchar(25) , `disposition_reason`  varchar(300) , `is_active`  int , `_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_call_disposition/2026-04-15/1776243652'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_call_disposition"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_call_disposition/2026-04-15/1776243652
id: 1715579
processed: 1

raw_data:

{
    "_origin": "6",
    "audit_id": "0",
    "calltype": "2",
    "disposition_reason": "4",
    "disposition_reason_key": "1",
    "is_active": "5",
    "sales_outcome": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "calltype": "varchar(25)",
    "disposition_reason": "varchar(300)",
    "disposition_reason_key": "int",
    "is_active": "int",
    "sales_outcome": "varchar(25)"
}

schema_name_id: 423
schema_scan_id: 162057547
updated: 2026-04-15 04:02:03

Version 1714268

created: 2026-04-14 03:58:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_call_disposition`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_call_disposition`\n(\n `audit_id`  bigint , `disposition_reason_key`  int , `calltype`  varchar(25) , `sales_outcome`  varchar(25) , `disposition_reason`  varchar(300) , `is_active`  int , `_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_call_disposition/2026-04-14/1776157061'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_call_disposition"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_call_disposition/2026-04-14/1776157061
id: 1714268
processed: 1

raw_data:

{
    "_origin": "6",
    "audit_id": "0",
    "calltype": "2",
    "disposition_reason": "4",
    "disposition_reason_key": "1",
    "is_active": "5",
    "sales_outcome": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "calltype": "varchar(25)",
    "disposition_reason": "varchar(300)",
    "disposition_reason_key": "int",
    "is_active": "int",
    "sales_outcome": "varchar(25)"
}

schema_name_id: 423
schema_scan_id: 162001442
updated: 2026-04-14 03:58:50

Version 1713012

created: 2026-04-13 03:46:26

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_call_disposition`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_call_disposition`\n(\n `audit_id`  bigint , `disposition_reason_key`  int , `calltype`  varchar(25) , `sales_outcome`  varchar(25) , `disposition_reason`  varchar(300) , `is_active`  int , `_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_call_disposition/2026-04-13/1776069964'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_call_disposition"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_call_disposition/2026-04-13/1776069964
id: 1713012
processed: 1

raw_data:

{
    "_origin": "6",
    "audit_id": "0",
    "calltype": "2",
    "disposition_reason": "4",
    "disposition_reason_key": "1",
    "is_active": "5",
    "sales_outcome": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "calltype": "varchar(25)",
    "disposition_reason": "varchar(300)",
    "disposition_reason_key": "int",
    "is_active": "int",
    "sales_outcome": "varchar(25)"
}

schema_name_id: 423
schema_scan_id: 161942959
updated: 2026-04-13 03:46:37

Version 1711845

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_call_disposition`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_call_disposition`\n(\n `audit_id`  bigint , `disposition_reason_key`  int , `calltype`  varchar(25) , `sales_outcome`  varchar(25) , `disposition_reason`  varchar(300) , `is_active`  int , `_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_call_disposition/2026-04-12/1775984148'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_call_disposition"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_call_disposition/2026-04-12/1775984148
id: 1711845
processed: 1

raw_data:

{
    "_origin": "6",
    "audit_id": "0",
    "calltype": "2",
    "disposition_reason": "4",
    "disposition_reason_key": "1",
    "is_active": "5",
    "sales_outcome": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "calltype": "varchar(25)",
    "disposition_reason": "varchar(300)",
    "disposition_reason_key": "int",
    "is_active": "int",
    "sales_outcome": "varchar(25)"
}

schema_name_id: 423
schema_scan_id: 161893884
updated: 2026-04-12 03:56:21

Version 1710644

created: 2026-04-11 04:02:07

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_call_disposition`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_call_disposition`\n(\n `audit_id`  bigint , `disposition_reason_key`  int , `calltype`  varchar(25) , `sales_outcome`  varchar(25) , `disposition_reason`  varchar(300) , `is_active`  int , `_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_call_disposition/2026-04-11/1775898095'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_call_disposition"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_call_disposition/2026-04-11/1775898095
id: 1710644
processed: 1

raw_data:

{
    "_origin": "6",
    "audit_id": "0",
    "calltype": "2",
    "disposition_reason": "4",
    "disposition_reason_key": "1",
    "is_active": "5",
    "sales_outcome": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "calltype": "varchar(25)",
    "disposition_reason": "varchar(300)",
    "disposition_reason_key": "int",
    "is_active": "int",
    "sales_outcome": "varchar(25)"
}

schema_name_id: 423
schema_scan_id: 161842630
updated: 2026-04-11 04:02:18

Version 1709481

created: 2026-04-10 04:05:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_call_disposition`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_call_disposition`\n(\n `audit_id`  bigint , `disposition_reason_key`  int , `calltype`  varchar(25) , `sales_outcome`  varchar(25) , `disposition_reason`  varchar(300) , `is_active`  int , `_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_call_disposition/2026-04-10/1775811935'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_call_disposition"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_call_disposition/2026-04-10/1775811935
id: 1709481
processed: 1

raw_data:

{
    "_origin": "6",
    "audit_id": "0",
    "calltype": "2",
    "disposition_reason": "4",
    "disposition_reason_key": "1",
    "is_active": "5",
    "sales_outcome": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "calltype": "varchar(25)",
    "disposition_reason": "varchar(300)",
    "disposition_reason_key": "int",
    "is_active": "int",
    "sales_outcome": "varchar(25)"
}

schema_name_id: 423
schema_scan_id: 161787370
updated: 2026-04-10 04:06:00

Version 1708315

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_call_disposition`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_call_disposition`\n(\n `audit_id`  bigint , `disposition_reason_key`  int , `calltype`  varchar(25) , `sales_outcome`  varchar(25) , `disposition_reason`  varchar(300) , `is_active`  int , `_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_call_disposition/2026-04-09/1775723404'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_call_disposition"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_call_disposition/2026-04-09/1775723404
id: 1708315
processed: 1

raw_data:

{
    "_origin": "6",
    "audit_id": "0",
    "calltype": "2",
    "disposition_reason": "4",
    "disposition_reason_key": "1",
    "is_active": "5",
    "sales_outcome": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "calltype": "varchar(25)",
    "disposition_reason": "varchar(300)",
    "disposition_reason_key": "int",
    "is_active": "int",
    "sales_outcome": "varchar(25)"
}

schema_name_id: 423
schema_scan_id: 161730633
updated: 2026-04-09 03:30:29

Version 1707113

created: 2026-04-08 03:36:10

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_call_disposition`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_call_disposition`\n(\n `audit_id`  bigint , `disposition_reason_key`  int , `calltype`  varchar(25) , `sales_outcome`  varchar(25) , `disposition_reason`  varchar(300) , `is_active`  int , `_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_call_disposition/2026-04-08/1775637352'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_call_disposition"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_call_disposition/2026-04-08/1775637352
id: 1707113
processed: 1

raw_data:

{
    "_origin": "6",
    "audit_id": "0",
    "calltype": "2",
    "disposition_reason": "4",
    "disposition_reason_key": "1",
    "is_active": "5",
    "sales_outcome": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "calltype": "varchar(25)",
    "disposition_reason": "varchar(300)",
    "disposition_reason_key": "int",
    "is_active": "int",
    "sales_outcome": "varchar(25)"
}

schema_name_id: 423
schema_scan_id: 161675822
updated: 2026-04-08 03:36:21

Version 1705913

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_call_disposition`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_call_disposition`\n(\n `audit_id`  bigint , `disposition_reason_key`  int , `calltype`  varchar(25) , `sales_outcome`  varchar(25) , `disposition_reason`  varchar(300) , `is_active`  int , `_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_call_disposition/2026-04-07/1775550749'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_call_disposition"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_call_disposition/2026-04-07/1775550749
id: 1705913
processed: 1

raw_data:

{
    "_origin": "6",
    "audit_id": "0",
    "calltype": "2",
    "disposition_reason": "4",
    "disposition_reason_key": "1",
    "is_active": "5",
    "sales_outcome": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "calltype": "varchar(25)",
    "disposition_reason": "varchar(300)",
    "disposition_reason_key": "int",
    "is_active": "int",
    "sales_outcome": "varchar(25)"
}

schema_name_id: 423
schema_scan_id: 161619678
updated: 2026-04-07 03:32:48

Version 1704687

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_call_disposition`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_call_disposition`\n(\n `audit_id`  bigint , `disposition_reason_key`  int , `calltype`  varchar(25) , `sales_outcome`  varchar(25) , `disposition_reason`  varchar(300) , `is_active`  int , `_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_call_disposition/2026-04-06/1775464814'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_call_disposition"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_call_disposition/2026-04-06/1775464814
id: 1704687
processed: 1

raw_data:

{
    "_origin": "6",
    "audit_id": "0",
    "calltype": "2",
    "disposition_reason": "4",
    "disposition_reason_key": "1",
    "is_active": "5",
    "sales_outcome": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "calltype": "varchar(25)",
    "disposition_reason": "varchar(300)",
    "disposition_reason_key": "int",
    "is_active": "int",
    "sales_outcome": "varchar(25)"
}

schema_name_id: 423
schema_scan_id: 161561882
updated: 2026-04-06 03:40:39

Version 1703514

created: 2026-04-05 03:59:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_call_disposition`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_call_disposition`\n(\n `audit_id`  bigint , `disposition_reason_key`  int , `calltype`  varchar(25) , `sales_outcome`  varchar(25) , `disposition_reason`  varchar(300) , `is_active`  int , `_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_call_disposition/2026-04-05/1775379446'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_call_disposition"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_call_disposition/2026-04-05/1775379446
id: 1703514
processed: 1

raw_data:

{
    "_origin": "6",
    "audit_id": "0",
    "calltype": "2",
    "disposition_reason": "4",
    "disposition_reason_key": "1",
    "is_active": "5",
    "sales_outcome": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "calltype": "varchar(25)",
    "disposition_reason": "varchar(300)",
    "disposition_reason_key": "int",
    "is_active": "int",
    "sales_outcome": "varchar(25)"
}

schema_name_id: 423
schema_scan_id: 161515956
updated: 2026-04-05 03:59:32

Version 1702316

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_call_disposition`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_call_disposition`\n(\n `audit_id`  bigint , `disposition_reason_key`  int , `calltype`  varchar(25) , `sales_outcome`  varchar(25) , `disposition_reason`  varchar(300) , `is_active`  int , `_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_call_disposition/2026-04-04/1775291077'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_call_disposition"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_call_disposition/2026-04-04/1775291077
id: 1702316
processed: 1

raw_data:

{
    "_origin": "6",
    "audit_id": "0",
    "calltype": "2",
    "disposition_reason": "4",
    "disposition_reason_key": "1",
    "is_active": "5",
    "sales_outcome": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "calltype": "varchar(25)",
    "disposition_reason": "varchar(300)",
    "disposition_reason_key": "int",
    "is_active": "int",
    "sales_outcome": "varchar(25)"
}

schema_name_id: 423
schema_scan_id: 161460675
updated: 2026-04-04 03:25:16

Version 1701118

created: 2026-04-03 03:33:59

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_call_disposition`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_call_disposition`\n(\n `audit_id`  bigint , `disposition_reason_key`  int , `calltype`  varchar(25) , `sales_outcome`  varchar(25) , `disposition_reason`  varchar(300) , `is_active`  int , `_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_call_disposition/2026-04-03/1775205231'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_call_disposition"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_call_disposition/2026-04-03/1775205231
id: 1701118
processed: 1

raw_data:

{
    "_origin": "6",
    "audit_id": "0",
    "calltype": "2",
    "disposition_reason": "4",
    "disposition_reason_key": "1",
    "is_active": "5",
    "sales_outcome": "3"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "calltype": "varchar(25)",
    "disposition_reason": "varchar(300)",
    "disposition_reason_key": "int",
    "is_active": "int",
    "sales_outcome": "varchar(25)"
}

schema_name_id: 423
schema_scan_id: 161402143
updated: 2026-04-03 03:34:10

Schema Scans: 15

Last at 2026-04-17 03:18:22

Scan 162167890

duration: 0:00:11.812832

exit_message:

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

id: 162167890

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "calltype": "varchar(25)",
        "disposition_reason": "varchar(300)",
        "disposition_reason_key": "int",
        "is_active": "int",
        "origin_key": "varchar",
        "sales_outcome": "varchar(25)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_call_disposition/2026-04-17/1776413895/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_call_disposition/2026-04-17/1776413895",
        "key": "raw/reference_dim_call_disposition/2026-04-17/1776413895/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_call_disposition",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 1168807635370686555,
        "service_name": "redshift_unloads",
        "span_id": 17493183263605750745,
        "trace_id": 4716615518561043082
    }
}

running: False
schema_name_id: 423
start_time: 2026-04-17 03:18:22
success: True
trace_id: 4716615518561043082

Scan 162112153

duration: 0:00:14.185355

exit_message:

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

id: 162112153

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "calltype": "varchar(25)",
        "disposition_reason": "varchar(300)",
        "disposition_reason_key": "int",
        "is_active": "int",
        "origin_key": "varchar",
        "sales_outcome": "varchar(25)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_call_disposition/2026-04-16/1776328707/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_call_disposition/2026-04-16/1776328707",
        "key": "raw/reference_dim_call_disposition/2026-04-16/1776328707/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_call_disposition",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 7661006185303378055,
        "service_name": "redshift_unloads",
        "span_id": 3499483242842406191,
        "trace_id": 15458182089584412370
    }
}

running: False
schema_name_id: 423
start_time: 2026-04-16 03:38:40
success: True
trace_id: 15458182089584412370

Scan 162057547

duration: 0:00:14.219490

exit_message:

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

id: 162057547

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "calltype": "varchar(25)",
        "disposition_reason": "varchar(300)",
        "disposition_reason_key": "int",
        "is_active": "int",
        "origin_key": "varchar",
        "sales_outcome": "varchar(25)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_call_disposition/2026-04-15/1776243652/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_call_disposition/2026-04-15/1776243652",
        "key": "raw/reference_dim_call_disposition/2026-04-15/1776243652/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_call_disposition",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13959958862522308158,
        "service_name": "redshift_unloads",
        "span_id": 5153549818055742889,
        "trace_id": 1724250121338680783
    }
}

running: False
schema_name_id: 423
start_time: 2026-04-15 04:01:49
success: True
trace_id: 1724250121338680783

Scan 162001442

duration: 0:00:14.273652

exit_message:

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

id: 162001442

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "calltype": "varchar(25)",
        "disposition_reason": "varchar(300)",
        "disposition_reason_key": "int",
        "is_active": "int",
        "origin_key": "varchar",
        "sales_outcome": "varchar(25)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_call_disposition/2026-04-14/1776157061/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_call_disposition/2026-04-14/1776157061",
        "key": "raw/reference_dim_call_disposition/2026-04-14/1776157061/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_call_disposition",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 9617183138317555983,
        "service_name": "redshift_unloads",
        "span_id": 1658249867035258517,
        "trace_id": 2067688123336935050
    }
}

running: False
schema_name_id: 423
start_time: 2026-04-14 03:58:36
success: True
trace_id: 2067688123336935050

Scan 161942959

duration: 0:00:11.783791

exit_message:

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

id: 161942959

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "calltype": "varchar(25)",
        "disposition_reason": "varchar(300)",
        "disposition_reason_key": "int",
        "is_active": "int",
        "origin_key": "varchar",
        "sales_outcome": "varchar(25)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_call_disposition/2026-04-13/1776069964/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_call_disposition/2026-04-13/1776069964",
        "key": "raw/reference_dim_call_disposition/2026-04-13/1776069964/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_call_disposition",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 17026823862207770651,
        "service_name": "redshift_unloads",
        "span_id": 15755585167638578767,
        "trace_id": 9086705030482420234
    }
}

running: False
schema_name_id: 423
start_time: 2026-04-13 03:46:25
success: True
trace_id: 9086705030482420234

Scan 161893884

duration: 0:00:11.625861

exit_message:

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

id: 161893884

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "calltype": "varchar(25)",
        "disposition_reason": "varchar(300)",
        "disposition_reason_key": "int",
        "is_active": "int",
        "origin_key": "varchar",
        "sales_outcome": "varchar(25)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_call_disposition/2026-04-12/1775984148/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_call_disposition/2026-04-12/1775984148",
        "key": "raw/reference_dim_call_disposition/2026-04-12/1775984148/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_call_disposition",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8944092076631240108,
        "service_name": "redshift_unloads",
        "span_id": 10151270535849777751,
        "trace_id": 4352065266182963146
    }
}

running: False
schema_name_id: 423
start_time: 2026-04-12 03:56:10
success: True
trace_id: 4352065266182963146

Scan 161842630

duration: 0:00:11.667517

exit_message:

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

id: 161842630

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "calltype": "varchar(25)",
        "disposition_reason": "varchar(300)",
        "disposition_reason_key": "int",
        "is_active": "int",
        "origin_key": "varchar",
        "sales_outcome": "varchar(25)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_call_disposition/2026-04-11/1775898095/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_call_disposition/2026-04-11/1775898095",
        "key": "raw/reference_dim_call_disposition/2026-04-11/1775898095/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_call_disposition",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 11374762532515755132,
        "service_name": "redshift_unloads",
        "span_id": 1216014981594804145,
        "trace_id": 10938886027972105850
    }
}

running: False
schema_name_id: 423
start_time: 2026-04-11 04:02:06
success: True
trace_id: 10938886027972105850

Scan 161787370

duration: 0:00:11.916481

exit_message:

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

id: 161787370

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "calltype": "varchar(25)",
        "disposition_reason": "varchar(300)",
        "disposition_reason_key": "int",
        "is_active": "int",
        "origin_key": "varchar",
        "sales_outcome": "varchar(25)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_call_disposition/2026-04-10/1775811935/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_call_disposition/2026-04-10/1775811935",
        "key": "raw/reference_dim_call_disposition/2026-04-10/1775811935/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_call_disposition",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 1241250030537498781,
        "service_name": "redshift_unloads",
        "span_id": 2683721066385643155,
        "trace_id": 11652004863286902129
    }
}

running: False
schema_name_id: 423
start_time: 2026-04-10 04:05:49
success: True
trace_id: 11652004863286902129

Scan 161730633

duration: 0:00:14.209637

exit_message:

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

id: 161730633

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "calltype": "varchar(25)",
        "disposition_reason": "varchar(300)",
        "disposition_reason_key": "int",
        "is_active": "int",
        "origin_key": "varchar",
        "sales_outcome": "varchar(25)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_call_disposition/2026-04-09/1775723404/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_call_disposition/2026-04-09/1775723404",
        "key": "raw/reference_dim_call_disposition/2026-04-09/1775723404/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_call_disposition",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 17444920973052043653,
        "service_name": "redshift_unloads",
        "span_id": 15493726478058496758,
        "trace_id": 15708192953951184750
    }
}

running: False
schema_name_id: 423
start_time: 2026-04-09 03:30:15
success: True
trace_id: 15708192953951184750

Scan 161675822

duration: 0:00:11.781599

exit_message:

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

id: 161675822

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "calltype": "varchar(25)",
        "disposition_reason": "varchar(300)",
        "disposition_reason_key": "int",
        "is_active": "int",
        "origin_key": "varchar",
        "sales_outcome": "varchar(25)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_call_disposition/2026-04-08/1775637352/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_call_disposition/2026-04-08/1775637352",
        "key": "raw/reference_dim_call_disposition/2026-04-08/1775637352/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_call_disposition",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 6023022747561897193,
        "service_name": "redshift_unloads",
        "span_id": 12461331314117137821,
        "trace_id": 8169768277766300808
    }
}

running: False
schema_name_id: 423
start_time: 2026-04-08 03:36:09
success: True
trace_id: 8169768277766300808

Scan 161619678

duration: 0:00:11.663180

exit_message:

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

id: 161619678

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "calltype": "varchar(25)",
        "disposition_reason": "varchar(300)",
        "disposition_reason_key": "int",
        "is_active": "int",
        "origin_key": "varchar",
        "sales_outcome": "varchar(25)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_call_disposition/2026-04-07/1775550749/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_call_disposition/2026-04-07/1775550749",
        "key": "raw/reference_dim_call_disposition/2026-04-07/1775550749/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_call_disposition",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 10418341072571302175,
        "service_name": "redshift_unloads",
        "span_id": 2072960596030539600,
        "trace_id": 10734680620881205683
    }
}

running: False
schema_name_id: 423
start_time: 2026-04-07 03:32:36
success: True
trace_id: 10734680620881205683

Scan 161561882

duration: 0:00:14.217758

exit_message:

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

id: 161561882

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "calltype": "varchar(25)",
        "disposition_reason": "varchar(300)",
        "disposition_reason_key": "int",
        "is_active": "int",
        "origin_key": "varchar",
        "sales_outcome": "varchar(25)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_call_disposition/2026-04-06/1775464814/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_call_disposition/2026-04-06/1775464814",
        "key": "raw/reference_dim_call_disposition/2026-04-06/1775464814/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_call_disposition",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 11133336750665093165,
        "service_name": "redshift_unloads",
        "span_id": 11712972306782581498,
        "trace_id": 12503355179570506228
    }
}

running: False
schema_name_id: 423
start_time: 2026-04-06 03:40:24
success: True
trace_id: 12503355179570506228

Scan 161515956

duration: 0:00:11.586130

exit_message:

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

id: 161515956

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "calltype": "varchar(25)",
        "disposition_reason": "varchar(300)",
        "disposition_reason_key": "int",
        "is_active": "int",
        "origin_key": "varchar",
        "sales_outcome": "varchar(25)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_call_disposition/2026-04-05/1775379446/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_call_disposition/2026-04-05/1775379446",
        "key": "raw/reference_dim_call_disposition/2026-04-05/1775379446/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_call_disposition",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 9402454109945461764,
        "service_name": "redshift_unloads",
        "span_id": 1261735109778105868,
        "trace_id": 2479376775821794674
    }
}

running: False
schema_name_id: 423
start_time: 2026-04-05 03:59:21
success: True
trace_id: 2479376775821794674

Scan 161460675

duration: 0:00:11.820979

exit_message:

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

id: 161460675

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "calltype": "varchar(25)",
        "disposition_reason": "varchar(300)",
        "disposition_reason_key": "int",
        "is_active": "int",
        "origin_key": "varchar",
        "sales_outcome": "varchar(25)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_call_disposition/2026-04-04/1775291077/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_call_disposition/2026-04-04/1775291077",
        "key": "raw/reference_dim_call_disposition/2026-04-04/1775291077/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_call_disposition",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 14407096671645619722,
        "service_name": "redshift_unloads",
        "span_id": 14603304882061188652,
        "trace_id": 8873013479903352936
    }
}

running: False
schema_name_id: 423
start_time: 2026-04-04 03:25:04
success: True
trace_id: 8873013479903352936

Scan 161402143

duration: 0:00:11.683287

exit_message:

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

id: 161402143

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "calltype": "varchar(25)",
        "disposition_reason": "varchar(300)",
        "disposition_reason_key": "int",
        "is_active": "int",
        "origin_key": "varchar",
        "sales_outcome": "varchar(25)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/reference_dim_call_disposition/2026-04-03/1775205231/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_call_disposition/2026-04-03/1775205231",
        "key": "raw/reference_dim_call_disposition/2026-04-03/1775205231/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_call_disposition",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8937654864638504388,
        "service_name": "redshift_unloads",
        "span_id": 5748671937671110175,
        "trace_id": 8750131967184853973
    }
}

running: False
schema_name_id: 423
start_time: 2026-04-03 03:33:59
success: True
trace_id: 8750131967184853973

Partitions:

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

Schema:

attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "calltype": "varchar(25)",
    "disposition_reason": "varchar(300)",
    "disposition_reason_key": "int",
    "is_active": "int",
    "sales_outcome": "varchar(25)"
}

created: 2026-04-17 03:18:22

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_call_disposition`\n(\n `audit_id`  bigint , `disposition_reason_key`  int , `calltype`  varchar(25) , `sales_outcome`  varchar(25) , `disposition_reason`  varchar(300) , `is_active`  int , `_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_call_disposition/2026-04-17/1776413895'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_call_disposition`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_call_disposition"
}

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 15:04:04",
        "disabled": false,
        "format": "raw",
        "id": 423,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_redshift",
            "table": "analytics_reference_dim_call_disposition"
        },
        "type": "redshift"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "_origin": "string",
            "audit_id": "bigint",
            "calltype": "varchar(25)",
            "disposition_reason": "varchar(300)",
            "disposition_reason_key": "int",
            "is_active": "int",
            "sales_outcome": "varchar(25)"
        },
        "created": "2026-04-17 03:18:22",
        "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_call_disposition`\n(\n `audit_id`  bigint , `disposition_reason_key`  int , `calltype`  varchar(25) , `sales_outcome`  varchar(25) , `disposition_reason`  varchar(300) , `is_active`  int , `_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_call_disposition/2026-04-17/1776413895'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_call_disposition`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_call_disposition"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}