Schema Info

Schema Name: sfdl_stage_json.yaypay_contacts

created: 2024-01-25 15:07:39
disabled: False
format: raw
id: 2090
is_partitioned: False
is_schema_datatyped: True

name:

{
    "database": "sfdl_stage_json",
    "table": "yaypay_contacts"
}

type: json

Schema Versions: 15

Version 906665

created: 2026-04-17 07:01:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_json`",
    "DROP TABLE IF EXISTS `sfdl_stage_json.yaypay_contacts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_json.yaypay_contacts`\n(\n`internal_id`STRING,`customer_name`STRING,`customer_int_id`STRING,`email`STRING,`first_name`STRING,`last_name`STRING,`phone`STRING,`mobile_phone`STRING,`role`STRING,`title`STRING,`note`STRING,`is_billing_contact`STRING,`source_system`STRING,`updated_at`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-json-yaypay-stage/raw/contacts/2026-04-17/1776427289'\n",
    "MSCK REPAIR TABLE sfdl_stage_json.yaypay_contacts"
]

hive_path: s3://sfdl-json-yaypay-stage/raw/contacts/2026-04-17/1776427289
id: 906665
processed: 1

raw_data:

{
    "customer_int_id": "2588887",
    "customer_name": "Grand Ledge Comet Mini Storage",
    "email": "[email protected]",
    "first_name": "Grand Ledge Comet Mini Storage",
    "internal_id": "2588887_AUTO_CREATED",
    "is_billing_contact": true,
    "last_name": null,
    "mobile_phone": null,
    "note": null,
    "phone": "(561) 775-7393",
    "role": null,
    "source_system": "NET_SUITE",
    "title": null,
    "updated_at": "2025-11-12T18:57:16"
}

schema_attributes:

{
    "customer_int_id": "string",
    "customer_name": "string",
    "email": "string",
    "first_name": "string",
    "internal_id": "string",
    "is_billing_contact": "string",
    "last_name": "string",
    "mobile_phone": "string",
    "note": "string",
    "phone": "string",
    "role": "string",
    "source_system": "string",
    "title": "string",
    "updated_at": "string"
}

schema_name_id: 2090
schema_scan_id: 6415264
updated: 2026-04-17 07:01:48

Version 906448

created: 2026-04-16 07:01:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_json`",
    "DROP TABLE IF EXISTS `sfdl_stage_json.yaypay_contacts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_json.yaypay_contacts`\n(\n`internal_id`STRING,`customer_name`STRING,`customer_int_id`STRING,`email`STRING,`first_name`STRING,`last_name`STRING,`phone`STRING,`mobile_phone`STRING,`role`STRING,`title`STRING,`note`STRING,`is_billing_contact`STRING,`source_system`STRING,`updated_at`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-json-yaypay-stage/raw/contacts/2026-04-16/1776340887'\n",
    "MSCK REPAIR TABLE sfdl_stage_json.yaypay_contacts"
]

hive_path: s3://sfdl-json-yaypay-stage/raw/contacts/2026-04-16/1776340887
id: 906448
processed: 1

raw_data:

{
    "customer_int_id": "2588887",
    "customer_name": "Grand Ledge Comet Mini Storage",
    "email": "[email protected]",
    "first_name": "Grand Ledge Comet Mini Storage",
    "internal_id": "2588887_AUTO_CREATED",
    "is_billing_contact": true,
    "last_name": null,
    "mobile_phone": null,
    "note": null,
    "phone": "(561) 775-7393",
    "role": null,
    "source_system": "NET_SUITE",
    "title": null,
    "updated_at": "2025-11-12T18:57:16"
}

schema_attributes:

{
    "customer_int_id": "string",
    "customer_name": "string",
    "email": "string",
    "first_name": "string",
    "internal_id": "string",
    "is_billing_contact": "string",
    "last_name": "string",
    "mobile_phone": "string",
    "note": "string",
    "phone": "string",
    "role": "string",
    "source_system": "string",
    "title": "string",
    "updated_at": "string"
}

schema_name_id: 2090
schema_scan_id: 6414716
updated: 2026-04-16 07:01:43

Version 906235

created: 2026-04-15 07:01:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_json`",
    "DROP TABLE IF EXISTS `sfdl_stage_json.yaypay_contacts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_json.yaypay_contacts`\n(\n`internal_id`STRING,`customer_name`STRING,`customer_int_id`STRING,`email`STRING,`first_name`STRING,`last_name`STRING,`phone`STRING,`mobile_phone`STRING,`role`STRING,`title`STRING,`note`STRING,`is_billing_contact`STRING,`source_system`STRING,`updated_at`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-json-yaypay-stage/raw/contacts/2026-04-15/1776254487'\n",
    "MSCK REPAIR TABLE sfdl_stage_json.yaypay_contacts"
]

hive_path: s3://sfdl-json-yaypay-stage/raw/contacts/2026-04-15/1776254487
id: 906235
processed: 1

raw_data:

{
    "customer_int_id": "2588887",
    "customer_name": "Grand Ledge Comet Mini Storage",
    "email": "[email protected]",
    "first_name": "Grand Ledge Comet Mini Storage",
    "internal_id": "2588887_AUTO_CREATED",
    "is_billing_contact": true,
    "last_name": null,
    "mobile_phone": null,
    "note": null,
    "phone": "(561) 775-7393",
    "role": null,
    "source_system": "NET_SUITE",
    "title": null,
    "updated_at": "2025-11-12T18:57:16"
}

schema_attributes:

{
    "customer_int_id": "string",
    "customer_name": "string",
    "email": "string",
    "first_name": "string",
    "internal_id": "string",
    "is_billing_contact": "string",
    "last_name": "string",
    "mobile_phone": "string",
    "note": "string",
    "phone": "string",
    "role": "string",
    "source_system": "string",
    "title": "string",
    "updated_at": "string"
}

schema_name_id: 2090
schema_scan_id: 6414229
updated: 2026-04-15 07:02:04

Version 906022

created: 2026-04-14 07:01:41

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_json`",
    "DROP TABLE IF EXISTS `sfdl_stage_json.yaypay_contacts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_json.yaypay_contacts`\n(\n`internal_id`STRING,`customer_name`STRING,`customer_int_id`STRING,`email`STRING,`first_name`STRING,`last_name`STRING,`phone`STRING,`mobile_phone`STRING,`role`STRING,`title`STRING,`note`STRING,`is_billing_contact`STRING,`source_system`STRING,`updated_at`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-json-yaypay-stage/raw/contacts/2026-04-14/1776168086'\n",
    "MSCK REPAIR TABLE sfdl_stage_json.yaypay_contacts"
]

hive_path: s3://sfdl-json-yaypay-stage/raw/contacts/2026-04-14/1776168086
id: 906022
processed: 1

raw_data:

{
    "customer_int_id": "2588888",
    "customer_name": "Legacy Self Storage - Northport 64th Ave",
    "email": "[email protected]",
    "first_name": "Legacy Self Storage - Northport 64th Ave",
    "internal_id": "2588888_AUTO_CREATED",
    "is_billing_contact": true,
    "last_name": null,
    "mobile_phone": null,
    "note": null,
    "phone": "(561) 775-7393",
    "role": null,
    "source_system": "NET_SUITE",
    "title": null,
    "updated_at": "2025-11-12T18:57:16"
}

schema_attributes:

{
    "customer_int_id": "string",
    "customer_name": "string",
    "email": "string",
    "first_name": "string",
    "internal_id": "string",
    "is_billing_contact": "string",
    "last_name": "string",
    "mobile_phone": "string",
    "note": "string",
    "phone": "string",
    "role": "string",
    "source_system": "string",
    "title": "string",
    "updated_at": "string"
}

schema_name_id: 2090
schema_scan_id: 6413737
updated: 2026-04-14 07:01:53

Version 905805

created: 2026-04-13 07:01:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_json`",
    "DROP TABLE IF EXISTS `sfdl_stage_json.yaypay_contacts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_json.yaypay_contacts`\n(\n`internal_id`STRING,`customer_name`STRING,`customer_int_id`STRING,`email`STRING,`first_name`STRING,`last_name`STRING,`phone`STRING,`mobile_phone`STRING,`role`STRING,`title`STRING,`note`STRING,`is_billing_contact`STRING,`source_system`STRING,`updated_at`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-json-yaypay-stage/raw/contacts/2026-04-13/1776081687'\n",
    "MSCK REPAIR TABLE sfdl_stage_json.yaypay_contacts"
]

hive_path: s3://sfdl-json-yaypay-stage/raw/contacts/2026-04-13/1776081687
id: 905805
processed: 1

raw_data:

{
    "customer_int_id": "2588888",
    "customer_name": "Legacy Self Storage - Northport 64th Ave",
    "email": "[email protected]",
    "first_name": "Legacy Self Storage - Northport 64th Ave",
    "internal_id": "2588888_AUTO_CREATED",
    "is_billing_contact": true,
    "last_name": null,
    "mobile_phone": null,
    "note": null,
    "phone": "(561) 775-7393",
    "role": null,
    "source_system": "NET_SUITE",
    "title": null,
    "updated_at": "2025-11-12T18:57:16"
}

schema_attributes:

{
    "customer_int_id": "string",
    "customer_name": "string",
    "email": "string",
    "first_name": "string",
    "internal_id": "string",
    "is_billing_contact": "string",
    "last_name": "string",
    "mobile_phone": "string",
    "note": "string",
    "phone": "string",
    "role": "string",
    "source_system": "string",
    "title": "string",
    "updated_at": "string"
}

schema_name_id: 2090
schema_scan_id: 6413183
updated: 2026-04-13 07:01:47

Version 905602

created: 2026-04-12 07:01:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_json`",
    "DROP TABLE IF EXISTS `sfdl_stage_json.yaypay_contacts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_json.yaypay_contacts`\n(\n`internal_id`STRING,`customer_name`STRING,`customer_int_id`STRING,`email`STRING,`first_name`STRING,`last_name`STRING,`phone`STRING,`mobile_phone`STRING,`role`STRING,`title`STRING,`note`STRING,`is_billing_contact`STRING,`source_system`STRING,`updated_at`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-json-yaypay-stage/raw/contacts/2026-04-12/1775995283'\n",
    "MSCK REPAIR TABLE sfdl_stage_json.yaypay_contacts"
]

hive_path: s3://sfdl-json-yaypay-stage/raw/contacts/2026-04-12/1775995283
id: 905602
processed: 1

raw_data:

{
    "customer_int_id": "2588888",
    "customer_name": "Legacy Self Storage - Northport 64th Ave",
    "email": "[email protected]",
    "first_name": "Legacy Self Storage - Northport 64th Ave",
    "internal_id": "2588888_AUTO_CREATED",
    "is_billing_contact": true,
    "last_name": null,
    "mobile_phone": null,
    "note": null,
    "phone": "(561) 775-7393",
    "role": null,
    "source_system": "NET_SUITE",
    "title": null,
    "updated_at": "2025-11-12T18:57:16"
}

schema_attributes:

{
    "customer_int_id": "string",
    "customer_name": "string",
    "email": "string",
    "first_name": "string",
    "internal_id": "string",
    "is_billing_contact": "string",
    "last_name": "string",
    "mobile_phone": "string",
    "note": "string",
    "phone": "string",
    "role": "string",
    "source_system": "string",
    "title": "string",
    "updated_at": "string"
}

schema_name_id: 2090
schema_scan_id: 6412782
updated: 2026-04-12 07:01:48

Version 905400

created: 2026-04-11 07:01:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_json`",
    "DROP TABLE IF EXISTS `sfdl_stage_json.yaypay_contacts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_json.yaypay_contacts`\n(\n`internal_id`STRING,`customer_name`STRING,`customer_int_id`STRING,`email`STRING,`first_name`STRING,`last_name`STRING,`phone`STRING,`mobile_phone`STRING,`role`STRING,`title`STRING,`note`STRING,`is_billing_contact`STRING,`source_system`STRING,`updated_at`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-json-yaypay-stage/raw/contacts/2026-04-11/1775908886/1822184450'\n",
    "MSCK REPAIR TABLE sfdl_stage_json.yaypay_contacts"
]

hive_path: s3://sfdl-json-yaypay-stage/raw/contacts/2026-04-11/1775908886/1822184450
id: 905400
processed: 1

raw_data:

{
    "customer_int_id": "2588888",
    "customer_name": "Legacy Self Storage - Northport 64th Ave",
    "email": "[email protected]",
    "first_name": "Legacy Self Storage - Northport 64th Ave",
    "internal_id": "2588888_AUTO_CREATED",
    "is_billing_contact": true,
    "last_name": null,
    "mobile_phone": null,
    "note": null,
    "phone": "(561) 775-7393",
    "role": null,
    "source_system": "NET_SUITE",
    "title": null,
    "updated_at": "2025-11-12T18:57:16"
}

schema_attributes:

{
    "customer_int_id": "string",
    "customer_name": "string",
    "email": "string",
    "first_name": "string",
    "internal_id": "string",
    "is_billing_contact": "string",
    "last_name": "string",
    "mobile_phone": "string",
    "note": "string",
    "phone": "string",
    "role": "string",
    "source_system": "string",
    "title": "string",
    "updated_at": "string"
}

schema_name_id: 2090
schema_scan_id: 6412401
updated: 2026-04-11 07:01:54

Version 905187

created: 2026-04-10 07:01:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_json`",
    "DROP TABLE IF EXISTS `sfdl_stage_json.yaypay_contacts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_json.yaypay_contacts`\n(\n`internal_id`STRING,`customer_name`STRING,`customer_int_id`STRING,`email`STRING,`first_name`STRING,`last_name`STRING,`phone`STRING,`mobile_phone`STRING,`role`STRING,`title`STRING,`note`STRING,`is_billing_contact`STRING,`source_system`STRING,`updated_at`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-json-yaypay-stage/raw/contacts/2026-04-10/1775822488/1735787534'\n",
    "MSCK REPAIR TABLE sfdl_stage_json.yaypay_contacts"
]

hive_path: s3://sfdl-json-yaypay-stage/raw/contacts/2026-04-10/1775822488/1735787534
id: 905187
processed: 1

raw_data:

{
    "customer_int_id": "2588888",
    "customer_name": "Legacy Self Storage - Northport 64th Ave",
    "email": "[email protected]",
    "first_name": "Legacy Self Storage - Northport 64th Ave",
    "internal_id": "2588888_AUTO_CREATED",
    "is_billing_contact": true,
    "last_name": null,
    "mobile_phone": null,
    "note": null,
    "phone": "(561) 775-7393",
    "role": null,
    "source_system": "NET_SUITE",
    "title": null,
    "updated_at": "2025-11-12T18:57:16"
}

schema_attributes:

{
    "customer_int_id": "string",
    "customer_name": "string",
    "email": "string",
    "first_name": "string",
    "internal_id": "string",
    "is_billing_contact": "string",
    "last_name": "string",
    "mobile_phone": "string",
    "note": "string",
    "phone": "string",
    "role": "string",
    "source_system": "string",
    "title": "string",
    "updated_at": "string"
}

schema_name_id: 2090
schema_scan_id: 6411918
updated: 2026-04-10 07:01:47

Version 904973

created: 2026-04-09 07:01:38

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_json`",
    "DROP TABLE IF EXISTS `sfdl_stage_json.yaypay_contacts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_json.yaypay_contacts`\n(\n`internal_id`STRING,`customer_name`STRING,`customer_int_id`STRING,`email`STRING,`first_name`STRING,`last_name`STRING,`phone`STRING,`mobile_phone`STRING,`role`STRING,`title`STRING,`note`STRING,`is_billing_contact`STRING,`source_system`STRING,`updated_at`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-json-yaypay-stage/raw/contacts/2026-04-09/1775736093/1649386772'\n",
    "MSCK REPAIR TABLE sfdl_stage_json.yaypay_contacts"
]

hive_path: s3://sfdl-json-yaypay-stage/raw/contacts/2026-04-09/1775736093/1649386772
id: 904973
processed: 1

raw_data:

{
    "customer_int_id": "2588888",
    "customer_name": "Legacy Self Storage - Northport 64th Ave",
    "email": "[email protected]",
    "first_name": "Legacy Self Storage - Northport 64th Ave",
    "internal_id": "2588888_AUTO_CREATED",
    "is_billing_contact": true,
    "last_name": null,
    "mobile_phone": null,
    "note": null,
    "phone": "(561) 775-7393",
    "role": null,
    "source_system": "NET_SUITE",
    "title": null,
    "updated_at": "2025-11-12T18:57:16"
}

schema_attributes:

{
    "customer_int_id": "string",
    "customer_name": "string",
    "email": "string",
    "first_name": "string",
    "internal_id": "string",
    "is_billing_contact": "string",
    "last_name": "string",
    "mobile_phone": "string",
    "note": "string",
    "phone": "string",
    "role": "string",
    "source_system": "string",
    "title": "string",
    "updated_at": "string"
}

schema_name_id: 2090
schema_scan_id: 6411404
updated: 2026-04-09 07:01:52

Version 904760

created: 2026-04-08 07:01:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_json`",
    "DROP TABLE IF EXISTS `sfdl_stage_json.yaypay_contacts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_json.yaypay_contacts`\n(\n`internal_id`STRING,`customer_name`STRING,`customer_int_id`STRING,`email`STRING,`first_name`STRING,`last_name`STRING,`phone`STRING,`mobile_phone`STRING,`role`STRING,`title`STRING,`note`STRING,`is_billing_contact`STRING,`source_system`STRING,`updated_at`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-json-yaypay-stage/raw/contacts/2026-04-08/1775649696/1562984661'\n",
    "MSCK REPAIR TABLE sfdl_stage_json.yaypay_contacts"
]

hive_path: s3://sfdl-json-yaypay-stage/raw/contacts/2026-04-08/1775649696/1562984661
id: 904760
processed: 1

raw_data:

{
    "customer_int_id": "2588888",
    "customer_name": "Legacy Self Storage - Northport 64th Ave",
    "email": "[email protected]",
    "first_name": "Legacy Self Storage - Northport 64th Ave",
    "internal_id": "2588888_AUTO_CREATED",
    "is_billing_contact": true,
    "last_name": null,
    "mobile_phone": null,
    "note": null,
    "phone": "(561) 775-7393",
    "role": null,
    "source_system": "NET_SUITE",
    "title": null,
    "updated_at": "2025-11-12T18:57:16"
}

schema_attributes:

{
    "customer_int_id": "string",
    "customer_name": "string",
    "email": "string",
    "first_name": "string",
    "internal_id": "string",
    "is_billing_contact": "string",
    "last_name": "string",
    "mobile_phone": "string",
    "note": "string",
    "phone": "string",
    "role": "string",
    "source_system": "string",
    "title": "string",
    "updated_at": "string"
}

schema_name_id: 2090
schema_scan_id: 6410901
updated: 2026-04-08 07:02:03

Version 904546

created: 2026-04-07 07:01:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_json`",
    "DROP TABLE IF EXISTS `sfdl_stage_json.yaypay_contacts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_json.yaypay_contacts`\n(\n`internal_id`STRING,`customer_name`STRING,`customer_int_id`STRING,`email`STRING,`first_name`STRING,`last_name`STRING,`phone`STRING,`mobile_phone`STRING,`role`STRING,`title`STRING,`note`STRING,`is_billing_contact`STRING,`source_system`STRING,`updated_at`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-json-yaypay-stage/raw/contacts/2026-04-07/1775563290/1476585880'\n",
    "MSCK REPAIR TABLE sfdl_stage_json.yaypay_contacts"
]

hive_path: s3://sfdl-json-yaypay-stage/raw/contacts/2026-04-07/1775563290/1476585880
id: 904546
processed: 1

raw_data:

{
    "customer_int_id": "2588888",
    "customer_name": "Legacy Self Storage - Northport 64th Ave",
    "email": "[email protected]",
    "first_name": "Legacy Self Storage - Northport 64th Ave",
    "internal_id": "2588888_AUTO_CREATED",
    "is_billing_contact": true,
    "last_name": null,
    "mobile_phone": null,
    "note": null,
    "phone": "(561) 775-7393",
    "role": null,
    "source_system": "NET_SUITE",
    "title": null,
    "updated_at": "2025-11-12T18:57:16"
}

schema_attributes:

{
    "customer_int_id": "string",
    "customer_name": "string",
    "email": "string",
    "first_name": "string",
    "internal_id": "string",
    "is_billing_contact": "string",
    "last_name": "string",
    "mobile_phone": "string",
    "note": "string",
    "phone": "string",
    "role": "string",
    "source_system": "string",
    "title": "string",
    "updated_at": "string"
}

schema_name_id: 2090
schema_scan_id: 6410390
updated: 2026-04-07 07:02:07

Version 904332

created: 2026-04-06 07:01:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_json`",
    "DROP TABLE IF EXISTS `sfdl_stage_json.yaypay_contacts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_json.yaypay_contacts`\n(\n`internal_id`STRING,`customer_name`STRING,`customer_int_id`STRING,`email`STRING,`first_name`STRING,`last_name`STRING,`phone`STRING,`mobile_phone`STRING,`role`STRING,`title`STRING,`note`STRING,`is_billing_contact`STRING,`source_system`STRING,`updated_at`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-json-yaypay-stage/raw/contacts/2026-04-06/1775476886'\n",
    "MSCK REPAIR TABLE sfdl_stage_json.yaypay_contacts"
]

hive_path: s3://sfdl-json-yaypay-stage/raw/contacts/2026-04-06/1775476886
id: 904332
processed: 1

raw_data:

{
    "customer_int_id": "2588888",
    "customer_name": "Legacy Self Storage - Northport 64th Ave",
    "email": "[email protected]",
    "first_name": "Legacy Self Storage - Northport 64th Ave",
    "internal_id": "2588888_AUTO_CREATED",
    "is_billing_contact": true,
    "last_name": null,
    "mobile_phone": null,
    "note": null,
    "phone": "(561) 775-7393",
    "role": null,
    "source_system": "NET_SUITE",
    "title": null,
    "updated_at": "2025-11-12T18:57:16"
}

schema_attributes:

{
    "customer_int_id": "string",
    "customer_name": "string",
    "email": "string",
    "first_name": "string",
    "internal_id": "string",
    "is_billing_contact": "string",
    "last_name": "string",
    "mobile_phone": "string",
    "note": "string",
    "phone": "string",
    "role": "string",
    "source_system": "string",
    "title": "string",
    "updated_at": "string"
}

schema_name_id: 2090
schema_scan_id: 6409847
updated: 2026-04-06 07:01:45

Version 904128

created: 2026-04-05 07:01:45

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_json`",
    "DROP TABLE IF EXISTS `sfdl_stage_json.yaypay_contacts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_json.yaypay_contacts`\n(\n`internal_id`STRING,`customer_name`STRING,`customer_int_id`STRING,`email`STRING,`first_name`STRING,`last_name`STRING,`phone`STRING,`mobile_phone`STRING,`role`STRING,`title`STRING,`note`STRING,`is_billing_contact`STRING,`source_system`STRING,`updated_at`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-json-yaypay-stage/raw/contacts/2026-04-05/1775390483'\n",
    "MSCK REPAIR TABLE sfdl_stage_json.yaypay_contacts"
]

hive_path: s3://sfdl-json-yaypay-stage/raw/contacts/2026-04-05/1775390483
id: 904128
processed: 1

raw_data:

{
    "customer_int_id": "2588888",
    "customer_name": "Legacy Self Storage - Northport 64th Ave",
    "email": "[email protected]",
    "first_name": "Legacy Self Storage - Northport 64th Ave",
    "internal_id": "2588888_AUTO_CREATED",
    "is_billing_contact": true,
    "last_name": null,
    "mobile_phone": null,
    "note": null,
    "phone": "(561) 775-7393",
    "role": null,
    "source_system": "NET_SUITE",
    "title": null,
    "updated_at": "2025-11-12T18:57:16"
}

schema_attributes:

{
    "customer_int_id": "string",
    "customer_name": "string",
    "email": "string",
    "first_name": "string",
    "internal_id": "string",
    "is_billing_contact": "string",
    "last_name": "string",
    "mobile_phone": "string",
    "note": "string",
    "phone": "string",
    "role": "string",
    "source_system": "string",
    "title": "string",
    "updated_at": "string"
}

schema_name_id: 2090
schema_scan_id: 6409452
updated: 2026-04-05 07:01:59

Version 903926

created: 2026-04-04 07:01:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_json`",
    "DROP TABLE IF EXISTS `sfdl_stage_json.yaypay_contacts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_json.yaypay_contacts`\n(\n`internal_id`STRING,`customer_name`STRING,`customer_int_id`STRING,`email`STRING,`first_name`STRING,`last_name`STRING,`phone`STRING,`mobile_phone`STRING,`role`STRING,`title`STRING,`note`STRING,`is_billing_contact`STRING,`source_system`STRING,`updated_at`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-json-yaypay-stage/raw/contacts/2026-04-04/1775304084'\n",
    "MSCK REPAIR TABLE sfdl_stage_json.yaypay_contacts"
]

hive_path: s3://sfdl-json-yaypay-stage/raw/contacts/2026-04-04/1775304084
id: 903926
processed: 1

raw_data:

{
    "customer_int_id": "2588888",
    "customer_name": "Legacy Self Storage - Northport 64th Ave",
    "email": "[email protected]",
    "first_name": "Legacy Self Storage - Northport 64th Ave",
    "internal_id": "2588888_AUTO_CREATED",
    "is_billing_contact": true,
    "last_name": null,
    "mobile_phone": null,
    "note": null,
    "phone": "(561) 775-7393",
    "role": null,
    "source_system": "NET_SUITE",
    "title": null,
    "updated_at": "2025-11-12T18:57:16"
}

schema_attributes:

{
    "customer_int_id": "string",
    "customer_name": "string",
    "email": "string",
    "first_name": "string",
    "internal_id": "string",
    "is_billing_contact": "string",
    "last_name": "string",
    "mobile_phone": "string",
    "note": "string",
    "phone": "string",
    "role": "string",
    "source_system": "string",
    "title": "string",
    "updated_at": "string"
}

schema_name_id: 2090
schema_scan_id: 6409071
updated: 2026-04-04 07:01:48

Version 903714

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_json`",
    "DROP TABLE IF EXISTS `sfdl_stage_json.yaypay_contacts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_json.yaypay_contacts`\n(\n`internal_id`STRING,`customer_name`STRING,`customer_int_id`STRING,`email`STRING,`first_name`STRING,`last_name`STRING,`phone`STRING,`mobile_phone`STRING,`role`STRING,`title`STRING,`note`STRING,`is_billing_contact`STRING,`source_system`STRING,`updated_at`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-json-yaypay-stage/raw/contacts/2026-04-03/1775217686'\n",
    "MSCK REPAIR TABLE sfdl_stage_json.yaypay_contacts"
]

hive_path: s3://sfdl-json-yaypay-stage/raw/contacts/2026-04-03/1775217686
id: 903714
processed: 1

raw_data:

{
    "customer_int_id": "2588890",
    "customer_name": "Blue Sky Self Storage - Grand Rapids",
    "email": "[email protected]",
    "first_name": "Blue Sky Self Storage - Grand Rapids",
    "internal_id": "2588890_AUTO_CREATED",
    "is_billing_contact": true,
    "last_name": null,
    "mobile_phone": null,
    "note": null,
    "phone": "(561) 775-7393",
    "role": null,
    "source_system": "NET_SUITE",
    "title": null,
    "updated_at": "2025-11-12T18:57:16"
}

schema_attributes:

{
    "customer_int_id": "string",
    "customer_name": "string",
    "email": "string",
    "first_name": "string",
    "internal_id": "string",
    "is_billing_contact": "string",
    "last_name": "string",
    "mobile_phone": "string",
    "note": "string",
    "phone": "string",
    "role": "string",
    "source_system": "string",
    "title": "string",
    "updated_at": "string"
}

schema_name_id: 2090
schema_scan_id: 6408584
updated: 2026-04-03 07:01:52

Schema Scans: 15

Last at 2026-04-17 07:01:33

Scan 6415264

duration: 0:00:15.473135

exit_message:

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

id: 6415264

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-json-yaypay-stage",
        "hive_path": "s3://sfdl-json-yaypay-stage/raw/contacts/2026-04-17/1776427289",
        "key": "raw/contacts/2026-04-17/1776427289/2340587343248152fb545d62-3a54-11f1-b068-9d60297fb6394231745856984588216.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_json.yaypay_contacts",
        "type": "json"
    },
    "trace_context": {
        "parent_id": 5544726266633958170,
        "service_name": "drive-thru",
        "span_id": 18359602917095157569,
        "trace_id": 16402623938921777991
    }
}

running: False
schema_name_id: 2090
start_time: 2026-04-17 07:01:33
success: True
trace_id: 16402623938921777991

Scan 6414716

duration: 0:00:13.082412

exit_message:

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

id: 6414716

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-json-yaypay-stage",
        "hive_path": "s3://sfdl-json-yaypay-stage/raw/contacts/2026-04-16/1776340887",
        "key": "raw/contacts/2026-04-16/1776340887/2254186997600614d045f95f-398b-11f1-b068-475e80100cd16391788859857199580.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_json.yaypay_contacts",
        "type": "json"
    },
    "trace_context": {
        "parent_id": 5323758318444731755,
        "service_name": "drive-thru",
        "span_id": 2660480097171636130,
        "trace_id": 15662270070662906819
    }
}

running: False
schema_name_id: 2090
start_time: 2026-04-16 07:01:30
success: True
trace_id: 15662270070662906819

Scan 6414229

duration: 0:00:13.177114

exit_message:

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

id: 6414229

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-json-yaypay-stage",
        "hive_path": "s3://sfdl-json-yaypay-stage/raw/contacts/2026-04-15/1776254487",
        "key": "raw/contacts/2026-04-15/1776254487/2167786516503945a5e56162-38c2-11f1-aa84-511b9ac6d0b812641246562328165786.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_json.yaypay_contacts",
        "type": "json"
    },
    "trace_context": {
        "parent_id": 13351647689127409803,
        "service_name": "drive-thru",
        "span_id": 12311480765868084524,
        "trace_id": 6879102097498064820
    }
}

running: False
schema_name_id: 2090
start_time: 2026-04-15 07:01:51
success: True
trace_id: 6879102097498064820

Scan 6413737

duration: 0:00:13.187427

exit_message:

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

id: 6413737

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-json-yaypay-stage",
        "hive_path": "s3://sfdl-json-yaypay-stage/raw/contacts/2026-04-14/1776168086",
        "key": "raw/contacts/2026-04-14/1776168086/20813856837454627b5888f2-37f9-11f1-aa84-fbee7c70626d11590864080532147160.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_json.yaypay_contacts",
        "type": "json"
    },
    "trace_context": {
        "parent_id": 4364034511342146793,
        "service_name": "drive-thru",
        "span_id": 14707651311850939295,
        "trace_id": 12909997270857224288
    }
}

running: False
schema_name_id: 2090
start_time: 2026-04-14 07:01:40
success: True
trace_id: 12909997270857224288

Scan 6413183

duration: 0:00:15.669801

exit_message:

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

id: 6413183

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-json-yaypay-stage",
        "hive_path": "s3://sfdl-json-yaypay-stage/raw/contacts/2026-04-13/1776081687",
        "key": "raw/contacts/2026-04-13/1776081687/199498772372467550d61048-3730-11f1-b068-75e11b70464a2968277136194012230.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_json.yaypay_contacts",
        "type": "json"
    },
    "trace_context": {
        "parent_id": 15636133630401555538,
        "service_name": "drive-thru",
        "span_id": 14041778372431118770,
        "trace_id": 10513665222992359947
    }
}

running: False
schema_name_id: 2090
start_time: 2026-04-13 07:01:31
success: True
trace_id: 10513665222992359947

Scan 6412782

duration: 0:00:15.510769

exit_message:

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

id: 6412782

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-json-yaypay-stage",
        "hive_path": "s3://sfdl-json-yaypay-stage/raw/contacts/2026-04-12/1775995283",
        "key": "raw/contacts/2026-04-12/1775995283/1908586957452062269e5d37-3667-11f1-aa84-77b75f4c37c712064037168242631837.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_json.yaypay_contacts",
        "type": "json"
    },
    "trace_context": {
        "parent_id": 13896594599541040474,
        "service_name": "drive-thru",
        "span_id": 17832274285961188148,
        "trace_id": 5380832934130155586
    }
}

running: False
schema_name_id: 2090
start_time: 2026-04-12 07:01:32
success: True
trace_id: 5380832934130155586

Scan 6412401

duration: 0:00:15.568355

exit_message:

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

id: 6412401

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-json-yaypay-stage",
        "hive_path": "s3://sfdl-json-yaypay-stage/raw/contacts/2026-04-11/1775908886/1822184450",
        "key": "raw/contacts/2026-04-11/1775908886/1822184450952241fd0337c9-359d-11f1-b068-3d864dc95f552882854839096333462.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_json.yaypay_contacts",
        "type": "json"
    },
    "trace_context": {
        "parent_id": 8585034841116411904,
        "service_name": "drive-thru",
        "span_id": 8212025332454703122,
        "trace_id": 17088282508801764681
    }
}

running: False
schema_name_id: 2090
start_time: 2026-04-11 07:01:39
success: True
trace_id: 17088282508801764681

Scan 6411918

duration: 0:00:13.028687

exit_message:

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

id: 6411918

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-json-yaypay-stage",
        "hive_path": "s3://sfdl-json-yaypay-stage/raw/contacts/2026-04-10/1775822488/1735787534",
        "key": "raw/contacts/2026-04-10/1775822488/1735787534415186d30f1cc3-34d4-11f1-aa84-33dabd157eb013083686609102090056.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_json.yaypay_contacts",
        "type": "json"
    },
    "trace_context": {
        "parent_id": 17280486150676380244,
        "service_name": "drive-thru",
        "span_id": 10215620456851849347,
        "trace_id": 3041857571391808879
    }
}

running: False
schema_name_id: 2090
start_time: 2026-04-10 07:01:34
success: True
trace_id: 3041857571391808879

Scan 6411404

duration: 0:00:15.594719

exit_message:

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

id: 6411404

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-json-yaypay-stage",
        "hive_path": "s3://sfdl-json-yaypay-stage/raw/contacts/2026-04-09/1775736093/1649386772",
        "key": "raw/contacts/2026-04-09/1775736093/1649386772518071a8cb5b5e-340b-11f1-b068-955eb7041a617009303544162787987.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_json.yaypay_contacts",
        "type": "json"
    },
    "trace_context": {
        "parent_id": 2956179785158553076,
        "service_name": "drive-thru",
        "span_id": 6951515775803466424,
        "trace_id": 801495696601065135
    }
}

running: False
schema_name_id: 2090
start_time: 2026-04-09 07:01:36
success: True
trace_id: 801495696601065135

Scan 6410901

duration: 0:00:15.498824

exit_message:

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

id: 6410901

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-json-yaypay-stage",
        "hive_path": "s3://sfdl-json-yaypay-stage/raw/contacts/2026-04-08/1775649696/1562984661",
        "key": "raw/contacts/2026-04-08/1775649696/15629846617365887e13066c-3342-11f1-b068-790e766fafb613952949378403267725.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_json.yaypay_contacts",
        "type": "json"
    },
    "trace_context": {
        "parent_id": 13367373488228332636,
        "service_name": "drive-thru",
        "span_id": 15769388043308158897,
        "trace_id": 12546228730107570712
    }
}

running: False
schema_name_id: 2090
start_time: 2026-04-08 07:01:47
success: True
trace_id: 12546228730107570712

Scan 6410390

duration: 0:00:15.326660

exit_message:

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

id: 6410390

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-json-yaypay-stage",
        "hive_path": "s3://sfdl-json-yaypay-stage/raw/contacts/2026-04-07/1775563290/1476585880",
        "key": "raw/contacts/2026-04-07/1775563290/1476585880473100530f9e11-3279-11f1-aa84-81638877ce429404430365487474078.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_json.yaypay_contacts",
        "type": "json"
    },
    "trace_context": {
        "parent_id": 3143319199012954736,
        "service_name": "drive-thru",
        "span_id": 14360634537074090064,
        "trace_id": 12150218590646698776
    }
}

running: False
schema_name_id: 2090
start_time: 2026-04-07 07:01:52
success: True
trace_id: 12150218590646698776

Scan 6409847

duration: 0:00:15.476881

exit_message:

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

id: 6409847

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-json-yaypay-stage",
        "hive_path": "s3://sfdl-json-yaypay-stage/raw/contacts/2026-04-06/1775476886",
        "key": "raw/contacts/2026-04-06/1775476886/139018973216062429df21ee-31b0-11f1-b068-7b4eb0c87ec310185772274913633316.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_json.yaypay_contacts",
        "type": "json"
    },
    "trace_context": {
        "parent_id": 4266270952831221207,
        "service_name": "drive-thru",
        "span_id": 15978446664747329229,
        "trace_id": 5837019853826483599
    }
}

running: False
schema_name_id: 2090
start_time: 2026-04-06 07:01:30
success: True
trace_id: 5837019853826483599

Scan 6409452

duration: 0:00:15.706004

exit_message:

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

id: 6409452

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-json-yaypay-stage",
        "hive_path": "s3://sfdl-json-yaypay-stage/raw/contacts/2026-04-05/1775390483",
        "key": "raw/contacts/2026-04-05/1775390483/1303791492990650fdef0fe2-30e6-11f1-b068-7355bba6046a17327414518518752483.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_json.yaypay_contacts",
        "type": "json"
    },
    "trace_context": {
        "parent_id": 6979232541937688029,
        "service_name": "drive-thru",
        "span_id": 13745536855590508198,
        "trace_id": 10808249959163422839
    }
}

running: False
schema_name_id: 2090
start_time: 2026-04-05 07:01:44
success: True
trace_id: 10808249959163422839

Scan 6409071

duration: 0:00:12.934982

exit_message:

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

id: 6409071

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-json-yaypay-stage",
        "hive_path": "s3://sfdl-json-yaypay-stage/raw/contacts/2026-04-04/1775304084",
        "key": "raw/contacts/2026-04-04/1775304084/1217389640736787d3b5fcfc-301d-11f1-b068-29b9284b8c7d2237760441155629816.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_json.yaypay_contacts",
        "type": "json"
    },
    "trace_context": {
        "parent_id": 9104114875830179985,
        "service_name": "drive-thru",
        "span_id": 12065824102083765454,
        "trace_id": 3266157532759279223
    }
}

running: False
schema_name_id: 2090
start_time: 2026-04-04 07:01:35
success: True
trace_id: 3266157532759279223

Scan 6408584

duration: 0:00:15.550717

exit_message:

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

id: 6408584

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-json-yaypay-stage",
        "hive_path": "s3://sfdl-json-yaypay-stage/raw/contacts/2026-04-03/1775217686",
        "key": "raw/contacts/2026-04-03/1775217686/1130985054913690a8e2a58a-2f54-11f1-aa84-2721bd9c394011727610606163826954.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_json.yaypay_contacts",
        "type": "json"
    },
    "trace_context": {
        "parent_id": 7740859349786766473,
        "service_name": "drive-thru",
        "span_id": 12678507733209764499,
        "trace_id": 12806988400806689249
    }
}

running: False
schema_name_id: 2090
start_time: 2026-04-03 07:01:37
success: True
trace_id: 12806988400806689249

Partitions:

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

Schema:

attributes:

{
    "customer_int_id": "string",
    "customer_name": "string",
    "email": "string",
    "first_name": "string",
    "internal_id": "string",
    "is_billing_contact": "string",
    "last_name": "string",
    "mobile_phone": "string",
    "note": "string",
    "phone": "string",
    "role": "string",
    "source_system": "string",
    "title": "string",
    "updated_at": "string"
}

created: 2026-04-17 07:01:34

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_json`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_json.yaypay_contacts`\n(\n`internal_id`STRING,`customer_name`STRING,`customer_int_id`STRING,`email`STRING,`first_name`STRING,`last_name`STRING,`phone`STRING,`mobile_phone`STRING,`role`STRING,`title`STRING,`note`STRING,`is_billing_contact`STRING,`source_system`STRING,`updated_at`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-json-yaypay-stage/raw/contacts/2026-04-17/1776427289'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_json.yaypay_contacts`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_json.yaypay_contacts"
}

Server:

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

Raw:

{
    "name": {
        "created": "2024-01-25 15:07:39",
        "disabled": false,
        "format": "raw",
        "id": 2090,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_json",
            "table": "yaypay_contacts"
        },
        "type": "json"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "customer_int_id": "string",
            "customer_name": "string",
            "email": "string",
            "first_name": "string",
            "internal_id": "string",
            "is_billing_contact": "string",
            "last_name": "string",
            "mobile_phone": "string",
            "note": "string",
            "phone": "string",
            "role": "string",
            "source_system": "string",
            "title": "string",
            "updated_at": "string"
        },
        "created": "2026-04-17 07:01:34",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_json`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_json.yaypay_contacts`\n(\n`internal_id`STRING,`customer_name`STRING,`customer_int_id`STRING,`email`STRING,`first_name`STRING,`last_name`STRING,`phone`STRING,`mobile_phone`STRING,`role`STRING,`title`STRING,`note`STRING,`is_billing_contact`STRING,`source_system`STRING,`updated_at`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-json-yaypay-stage/raw/contacts/2026-04-17/1776427289'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_json.yaypay_contacts`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_json.yaypay_contacts"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}