Schema Info

Schema Name: sfdl_stage_redshift.analytics_dwh_dim_problem_visitor

created: 2018-02-21 00:01:25
disabled: False
format: raw
id: 394
is_partitioned: False
is_schema_datatyped: True

name:

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

type: redshift

Schema Versions: 15

Version 906652

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

ddl:

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

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_problem_visitor/2026-04-17/1776415823
id: 906652
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: 394
schema_scan_id: 6415232
updated: 2026-04-17 03:50:49

Version 906425

created: 2026-04-16 04:00:53

ddl:

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

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_problem_visitor/2026-04-16/1776330033
id: 906425
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: 394
schema_scan_id: 6414675
updated: 2026-04-16 04:01:07

Version 906216

created: 2026-04-15 03:53:30

ddl:

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

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_problem_visitor/2026-04-15/1776243188
id: 906216
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: 394
schema_scan_id: 6414192
updated: 2026-04-15 03:53:41

Version 906005

created: 2026-04-14 03:55:48

ddl:

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

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_problem_visitor/2026-04-14/1776156934
id: 906005
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: 394
schema_scan_id: 6413691
updated: 2026-04-14 03:56:00

Version 905791

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

ddl:

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

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_problem_visitor/2026-04-13/1776069644
id: 905791
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: 394
schema_scan_id: 6413147
updated: 2026-04-13 03:41:10

Version 905579

created: 2026-04-12 03:58:31

ddl:

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

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_problem_visitor/2026-04-12/1775984281
id: 905579
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: 394
schema_scan_id: 6412743
updated: 2026-04-12 03:58:45

Version 905370

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

ddl:

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

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_problem_visitor/2026-04-11/1775896346
id: 905370
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: 394
schema_scan_id: 6412355
updated: 2026-04-11 03:32:48

Version 905146

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

ddl:

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

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_problem_visitor/2026-04-10/1775809465
id: 905146
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: 394
schema_scan_id: 6411850
updated: 2026-04-10 03:24:56

Version 904931

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

ddl:

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

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_problem_visitor/2026-04-09/1775724920
id: 904931
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: 394
schema_scan_id: 6411333
updated: 2026-04-09 03:56:03

Version 904720

created: 2026-04-08 03:39:18

ddl:

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

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_problem_visitor/2026-04-08/1775637548
id: 904720
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: 394
schema_scan_id: 6410841
updated: 2026-04-08 03:39:30

Version 904525

created: 2026-04-07 03:48:00

ddl:

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

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_problem_visitor/2026-04-07/1775551670
id: 904525
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: 394
schema_scan_id: 6410351
updated: 2026-04-07 03:48:11

Version 904309

created: 2026-04-06 03:56:31

ddl:

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

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_problem_visitor/2026-04-06/1775465781
id: 904309
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: 394
schema_scan_id: 6409803
updated: 2026-04-06 03:56:42

Version 904116

created: 2026-04-05 04:04:56

ddl:

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

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_problem_visitor/2026-04-05/1775379867
id: 904116
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: 394
schema_scan_id: 6409424
updated: 2026-04-05 04:05:10

Version 903903

created: 2026-04-04 03:39:38

ddl:

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

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_problem_visitor/2026-04-04/1775291968
id: 903903
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: 394
schema_scan_id: 6409032
updated: 2026-04-04 03:39:52

Version 903680

created: 2026-04-03 03:45:10

ddl:

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

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_problem_visitor/2026-04-03/1775205886
id: 903680
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: 394
schema_scan_id: 6408534
updated: 2026-04-03 03:45:21

Schema Scans: 15

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

Scan 6415232

duration: 0:00:11.679574

exit_message:

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

id: 6415232

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

running: False
schema_name_id: 394
start_time: 2026-04-17 03:50:37
success: True
trace_id: 14401941804813969472

Scan 6414675

duration: 0:00:14.256457

exit_message:

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

id: 6414675

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

running: False
schema_name_id: 394
start_time: 2026-04-16 04:00:53
success: True
trace_id: 3718377512462732133

Scan 6414192

duration: 0:00:11.741607

exit_message:

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

id: 6414192

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

running: False
schema_name_id: 394
start_time: 2026-04-15 03:53:29
success: True
trace_id: 5255561814487384077

Scan 6413691

duration: 0:00:11.758212

exit_message:

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

id: 6413691

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

running: False
schema_name_id: 394
start_time: 2026-04-14 03:55:48
success: True
trace_id: 1434037860063013717

Scan 6413147

duration: 0:00:14.181958

exit_message:

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

id: 6413147

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

running: False
schema_name_id: 394
start_time: 2026-04-13 03:40:56
success: True
trace_id: 388389650417837586

Scan 6412743

duration: 0:00:14.128734

exit_message:

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

id: 6412743

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

running: False
schema_name_id: 394
start_time: 2026-04-12 03:58:31
success: True
trace_id: 11291374053806941763

Scan 6412355

duration: 0:00:11.640529

exit_message:

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

id: 6412355

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

running: False
schema_name_id: 394
start_time: 2026-04-11 03:32:36
success: True
trace_id: 5506995395809811493

Scan 6411850

duration: 0:00:11.613065

exit_message:

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

id: 6411850

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

running: False
schema_name_id: 394
start_time: 2026-04-10 03:24:44
success: True
trace_id: 12628998528814000931

Scan 6411333

duration: 0:00:14.323076

exit_message:

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

id: 6411333

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

running: False
schema_name_id: 394
start_time: 2026-04-09 03:55:48
success: True
trace_id: 10264056718737866037

Scan 6410841

duration: 0:00:11.731489

exit_message:

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

id: 6410841

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

running: False
schema_name_id: 394
start_time: 2026-04-08 03:39:18
success: True
trace_id: 9819801094708357048

Scan 6410351

duration: 0:00:11.705145

exit_message:

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

id: 6410351

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

running: False
schema_name_id: 394
start_time: 2026-04-07 03:48:00
success: True
trace_id: 11238201887180130138

Scan 6409803

duration: 0:00:11.669563

exit_message:

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

id: 6409803

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

running: False
schema_name_id: 394
start_time: 2026-04-06 03:56:30
success: True
trace_id: 17292957556566524486

Scan 6409424

duration: 0:00:14.220457

exit_message:

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

id: 6409424

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

running: False
schema_name_id: 394
start_time: 2026-04-05 04:04:56
success: True
trace_id: 3856198270870910358

Scan 6409032

duration: 0:00:14.143993

exit_message:

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

id: 6409032

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

running: False
schema_name_id: 394
start_time: 2026-04-04 03:39:38
success: True
trace_id: 9286649972895378907

Scan 6408534

duration: 0:00:11.597159

exit_message:

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

id: 6408534

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

running: False
schema_name_id: 394
start_time: 2026-04-03 03:45:10
success: True
trace_id: 162313081057974780

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

ddl:

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

Server:

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

Raw:

{
    "name": {
        "created": "2018-02-21 00:01:25",
        "disabled": false,
        "format": "raw",
        "id": 394,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_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:50:37",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_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-stage/raw/dwh_dim_problem_visitor/2026-04-17/1776415823'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_problem_visitor`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_problem_visitor"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}