Schema Info

Schema Name: sfdl_stage_redshift.analytics_reference_dim_call_disposition

created: 2018-05-09 10:28:13
disabled: False
format: raw
id: 519
is_partitioned: False
is_schema_datatyped: True

name:

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

type: redshift

Schema Versions: 15

Version 906635

created: 2026-04-17 03:44:49

ddl:

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

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_call_disposition/2026-04-17/1776415477
id: 906635
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: 519
schema_scan_id: 6415215
updated: 2026-04-17 03:45:03

Version 906418

created: 2026-04-16 04:00:29

ddl:

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

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_call_disposition/2026-04-16/1776330003
id: 906418
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: 519
schema_scan_id: 6414668
updated: 2026-04-16 04:00:43

Version 906180

created: 2026-04-15 03:43:02

ddl:

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

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_call_disposition/2026-04-15/1776242575
id: 906180
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: 519
schema_scan_id: 6414156
updated: 2026-04-15 03:43:16

Version 905991

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

ddl:

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

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_call_disposition/2026-04-14/1776156798
id: 905991
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: 519
schema_scan_id: 6413677
updated: 2026-04-14 03:53:40

Version 905749

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

ddl:

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

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_call_disposition/2026-04-13/1776068510
id: 905749
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: 519
schema_scan_id: 6413104
updated: 2026-04-13 03:22:15

Version 905562

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

ddl:

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

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_call_disposition/2026-04-12/1775983087
id: 905562
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: 519
schema_scan_id: 6412725
updated: 2026-04-12 03:38:26

Version 905347

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

ddl:

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

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_call_disposition/2026-04-11/1775895648
id: 905347
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: 519
schema_scan_id: 6412331
updated: 2026-04-11 03:21:15

Version 905177

created: 2026-04-10 04:00:04

ddl:

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

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_call_disposition/2026-04-10/1775811576
id: 905177
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: 519
schema_scan_id: 6411883
updated: 2026-04-10 04:00:18

Version 904949

created: 2026-04-09 04:00:16

ddl:

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

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_call_disposition/2026-04-09/1775725208
id: 904949
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: 519
schema_scan_id: 6411352
updated: 2026-04-09 04:00:29

Version 904704

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

ddl:

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

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_call_disposition/2026-04-08/1775637075
id: 904704
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: 519
schema_scan_id: 6410825
updated: 2026-04-08 03:31:43

Version 904492

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

ddl:

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

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_call_disposition/2026-04-07/1775550778
id: 904492
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: 519
schema_scan_id: 6410315
updated: 2026-04-07 03:33:30

Version 904279

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

ddl:

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

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_call_disposition/2026-04-06/1775465035
id: 904279
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: 519
schema_scan_id: 6409773
updated: 2026-04-06 03:44:50

Version 904096

created: 2026-04-05 03:44:20

ddl:

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

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_call_disposition/2026-04-05/1775378627
id: 904096
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: 519
schema_scan_id: 6409404
updated: 2026-04-05 03:44:34

Version 903873

created: 2026-04-04 03:22:56

ddl:

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

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_call_disposition/2026-04-04/1775290955
id: 903873
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: 519
schema_scan_id: 6409002
updated: 2026-04-04 03:23:07

Version 903660

created: 2026-04-03 03:43:51

ddl:

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

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_dim_call_disposition/2026-04-03/1775205820
id: 903660
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: 519
schema_scan_id: 6408515
updated: 2026-04-03 03:44:03

Schema Scans: 15

Last at 2026-04-17 03:44:48

Scan 6415215

duration: 0:00:14.435023

exit_message:

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

id: 6415215

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-stage",
            "key": "meta/reference_dim_call_disposition/2026-04-17/1776415477/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_call_disposition/2026-04-17/1776415477",
        "key": "raw/reference_dim_call_disposition/2026-04-17/1776415477/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_call_disposition",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 17701065178220658795,
        "service_name": "redshift_unloads",
        "span_id": 4223838496001649399,
        "trace_id": 17019988825508755327
    }
}

running: False
schema_name_id: 519
start_time: 2026-04-17 03:44:48
success: True
trace_id: 17019988825508755327

Scan 6414668

duration: 0:00:14.370245

exit_message:

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

id: 6414668

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-stage",
            "key": "meta/reference_dim_call_disposition/2026-04-16/1776330003/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_call_disposition/2026-04-16/1776330003",
        "key": "raw/reference_dim_call_disposition/2026-04-16/1776330003/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_call_disposition",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 16845606811831324520,
        "service_name": "redshift_unloads",
        "span_id": 12628007198183112913,
        "trace_id": 16276899576136216420
    }
}

running: False
schema_name_id: 519
start_time: 2026-04-16 04:00:29
success: True
trace_id: 16276899576136216420

Scan 6414156

duration: 0:00:14.196209

exit_message:

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

id: 6414156

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-stage",
            "key": "meta/reference_dim_call_disposition/2026-04-15/1776242575/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_call_disposition/2026-04-15/1776242575",
        "key": "raw/reference_dim_call_disposition/2026-04-15/1776242575/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_call_disposition",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 160270723079081405,
        "service_name": "redshift_unloads",
        "span_id": 9739225598245727146,
        "trace_id": 2344073201641177135
    }
}

running: False
schema_name_id: 519
start_time: 2026-04-15 03:43:02
success: True
trace_id: 2344073201641177135

Scan 6413677

duration: 0:00:11.769107

exit_message:

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

id: 6413677

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-stage",
            "key": "meta/reference_dim_call_disposition/2026-04-14/1776156798/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_call_disposition/2026-04-14/1776156798",
        "key": "raw/reference_dim_call_disposition/2026-04-14/1776156798/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_call_disposition",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 2185467505592594378,
        "service_name": "redshift_unloads",
        "span_id": 2298989014973398184,
        "trace_id": 12624227846297130440
    }
}

running: False
schema_name_id: 519
start_time: 2026-04-14 03:53:29
success: True
trace_id: 12624227846297130440

Scan 6413104

duration: 0:00:14.442751

exit_message:

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

id: 6413104

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-stage",
            "key": "meta/reference_dim_call_disposition/2026-04-13/1776068510/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_call_disposition/2026-04-13/1776068510",
        "key": "raw/reference_dim_call_disposition/2026-04-13/1776068510/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_call_disposition",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 17859992400166319051,
        "service_name": "redshift_unloads",
        "span_id": 3539423850108371671,
        "trace_id": 5621238612100187203
    }
}

running: False
schema_name_id: 519
start_time: 2026-04-13 03:22:01
success: True
trace_id: 5621238612100187203

Scan 6412725

duration: 0:00:11.715094

exit_message:

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

id: 6412725

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-stage",
            "key": "meta/reference_dim_call_disposition/2026-04-12/1775983087/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_call_disposition/2026-04-12/1775983087",
        "key": "raw/reference_dim_call_disposition/2026-04-12/1775983087/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_call_disposition",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 1349371464177097610,
        "service_name": "redshift_unloads",
        "span_id": 13961223017544513600,
        "trace_id": 3067437932417353808
    }
}

running: False
schema_name_id: 519
start_time: 2026-04-12 03:38:15
success: True
trace_id: 3067437932417353808

Scan 6412331

duration: 0:00:11.827423

exit_message:

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

id: 6412331

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-stage",
            "key": "meta/reference_dim_call_disposition/2026-04-11/1775895648/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_call_disposition/2026-04-11/1775895648",
        "key": "raw/reference_dim_call_disposition/2026-04-11/1775895648/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_call_disposition",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 938864683787328564,
        "service_name": "redshift_unloads",
        "span_id": 10534063193500982891,
        "trace_id": 13347679928180974173
    }
}

running: False
schema_name_id: 519
start_time: 2026-04-11 03:21:03
success: True
trace_id: 13347679928180974173

Scan 6411883

duration: 0:00:14.318314

exit_message:

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

id: 6411883

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-stage",
            "key": "meta/reference_dim_call_disposition/2026-04-10/1775811576/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_call_disposition/2026-04-10/1775811576",
        "key": "raw/reference_dim_call_disposition/2026-04-10/1775811576/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_call_disposition",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15095579766880879659,
        "service_name": "redshift_unloads",
        "span_id": 7639093965135010770,
        "trace_id": 9975548013732400998
    }
}

running: False
schema_name_id: 519
start_time: 2026-04-10 04:00:03
success: True
trace_id: 9975548013732400998

Scan 6411352

duration: 0:00:14.227322

exit_message:

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

id: 6411352

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-stage",
            "key": "meta/reference_dim_call_disposition/2026-04-09/1775725208/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_call_disposition/2026-04-09/1775725208",
        "key": "raw/reference_dim_call_disposition/2026-04-09/1775725208/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_call_disposition",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13344590041367238583,
        "service_name": "redshift_unloads",
        "span_id": 1721145238265325469,
        "trace_id": 13796291893573970784
    }
}

running: False
schema_name_id: 519
start_time: 2026-04-09 04:00:15
success: True
trace_id: 13796291893573970784

Scan 6410825

duration: 0:00:11.821038

exit_message:

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

id: 6410825

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-stage",
            "key": "meta/reference_dim_call_disposition/2026-04-08/1775637075/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_call_disposition/2026-04-08/1775637075",
        "key": "raw/reference_dim_call_disposition/2026-04-08/1775637075/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_call_disposition",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 9295558233405503841,
        "service_name": "redshift_unloads",
        "span_id": 836396637174348138,
        "trace_id": 2269750746065388226
    }
}

running: False
schema_name_id: 519
start_time: 2026-04-08 03:31:31
success: True
trace_id: 2269750746065388226

Scan 6410315

duration: 0:00:11.674011

exit_message:

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

id: 6410315

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-stage",
            "key": "meta/reference_dim_call_disposition/2026-04-07/1775550778/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_call_disposition/2026-04-07/1775550778",
        "key": "raw/reference_dim_call_disposition/2026-04-07/1775550778/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_call_disposition",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 2789817063716341001,
        "service_name": "redshift_unloads",
        "span_id": 17367105638357227106,
        "trace_id": 1789440169164921072
    }
}

running: False
schema_name_id: 519
start_time: 2026-04-07 03:33:18
success: True
trace_id: 1789440169164921072

Scan 6409773

duration: 0:00:14.275156

exit_message:

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

id: 6409773

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-stage",
            "key": "meta/reference_dim_call_disposition/2026-04-06/1775465035/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_call_disposition/2026-04-06/1775465035",
        "key": "raw/reference_dim_call_disposition/2026-04-06/1775465035/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_call_disposition",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 12560482021720955584,
        "service_name": "redshift_unloads",
        "span_id": 11679071850799086100,
        "trace_id": 13996165495569996763
    }
}

running: False
schema_name_id: 519
start_time: 2026-04-06 03:44:35
success: True
trace_id: 13996165495569996763

Scan 6409404

duration: 0:00:14.299618

exit_message:

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

id: 6409404

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-stage",
            "key": "meta/reference_dim_call_disposition/2026-04-05/1775378627/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_call_disposition/2026-04-05/1775378627",
        "key": "raw/reference_dim_call_disposition/2026-04-05/1775378627/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_call_disposition",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 9637103322628244946,
        "service_name": "redshift_unloads",
        "span_id": 14558295325517508442,
        "trace_id": 8039807450211642543
    }
}

running: False
schema_name_id: 519
start_time: 2026-04-05 03:44:20
success: True
trace_id: 8039807450211642543

Scan 6409002

duration: 0:00:11.727160

exit_message:

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

id: 6409002

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-stage",
            "key": "meta/reference_dim_call_disposition/2026-04-04/1775290955/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_call_disposition/2026-04-04/1775290955",
        "key": "raw/reference_dim_call_disposition/2026-04-04/1775290955/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_call_disposition",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13927263053696584857,
        "service_name": "redshift_unloads",
        "span_id": 12615106402980131662,
        "trace_id": 2321971520569752834
    }
}

running: False
schema_name_id: 519
start_time: 2026-04-04 03:22:56
success: True
trace_id: 2321971520569752834

Scan 6408515

duration: 0:00:11.785241

exit_message:

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

id: 6408515

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-stage",
            "key": "meta/reference_dim_call_disposition/2026-04-03/1775205820/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_dim_call_disposition/2026-04-03/1775205820",
        "key": "raw/reference_dim_call_disposition/2026-04-03/1775205820/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_dim_call_disposition",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 6053983256049421864,
        "service_name": "redshift_unloads",
        "span_id": 4119859720105692241,
        "trace_id": 9039586566773978142
    }
}

running: False
schema_name_id: 519
start_time: 2026-04-03 03:43:51
success: True
trace_id: 9039586566773978142

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:44:49

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_dim_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-stage/raw/reference_dim_call_disposition/2026-04-17/1776415477'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_call_disposition`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_call_disposition"
}

Server:

hostname: schemamanager-5c55c886bf-h2ts4
name: schema_manager
process_start: 2025-10-21 13:03:27
sf_env: stage
version: 2112174301

Raw:

{
    "name": {
        "created": "2018-05-09 10:28:13",
        "disabled": false,
        "format": "raw",
        "id": 519,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_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:44:49",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_dim_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-stage/raw/reference_dim_call_disposition/2026-04-17/1776415477'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_dim_call_disposition`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_dim_call_disposition"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}