Schema Info

Schema Name: sfdl_stage_redshift.analytics_reference_image_verified_visit_patch

created: 2018-05-09 11:02:45
disabled: False
format: raw
id: 528
is_partitioned: False
is_schema_datatyped: True

name:

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

type: redshift

Schema Versions: 15

Version 906610

created: 2026-04-17 03:36:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_image_verified_visit_patch`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_image_verified_visit_patch`\n(\n `visit_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/reference_image_verified_visit_patch/2026-04-17/1776414976'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_image_verified_visit_patch"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_image_verified_visit_patch/2026-04-17/1776414976
id: 906610
processed: 1

raw_data:

{
    "_origin": "1",
    "visit_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "visit_key": "bigint"
}

schema_name_id: 528
schema_scan_id: 6415190
updated: 2026-04-17 03:36:49

Version 906405

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_image_verified_visit_patch`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_image_verified_visit_patch`\n(\n `visit_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/reference_image_verified_visit_patch/2026-04-16/1776329927'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_image_verified_visit_patch"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_image_verified_visit_patch/2026-04-16/1776329927
id: 906405
processed: 1

raw_data:

{
    "_origin": "1",
    "visit_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "visit_key": "bigint"
}

schema_name_id: 528
schema_scan_id: 6414655
updated: 2026-04-16 03:59:30

Version 906185

created: 2026-04-15 03:44:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_image_verified_visit_patch`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_image_verified_visit_patch`\n(\n `visit_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/reference_image_verified_visit_patch/2026-04-15/1776242663'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_image_verified_visit_patch"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_image_verified_visit_patch/2026-04-15/1776242663
id: 906185
processed: 1

raw_data:

{
    "_origin": "1",
    "visit_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "visit_key": "bigint"
}

schema_name_id: 528
schema_scan_id: 6414161
updated: 2026-04-15 03:44:53

Version 905969

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_image_verified_visit_patch`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_image_verified_visit_patch`\n(\n `visit_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/reference_image_verified_visit_patch/2026-04-14/1776155925'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_image_verified_visit_patch"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_image_verified_visit_patch/2026-04-14/1776155925
id: 905969
processed: 1

raw_data:

{
    "_origin": "1",
    "visit_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "visit_key": "bigint"
}

schema_name_id: 528
schema_scan_id: 6413655
updated: 2026-04-14 03:39:03

Version 905761

created: 2026-04-13 03:32:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_image_verified_visit_patch`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_image_verified_visit_patch`\n(\n `visit_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/reference_image_verified_visit_patch/2026-04-13/1776069116'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_image_verified_visit_patch"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_image_verified_visit_patch/2026-04-13/1776069116
id: 905761
processed: 1

raw_data:

{
    "_origin": "1",
    "visit_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "visit_key": "bigint"
}

schema_name_id: 528
schema_scan_id: 6413117
updated: 2026-04-13 03:32:23

Version 905591

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_image_verified_visit_patch`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_image_verified_visit_patch`\n(\n `visit_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/reference_image_verified_visit_patch/2026-04-12/1775984571'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_image_verified_visit_patch"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_image_verified_visit_patch/2026-04-12/1775984571
id: 905591
processed: 1

raw_data:

{
    "_origin": "1",
    "visit_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "visit_key": "bigint"
}

schema_name_id: 528
schema_scan_id: 6412755
updated: 2026-04-12 04:03:15

Version 905363

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_image_verified_visit_patch`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_image_verified_visit_patch`\n(\n `visit_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/reference_image_verified_visit_patch/2026-04-11/1775896231'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_image_verified_visit_patch"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_image_verified_visit_patch/2026-04-11/1775896231
id: 905363
processed: 1

raw_data:

{
    "_origin": "1",
    "visit_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "visit_key": "bigint"
}

schema_name_id: 528
schema_scan_id: 6412348
updated: 2026-04-11 03:31:05

Version 905169

created: 2026-04-10 03:56:03

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_image_verified_visit_patch`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_image_verified_visit_patch`\n(\n `visit_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/reference_image_verified_visit_patch/2026-04-10/1775811352'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_image_verified_visit_patch"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_image_verified_visit_patch/2026-04-10/1775811352
id: 905169
processed: 1

raw_data:

{
    "_origin": "1",
    "visit_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "visit_key": "bigint"
}

schema_name_id: 528
schema_scan_id: 6411874
updated: 2026-04-10 03:56:17

Version 904938

created: 2026-04-09 03:56:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_image_verified_visit_patch`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_image_verified_visit_patch`\n(\n `visit_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/reference_image_verified_visit_patch/2026-04-09/1775724955'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_image_verified_visit_patch"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_image_verified_visit_patch/2026-04-09/1775724955
id: 904938
processed: 1

raw_data:

{
    "_origin": "1",
    "visit_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "visit_key": "bigint"
}

schema_name_id: 528
schema_scan_id: 6411340
updated: 2026-04-09 03:56:28

Version 904711

created: 2026-04-08 03:32:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_image_verified_visit_patch`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_image_verified_visit_patch`\n(\n `visit_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/reference_image_verified_visit_patch/2026-04-08/1775637131'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_image_verified_visit_patch"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_image_verified_visit_patch/2026-04-08/1775637131
id: 904711
processed: 1

raw_data:

{
    "_origin": "1",
    "visit_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "visit_key": "bigint"
}

schema_name_id: 528
schema_scan_id: 6410832
updated: 2026-04-08 03:32:49

Version 904493

created: 2026-04-07 03:33:30

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_image_verified_visit_patch`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_image_verified_visit_patch`\n(\n `visit_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/reference_image_verified_visit_patch/2026-04-07/1775550788'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_image_verified_visit_patch"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_image_verified_visit_patch/2026-04-07/1775550788
id: 904493
processed: 1

raw_data:

{
    "_origin": "1",
    "visit_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "visit_key": "bigint"
}

schema_name_id: 528
schema_scan_id: 6410316
updated: 2026-04-07 03:33:41

Version 904282

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_image_verified_visit_patch`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_image_verified_visit_patch`\n(\n `visit_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/reference_image_verified_visit_patch/2026-04-06/1775465089'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_image_verified_visit_patch"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_image_verified_visit_patch/2026-04-06/1775465089
id: 904282
processed: 1

raw_data:

{
    "_origin": "1",
    "visit_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "visit_key": "bigint"
}

schema_name_id: 528
schema_scan_id: 6409776
updated: 2026-04-06 03:45:07

Version 904100

created: 2026-04-05 03:44:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_image_verified_visit_patch`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_image_verified_visit_patch`\n(\n `visit_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/reference_image_verified_visit_patch/2026-04-05/1775378677'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_image_verified_visit_patch"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_image_verified_visit_patch/2026-04-05/1775378677
id: 904100
processed: 1

raw_data:

{
    "_origin": "1",
    "visit_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "visit_key": "bigint"
}

schema_name_id: 528
schema_scan_id: 6409408
updated: 2026-04-05 03:44:58

Version 903877

created: 2026-04-04 03:23:10

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_image_verified_visit_patch`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_image_verified_visit_patch`\n(\n `visit_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/reference_image_verified_visit_patch/2026-04-04/1775290981'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_image_verified_visit_patch"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_image_verified_visit_patch/2026-04-04/1775290981
id: 903877
processed: 1

raw_data:

{
    "_origin": "1",
    "visit_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "visit_key": "bigint"
}

schema_name_id: 528
schema_scan_id: 6409006
updated: 2026-04-04 03:23:24

Version 903673

created: 2026-04-03 03:44:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_image_verified_visit_patch`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_image_verified_visit_patch`\n(\n `visit_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/reference_image_verified_visit_patch/2026-04-03/1775205837'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_image_verified_visit_patch"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/reference_image_verified_visit_patch/2026-04-03/1775205837
id: 903673
processed: 1

raw_data:

{
    "_origin": "1",
    "visit_key": "0"
}

schema_attributes:

{
    "_origin": "string",
    "visit_key": "bigint"
}

schema_name_id: 528
schema_scan_id: 6408527
updated: 2026-04-03 03:44:46

Schema Scans: 15

Last at 2026-04-17 03:36:35

Scan 6415190

duration: 0:00:14.128242

exit_message:

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

id: 6415190

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "visit_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_image_verified_visit_patch/2026-04-17/1776414976/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_image_verified_visit_patch/2026-04-17/1776414976",
        "key": "raw/reference_image_verified_visit_patch/2026-04-17/1776414976/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_image_verified_visit_patch",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13571939281344480104,
        "service_name": "redshift_unloads",
        "span_id": 6965032248601007856,
        "trace_id": 12255322447374521926
    }
}

running: False
schema_name_id: 528
start_time: 2026-04-17 03:36:35
success: True
trace_id: 12255322447374521926

Scan 6414655

duration: 0:00:14.201467

exit_message:

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

id: 6414655

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "visit_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_image_verified_visit_patch/2026-04-16/1776329927/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_image_verified_visit_patch/2026-04-16/1776329927",
        "key": "raw/reference_image_verified_visit_patch/2026-04-16/1776329927/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_image_verified_visit_patch",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 166453741832045654,
        "service_name": "redshift_unloads",
        "span_id": 5959143387857290854,
        "trace_id": 13394472501853806944
    }
}

running: False
schema_name_id: 528
start_time: 2026-04-16 03:59:15
success: True
trace_id: 13394472501853806944

Scan 6414161

duration: 0:00:11.533245

exit_message:

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

id: 6414161

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "visit_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_image_verified_visit_patch/2026-04-15/1776242663/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_image_verified_visit_patch/2026-04-15/1776242663",
        "key": "raw/reference_image_verified_visit_patch/2026-04-15/1776242663/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_image_verified_visit_patch",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 17058473084226509385,
        "service_name": "redshift_unloads",
        "span_id": 21650675479000417,
        "trace_id": 222454454625818629
    }
}

running: False
schema_name_id: 528
start_time: 2026-04-15 03:44:42
success: True
trace_id: 222454454625818629

Scan 6413655

duration: 0:00:11.620900

exit_message:

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

id: 6413655

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "visit_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_image_verified_visit_patch/2026-04-14/1776155925/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_image_verified_visit_patch/2026-04-14/1776155925",
        "key": "raw/reference_image_verified_visit_patch/2026-04-14/1776155925/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_image_verified_visit_patch",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 6936562783186925871,
        "service_name": "redshift_unloads",
        "span_id": 16998642929511594565,
        "trace_id": 4916789329616079602
    }
}

running: False
schema_name_id: 528
start_time: 2026-04-14 03:38:52
success: True
trace_id: 4916789329616079602

Scan 6413117

duration: 0:00:11.649639

exit_message:

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

id: 6413117

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "visit_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_image_verified_visit_patch/2026-04-13/1776069116/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_image_verified_visit_patch/2026-04-13/1776069116",
        "key": "raw/reference_image_verified_visit_patch/2026-04-13/1776069116/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_image_verified_visit_patch",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 6182394672525850126,
        "service_name": "redshift_unloads",
        "span_id": 11121083964737915060,
        "trace_id": 215991639918187560
    }
}

running: False
schema_name_id: 528
start_time: 2026-04-13 03:32:11
success: True
trace_id: 215991639918187560

Scan 6412755

duration: 0:00:11.687890

exit_message:

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

id: 6412755

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "visit_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_image_verified_visit_patch/2026-04-12/1775984571/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_image_verified_visit_patch/2026-04-12/1775984571",
        "key": "raw/reference_image_verified_visit_patch/2026-04-12/1775984571/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_image_verified_visit_patch",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 14384094934848025133,
        "service_name": "redshift_unloads",
        "span_id": 4274255939686185713,
        "trace_id": 7122998024181021427
    }
}

running: False
schema_name_id: 528
start_time: 2026-04-12 04:03:04
success: True
trace_id: 7122998024181021427

Scan 6412348

duration: 0:00:11.671670

exit_message:

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

id: 6412348

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "visit_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_image_verified_visit_patch/2026-04-11/1775896231/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_image_verified_visit_patch/2026-04-11/1775896231",
        "key": "raw/reference_image_verified_visit_patch/2026-04-11/1775896231/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_image_verified_visit_patch",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 16278601032128663834,
        "service_name": "redshift_unloads",
        "span_id": 9048996200292894877,
        "trace_id": 13688039511734803594
    }
}

running: False
schema_name_id: 528
start_time: 2026-04-11 03:30:53
success: True
trace_id: 13688039511734803594

Scan 6411874

duration: 0:00:14.166101

exit_message:

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

id: 6411874

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "visit_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_image_verified_visit_patch/2026-04-10/1775811352/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_image_verified_visit_patch/2026-04-10/1775811352",
        "key": "raw/reference_image_verified_visit_patch/2026-04-10/1775811352/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_image_verified_visit_patch",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 9704019556414791232,
        "service_name": "redshift_unloads",
        "span_id": 16727741660264618031,
        "trace_id": 17610350873607018276
    }
}

running: False
schema_name_id: 528
start_time: 2026-04-10 03:56:03
success: True
trace_id: 17610350873607018276

Scan 6411340

duration: 0:00:14.212361

exit_message:

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

id: 6411340

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "visit_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_image_verified_visit_patch/2026-04-09/1775724955/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_image_verified_visit_patch/2026-04-09/1775724955",
        "key": "raw/reference_image_verified_visit_patch/2026-04-09/1775724955/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_image_verified_visit_patch",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 17055058046336335258,
        "service_name": "redshift_unloads",
        "span_id": 12650779208588422433,
        "trace_id": 3309237296182542427
    }
}

running: False
schema_name_id: 528
start_time: 2026-04-09 03:56:14
success: True
trace_id: 3309237296182542427

Scan 6410832

duration: 0:00:14.354693

exit_message:

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

id: 6410832

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "visit_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_image_verified_visit_patch/2026-04-08/1775637131/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_image_verified_visit_patch/2026-04-08/1775637131",
        "key": "raw/reference_image_verified_visit_patch/2026-04-08/1775637131/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_image_verified_visit_patch",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15340769826367035948,
        "service_name": "redshift_unloads",
        "span_id": 296799245292214836,
        "trace_id": 17144784222910830971
    }
}

running: False
schema_name_id: 528
start_time: 2026-04-08 03:32:35
success: True
trace_id: 17144784222910830971

Scan 6410316

duration: 0:00:11.597312

exit_message:

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

id: 6410316

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "visit_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_image_verified_visit_patch/2026-04-07/1775550788/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_image_verified_visit_patch/2026-04-07/1775550788",
        "key": "raw/reference_image_verified_visit_patch/2026-04-07/1775550788/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_image_verified_visit_patch",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13963869179388682139,
        "service_name": "redshift_unloads",
        "span_id": 11516404264582696631,
        "trace_id": 4345824123440842511
    }
}

running: False
schema_name_id: 528
start_time: 2026-04-07 03:33:30
success: True
trace_id: 4345824123440842511

Scan 6409776

duration: 0:00:11.755190

exit_message:

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

id: 6409776

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "visit_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_image_verified_visit_patch/2026-04-06/1775465089/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_image_verified_visit_patch/2026-04-06/1775465089",
        "key": "raw/reference_image_verified_visit_patch/2026-04-06/1775465089/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_image_verified_visit_patch",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 6396771780903207298,
        "service_name": "redshift_unloads",
        "span_id": 7675963443257909595,
        "trace_id": 14659579569986799783
    }
}

running: False
schema_name_id: 528
start_time: 2026-04-06 03:44:55
success: True
trace_id: 14659579569986799783

Scan 6409408

duration: 0:00:14.189039

exit_message:

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

id: 6409408

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "visit_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_image_verified_visit_patch/2026-04-05/1775378677/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_image_verified_visit_patch/2026-04-05/1775378677",
        "key": "raw/reference_image_verified_visit_patch/2026-04-05/1775378677/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_image_verified_visit_patch",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 18341677599168707336,
        "service_name": "redshift_unloads",
        "span_id": 13668384957321094183,
        "trace_id": 6715977838827397873
    }
}

running: False
schema_name_id: 528
start_time: 2026-04-05 03:44:44
success: True
trace_id: 6715977838827397873

Scan 6409006

duration: 0:00:14.164990

exit_message:

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

id: 6409006

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "visit_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_image_verified_visit_patch/2026-04-04/1775290981/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_image_verified_visit_patch/2026-04-04/1775290981",
        "key": "raw/reference_image_verified_visit_patch/2026-04-04/1775290981/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_image_verified_visit_patch",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8621453444494016871,
        "service_name": "redshift_unloads",
        "span_id": 16341218442737951993,
        "trace_id": 388459461262815281
    }
}

running: False
schema_name_id: 528
start_time: 2026-04-04 03:23:10
success: True
trace_id: 388459461262815281

Scan 6408527

duration: 0:00:11.659756

exit_message:

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

id: 6408527

payload:

{
    "datatype_dict": {
        "origin_key": "varchar",
        "visit_key": "bigint"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/reference_image_verified_visit_patch/2026-04-03/1775205837/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/reference_image_verified_visit_patch/2026-04-03/1775205837",
        "key": "raw/reference_image_verified_visit_patch/2026-04-03/1775205837/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_reference_image_verified_visit_patch",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 16885208924472366182,
        "service_name": "redshift_unloads",
        "span_id": 12835216475768354722,
        "trace_id": 12863672501143656719
    }
}

running: False
schema_name_id: 528
start_time: 2026-04-03 03:44:34
success: True
trace_id: 12863672501143656719

Partitions:

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

Schema:

attributes:

{
    "_origin": "string",
    "visit_key": "bigint"
}

created: 2026-04-17 03:36:35

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_image_verified_visit_patch`\n(\n `visit_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/reference_image_verified_visit_patch/2026-04-17/1776414976'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_image_verified_visit_patch`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_image_verified_visit_patch"
}

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-05-09 11:02:45",
        "disabled": false,
        "format": "raw",
        "id": 528,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_redshift",
            "table": "analytics_reference_image_verified_visit_patch"
        },
        "type": "redshift"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "_origin": "string",
            "visit_key": "bigint"
        },
        "created": "2026-04-17 03:36:35",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_reference_image_verified_visit_patch`\n(\n `visit_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/reference_image_verified_visit_patch/2026-04-17/1776414976'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_reference_image_verified_visit_patch`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_reference_image_verified_visit_patch"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}