Schema Info

Schema Name: sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor

created: 2018-02-21 00:03:00
disabled: False
format: raw
id: 401
is_partitioned: False
is_schema_datatyped: True

name:

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

type: redshift

Schema Versions: 15

Version 906655

created: 2026-04-17 03:55:31

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor`\n(\n `audit_id`  bigint , `visitor_key`  bigint , `_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_image_verified_visitor/2026-04-17/1776415837'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_image_verified_visitor/2026-04-17/1776415837
id: 906655
processed: 1

raw_data:

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

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "visitor_key": "bigint"
}

schema_name_id: 401
schema_scan_id: 6415235
updated: 2026-04-17 03:55:43

Version 906436

created: 2026-04-16 04:06:28

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor`\n(\n `audit_id`  bigint , `visitor_key`  bigint , `_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_image_verified_visitor/2026-04-16/1776330044'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_image_verified_visitor/2026-04-16/1776330044
id: 906436
processed: 1

raw_data:

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

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "visitor_key": "bigint"
}

schema_name_id: 401
schema_scan_id: 6414686
updated: 2026-04-16 04:06:40

Version 906217

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor`\n(\n `audit_id`  bigint , `visitor_key`  bigint , `_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_image_verified_visitor/2026-04-15/1776243198'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_image_verified_visitor/2026-04-15/1776243198
id: 906217
processed: 1

raw_data:

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

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "visitor_key": "bigint"
}

schema_name_id: 401
schema_scan_id: 6414193
updated: 2026-04-15 03:58:42

Version 905980

created: 2026-04-14 03:50:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor`\n(\n `audit_id`  bigint , `visitor_key`  bigint , `_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_image_verified_visitor/2026-04-14/1776156253'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_image_verified_visitor/2026-04-14/1776156253
id: 905980
processed: 1

raw_data:

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

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "visitor_key": "bigint"
}

schema_name_id: 401
schema_scan_id: 6413666
updated: 2026-04-14 03:50:53

Version 905785

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor`\n(\n `audit_id`  bigint , `visitor_key`  bigint , `_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_image_verified_visitor/2026-04-13/1776069336'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_image_verified_visitor/2026-04-13/1776069336
id: 905785
processed: 1

raw_data:

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

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "visitor_key": "bigint"
}

schema_name_id: 401
schema_scan_id: 6413141
updated: 2026-04-13 03:40:52

Version 905596

created: 2026-04-12 04:06:45

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor`\n(\n `audit_id`  bigint , `visitor_key`  bigint , `_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_image_verified_visitor/2026-04-12/1775984517'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_image_verified_visitor/2026-04-12/1775984517
id: 905596
processed: 1

raw_data:

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

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "visitor_key": "bigint"
}

schema_name_id: 401
schema_scan_id: 6412761
updated: 2026-04-12 04:06:59

Version 905358

created: 2026-04-11 03:30:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor`\n(\n `audit_id`  bigint , `visitor_key`  bigint , `_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_image_verified_visitor/2026-04-11/1775895948'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_image_verified_visitor/2026-04-11/1775895948
id: 905358
processed: 1

raw_data:

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

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "visitor_key": "bigint"
}

schema_name_id: 401
schema_scan_id: 6412344
updated: 2026-04-11 03:30:49

Version 905156

created: 2026-04-10 03:46:59

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor`\n(\n `audit_id`  bigint , `visitor_key`  bigint , `_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_image_verified_visitor/2026-04-10/1775810523'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_image_verified_visitor/2026-04-10/1775810523
id: 905156
processed: 1

raw_data:

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

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "visitor_key": "bigint"
}

schema_name_id: 401
schema_scan_id: 6411861
updated: 2026-04-10 03:47:11

Version 904934

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor`\n(\n `audit_id`  bigint , `visitor_key`  bigint , `_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_image_verified_visitor/2026-04-09/1775724606'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_image_verified_visitor/2026-04-09/1775724606
id: 904934
processed: 1

raw_data:

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

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "visitor_key": "bigint"
}

schema_name_id: 401
schema_scan_id: 6411336
updated: 2026-04-09 03:56:13

Version 904716

created: 2026-04-08 03:37:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor`\n(\n `audit_id`  bigint , `visitor_key`  bigint , `_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_image_verified_visitor/2026-04-08/1775637159'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_image_verified_visitor/2026-04-08/1775637159
id: 904716
processed: 1

raw_data:

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

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "visitor_key": "bigint"
}

schema_name_id: 401
schema_scan_id: 6410837
updated: 2026-04-08 03:37:45

Version 904528

created: 2026-04-07 03:53:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor`\n(\n `audit_id`  bigint , `visitor_key`  bigint , `_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_image_verified_visitor/2026-04-07/1775551684'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_image_verified_visitor/2026-04-07/1775551684
id: 904528
processed: 1

raw_data:

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

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "visitor_key": "bigint"
}

schema_name_id: 401
schema_scan_id: 6410354
updated: 2026-04-07 03:53:59

Version 904317

created: 2026-04-06 04:01:37

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor`\n(\n `audit_id`  bigint , `visitor_key`  bigint , `_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_image_verified_visitor/2026-04-06/1775465792'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_image_verified_visitor/2026-04-06/1775465792
id: 904317
processed: 1

raw_data:

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

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "visitor_key": "bigint"
}

schema_name_id: 401
schema_scan_id: 6409811
updated: 2026-04-06 04:01:51

Version 904106

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor`\n(\n `audit_id`  bigint , `visitor_key`  bigint , `_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_image_verified_visitor/2026-04-05/1775378758'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_image_verified_visitor/2026-04-05/1775378758
id: 904106
processed: 1

raw_data:

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

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "visitor_key": "bigint"
}

schema_name_id: 401
schema_scan_id: 6409414
updated: 2026-04-05 03:51:08

Version 903913

created: 2026-04-04 03:44:26

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor`\n(\n `audit_id`  bigint , `visitor_key`  bigint , `_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_image_verified_visitor/2026-04-04/1775291981'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_image_verified_visitor/2026-04-04/1775291981
id: 903913
processed: 1

raw_data:

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

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "visitor_key": "bigint"
}

schema_name_id: 401
schema_scan_id: 6409042
updated: 2026-04-04 03:44:40

Version 903697

created: 2026-04-03 03:55:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor`\n(\n `audit_id`  bigint , `visitor_key`  bigint , `_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_image_verified_visitor/2026-04-03/1775206235'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_image_verified_visitor/2026-04-03/1775206235
id: 903697
processed: 1

raw_data:

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

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "visitor_key": "bigint"
}

schema_name_id: 401
schema_scan_id: 6408551
updated: 2026-04-03 03:55:40

Schema Scans: 15

Last at 2026-04-17 03:55:31

Scan 6415235

duration: 0:00:11.712525

exit_message:

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

id: 6415235

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "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_image_verified_visitor/2026-04-17/1776415837/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_image_verified_visitor/2026-04-17/1776415837",
        "key": "raw/dwh_dim_image_verified_visitor/2026-04-17/1776415837/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 16250739528379973110,
        "service_name": "redshift_unloads",
        "span_id": 10184316911042651874,
        "trace_id": 6984064604609559512
    }
}

running: False
schema_name_id: 401
start_time: 2026-04-17 03:55:31
success: True
trace_id: 6984064604609559512

Scan 6414686

duration: 0:00:11.798559

exit_message:

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

id: 6414686

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "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_image_verified_visitor/2026-04-16/1776330044/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_image_verified_visitor/2026-04-16/1776330044",
        "key": "raw/dwh_dim_image_verified_visitor/2026-04-16/1776330044/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 6140134850229719107,
        "service_name": "redshift_unloads",
        "span_id": 12597415927452773918,
        "trace_id": 7211604951221424488
    }
}

running: False
schema_name_id: 401
start_time: 2026-04-16 04:06:28
success: True
trace_id: 7211604951221424488

Scan 6414193

duration: 0:00:14.093416

exit_message:

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

id: 6414193

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "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_image_verified_visitor/2026-04-15/1776243198/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_image_verified_visitor/2026-04-15/1776243198",
        "key": "raw/dwh_dim_image_verified_visitor/2026-04-15/1776243198/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 5696022570851942020,
        "service_name": "redshift_unloads",
        "span_id": 16228714179632465976,
        "trace_id": 4700520063941094594
    }
}

running: False
schema_name_id: 401
start_time: 2026-04-15 03:58:28
success: True
trace_id: 4700520063941094594

Scan 6413666

duration: 0:00:11.638149

exit_message:

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

id: 6413666

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "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_image_verified_visitor/2026-04-14/1776156253/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_image_verified_visitor/2026-04-14/1776156253",
        "key": "raw/dwh_dim_image_verified_visitor/2026-04-14/1776156253/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 9091666426314024769,
        "service_name": "redshift_unloads",
        "span_id": 9996755699522750608,
        "trace_id": 11123614309993295507
    }
}

running: False
schema_name_id: 401
start_time: 2026-04-14 03:50:41
success: True
trace_id: 11123614309993295507

Scan 6413141

duration: 0:00:11.619197

exit_message:

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

id: 6413141

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "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_image_verified_visitor/2026-04-13/1776069336/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_image_verified_visitor/2026-04-13/1776069336",
        "key": "raw/dwh_dim_image_verified_visitor/2026-04-13/1776069336/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 2352468029184267995,
        "service_name": "redshift_unloads",
        "span_id": 15365037369291935536,
        "trace_id": 4824940034394165498
    }
}

running: False
schema_name_id: 401
start_time: 2026-04-13 03:40:41
success: True
trace_id: 4824940034394165498

Scan 6412761

duration: 0:00:14.141730

exit_message:

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

id: 6412761

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "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_image_verified_visitor/2026-04-12/1775984517/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_image_verified_visitor/2026-04-12/1775984517",
        "key": "raw/dwh_dim_image_verified_visitor/2026-04-12/1775984517/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 1932967868598907183,
        "service_name": "redshift_unloads",
        "span_id": 11515352494131166212,
        "trace_id": 3176788009356116825
    }
}

running: False
schema_name_id: 401
start_time: 2026-04-12 04:06:45
success: True
trace_id: 3176788009356116825

Scan 6412344

duration: 0:00:14.229431

exit_message:

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

id: 6412344

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "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_image_verified_visitor/2026-04-11/1775895948/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_image_verified_visitor/2026-04-11/1775895948",
        "key": "raw/dwh_dim_image_verified_visitor/2026-04-11/1775895948/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 6005374592840272541,
        "service_name": "redshift_unloads",
        "span_id": 10078033308094945117,
        "trace_id": 8321482066233734257
    }
}

running: False
schema_name_id: 401
start_time: 2026-04-11 03:30:35
success: True
trace_id: 8321482066233734257

Scan 6411861

duration: 0:00:11.725525

exit_message:

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

id: 6411861

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "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_image_verified_visitor/2026-04-10/1775810523/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_image_verified_visitor/2026-04-10/1775810523",
        "key": "raw/dwh_dim_image_verified_visitor/2026-04-10/1775810523/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3288901654604473039,
        "service_name": "redshift_unloads",
        "span_id": 14956908077627506561,
        "trace_id": 12985671197222004900
    }
}

running: False
schema_name_id: 401
start_time: 2026-04-10 03:46:59
success: True
trace_id: 12985671197222004900

Scan 6411336

duration: 0:00:14.281398

exit_message:

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

id: 6411336

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "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_image_verified_visitor/2026-04-09/1775724606/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_image_verified_visitor/2026-04-09/1775724606",
        "key": "raw/dwh_dim_image_verified_visitor/2026-04-09/1775724606/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3177289232929346326,
        "service_name": "redshift_unloads",
        "span_id": 13512676294828917521,
        "trace_id": 877535303927707272
    }
}

running: False
schema_name_id: 401
start_time: 2026-04-09 03:55:59
success: True
trace_id: 877535303927707272

Scan 6410837

duration: 0:00:11.654137

exit_message:

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

id: 6410837

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "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_image_verified_visitor/2026-04-08/1775637159/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_image_verified_visitor/2026-04-08/1775637159",
        "key": "raw/dwh_dim_image_verified_visitor/2026-04-08/1775637159/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13499530182832618308,
        "service_name": "redshift_unloads",
        "span_id": 4383002264935619162,
        "trace_id": 13634993478341621323
    }
}

running: False
schema_name_id: 401
start_time: 2026-04-08 03:37:34
success: True
trace_id: 13634993478341621323

Scan 6410354

duration: 0:00:11.796441

exit_message:

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

id: 6410354

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "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_image_verified_visitor/2026-04-07/1775551684/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_image_verified_visitor/2026-04-07/1775551684",
        "key": "raw/dwh_dim_image_verified_visitor/2026-04-07/1775551684/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13393153269471093114,
        "service_name": "redshift_unloads",
        "span_id": 6225485310100804488,
        "trace_id": 15986758126793548668
    }
}

running: False
schema_name_id: 401
start_time: 2026-04-07 03:53:47
success: True
trace_id: 15986758126793548668

Scan 6409811

duration: 0:00:14.217477

exit_message:

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

id: 6409811

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "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_image_verified_visitor/2026-04-06/1775465792/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_image_verified_visitor/2026-04-06/1775465792",
        "key": "raw/dwh_dim_image_verified_visitor/2026-04-06/1775465792/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 6704620899730843122,
        "service_name": "redshift_unloads",
        "span_id": 13408449183308368359,
        "trace_id": 2279892654847415015
    }
}

running: False
schema_name_id: 401
start_time: 2026-04-06 04:01:37
success: True
trace_id: 2279892654847415015

Scan 6409414

duration: 0:00:11.669602

exit_message:

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

id: 6409414

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "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_image_verified_visitor/2026-04-05/1775378758/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_image_verified_visitor/2026-04-05/1775378758",
        "key": "raw/dwh_dim_image_verified_visitor/2026-04-05/1775378758/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 2147170926458723437,
        "service_name": "redshift_unloads",
        "span_id": 12254895012446993416,
        "trace_id": 8096610515160297942
    }
}

running: False
schema_name_id: 401
start_time: 2026-04-05 03:50:57
success: True
trace_id: 8096610515160297942

Scan 6409042

duration: 0:00:14.173175

exit_message:

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

id: 6409042

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "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_image_verified_visitor/2026-04-04/1775291981/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_image_verified_visitor/2026-04-04/1775291981",
        "key": "raw/dwh_dim_image_verified_visitor/2026-04-04/1775291981/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 12259187534556934300,
        "service_name": "redshift_unloads",
        "span_id": 7423567066127055479,
        "trace_id": 16574140487485233632
    }
}

running: False
schema_name_id: 401
start_time: 2026-04-04 03:44:26
success: True
trace_id: 16574140487485233632

Scan 6408551

duration: 0:00:11.570294

exit_message:

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

id: 6408551

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "origin_key": "varchar",
        "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_image_verified_visitor/2026-04-03/1775206235/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_image_verified_visitor/2026-04-03/1775206235",
        "key": "raw/dwh_dim_image_verified_visitor/2026-04-03/1775206235/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 457484117116517350,
        "service_name": "redshift_unloads",
        "span_id": 14724625782770245450,
        "trace_id": 7917645245436831952
    }
}

running: False
schema_name_id: 401
start_time: 2026-04-03 03:55:28
success: True
trace_id: 7917645245436831952

Partitions:

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

Schema:

attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "visitor_key": "bigint"
}

created: 2026-04-17 03:55:31

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_image_verified_visitor`\n(\n `audit_id`  bigint , `visitor_key`  bigint , `_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_image_verified_visitor/2026-04-17/1776415837'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_image_verified_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:03:00",
        "disabled": false,
        "format": "raw",
        "id": 401,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_redshift",
            "table": "analytics_dwh_dim_image_verified_visitor"
        },
        "type": "redshift"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "_origin": "string",
            "audit_id": "bigint",
            "visitor_key": "bigint"
        },
        "created": "2026-04-17 03:55:31",
        "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_image_verified_visitor`\n(\n `audit_id`  bigint , `visitor_key`  bigint , `_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_image_verified_visitor/2026-04-17/1776415837'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_image_verified_visitor"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}