Schema Info

Schema Name: sfdl_stage_redshift.analytics_dwh_dim_incontact_skill

created: 2018-02-21 00:02:05
disabled: False
format: raw
id: 397
is_partitioned: False
is_schema_datatyped: True

name:

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

type: redshift

Schema Versions: 15

Version 906630

created: 2026-04-17 03:43:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_incontact_skill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_incontact_skill`\n(\n `audit_id`  bigint , `incontact_skill_no`  int , `incontact_skill_name`  varchar(45) , `_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/dwh_dim_incontact_skill/2026-04-17/1776415410'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_incontact_skill"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_incontact_skill/2026-04-17/1776415410
id: 906630
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "incontact_skill_name": "2",
    "incontact_skill_no": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "incontact_skill_name": "varchar(45)",
    "incontact_skill_no": "int"
}

schema_name_id: 397
schema_scan_id: 6415210
updated: 2026-04-17 03:43:57

Version 906434

created: 2026-04-16 04:01:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_incontact_skill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_incontact_skill`\n(\n `audit_id`  bigint , `incontact_skill_no`  int , `incontact_skill_name`  varchar(45) , `_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/dwh_dim_incontact_skill/2026-04-16/1776330078'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_incontact_skill"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_incontact_skill/2026-04-16/1776330078
id: 906434
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "incontact_skill_name": "2",
    "incontact_skill_no": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "incontact_skill_name": "varchar(45)",
    "incontact_skill_no": "int"
}

schema_name_id: 397
schema_scan_id: 6414684
updated: 2026-04-16 04:01:45

Version 906223

created: 2026-04-15 03:58:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_incontact_skill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_incontact_skill`\n(\n `audit_id`  bigint , `incontact_skill_no`  int , `incontact_skill_name`  varchar(45) , `_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/dwh_dim_incontact_skill/2026-04-15/1776243531'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_incontact_skill"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_incontact_skill/2026-04-15/1776243531
id: 906223
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "incontact_skill_name": "2",
    "incontact_skill_no": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "incontact_skill_name": "varchar(45)",
    "incontact_skill_no": "int"
}

schema_name_id: 397
schema_scan_id: 6414199
updated: 2026-04-15 03:59:12

Version 906012

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_incontact_skill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_incontact_skill`\n(\n `audit_id`  bigint , `incontact_skill_no`  int , `incontact_skill_name`  varchar(45) , `_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/dwh_dim_incontact_skill/2026-04-14/1776156980'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_incontact_skill"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_incontact_skill/2026-04-14/1776156980
id: 906012
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "incontact_skill_name": "2",
    "incontact_skill_no": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "incontact_skill_name": "varchar(45)",
    "incontact_skill_no": "int"
}

schema_name_id: 397
schema_scan_id: 6413698
updated: 2026-04-14 03:56:46

Version 905793

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_incontact_skill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_incontact_skill`\n(\n `audit_id`  bigint , `incontact_skill_no`  int , `incontact_skill_name`  varchar(45) , `_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/dwh_dim_incontact_skill/2026-04-13/1776069650'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_incontact_skill"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_incontact_skill/2026-04-13/1776069650
id: 905793
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "incontact_skill_name": "2",
    "incontact_skill_no": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "incontact_skill_name": "varchar(45)",
    "incontact_skill_no": "int"
}

schema_name_id: 397
schema_scan_id: 6413149
updated: 2026-04-13 03:41:18

Version 905577

created: 2026-04-12 03:55:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_incontact_skill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_incontact_skill`\n(\n `audit_id`  bigint , `incontact_skill_no`  int , `incontact_skill_name`  varchar(45) , `_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/dwh_dim_incontact_skill/2026-04-12/1775984125'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_incontact_skill"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_incontact_skill/2026-04-12/1775984125
id: 905577
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "incontact_skill_name": "2",
    "incontact_skill_no": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "incontact_skill_name": "varchar(45)",
    "incontact_skill_no": "int"
}

schema_name_id: 397
schema_scan_id: 6412741
updated: 2026-04-12 03:55:46

Version 905371

created: 2026-04-11 03:32:41

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_incontact_skill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_incontact_skill`\n(\n `audit_id`  bigint , `incontact_skill_no`  int , `incontact_skill_name`  varchar(45) , `_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/dwh_dim_incontact_skill/2026-04-11/1775896354'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_incontact_skill"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_incontact_skill/2026-04-11/1775896354
id: 905371
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "incontact_skill_name": "2",
    "incontact_skill_no": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "incontact_skill_name": "varchar(45)",
    "incontact_skill_no": "int"
}

schema_name_id: 397
schema_scan_id: 6412356
updated: 2026-04-11 03:32:52

Version 905133

created: 2026-04-10 03:19:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_incontact_skill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_incontact_skill`\n(\n `audit_id`  bigint , `incontact_skill_no`  int , `incontact_skill_name`  varchar(45) , `_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/dwh_dim_incontact_skill/2026-04-10/1775809165'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_incontact_skill"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_incontact_skill/2026-04-10/1775809165
id: 905133
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "incontact_skill_name": "2",
    "incontact_skill_no": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "incontact_skill_name": "varchar(45)",
    "incontact_skill_no": "int"
}

schema_name_id: 397
schema_scan_id: 6411837
updated: 2026-04-10 03:19:44

Version 904920

created: 2026-04-09 03:49:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_incontact_skill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_incontact_skill`\n(\n `audit_id`  bigint , `incontact_skill_no`  int , `incontact_skill_name`  varchar(45) , `_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/dwh_dim_incontact_skill/2026-04-09/1775724567'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_incontact_skill"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_incontact_skill/2026-04-09/1775724567
id: 904920
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "incontact_skill_name": "2",
    "incontact_skill_no": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "incontact_skill_name": "varchar(45)",
    "incontact_skill_no": "int"
}

schema_name_id: 397
schema_scan_id: 6411322
updated: 2026-04-09 03:50:00

Version 904739

created: 2026-04-08 03:57:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_incontact_skill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_incontact_skill`\n(\n `audit_id`  bigint , `incontact_skill_no`  int , `incontact_skill_name`  varchar(45) , `_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/dwh_dim_incontact_skill/2026-04-08/1775638645'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_incontact_skill"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_incontact_skill/2026-04-08/1775638645
id: 904739
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "incontact_skill_name": "2",
    "incontact_skill_no": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "incontact_skill_name": "varchar(45)",
    "incontact_skill_no": "int"
}

schema_name_id: 397
schema_scan_id: 6410862
updated: 2026-04-08 03:57:51

Version 904536

created: 2026-04-07 03:54:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_incontact_skill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_incontact_skill`\n(\n `audit_id`  bigint , `incontact_skill_no`  int , `incontact_skill_name`  varchar(45) , `_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/dwh_dim_incontact_skill/2026-04-07/1775552037'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_incontact_skill"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_incontact_skill/2026-04-07/1775552037
id: 904536
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "incontact_skill_name": "2",
    "incontact_skill_no": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "incontact_skill_name": "varchar(45)",
    "incontact_skill_no": "int"
}

schema_name_id: 397
schema_scan_id: 6410362
updated: 2026-04-07 03:54:47

Version 904315

created: 2026-04-06 03:57:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_incontact_skill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_incontact_skill`\n(\n `audit_id`  bigint , `incontact_skill_no`  int , `incontact_skill_name`  varchar(45) , `_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/dwh_dim_incontact_skill/2026-04-06/1775465812'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_incontact_skill"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_incontact_skill/2026-04-06/1775465812
id: 904315
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "incontact_skill_name": "2",
    "incontact_skill_no": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "incontact_skill_name": "varchar(45)",
    "incontact_skill_no": "int"
}

schema_name_id: 397
schema_scan_id: 6409809
updated: 2026-04-06 03:57:15

Version 904123

created: 2026-04-05 04:05:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_incontact_skill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_incontact_skill`\n(\n `audit_id`  bigint , `incontact_skill_no`  int , `incontact_skill_name`  varchar(45) , `_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/dwh_dim_incontact_skill/2026-04-05/1775379888'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_incontact_skill"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_incontact_skill/2026-04-05/1775379888
id: 904123
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "incontact_skill_name": "2",
    "incontact_skill_no": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "incontact_skill_name": "varchar(45)",
    "incontact_skill_no": "int"
}

schema_name_id: 397
schema_scan_id: 6409431
updated: 2026-04-05 04:05:35

Version 903912

created: 2026-04-04 03:44:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_incontact_skill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_incontact_skill`\n(\n `audit_id`  bigint , `incontact_skill_no`  int , `incontact_skill_name`  varchar(45) , `_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/dwh_dim_incontact_skill/2026-04-04/1775292237'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_incontact_skill"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_incontact_skill/2026-04-04/1775292237
id: 903912
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "incontact_skill_name": "2",
    "incontact_skill_no": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "incontact_skill_name": "varchar(45)",
    "incontact_skill_no": "int"
}

schema_name_id: 397
schema_scan_id: 6409041
updated: 2026-04-04 03:44:35

Version 903694

created: 2026-04-03 03:51:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_incontact_skill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_incontact_skill`\n(\n `audit_id`  bigint , `incontact_skill_no`  int , `incontact_skill_name`  varchar(45) , `_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/dwh_dim_incontact_skill/2026-04-03/1775206284'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_incontact_skill"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_incontact_skill/2026-04-03/1775206284
id: 903694
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "incontact_skill_name": "2",
    "incontact_skill_no": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "incontact_skill_name": "varchar(45)",
    "incontact_skill_no": "int"
}

schema_name_id: 397
schema_scan_id: 6408548
updated: 2026-04-03 03:51:53

Schema Scans: 15

Last at 2026-04-17 03:43:46

Scan 6415210

duration: 0:00:11.628590

exit_message:

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

id: 6415210

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "incontact_skill_name": "varchar(45)",
        "incontact_skill_no": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_incontact_skill/2026-04-17/1776415410/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_incontact_skill/2026-04-17/1776415410",
        "key": "raw/dwh_dim_incontact_skill/2026-04-17/1776415410/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_incontact_skill",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8312063068077553967,
        "service_name": "redshift_unloads",
        "span_id": 802616941544063237,
        "trace_id": 10658540004595742548
    }
}

running: False
schema_name_id: 397
start_time: 2026-04-17 03:43:46
success: True
trace_id: 10658540004595742548

Scan 6414684

duration: 0:00:11.602492

exit_message:

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

id: 6414684

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "incontact_skill_name": "varchar(45)",
        "incontact_skill_no": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_incontact_skill/2026-04-16/1776330078/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_incontact_skill/2026-04-16/1776330078",
        "key": "raw/dwh_dim_incontact_skill/2026-04-16/1776330078/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_incontact_skill",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 20099856136649211,
        "service_name": "redshift_unloads",
        "span_id": 6339714706245069632,
        "trace_id": 8843013120976135043
    }
}

running: False
schema_name_id: 397
start_time: 2026-04-16 04:01:34
success: True
trace_id: 8843013120976135043

Scan 6414199

duration: 0:00:14.230530

exit_message:

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

id: 6414199

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "incontact_skill_name": "varchar(45)",
        "incontact_skill_no": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_incontact_skill/2026-04-15/1776243531/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_incontact_skill/2026-04-15/1776243531",
        "key": "raw/dwh_dim_incontact_skill/2026-04-15/1776243531/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_incontact_skill",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15852074335412698180,
        "service_name": "redshift_unloads",
        "span_id": 1554178734673962380,
        "trace_id": 13493746395422844419
    }
}

running: False
schema_name_id: 397
start_time: 2026-04-15 03:58:58
success: True
trace_id: 13493746395422844419

Scan 6413698

duration: 0:00:14.273945

exit_message:

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

id: 6413698

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "incontact_skill_name": "varchar(45)",
        "incontact_skill_no": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_incontact_skill/2026-04-14/1776156980/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_incontact_skill/2026-04-14/1776156980",
        "key": "raw/dwh_dim_incontact_skill/2026-04-14/1776156980/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_incontact_skill",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 7107128033473665296,
        "service_name": "redshift_unloads",
        "span_id": 8252668858848492816,
        "trace_id": 1741130356467929271
    }
}

running: False
schema_name_id: 397
start_time: 2026-04-14 03:56:32
success: True
trace_id: 1741130356467929271

Scan 6413149

duration: 0:00:11.675714

exit_message:

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

id: 6413149

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "incontact_skill_name": "varchar(45)",
        "incontact_skill_no": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_incontact_skill/2026-04-13/1776069650/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_incontact_skill/2026-04-13/1776069650",
        "key": "raw/dwh_dim_incontact_skill/2026-04-13/1776069650/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_incontact_skill",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 11013297258102557707,
        "service_name": "redshift_unloads",
        "span_id": 16978903547063925529,
        "trace_id": 7420593972391237905
    }
}

running: False
schema_name_id: 397
start_time: 2026-04-13 03:41:07
success: True
trace_id: 7420593972391237905

Scan 6412741

duration: 0:00:11.626726

exit_message:

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

id: 6412741

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "incontact_skill_name": "varchar(45)",
        "incontact_skill_no": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_incontact_skill/2026-04-12/1775984125/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_incontact_skill/2026-04-12/1775984125",
        "key": "raw/dwh_dim_incontact_skill/2026-04-12/1775984125/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_incontact_skill",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 16096000287175061698,
        "service_name": "redshift_unloads",
        "span_id": 4830389495542247596,
        "trace_id": 15025238052714165991
    }
}

running: False
schema_name_id: 397
start_time: 2026-04-12 03:55:34
success: True
trace_id: 15025238052714165991

Scan 6412356

duration: 0:00:11.683598

exit_message:

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

id: 6412356

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "incontact_skill_name": "varchar(45)",
        "incontact_skill_no": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_incontact_skill/2026-04-11/1775896354/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_incontact_skill/2026-04-11/1775896354",
        "key": "raw/dwh_dim_incontact_skill/2026-04-11/1775896354/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_incontact_skill",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 14359500167613979956,
        "service_name": "redshift_unloads",
        "span_id": 6663031480023974052,
        "trace_id": 4362316549078787927
    }
}

running: False
schema_name_id: 397
start_time: 2026-04-11 03:32:41
success: True
trace_id: 4362316549078787927

Scan 6411837

duration: 0:00:11.745568

exit_message:

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

id: 6411837

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "incontact_skill_name": "varchar(45)",
        "incontact_skill_no": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_incontact_skill/2026-04-10/1775809165/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_incontact_skill/2026-04-10/1775809165",
        "key": "raw/dwh_dim_incontact_skill/2026-04-10/1775809165/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_incontact_skill",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 2320903991419358477,
        "service_name": "redshift_unloads",
        "span_id": 11745716868884818206,
        "trace_id": 16130476172529907270
    }
}

running: False
schema_name_id: 397
start_time: 2026-04-10 03:19:33
success: True
trace_id: 16130476172529907270

Scan 6411322

duration: 0:00:14.256484

exit_message:

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

id: 6411322

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "incontact_skill_name": "varchar(45)",
        "incontact_skill_no": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_incontact_skill/2026-04-09/1775724567/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_incontact_skill/2026-04-09/1775724567",
        "key": "raw/dwh_dim_incontact_skill/2026-04-09/1775724567/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_incontact_skill",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 7981246278121221114,
        "service_name": "redshift_unloads",
        "span_id": 6764067324819560990,
        "trace_id": 6645353193637723870
    }
}

running: False
schema_name_id: 397
start_time: 2026-04-09 03:49:45
success: True
trace_id: 6645353193637723870

Scan 6410862

duration: 0:00:11.672822

exit_message:

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

id: 6410862

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "incontact_skill_name": "varchar(45)",
        "incontact_skill_no": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_incontact_skill/2026-04-08/1775638645/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_incontact_skill/2026-04-08/1775638645",
        "key": "raw/dwh_dim_incontact_skill/2026-04-08/1775638645/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_incontact_skill",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 11107401589724271152,
        "service_name": "redshift_unloads",
        "span_id": 2915423641685180490,
        "trace_id": 4298517505718859082
    }
}

running: False
schema_name_id: 397
start_time: 2026-04-08 03:57:39
success: True
trace_id: 4298517505718859082

Scan 6410362

duration: 0:00:11.691909

exit_message:

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

id: 6410362

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "incontact_skill_name": "varchar(45)",
        "incontact_skill_no": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_incontact_skill/2026-04-07/1775552037/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_incontact_skill/2026-04-07/1775552037",
        "key": "raw/dwh_dim_incontact_skill/2026-04-07/1775552037/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_incontact_skill",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 11462460279048719086,
        "service_name": "redshift_unloads",
        "span_id": 11859560849575712975,
        "trace_id": 11674177160575984755
    }
}

running: False
schema_name_id: 397
start_time: 2026-04-07 03:54:36
success: True
trace_id: 11674177160575984755

Scan 6409809

duration: 0:00:11.622733

exit_message:

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

id: 6409809

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "incontact_skill_name": "varchar(45)",
        "incontact_skill_no": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_incontact_skill/2026-04-06/1775465812/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_incontact_skill/2026-04-06/1775465812",
        "key": "raw/dwh_dim_incontact_skill/2026-04-06/1775465812/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_incontact_skill",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13744936317728018784,
        "service_name": "redshift_unloads",
        "span_id": 10665358522519263905,
        "trace_id": 8581740201156561181
    }
}

running: False
schema_name_id: 397
start_time: 2026-04-06 03:57:03
success: True
trace_id: 8581740201156561181

Scan 6409431

duration: 0:00:14.185773

exit_message:

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

id: 6409431

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "incontact_skill_name": "varchar(45)",
        "incontact_skill_no": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_incontact_skill/2026-04-05/1775379888/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_incontact_skill/2026-04-05/1775379888",
        "key": "raw/dwh_dim_incontact_skill/2026-04-05/1775379888/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_incontact_skill",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 2789488189151925593,
        "service_name": "redshift_unloads",
        "span_id": 3953399355544780220,
        "trace_id": 5012177302233507836
    }
}

running: False
schema_name_id: 397
start_time: 2026-04-05 04:05:20
success: True
trace_id: 5012177302233507836

Scan 6409041

duration: 0:00:14.273279

exit_message:

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

id: 6409041

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "incontact_skill_name": "varchar(45)",
        "incontact_skill_no": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_incontact_skill/2026-04-04/1775292237/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_incontact_skill/2026-04-04/1775292237",
        "key": "raw/dwh_dim_incontact_skill/2026-04-04/1775292237/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_incontact_skill",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 11908539554781283678,
        "service_name": "redshift_unloads",
        "span_id": 7673649357522199519,
        "trace_id": 17550323780973651421
    }
}

running: False
schema_name_id: 397
start_time: 2026-04-04 03:44:21
success: True
trace_id: 17550323780973651421

Scan 6408548

duration: 0:00:14.179767

exit_message:

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

id: 6408548

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "incontact_skill_name": "varchar(45)",
        "incontact_skill_no": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_dim_incontact_skill/2026-04-03/1775206284/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_incontact_skill/2026-04-03/1775206284",
        "key": "raw/dwh_dim_incontact_skill/2026-04-03/1775206284/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_incontact_skill",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 4876190883924007597,
        "service_name": "redshift_unloads",
        "span_id": 9568036335174555417,
        "trace_id": 7142175711080748343
    }
}

running: False
schema_name_id: 397
start_time: 2026-04-03 03:51:39
success: True
trace_id: 7142175711080748343

Partitions:

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

Schema:

attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "incontact_skill_name": "varchar(45)",
    "incontact_skill_no": "int"
}

created: 2026-04-17 03:43:46

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_incontact_skill`\n(\n `audit_id`  bigint , `incontact_skill_no`  int , `incontact_skill_name`  varchar(45) , `_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/dwh_dim_incontact_skill/2026-04-17/1776415410'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_incontact_skill`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_incontact_skill"
}

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-02-21 00:02:05",
        "disabled": false,
        "format": "raw",
        "id": 397,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_redshift",
            "table": "analytics_dwh_dim_incontact_skill"
        },
        "type": "redshift"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "_origin": "string",
            "audit_id": "bigint",
            "incontact_skill_name": "varchar(45)",
            "incontact_skill_no": "int"
        },
        "created": "2026-04-17 03:43:46",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_incontact_skill`\n(\n `audit_id`  bigint , `incontact_skill_no`  int , `incontact_skill_name`  varchar(45) , `_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/dwh_dim_incontact_skill/2026-04-17/1776415410'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_incontact_skill`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_incontact_skill"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}