Schema Info

Schema Name: sfdl_prod_redshift.analytics_dwh_dim_problem_visitor

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

name:

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

type: redshift

Schema Versions: 15

Version 1717859

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_problem_visitor`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_problem_visitor`\n(\n `audit_id`  bigint , `visitor_key`  bigint , `problem_type`  varchar(32) , `_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_problem_visitor/2026-04-17/1776413964'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_problem_visitor"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_problem_visitor/2026-04-17/1776413964
id: 1717859
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "problem_type": "2",
    "visitor_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "problem_type": "varchar(32)",
    "visitor_key": "bigint"
}

schema_name_id: 261
schema_scan_id: 162167905
updated: 2026-04-17 03:19:57

Version 1716636

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_problem_visitor`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_problem_visitor`\n(\n `audit_id`  bigint , `visitor_key`  bigint , `problem_type`  varchar(32) , `_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_problem_visitor/2026-04-16/1776329893'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_problem_visitor"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_problem_visitor/2026-04-16/1776329893
id: 1716636
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "problem_type": "2",
    "visitor_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "problem_type": "varchar(32)",
    "visitor_key": "bigint"
}

schema_name_id: 261
schema_scan_id: 162112895
updated: 2026-04-16 03:59:35

Version 1715574

created: 2026-04-15 03:51:13

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_problem_visitor`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_problem_visitor`\n(\n `audit_id`  bigint , `visitor_key`  bigint , `problem_type`  varchar(32) , `_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_problem_visitor/2026-04-15/1776243054'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_problem_visitor"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_problem_visitor/2026-04-15/1776243054
id: 1715574
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "problem_type": "2",
    "visitor_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "problem_type": "varchar(32)",
    "visitor_key": "bigint"
}

schema_name_id: 261
schema_scan_id: 162056525
updated: 2026-04-15 03:51:26

Version 1714285

created: 2026-04-14 04:03:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_problem_visitor`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_problem_visitor`\n(\n `audit_id`  bigint , `visitor_key`  bigint , `problem_type`  varchar(32) , `_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_problem_visitor/2026-04-14/1776157390'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_problem_visitor"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_problem_visitor/2026-04-14/1776157390
id: 1714285
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "problem_type": "2",
    "visitor_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "problem_type": "varchar(32)",
    "visitor_key": "bigint"
}

schema_name_id: 261
schema_scan_id: 162001924
updated: 2026-04-14 04:03:33

Version 1713032

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_problem_visitor`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_problem_visitor`\n(\n `audit_id`  bigint , `visitor_key`  bigint , `problem_type`  varchar(32) , `_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_problem_visitor/2026-04-13/1776070511'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_problem_visitor"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_problem_visitor/2026-04-13/1776070511
id: 1713032
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "problem_type": "2",
    "visitor_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "problem_type": "varchar(32)",
    "visitor_key": "bigint"
}

schema_name_id: 261
schema_scan_id: 161943143
updated: 2026-04-13 03:55:40

Version 1711826

created: 2026-04-12 03:50:27

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_problem_visitor`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_problem_visitor`\n(\n `audit_id`  bigint , `visitor_key`  bigint , `problem_type`  varchar(32) , `_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_problem_visitor/2026-04-12/1775983811'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_problem_visitor"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_problem_visitor/2026-04-12/1775983811
id: 1711826
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "problem_type": "2",
    "visitor_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "problem_type": "varchar(32)",
    "visitor_key": "bigint"
}

schema_name_id: 261
schema_scan_id: 161893648
updated: 2026-04-12 03:50:41

Version 1710612

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_problem_visitor`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_problem_visitor`\n(\n `audit_id`  bigint , `visitor_key`  bigint , `problem_type`  varchar(32) , `_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_problem_visitor/2026-04-11/1775896865'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_problem_visitor"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_problem_visitor/2026-04-11/1775896865
id: 1710612
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "problem_type": "2",
    "visitor_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "problem_type": "varchar(32)",
    "visitor_key": "bigint"
}

schema_name_id: 261
schema_scan_id: 161841451
updated: 2026-04-11 03:41:31

Version 1709435

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_problem_visitor`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_problem_visitor`\n(\n `audit_id`  bigint , `visitor_key`  bigint , `problem_type`  varchar(32) , `_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_problem_visitor/2026-04-10/1775809473'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_problem_visitor"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_problem_visitor/2026-04-10/1775809473
id: 1709435
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "problem_type": "2",
    "visitor_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "problem_type": "varchar(32)",
    "visitor_key": "bigint"
}

schema_name_id: 261
schema_scan_id: 161786170
updated: 2026-04-10 03:24:55

Version 1708344

created: 2026-04-09 03:50:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_problem_visitor`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_problem_visitor`\n(\n `audit_id`  bigint , `visitor_key`  bigint , `problem_type`  varchar(32) , `_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_problem_visitor/2026-04-09/1775724641'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_problem_visitor"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_problem_visitor/2026-04-09/1775724641
id: 1708344
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "problem_type": "2",
    "visitor_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "problem_type": "varchar(32)",
    "visitor_key": "bigint"
}

schema_name_id: 261
schema_scan_id: 161730723
updated: 2026-04-09 03:51:02

Version 1707116

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_problem_visitor`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_problem_visitor`\n(\n `audit_id`  bigint , `visitor_key`  bigint , `problem_type`  varchar(32) , `_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_problem_visitor/2026-04-08/1775637373'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_problem_visitor"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_problem_visitor/2026-04-08/1775637373
id: 1707116
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "problem_type": "2",
    "visitor_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "problem_type": "varchar(32)",
    "visitor_key": "bigint"
}

schema_name_id: 261
schema_scan_id: 161675825
updated: 2026-04-08 03:36:38

Version 1705926

created: 2026-04-07 03:39:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_problem_visitor`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_problem_visitor`\n(\n `audit_id`  bigint , `visitor_key`  bigint , `problem_type`  varchar(32) , `_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_problem_visitor/2026-04-07/1775551166'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_problem_visitor"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_problem_visitor/2026-04-07/1775551166
id: 1705926
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "problem_type": "2",
    "visitor_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "problem_type": "varchar(32)",
    "visitor_key": "bigint"
}

schema_name_id: 261
schema_scan_id: 161619718
updated: 2026-04-07 03:39:58

Version 1704714

created: 2026-04-06 03:59:59

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_problem_visitor`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_problem_visitor`\n(\n `audit_id`  bigint , `visitor_key`  bigint , `problem_type`  varchar(32) , `_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_problem_visitor/2026-04-06/1775465987'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_problem_visitor"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_problem_visitor/2026-04-06/1775465987
id: 1704714
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "problem_type": "2",
    "visitor_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "problem_type": "varchar(32)",
    "visitor_key": "bigint"
}

schema_name_id: 261
schema_scan_id: 161562825
updated: 2026-04-06 04:00:10

Version 1703503

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_problem_visitor`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_problem_visitor`\n(\n `audit_id`  bigint , `visitor_key`  bigint , `problem_type`  varchar(32) , `_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_problem_visitor/2026-04-05/1775379373'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_problem_visitor"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_problem_visitor/2026-04-05/1775379373
id: 1703503
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "problem_type": "2",
    "visitor_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "problem_type": "varchar(32)",
    "visitor_key": "bigint"
}

schema_name_id: 261
schema_scan_id: 161515613
updated: 2026-04-05 03:57:29

Version 1702334

created: 2026-04-04 03:34:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_problem_visitor`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_problem_visitor`\n(\n `audit_id`  bigint , `visitor_key`  bigint , `problem_type`  varchar(32) , `_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_problem_visitor/2026-04-04/1775291669'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_problem_visitor"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_problem_visitor/2026-04-04/1775291669
id: 1702334
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "problem_type": "2",
    "visitor_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "problem_type": "varchar(32)",
    "visitor_key": "bigint"
}

schema_name_id: 261
schema_scan_id: 161460705
updated: 2026-04-04 03:35:01

Version 1701137

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_problem_visitor`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_problem_visitor`\n(\n `audit_id`  bigint , `visitor_key`  bigint , `problem_type`  varchar(32) , `_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_problem_visitor/2026-04-03/1775205344'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_problem_visitor"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_problem_visitor/2026-04-03/1775205344
id: 1701137
processed: 1

raw_data:

{
    "_origin": "3",
    "audit_id": "0",
    "problem_type": "2",
    "visitor_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "problem_type": "varchar(32)",
    "visitor_key": "bigint"
}

schema_name_id: 261
schema_scan_id: 161402165
updated: 2026-04-03 03:36:20

Schema Scans: 15

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

Scan 162167905

duration: 0:00:14.045754

exit_message:

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

id: 162167905

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "problem_type": "varchar(32)",
        "visitor_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_problem_visitor/2026-04-17/1776413964/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_problem_visitor/2026-04-17/1776413964",
        "key": "raw/dwh_dim_problem_visitor/2026-04-17/1776413964/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_problem_visitor",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 2006496758958500437,
        "service_name": "redshift_unloads",
        "span_id": 6961764006075928271,
        "trace_id": 2921118384585040979
    }
}

running: False
schema_name_id: 261
start_time: 2026-04-17 03:19:43
success: True
trace_id: 2921118384585040979

Scan 162112895

duration: 0:00:14.140918

exit_message:

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

id: 162112895

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "problem_type": "varchar(32)",
        "visitor_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_problem_visitor/2026-04-16/1776329893/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_problem_visitor/2026-04-16/1776329893",
        "key": "raw/dwh_dim_problem_visitor/2026-04-16/1776329893/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_problem_visitor",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 17602596859946684710,
        "service_name": "redshift_unloads",
        "span_id": 4508218963446098846,
        "trace_id": 5065455114870614604
    }
}

running: False
schema_name_id: 261
start_time: 2026-04-16 03:59:21
success: True
trace_id: 5065455114870614604

Scan 162056525

duration: 0:00:14.077267

exit_message:

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

id: 162056525

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "problem_type": "varchar(32)",
        "visitor_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_problem_visitor/2026-04-15/1776243054/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_problem_visitor/2026-04-15/1776243054",
        "key": "raw/dwh_dim_problem_visitor/2026-04-15/1776243054/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_problem_visitor",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15746889321188703117,
        "service_name": "redshift_unloads",
        "span_id": 8461840941091746956,
        "trace_id": 14660507187126262512
    }
}

running: False
schema_name_id: 261
start_time: 2026-04-15 03:51:12
success: True
trace_id: 14660507187126262512

Scan 162001924

duration: 0:00:14.155742

exit_message:

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

id: 162001924

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "problem_type": "varchar(32)",
        "visitor_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_problem_visitor/2026-04-14/1776157390/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_problem_visitor/2026-04-14/1776157390",
        "key": "raw/dwh_dim_problem_visitor/2026-04-14/1776157390/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_problem_visitor",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 881497855927989312,
        "service_name": "redshift_unloads",
        "span_id": 17006433190116084785,
        "trace_id": 9856456420715927381
    }
}

running: False
schema_name_id: 261
start_time: 2026-04-14 04:03:19
success: True
trace_id: 9856456420715927381

Scan 161943143

duration: 0:00:14.145639

exit_message:

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

id: 161943143

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "problem_type": "varchar(32)",
        "visitor_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_problem_visitor/2026-04-13/1776070511/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_problem_visitor/2026-04-13/1776070511",
        "key": "raw/dwh_dim_problem_visitor/2026-04-13/1776070511/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_problem_visitor",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 4118806521802483514,
        "service_name": "redshift_unloads",
        "span_id": 12612152079584091678,
        "trace_id": 1656346651177970051
    }
}

running: False
schema_name_id: 261
start_time: 2026-04-13 03:55:26
success: True
trace_id: 1656346651177970051

Scan 161893648

duration: 0:00:14.363942

exit_message:

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

id: 161893648

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "problem_type": "varchar(32)",
        "visitor_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_problem_visitor/2026-04-12/1775983811/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_problem_visitor/2026-04-12/1775983811",
        "key": "raw/dwh_dim_problem_visitor/2026-04-12/1775983811/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_problem_visitor",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15450452539368973664,
        "service_name": "redshift_unloads",
        "span_id": 2289367640249045331,
        "trace_id": 4099141426212741771
    }
}

running: False
schema_name_id: 261
start_time: 2026-04-12 03:50:26
success: True
trace_id: 4099141426212741771

Scan 161841451

duration: 0:00:11.601064

exit_message:

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

id: 161841451

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "problem_type": "varchar(32)",
        "visitor_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_problem_visitor/2026-04-11/1775896865/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_problem_visitor/2026-04-11/1775896865",
        "key": "raw/dwh_dim_problem_visitor/2026-04-11/1775896865/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_problem_visitor",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13160171989310740254,
        "service_name": "redshift_unloads",
        "span_id": 4703300520034434815,
        "trace_id": 6045993298820719381
    }
}

running: False
schema_name_id: 261
start_time: 2026-04-11 03:41:20
success: True
trace_id: 6045993298820719381

Scan 161786170

duration: 0:00:11.586010

exit_message:

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

id: 161786170

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "problem_type": "varchar(32)",
        "visitor_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_problem_visitor/2026-04-10/1775809473/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_problem_visitor/2026-04-10/1775809473",
        "key": "raw/dwh_dim_problem_visitor/2026-04-10/1775809473/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_problem_visitor",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 10778236508633552633,
        "service_name": "redshift_unloads",
        "span_id": 9152617234620377480,
        "trace_id": 15116651735830310058
    }
}

running: False
schema_name_id: 261
start_time: 2026-04-10 03:24:43
success: True
trace_id: 15116651735830310058

Scan 161730723

duration: 0:00:11.548291

exit_message:

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

id: 161730723

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "problem_type": "varchar(32)",
        "visitor_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_problem_visitor/2026-04-09/1775724641/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_problem_visitor/2026-04-09/1775724641",
        "key": "raw/dwh_dim_problem_visitor/2026-04-09/1775724641/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_problem_visitor",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 1647816372046956360,
        "service_name": "redshift_unloads",
        "span_id": 17144115077953649251,
        "trace_id": 14222437035585662785
    }
}

running: False
schema_name_id: 261
start_time: 2026-04-09 03:50:50
success: True
trace_id: 14222437035585662785

Scan 161675825

duration: 0:00:14.228843

exit_message:

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

id: 161675825

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "problem_type": "varchar(32)",
        "visitor_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_problem_visitor/2026-04-08/1775637373/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_problem_visitor/2026-04-08/1775637373",
        "key": "raw/dwh_dim_problem_visitor/2026-04-08/1775637373/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_problem_visitor",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 6604920912642739324,
        "service_name": "redshift_unloads",
        "span_id": 303719648328712272,
        "trace_id": 7754725622986011196
    }
}

running: False
schema_name_id: 261
start_time: 2026-04-08 03:36:23
success: True
trace_id: 7754725622986011196

Scan 161619718

duration: 0:00:14.169492

exit_message:

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

id: 161619718

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "problem_type": "varchar(32)",
        "visitor_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_problem_visitor/2026-04-07/1775551166/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_problem_visitor/2026-04-07/1775551166",
        "key": "raw/dwh_dim_problem_visitor/2026-04-07/1775551166/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_problem_visitor",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3641944065449525695,
        "service_name": "redshift_unloads",
        "span_id": 1651091359877958403,
        "trace_id": 16402155206008783932
    }
}

running: False
schema_name_id: 261
start_time: 2026-04-07 03:39:44
success: True
trace_id: 16402155206008783932

Scan 161562825

duration: 0:00:11.611264

exit_message:

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

id: 161562825

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "problem_type": "varchar(32)",
        "visitor_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_problem_visitor/2026-04-06/1775465987/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_problem_visitor/2026-04-06/1775465987",
        "key": "raw/dwh_dim_problem_visitor/2026-04-06/1775465987/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_problem_visitor",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 6674931094837873857,
        "service_name": "redshift_unloads",
        "span_id": 11749675795563238146,
        "trace_id": 10581616235560490612
    }
}

running: False
schema_name_id: 261
start_time: 2026-04-06 03:59:59
success: True
trace_id: 10581616235560490612

Scan 161515613

duration: 0:00:14.250179

exit_message:

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

id: 161515613

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "problem_type": "varchar(32)",
        "visitor_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_problem_visitor/2026-04-05/1775379373/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_problem_visitor/2026-04-05/1775379373",
        "key": "raw/dwh_dim_problem_visitor/2026-04-05/1775379373/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_problem_visitor",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 11519360564352811493,
        "service_name": "redshift_unloads",
        "span_id": 13240243087132256275,
        "trace_id": 3184829157157832966
    }
}

running: False
schema_name_id: 261
start_time: 2026-04-05 03:57:15
success: True
trace_id: 3184829157157832966

Scan 161460705

duration: 0:00:14.122813

exit_message:

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

id: 161460705

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "problem_type": "varchar(32)",
        "visitor_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_problem_visitor/2026-04-04/1775291669/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_problem_visitor/2026-04-04/1775291669",
        "key": "raw/dwh_dim_problem_visitor/2026-04-04/1775291669/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_problem_visitor",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 4862444760645369301,
        "service_name": "redshift_unloads",
        "span_id": 4294054433737795355,
        "trace_id": 8662455246245082055
    }
}

running: False
schema_name_id: 261
start_time: 2026-04-04 03:34:47
success: True
trace_id: 8662455246245082055

Scan 161402165

duration: 0:00:14.113359

exit_message:

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

id: 161402165

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "problem_type": "varchar(32)",
        "visitor_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_problem_visitor/2026-04-03/1775205344/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_problem_visitor/2026-04-03/1775205344",
        "key": "raw/dwh_dim_problem_visitor/2026-04-03/1775205344/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_problem_visitor",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3696313477607060138,
        "service_name": "redshift_unloads",
        "span_id": 10546690352868099453,
        "trace_id": 6362918775942901822
    }
}

running: False
schema_name_id: 261
start_time: 2026-04-03 03:36:06
success: True
trace_id: 6362918775942901822

Partitions:

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

Schema:

attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "problem_type": "varchar(32)",
    "visitor_key": "bigint"
}

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

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_problem_visitor`\n(\n `audit_id`  bigint , `visitor_key`  bigint , `problem_type`  varchar(32) , `_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_problem_visitor/2026-04-17/1776413964'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_problem_visitor`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_problem_visitor"
}

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:16",
        "disabled": false,
        "format": "raw",
        "id": 261,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_redshift",
            "table": "analytics_dwh_dim_problem_visitor"
        },
        "type": "redshift"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "_origin": "string",
            "audit_id": "bigint",
            "problem_type": "varchar(32)",
            "visitor_key": "bigint"
        },
        "created": "2026-04-17 03:19:43",
        "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_problem_visitor`\n(\n `audit_id`  bigint , `visitor_key`  bigint , `problem_type`  varchar(32) , `_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_problem_visitor/2026-04-17/1776413964'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_problem_visitor`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_problem_visitor"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}