Schema Info

Schema Name: sfdl_prod_redshift.analytics_reference_dim_nvm_skill

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

name:

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

type: redshift

Schema Versions: 15

Version 1717851

created: 2026-04-17 03:19:05

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_nvm_skill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_nvm_skill`\n(\n `audit_id`  bigint , `nvm_skill_no`  int , `nvm_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/reference_dim_nvm_skill/2026-04-17/1776413938'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_nvm_skill"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_nvm_skill/2026-04-17/1776413938
id: 1717851
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "nvm_skill_name": "2",
    "nvm_skill_no": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "nvm_skill_name": "varchar(45)",
    "nvm_skill_no": "int"
}

schema_name_id: 414
schema_scan_id: 162167897
updated: 2026-04-17 03:19:16

Version 1716635

created: 2026-04-16 03:59:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_nvm_skill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_nvm_skill`\n(\n `audit_id`  bigint , `nvm_skill_no`  int , `nvm_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/reference_dim_nvm_skill/2026-04-16/1776329899'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_nvm_skill"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_nvm_skill/2026-04-16/1776329899
id: 1716635
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "nvm_skill_name": "2",
    "nvm_skill_no": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "nvm_skill_name": "varchar(45)",
    "nvm_skill_no": "int"
}

schema_name_id: 414
schema_scan_id: 162112871
updated: 2026-04-16 03:59:26

Version 1715421

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_nvm_skill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_nvm_skill`\n(\n `audit_id`  bigint , `nvm_skill_no`  int , `nvm_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/reference_dim_nvm_skill/2026-04-15/1776241936'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_nvm_skill"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_nvm_skill/2026-04-15/1776241936
id: 1715421
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "nvm_skill_name": "2",
    "nvm_skill_no": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "nvm_skill_name": "varchar(45)",
    "nvm_skill_no": "int"
}

schema_name_id: 414
schema_scan_id: 162056271
updated: 2026-04-15 03:32:44

Version 1714237

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_nvm_skill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_nvm_skill`\n(\n `audit_id`  bigint , `nvm_skill_no`  int , `nvm_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/reference_dim_nvm_skill/2026-04-14/1776155880'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_nvm_skill"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_nvm_skill/2026-04-14/1776155880
id: 1714237
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "nvm_skill_name": "2",
    "nvm_skill_no": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "nvm_skill_name": "varchar(45)",
    "nvm_skill_no": "int"
}

schema_name_id: 414
schema_scan_id: 162000803
updated: 2026-04-14 03:38:19

Version 1712991

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_nvm_skill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_nvm_skill`\n(\n `audit_id`  bigint , `nvm_skill_no`  int , `nvm_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/reference_dim_nvm_skill/2026-04-13/1776069402'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_nvm_skill"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_nvm_skill/2026-04-13/1776069402
id: 1712991
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "nvm_skill_name": "2",
    "nvm_skill_no": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "nvm_skill_name": "varchar(45)",
    "nvm_skill_no": "int"
}

schema_name_id: 414
schema_scan_id: 161942921
updated: 2026-04-13 03:37:09

Version 1711836

created: 2026-04-12 03:54:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_nvm_skill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_nvm_skill`\n(\n `audit_id`  bigint , `nvm_skill_no`  int , `nvm_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/reference_dim_nvm_skill/2026-04-12/1775984044'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_nvm_skill"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_nvm_skill/2026-04-12/1775984044
id: 1711836
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "nvm_skill_name": "2",
    "nvm_skill_no": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "nvm_skill_name": "varchar(45)",
    "nvm_skill_no": "int"
}

schema_name_id: 414
schema_scan_id: 161893721
updated: 2026-04-12 03:54:25

Version 1710636

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_nvm_skill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_nvm_skill`\n(\n `audit_id`  bigint , `nvm_skill_no`  int , `nvm_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/reference_dim_nvm_skill/2026-04-11/1775897815'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_nvm_skill"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_nvm_skill/2026-04-11/1775897815
id: 1710636
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "nvm_skill_name": "2",
    "nvm_skill_no": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "nvm_skill_name": "varchar(45)",
    "nvm_skill_no": "int"
}

schema_name_id: 414
schema_scan_id: 161841900
updated: 2026-04-11 03:57:30

Version 1709487

created: 2026-04-10 04:06:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_nvm_skill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_nvm_skill`\n(\n `audit_id`  bigint , `nvm_skill_no`  int , `nvm_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/reference_dim_nvm_skill/2026-04-10/1775811973'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_nvm_skill"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_nvm_skill/2026-04-10/1775811973
id: 1709487
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "nvm_skill_name": "2",
    "nvm_skill_no": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "nvm_skill_name": "varchar(45)",
    "nvm_skill_no": "int"
}

schema_name_id: 414
schema_scan_id: 161787376
updated: 2026-04-10 04:06:33

Version 1708296

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_nvm_skill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_nvm_skill`\n(\n `audit_id`  bigint , `nvm_skill_no`  int , `nvm_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/reference_dim_nvm_skill/2026-04-09/1775723291'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_nvm_skill"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_nvm_skill/2026-04-09/1775723291
id: 1708296
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "nvm_skill_name": "2",
    "nvm_skill_no": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "nvm_skill_name": "varchar(45)",
    "nvm_skill_no": "int"
}

schema_name_id: 414
schema_scan_id: 161730613
updated: 2026-04-09 03:28:36

Version 1707093

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_nvm_skill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_nvm_skill`\n(\n `audit_id`  bigint , `nvm_skill_no`  int , `nvm_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/reference_dim_nvm_skill/2026-04-08/1775636488'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_nvm_skill"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_nvm_skill/2026-04-08/1775636488
id: 1707093
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "nvm_skill_name": "2",
    "nvm_skill_no": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "nvm_skill_name": "varchar(45)",
    "nvm_skill_no": "int"
}

schema_name_id: 414
schema_scan_id: 161675791
updated: 2026-04-08 03:22:04

Version 1705921

created: 2026-04-07 03:34:03

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_nvm_skill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_nvm_skill`\n(\n `audit_id`  bigint , `nvm_skill_no`  int , `nvm_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/reference_dim_nvm_skill/2026-04-07/1775550829'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_nvm_skill"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_nvm_skill/2026-04-07/1775550829
id: 1705921
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "nvm_skill_name": "2",
    "nvm_skill_no": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "nvm_skill_name": "varchar(45)",
    "nvm_skill_no": "int"
}

schema_name_id: 414
schema_scan_id: 161619686
updated: 2026-04-07 03:34:17

Version 1704703

created: 2026-04-06 03:52:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_nvm_skill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_nvm_skill`\n(\n `audit_id`  bigint , `nvm_skill_no`  int , `nvm_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/reference_dim_nvm_skill/2026-04-06/1775465571'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_nvm_skill"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_nvm_skill/2026-04-06/1775465571
id: 1704703
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "nvm_skill_name": "2",
    "nvm_skill_no": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "nvm_skill_name": "varchar(45)",
    "nvm_skill_no": "int"
}

schema_name_id: 414
schema_scan_id: 161561953
updated: 2026-04-06 03:53:09

Version 1703505

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_nvm_skill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_nvm_skill`\n(\n `audit_id`  bigint , `nvm_skill_no`  int , `nvm_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/reference_dim_nvm_skill/2026-04-05/1775379419'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_nvm_skill"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_nvm_skill/2026-04-05/1775379419
id: 1703505
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "nvm_skill_name": "2",
    "nvm_skill_no": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "nvm_skill_name": "varchar(45)",
    "nvm_skill_no": "int"
}

schema_name_id: 414
schema_scan_id: 161515693
updated: 2026-04-05 03:57:53

Version 1702363

created: 2026-04-04 04:01:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_nvm_skill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_nvm_skill`\n(\n `audit_id`  bigint , `nvm_skill_no`  int , `nvm_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/reference_dim_nvm_skill/2026-04-04/1775293302'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_nvm_skill"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_nvm_skill/2026-04-04/1775293302
id: 1702363
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "nvm_skill_name": "2",
    "nvm_skill_no": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "nvm_skill_name": "varchar(45)",
    "nvm_skill_no": "int"
}

schema_name_id: 414
schema_scan_id: 161461916
updated: 2026-04-04 04:02:06

Version 1701121

created: 2026-04-03 03:34:10

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_nvm_skill`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_nvm_skill`\n(\n `audit_id`  bigint , `nvm_skill_no`  int , `nvm_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/reference_dim_nvm_skill/2026-04-03/1775205243'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_nvm_skill"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/reference_dim_nvm_skill/2026-04-03/1775205243
id: 1701121
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "nvm_skill_name": "2",
    "nvm_skill_no": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "nvm_skill_name": "varchar(45)",
    "nvm_skill_no": "int"
}

schema_name_id: 414
schema_scan_id: 161402146
updated: 2026-04-03 03:34:24

Schema Scans: 15

Last at 2026-04-17 03:19:04

Scan 162167897

duration: 0:00:11.600074

exit_message:

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

id: 162167897

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "nvm_skill_name": "varchar(45)",
        "nvm_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/reference_dim_nvm_skill/2026-04-17/1776413938/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_nvm_skill/2026-04-17/1776413938",
        "key": "raw/reference_dim_nvm_skill/2026-04-17/1776413938/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_nvm_skill",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8895817021942192533,
        "service_name": "redshift_unloads",
        "span_id": 17084185984972034221,
        "trace_id": 1181187165625756610
    }
}

running: False
schema_name_id: 414
start_time: 2026-04-17 03:19:04
success: True
trace_id: 1181187165625756610

Scan 162112871

duration: 0:00:14.125313

exit_message:

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

id: 162112871

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "nvm_skill_name": "varchar(45)",
        "nvm_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/reference_dim_nvm_skill/2026-04-16/1776329899/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_nvm_skill/2026-04-16/1776329899",
        "key": "raw/reference_dim_nvm_skill/2026-04-16/1776329899/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_nvm_skill",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15118862603431114462,
        "service_name": "redshift_unloads",
        "span_id": 4953568941913276748,
        "trace_id": 9642941956554848470
    }
}

running: False
schema_name_id: 414
start_time: 2026-04-16 03:59:11
success: True
trace_id: 9642941956554848470

Scan 162056271

duration: 0:00:14.179877

exit_message:

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

id: 162056271

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "nvm_skill_name": "varchar(45)",
        "nvm_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/reference_dim_nvm_skill/2026-04-15/1776241936/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_nvm_skill/2026-04-15/1776241936",
        "key": "raw/reference_dim_nvm_skill/2026-04-15/1776241936/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_nvm_skill",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 10145478793500458208,
        "service_name": "redshift_unloads",
        "span_id": 8432440669496745654,
        "trace_id": 4900920666259135914
    }
}

running: False
schema_name_id: 414
start_time: 2026-04-15 03:32:30
success: True
trace_id: 4900920666259135914

Scan 162000803

duration: 0:00:11.625117

exit_message:

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

id: 162000803

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "nvm_skill_name": "varchar(45)",
        "nvm_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/reference_dim_nvm_skill/2026-04-14/1776155880/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_nvm_skill/2026-04-14/1776155880",
        "key": "raw/reference_dim_nvm_skill/2026-04-14/1776155880/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_nvm_skill",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 7183815241550010252,
        "service_name": "redshift_unloads",
        "span_id": 301844480163157161,
        "trace_id": 11942032019010578997
    }
}

running: False
schema_name_id: 414
start_time: 2026-04-14 03:38:07
success: True
trace_id: 11942032019010578997

Scan 161942921

duration: 0:00:14.112341

exit_message:

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

id: 161942921

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "nvm_skill_name": "varchar(45)",
        "nvm_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/reference_dim_nvm_skill/2026-04-13/1776069402/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_nvm_skill/2026-04-13/1776069402",
        "key": "raw/reference_dim_nvm_skill/2026-04-13/1776069402/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_nvm_skill",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3964483090827120540,
        "service_name": "redshift_unloads",
        "span_id": 1119048187159503014,
        "trace_id": 3483536363451009544
    }
}

running: False
schema_name_id: 414
start_time: 2026-04-13 03:36:55
success: True
trace_id: 3483536363451009544

Scan 161893721

duration: 0:00:11.567033

exit_message:

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

id: 161893721

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "nvm_skill_name": "varchar(45)",
        "nvm_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/reference_dim_nvm_skill/2026-04-12/1775984044/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_nvm_skill/2026-04-12/1775984044",
        "key": "raw/reference_dim_nvm_skill/2026-04-12/1775984044/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_nvm_skill",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 10152603255522242340,
        "service_name": "redshift_unloads",
        "span_id": 6173898594604197983,
        "trace_id": 8306225262524503973
    }
}

running: False
schema_name_id: 414
start_time: 2026-04-12 03:54:14
success: True
trace_id: 8306225262524503973

Scan 161841900

duration: 0:00:11.594865

exit_message:

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

id: 161841900

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "nvm_skill_name": "varchar(45)",
        "nvm_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/reference_dim_nvm_skill/2026-04-11/1775897815/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_nvm_skill/2026-04-11/1775897815",
        "key": "raw/reference_dim_nvm_skill/2026-04-11/1775897815/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_nvm_skill",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 4894198712663390460,
        "service_name": "redshift_unloads",
        "span_id": 5640788104721200883,
        "trace_id": 11477580824729221965
    }
}

running: False
schema_name_id: 414
start_time: 2026-04-11 03:57:18
success: True
trace_id: 11477580824729221965

Scan 161787376

duration: 0:00:11.605581

exit_message:

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

id: 161787376

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "nvm_skill_name": "varchar(45)",
        "nvm_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/reference_dim_nvm_skill/2026-04-10/1775811973/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_nvm_skill/2026-04-10/1775811973",
        "key": "raw/reference_dim_nvm_skill/2026-04-10/1775811973/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_nvm_skill",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 5198327532775897873,
        "service_name": "redshift_unloads",
        "span_id": 9834119236062241573,
        "trace_id": 13718979343787543283
    }
}

running: False
schema_name_id: 414
start_time: 2026-04-10 04:06:21
success: True
trace_id: 13718979343787543283

Scan 161730613

duration: 0:00:11.578212

exit_message:

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

id: 161730613

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "nvm_skill_name": "varchar(45)",
        "nvm_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/reference_dim_nvm_skill/2026-04-09/1775723291/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_nvm_skill/2026-04-09/1775723291",
        "key": "raw/reference_dim_nvm_skill/2026-04-09/1775723291/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_nvm_skill",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8446374851778444303,
        "service_name": "redshift_unloads",
        "span_id": 4041241178994116257,
        "trace_id": 11712565884244485056
    }
}

running: False
schema_name_id: 414
start_time: 2026-04-09 03:28:24
success: True
trace_id: 11712565884244485056

Scan 161675791

duration: 0:00:11.700689

exit_message:

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

id: 161675791

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "nvm_skill_name": "varchar(45)",
        "nvm_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/reference_dim_nvm_skill/2026-04-08/1775636488/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_nvm_skill/2026-04-08/1775636488",
        "key": "raw/reference_dim_nvm_skill/2026-04-08/1775636488/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_nvm_skill",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 16292493056934336963,
        "service_name": "redshift_unloads",
        "span_id": 3214705061136366948,
        "trace_id": 9856535506040502108
    }
}

running: False
schema_name_id: 414
start_time: 2026-04-08 03:21:52
success: True
trace_id: 9856535506040502108

Scan 161619686

duration: 0:00:14.103194

exit_message:

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

id: 161619686

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "nvm_skill_name": "varchar(45)",
        "nvm_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/reference_dim_nvm_skill/2026-04-07/1775550829/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_nvm_skill/2026-04-07/1775550829",
        "key": "raw/reference_dim_nvm_skill/2026-04-07/1775550829/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_nvm_skill",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 6422693884203574640,
        "service_name": "redshift_unloads",
        "span_id": 12152831750623208129,
        "trace_id": 2430001278353858138
    }
}

running: False
schema_name_id: 414
start_time: 2026-04-07 03:34:03
success: True
trace_id: 2430001278353858138

Scan 161561953

duration: 0:00:11.648210

exit_message:

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

id: 161561953

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "nvm_skill_name": "varchar(45)",
        "nvm_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/reference_dim_nvm_skill/2026-04-06/1775465571/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_nvm_skill/2026-04-06/1775465571",
        "key": "raw/reference_dim_nvm_skill/2026-04-06/1775465571/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_nvm_skill",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 1165402633335109381,
        "service_name": "redshift_unloads",
        "span_id": 3449350433531736110,
        "trace_id": 31424130724159678
    }
}

running: False
schema_name_id: 414
start_time: 2026-04-06 03:52:58
success: True
trace_id: 31424130724159678

Scan 161515693

duration: 0:00:11.829238

exit_message:

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

id: 161515693

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "nvm_skill_name": "varchar(45)",
        "nvm_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/reference_dim_nvm_skill/2026-04-05/1775379419/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_nvm_skill/2026-04-05/1775379419",
        "key": "raw/reference_dim_nvm_skill/2026-04-05/1775379419/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_nvm_skill",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13345081821587015521,
        "service_name": "redshift_unloads",
        "span_id": 14185960456683458163,
        "trace_id": 14864769973154768172
    }
}

running: False
schema_name_id: 414
start_time: 2026-04-05 03:57:41
success: True
trace_id: 14864769973154768172

Scan 161461916

duration: 0:00:14.213730

exit_message:

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

id: 161461916

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "nvm_skill_name": "varchar(45)",
        "nvm_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/reference_dim_nvm_skill/2026-04-04/1775293302/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_nvm_skill/2026-04-04/1775293302",
        "key": "raw/reference_dim_nvm_skill/2026-04-04/1775293302/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_nvm_skill",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3519520953648074086,
        "service_name": "redshift_unloads",
        "span_id": 7775223287399343387,
        "trace_id": 3309980144827794231
    }
}

running: False
schema_name_id: 414
start_time: 2026-04-04 04:01:51
success: True
trace_id: 3309980144827794231

Scan 161402146

duration: 0:00:14.214103

exit_message:

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

id: 161402146

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "nvm_skill_name": "varchar(45)",
        "nvm_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/reference_dim_nvm_skill/2026-04-03/1775205243/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/reference_dim_nvm_skill/2026-04-03/1775205243",
        "key": "raw/reference_dim_nvm_skill/2026-04-03/1775205243/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_reference_dim_nvm_skill",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 10092169849420183194,
        "service_name": "redshift_unloads",
        "span_id": 846230118586191696,
        "trace_id": 11589295845856389872
    }
}

running: False
schema_name_id: 414
start_time: 2026-04-03 03:34:10
success: True
trace_id: 11589295845856389872

Partitions:

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

Schema:

attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "nvm_skill_name": "varchar(45)",
    "nvm_skill_no": "int"
}

created: 2026-04-17 03:19:05

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_nvm_skill`\n(\n `audit_id`  bigint , `nvm_skill_no`  int , `nvm_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/reference_dim_nvm_skill/2026-04-17/1776413938'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_nvm_skill`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_nvm_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-05-08 14:20:51",
        "disabled": false,
        "format": "raw",
        "id": 414,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_redshift",
            "table": "analytics_reference_dim_nvm_skill"
        },
        "type": "redshift"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "_origin": "string",
            "audit_id": "bigint",
            "nvm_skill_name": "varchar(45)",
            "nvm_skill_no": "int"
        },
        "created": "2026-04-17 03:19:05",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_reference_dim_nvm_skill`\n(\n `audit_id`  bigint , `nvm_skill_no`  int , `nvm_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/reference_dim_nvm_skill/2026-04-17/1776413938'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_reference_dim_nvm_skill`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_reference_dim_nvm_skill"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}