Schema Info

Schema Name: sfdl_prod_redshift.analytics_dwh_dim_incontact_skill

created: 2018-02-28 10:54:37
disabled: False
format: raw
id: 264
is_partitioned: False
is_schema_datatyped: True

name:

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

type: redshift

Schema Versions: 15

Version 1717885

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_incontact_skill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_incontact_skill/2026-04-17/1776414758'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_incontact_skill"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_incontact_skill/2026-04-17/1776414758
id: 1717885
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: 264
schema_scan_id: 162167998
updated: 2026-04-17 03:33:02

Version 1716665

created: 2026-04-16 04:09:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_incontact_skill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_incontact_skill/2026-04-16/1776330578'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_incontact_skill"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_incontact_skill/2026-04-16/1776330578
id: 1716665
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: 264
schema_scan_id: 162113322
updated: 2026-04-16 04:10:04

Version 1715566

created: 2026-04-15 03:50:26

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_incontact_skill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_incontact_skill/2026-04-15/1776243016'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_incontact_skill"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_incontact_skill/2026-04-15/1776243016
id: 1715566
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: 264
schema_scan_id: 162056517
updated: 2026-04-15 03:50:38

Version 1714248

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_incontact_skill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_incontact_skill/2026-04-14/1776156058'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_incontact_skill"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_incontact_skill/2026-04-14/1776156058
id: 1714248
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: 264
schema_scan_id: 162000816
updated: 2026-04-14 03:41:19

Version 1713042

created: 2026-04-13 03:59:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_incontact_skill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_incontact_skill/2026-04-13/1776070691'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_incontact_skill"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_incontact_skill/2026-04-13/1776070691
id: 1713042
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: 264
schema_scan_id: 161943795
updated: 2026-04-13 03:59:47

Version 1711819

created: 2026-04-12 03:47:03

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_incontact_skill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_incontact_skill/2026-04-12/1775983604'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_incontact_skill"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_incontact_skill/2026-04-12/1775983604
id: 1711819
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: 264
schema_scan_id: 161893630
updated: 2026-04-12 03:47:17

Version 1710618

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_incontact_skill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_incontact_skill/2026-04-11/1775896909'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_incontact_skill"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_incontact_skill/2026-04-11/1775896909
id: 1710618
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: 264
schema_scan_id: 161841461
updated: 2026-04-11 03:42:10

Version 1709436

created: 2026-04-10 03:24:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_incontact_skill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_incontact_skill/2026-04-10/1775809480'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_incontact_skill"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_incontact_skill/2026-04-10/1775809480
id: 1709436
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: 264
schema_scan_id: 161786171
updated: 2026-04-10 03:25:02

Version 1708347

created: 2026-04-09 03:51:07

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_incontact_skill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_incontact_skill/2026-04-09/1775724657'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_incontact_skill"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_incontact_skill/2026-04-09/1775724657
id: 1708347
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: 264
schema_scan_id: 161730731
updated: 2026-04-09 03:51:21

Version 1707137

created: 2026-04-08 04:02:09

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_incontact_skill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_incontact_skill/2026-04-08/1775638862'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_incontact_skill"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_incontact_skill/2026-04-08/1775638862
id: 1707137
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: 264
schema_scan_id: 161676913
updated: 2026-04-08 04:02:20

Version 1705951

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_incontact_skill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_incontact_skill/2026-04-07/1775552030'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_incontact_skill"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_incontact_skill/2026-04-07/1775552030
id: 1705951
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: 264
schema_scan_id: 161619844
updated: 2026-04-07 03:54:12

Version 1704698

created: 2026-04-06 03:50:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_incontact_skill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_incontact_skill/2026-04-06/1775465423'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_incontact_skill"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_incontact_skill/2026-04-06/1775465423
id: 1704698
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: 264
schema_scan_id: 161561922
updated: 2026-04-06 03:50:49

Version 1703481

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_incontact_skill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_incontact_skill/2026-04-05/1775378028'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_incontact_skill"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_incontact_skill/2026-04-05/1775378028
id: 1703481
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: 264
schema_scan_id: 161515094
updated: 2026-04-05 03:34:10

Version 1702324

created: 2026-04-04 03:32:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_incontact_skill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_incontact_skill/2026-04-04/1775291514'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_incontact_skill"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_incontact_skill/2026-04-04/1775291514
id: 1702324
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: 264
schema_scan_id: 161460695
updated: 2026-04-04 03:32:18

Version 1701163

created: 2026-04-03 03:52:30

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_incontact_skill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/dwh_dim_incontact_skill/2026-04-03/1775206340'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_incontact_skill"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_incontact_skill/2026-04-03/1775206340
id: 1701163
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: 264
schema_scan_id: 161402357
updated: 2026-04-03 03:52:44

Schema Scans: 15

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

Scan 162167998

duration: 0:00:11.676503

exit_message:

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

id: 162167998

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-prod",
            "key": "meta/dwh_dim_incontact_skill/2026-04-17/1776414758/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_incontact_skill/2026-04-17/1776414758",
        "key": "raw/dwh_dim_incontact_skill/2026-04-17/1776414758/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_incontact_skill",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 14498509008737130676,
        "service_name": "redshift_unloads",
        "span_id": 852510372703386389,
        "trace_id": 3605002796774639093
    }
}

running: False
schema_name_id: 264
start_time: 2026-04-17 03:32:50
success: True
trace_id: 3605002796774639093

Scan 162113322

duration: 0:00:14.259799

exit_message:

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

id: 162113322

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-prod",
            "key": "meta/dwh_dim_incontact_skill/2026-04-16/1776330578/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_incontact_skill/2026-04-16/1776330578",
        "key": "raw/dwh_dim_incontact_skill/2026-04-16/1776330578/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_incontact_skill",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 10230773832399290074,
        "service_name": "redshift_unloads",
        "span_id": 2206271830973413673,
        "trace_id": 10947589678263649484
    }
}

running: False
schema_name_id: 264
start_time: 2026-04-16 04:09:50
success: True
trace_id: 10947589678263649484

Scan 162056517

duration: 0:00:11.570554

exit_message:

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

id: 162056517

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-prod",
            "key": "meta/dwh_dim_incontact_skill/2026-04-15/1776243016/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_incontact_skill/2026-04-15/1776243016",
        "key": "raw/dwh_dim_incontact_skill/2026-04-15/1776243016/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_incontact_skill",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3367382591033619609,
        "service_name": "redshift_unloads",
        "span_id": 3592179622117878487,
        "trace_id": 5316283806180557498
    }
}

running: False
schema_name_id: 264
start_time: 2026-04-15 03:50:26
success: True
trace_id: 5316283806180557498

Scan 162000816

duration: 0:00:14.251323

exit_message:

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

id: 162000816

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-prod",
            "key": "meta/dwh_dim_incontact_skill/2026-04-14/1776156058/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_incontact_skill/2026-04-14/1776156058",
        "key": "raw/dwh_dim_incontact_skill/2026-04-14/1776156058/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_incontact_skill",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 1432206567576994366,
        "service_name": "redshift_unloads",
        "span_id": 14676781765449531111,
        "trace_id": 17012090022273142365
    }
}

running: False
schema_name_id: 264
start_time: 2026-04-14 03:41:05
success: True
trace_id: 17012090022273142365

Scan 161943795

duration: 0:00:11.578921

exit_message:

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

id: 161943795

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-prod",
            "key": "meta/dwh_dim_incontact_skill/2026-04-13/1776070691/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_incontact_skill/2026-04-13/1776070691",
        "key": "raw/dwh_dim_incontact_skill/2026-04-13/1776070691/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_incontact_skill",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3493792998562502808,
        "service_name": "redshift_unloads",
        "span_id": 12753256369717553752,
        "trace_id": 14427427289896942883
    }
}

running: False
schema_name_id: 264
start_time: 2026-04-13 03:59:36
success: True
trace_id: 14427427289896942883

Scan 161893630

duration: 0:00:14.102261

exit_message:

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

id: 161893630

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-prod",
            "key": "meta/dwh_dim_incontact_skill/2026-04-12/1775983604/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_incontact_skill/2026-04-12/1775983604",
        "key": "raw/dwh_dim_incontact_skill/2026-04-12/1775983604/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_incontact_skill",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 2891524223752265886,
        "service_name": "redshift_unloads",
        "span_id": 935869151479174372,
        "trace_id": 17812171340304586075
    }
}

running: False
schema_name_id: 264
start_time: 2026-04-12 03:47:03
success: True
trace_id: 17812171340304586075

Scan 161841461

duration: 0:00:14.127924

exit_message:

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

id: 161841461

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-prod",
            "key": "meta/dwh_dim_incontact_skill/2026-04-11/1775896909/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_incontact_skill/2026-04-11/1775896909",
        "key": "raw/dwh_dim_incontact_skill/2026-04-11/1775896909/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_incontact_skill",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13782222446179973003,
        "service_name": "redshift_unloads",
        "span_id": 6450497474350643624,
        "trace_id": 8683138681869535788
    }
}

running: False
schema_name_id: 264
start_time: 2026-04-11 03:41:56
success: True
trace_id: 8683138681869535788

Scan 161786171

duration: 0:00:14.117682

exit_message:

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

id: 161786171

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-prod",
            "key": "meta/dwh_dim_incontact_skill/2026-04-10/1775809480/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_incontact_skill/2026-04-10/1775809480",
        "key": "raw/dwh_dim_incontact_skill/2026-04-10/1775809480/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_incontact_skill",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 14956611610850104787,
        "service_name": "redshift_unloads",
        "span_id": 13555800795410398634,
        "trace_id": 1994863331532784966
    }
}

running: False
schema_name_id: 264
start_time: 2026-04-10 03:24:48
success: True
trace_id: 1994863331532784966

Scan 161730731

duration: 0:00:14.068003

exit_message:

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

id: 161730731

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-prod",
            "key": "meta/dwh_dim_incontact_skill/2026-04-09/1775724657/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_incontact_skill/2026-04-09/1775724657",
        "key": "raw/dwh_dim_incontact_skill/2026-04-09/1775724657/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_incontact_skill",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 5802130315596638677,
        "service_name": "redshift_unloads",
        "span_id": 9810330137451108427,
        "trace_id": 2066001064240082897
    }
}

running: False
schema_name_id: 264
start_time: 2026-04-09 03:51:07
success: True
trace_id: 2066001064240082897

Scan 161676913

duration: 0:00:11.561816

exit_message:

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

id: 161676913

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-prod",
            "key": "meta/dwh_dim_incontact_skill/2026-04-08/1775638862/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_incontact_skill/2026-04-08/1775638862",
        "key": "raw/dwh_dim_incontact_skill/2026-04-08/1775638862/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_incontact_skill",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 1590159861147700695,
        "service_name": "redshift_unloads",
        "span_id": 5876390361576636264,
        "trace_id": 2831675355124115699
    }
}

running: False
schema_name_id: 264
start_time: 2026-04-08 04:02:09
success: True
trace_id: 2831675355124115699

Scan 161619844

duration: 0:00:11.609657

exit_message:

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

id: 161619844

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-prod",
            "key": "meta/dwh_dim_incontact_skill/2026-04-07/1775552030/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_incontact_skill/2026-04-07/1775552030",
        "key": "raw/dwh_dim_incontact_skill/2026-04-07/1775552030/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_incontact_skill",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 11617322717940784212,
        "service_name": "redshift_unloads",
        "span_id": 5956803944887907525,
        "trace_id": 7732274243575473686
    }
}

running: False
schema_name_id: 264
start_time: 2026-04-07 03:54:00
success: True
trace_id: 7732274243575473686

Scan 161561922

duration: 0:00:14.287170

exit_message:

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

id: 161561922

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-prod",
            "key": "meta/dwh_dim_incontact_skill/2026-04-06/1775465423/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_incontact_skill/2026-04-06/1775465423",
        "key": "raw/dwh_dim_incontact_skill/2026-04-06/1775465423/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_incontact_skill",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 2912594269185806457,
        "service_name": "redshift_unloads",
        "span_id": 2954727834140165735,
        "trace_id": 6475234434298866229
    }
}

running: False
schema_name_id: 264
start_time: 2026-04-06 03:50:34
success: True
trace_id: 6475234434298866229

Scan 161515094

duration: 0:00:11.514957

exit_message:

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

id: 161515094

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-prod",
            "key": "meta/dwh_dim_incontact_skill/2026-04-05/1775378028/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_incontact_skill/2026-04-05/1775378028",
        "key": "raw/dwh_dim_incontact_skill/2026-04-05/1775378028/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_incontact_skill",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 10171299826085723520,
        "service_name": "redshift_unloads",
        "span_id": 8158603774598328720,
        "trace_id": 2429210627656576153
    }
}

running: False
schema_name_id: 264
start_time: 2026-04-05 03:33:59
success: True
trace_id: 2429210627656576153

Scan 161460695

duration: 0:00:14.147783

exit_message:

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

id: 161460695

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-prod",
            "key": "meta/dwh_dim_incontact_skill/2026-04-04/1775291514/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_incontact_skill/2026-04-04/1775291514",
        "key": "raw/dwh_dim_incontact_skill/2026-04-04/1775291514/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_incontact_skill",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 11432595935242590281,
        "service_name": "redshift_unloads",
        "span_id": 13434264165935797080,
        "trace_id": 512739891725527558
    }
}

running: False
schema_name_id: 264
start_time: 2026-04-04 03:32:04
success: True
trace_id: 512739891725527558

Scan 161402357

duration: 0:00:14.196563

exit_message:

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

id: 161402357

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-prod",
            "key": "meta/dwh_dim_incontact_skill/2026-04-03/1775206340/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_incontact_skill/2026-04-03/1775206340",
        "key": "raw/dwh_dim_incontact_skill/2026-04-03/1775206340/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_incontact_skill",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 4977005731369554801,
        "service_name": "redshift_unloads",
        "span_id": 14366540210672922402,
        "trace_id": 8270787736736844800
    }
}

running: False
schema_name_id: 264
start_time: 2026-04-03 03:52:30
success: True
trace_id: 8270787736736844800

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_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-prod/raw/dwh_dim_incontact_skill/2026-04-17/1776414758'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_incontact_skill`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_incontact_skill"
}

Server:

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

Raw:

{
    "name": {
        "created": "2018-02-28 10:54:37",
        "disabled": false,
        "format": "raw",
        "id": 264,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_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:32:50",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_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-prod/raw/dwh_dim_incontact_skill/2026-04-17/1776414758'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_incontact_skill`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_incontact_skill"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}