Schema Info

Schema Name: sfdl_prod_json.yaypay_contacts

created: 2023-12-05 10:51:01
disabled: False
format: raw
id: 1833
is_partitioned: False
is_schema_datatyped: True

name:

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

type: json

Schema Versions: 15

Version 1718054

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_json`",
    "DROP TABLE IF EXISTS `sfdl_prod_json.yaypay_contacts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/contacts/2026-04-17/1776427290'\n",
    "MSCK REPAIR TABLE sfdl_prod_json.yaypay_contacts"
]

hive_path: s3://sfdl-json-yaypay-prod/raw/contacts/2026-04-17/1776427290
id: 1718054
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: 1833
schema_scan_id: 162172997
updated: 2026-04-17 07:01:49

Version 1716826

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_json`",
    "DROP TABLE IF EXISTS `sfdl_prod_json.yaypay_contacts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/contacts/2026-04-16/1776340889'\n",
    "MSCK REPAIR TABLE sfdl_prod_json.yaypay_contacts"
]

hive_path: s3://sfdl-json-yaypay-prod/raw/contacts/2026-04-16/1776340889
id: 1716826
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: 1833
schema_scan_id: 162117244
updated: 2026-04-16 07:01:52

Version 1715618

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_json`",
    "DROP TABLE IF EXISTS `sfdl_prod_json.yaypay_contacts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/contacts/2026-04-15/1776254490'\n",
    "MSCK REPAIR TABLE sfdl_prod_json.yaypay_contacts"
]

hive_path: s3://sfdl-json-yaypay-prod/raw/contacts/2026-04-15/1776254490
id: 1715618
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: 1833
schema_scan_id: 162061568
updated: 2026-04-15 07:01:55

Version 1714434

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_json`",
    "DROP TABLE IF EXISTS `sfdl_prod_json.yaypay_contacts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/contacts/2026-04-14/1776168091'\n",
    "MSCK REPAIR TABLE sfdl_prod_json.yaypay_contacts"
]

hive_path: s3://sfdl-json-yaypay-prod/raw/contacts/2026-04-14/1776168091
id: 1714434
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: 1833
schema_scan_id: 162006281
updated: 2026-04-14 07:01:53

Version 1713209

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_json`",
    "DROP TABLE IF EXISTS `sfdl_prod_json.yaypay_contacts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/contacts/2026-04-13/1776081689'\n",
    "MSCK REPAIR TABLE sfdl_prod_json.yaypay_contacts"
]

hive_path: s3://sfdl-json-yaypay-prod/raw/contacts/2026-04-13/1776081689
id: 1713209
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: 1833
schema_scan_id: 161948197
updated: 2026-04-13 07:02:02

Version 1712027

created: 2026-04-12 07:04:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_json`",
    "DROP TABLE IF EXISTS `sfdl_prod_json.yaypay_contacts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/contacts/2026-04-12/1775995442'\n",
    "MSCK REPAIR TABLE sfdl_prod_json.yaypay_contacts"
]

hive_path: s3://sfdl-json-yaypay-prod/raw/contacts/2026-04-12/1775995442
id: 1712027
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: 1833
schema_scan_id: 161899494
updated: 2026-04-12 07:04:23

Version 1710813

created: 2026-04-11 07:02:06

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_json`",
    "DROP TABLE IF EXISTS `sfdl_prod_json.yaypay_contacts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/contacts/2026-04-11/1775908886/1822184473'\n",
    "MSCK REPAIR TABLE sfdl_prod_json.yaypay_contacts"
]

hive_path: s3://sfdl-json-yaypay-prod/raw/contacts/2026-04-11/1775908886/1822184473
id: 1710813
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: 1833
schema_scan_id: 161846750
updated: 2026-04-11 07:02:20

Version 1709635

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_json`",
    "DROP TABLE IF EXISTS `sfdl_prod_json.yaypay_contacts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/contacts/2026-04-10/1775822486/1735787536'\n",
    "MSCK REPAIR TABLE sfdl_prod_json.yaypay_contacts"
]

hive_path: s3://sfdl-json-yaypay-prod/raw/contacts/2026-04-10/1775822486/1735787536
id: 1709635
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: 1833
schema_scan_id: 161791942
updated: 2026-04-10 07:01:43

Version 1708490

created: 2026-04-09 07:02:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_json`",
    "DROP TABLE IF EXISTS `sfdl_prod_json.yaypay_contacts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/contacts/2026-04-09/1775736085/1649386756'\n",
    "MSCK REPAIR TABLE sfdl_prod_json.yaypay_contacts"
]

hive_path: s3://sfdl-json-yaypay-prod/raw/contacts/2026-04-09/1775736085/1649386756
id: 1708490
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: 1833
schema_scan_id: 161736069
updated: 2026-04-09 07:02:47

Version 1707304

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_json`",
    "DROP TABLE IF EXISTS `sfdl_prod_json.yaypay_contacts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/contacts/2026-04-08/1775649684/1562984661'\n",
    "MSCK REPAIR TABLE sfdl_prod_json.yaypay_contacts"
]

hive_path: s3://sfdl-json-yaypay-prod/raw/contacts/2026-04-08/1775649684/1562984661
id: 1707304
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: 1833
schema_scan_id: 161681350
updated: 2026-04-08 07:01:41

Version 1706107

created: 2026-04-07 07:00:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_json`",
    "DROP TABLE IF EXISTS `sfdl_prod_json.yaypay_contacts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/contacts/2026-04-07/1775563247/1476585904'\n",
    "MSCK REPAIR TABLE sfdl_prod_json.yaypay_contacts"
]

hive_path: s3://sfdl-json-yaypay-prod/raw/contacts/2026-04-07/1775563247/1476585904
id: 1706107
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: 1833
schema_scan_id: 161625006
updated: 2026-04-07 07:01:11

Version 1704901

created: 2026-04-06 07:04:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_json`",
    "DROP TABLE IF EXISTS `sfdl_prod_json.yaypay_contacts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/contacts/2026-04-06/1775476886'\n",
    "MSCK REPAIR TABLE sfdl_prod_json.yaypay_contacts"
]

hive_path: s3://sfdl-json-yaypay-prod/raw/contacts/2026-04-06/1775476886
id: 1704901
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: 1833
schema_scan_id: 161567299
updated: 2026-04-06 07:04:26

Version 1703667

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_json`",
    "DROP TABLE IF EXISTS `sfdl_prod_json.yaypay_contacts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/contacts/2026-04-05/1775390490'\n",
    "MSCK REPAIR TABLE sfdl_prod_json.yaypay_contacts"
]

hive_path: s3://sfdl-json-yaypay-prod/raw/contacts/2026-04-05/1775390490
id: 1703667
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: 1833
schema_scan_id: 161519934
updated: 2026-04-05 07:02:07

Version 1702518

created: 2026-04-04 07:01:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_json`",
    "DROP TABLE IF EXISTS `sfdl_prod_json.yaypay_contacts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/contacts/2026-04-04/1775304085'\n",
    "MSCK REPAIR TABLE sfdl_prod_json.yaypay_contacts"
]

hive_path: s3://sfdl-json-yaypay-prod/raw/contacts/2026-04-04/1775304085
id: 1702518
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: 1833
schema_scan_id: 161466339
updated: 2026-04-04 07:02:09

Version 1701326

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_json`",
    "DROP TABLE IF EXISTS `sfdl_prod_json.yaypay_contacts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/contacts/2026-04-03/1775217693'\n",
    "MSCK REPAIR TABLE sfdl_prod_json.yaypay_contacts"
]

hive_path: s3://sfdl-json-yaypay-prod/raw/contacts/2026-04-03/1775217693
id: 1701326
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: 1833
schema_scan_id: 161408371
updated: 2026-04-03 07:02:08

Schema Scans: 15

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

Scan 162172997

duration: 0:00:15.252102

exit_message:

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

id: 162172997

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-json-yaypay-prod",
        "hive_path": "s3://sfdl-json-yaypay-prod/raw/contacts/2026-04-17/1776427290",
        "key": "raw/contacts/2026-04-17/1776427290/2340587352130980fcf9d00d-3a54-11f1-b068-5f8dc135edce16611379171501384010.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_json.yaypay_contacts",
        "type": "json"
    },
    "trace_context": {
        "parent_id": 16398533497276488625,
        "service_name": "drive-thru",
        "span_id": 10675925381733110902,
        "trace_id": 7044639297374293804
    }
}

running: False
schema_name_id: 1833
start_time: 2026-04-17 07:01:34
success: True
trace_id: 7044639297374293804

Scan 162117244

duration: 0:00:15.604523

exit_message:

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

id: 162117244

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-json-yaypay-prod",
        "hive_path": "s3://sfdl-json-yaypay-prod/raw/contacts/2026-04-16/1776340889",
        "key": "raw/contacts/2026-04-16/1776340889/2254187003012039d2563b67-398b-11f1-aa84-599da95dae316161806751339973847.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_json.yaypay_contacts",
        "type": "json"
    },
    "trace_context": {
        "parent_id": 16015250221500191388,
        "service_name": "drive-thru",
        "span_id": 10346237323253590893,
        "trace_id": 15975857539748160915
    }
}

running: False
schema_name_id: 1833
start_time: 2026-04-16 07:01:37
success: True
trace_id: 15975857539748160915

Scan 162061568

duration: 0:00:15.396123

exit_message:

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

id: 162061568

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-json-yaypay-prod",
        "hive_path": "s3://sfdl-json-yaypay-prod/raw/contacts/2026-04-15/1776254490",
        "key": "raw/contacts/2026-04-15/1776254490/2167786512234395a7419534-38c2-11f1-b068-8b54ff1439ea1053830515523079717.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_json.yaypay_contacts",
        "type": "json"
    },
    "trace_context": {
        "parent_id": 11990005066105005003,
        "service_name": "drive-thru",
        "span_id": 10015093764373491238,
        "trace_id": 6802724635044450466
    }
}

running: False
schema_name_id: 1833
start_time: 2026-04-15 07:01:39
success: True
trace_id: 6802724635044450466

Scan 162006281

duration: 0:00:15.270853

exit_message:

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

id: 162006281

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-json-yaypay-prod",
        "hive_path": "s3://sfdl-json-yaypay-prod/raw/contacts/2026-04-14/1776168091",
        "key": "raw/contacts/2026-04-14/1776168091/20813857006132697db404f1-37f9-11f1-b068-8397e75f3f169857024603351970549.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_json.yaypay_contacts",
        "type": "json"
    },
    "trace_context": {
        "parent_id": 7184575104158721610,
        "service_name": "drive-thru",
        "span_id": 3812995244319023187,
        "trace_id": 8068606528327676117
    }
}

running: False
schema_name_id: 1833
start_time: 2026-04-14 07:01:37
success: True
trace_id: 8068606528327676117

Scan 161948197

duration: 0:00:15.386612

exit_message:

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

id: 161948197

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-json-yaypay-prod",
        "hive_path": "s3://sfdl-json-yaypay-prod/raw/contacts/2026-04-13/1776081689",
        "key": "raw/contacts/2026-04-13/1776081689/199498773515586052a9497f-3730-11f1-aa84-6502057305ab3662927823442298307.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_json.yaypay_contacts",
        "type": "json"
    },
    "trace_context": {
        "parent_id": 688994520834516462,
        "service_name": "drive-thru",
        "span_id": 13380507546170926924,
        "trace_id": 12022299339182424088
    }
}

running: False
schema_name_id: 1833
start_time: 2026-04-13 07:01:46
success: True
trace_id: 12022299339182424088

Scan 161899494

duration: 0:00:12.972584

exit_message:

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

id: 161899494

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-json-yaypay-prod",
        "hive_path": "s3://sfdl-json-yaypay-prod/raw/contacts/2026-04-12/1775995442",
        "key": "raw/contacts/2026-04-12/1775995442/190858697524111328366272-3667-11f1-aa84-53d0512ed9726014133368140666296.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_json.yaypay_contacts",
        "type": "json"
    },
    "trace_context": {
        "parent_id": 17636010700263698370,
        "service_name": "drive-thru",
        "span_id": 9855777914947083060,
        "trace_id": 12099084856699078958
    }
}

running: False
schema_name_id: 1833
start_time: 2026-04-12 07:04:10
success: True
trace_id: 12099084856699078958

Scan 161846750

duration: 0:00:15.425941

exit_message:

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

id: 161846750

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-json-yaypay-prod",
        "hive_path": "s3://sfdl-json-yaypay-prod/raw/contacts/2026-04-11/1775908886/1822184473",
        "key": "raw/contacts/2026-04-11/1775908886/1822184473666590fb9353ab-359d-11f1-aa84-530d4d51eda8635003115251454784.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_json.yaypay_contacts",
        "type": "json"
    },
    "trace_context": {
        "parent_id": 14262119973406038793,
        "service_name": "drive-thru",
        "span_id": 17089251569357213778,
        "trace_id": 16384099855333333629
    }
}

running: False
schema_name_id: 1833
start_time: 2026-04-11 07:02:05
success: True
trace_id: 16384099855333333629

Scan 161791942

duration: 0:00:13.215859

exit_message:

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

id: 161791942

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-json-yaypay-prod",
        "hive_path": "s3://sfdl-json-yaypay-prod/raw/contacts/2026-04-10/1775822486/1735787536",
        "key": "raw/contacts/2026-04-10/1775822486/1735787536041430d1eb84cc-34d4-11f1-b068-53ce6aedc64511020099921776415682.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_json.yaypay_contacts",
        "type": "json"
    },
    "trace_context": {
        "parent_id": 7795910926661498743,
        "service_name": "drive-thru",
        "span_id": 16497034878895361050,
        "trace_id": 16667551409920953395
    }
}

running: False
schema_name_id: 1833
start_time: 2026-04-10 07:01:30
success: True
trace_id: 16667551409920953395

Scan 161736069

duration: 0:00:12.746633

exit_message:

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

id: 161736069

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-json-yaypay-prod",
        "hive_path": "s3://sfdl-json-yaypay-prod/raw/contacts/2026-04-09/1775736085/1649386756",
        "key": "raw/contacts/2026-04-09/1775736085/1649386756156740a7b1d589-340b-11f1-aa84-4d67393025e33576121903023537639.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_json.yaypay_contacts",
        "type": "json"
    },
    "trace_context": {
        "parent_id": 11211531467423706296,
        "service_name": "drive-thru",
        "span_id": 10705952958512661852,
        "trace_id": 12436128596171241846
    }
}

running: False
schema_name_id: 1833
start_time: 2026-04-09 07:02:35
success: True
trace_id: 12436128596171241846

Scan 161681350

duration: 0:00:12.988861

exit_message:

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

id: 161681350

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-json-yaypay-prod",
        "hive_path": "s3://sfdl-json-yaypay-prod/raw/contacts/2026-04-08/1775649684/1562984661",
        "key": "raw/contacts/2026-04-08/1775649684/15629846616888707cd8d8b1-3342-11f1-b068-e3cd2eab27411473575875537088515.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_json.yaypay_contacts",
        "type": "json"
    },
    "trace_context": {
        "parent_id": 7341417188266593080,
        "service_name": "drive-thru",
        "span_id": 4078650354737001786,
        "trace_id": 10088620101947107827
    }
}

running: False
schema_name_id: 1833
start_time: 2026-04-08 07:01:28
success: True
trace_id: 10088620101947107827

Scan 161625006

duration: 0:00:15.361699

exit_message:

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

id: 161625006

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-json-yaypay-prod",
        "hive_path": "s3://sfdl-json-yaypay-prod/raw/contacts/2026-04-07/1775563247/1476585904",
        "key": "raw/contacts/2026-04-07/1775563247/1476585904864987524ee67a-3279-11f1-b068-61bac9fdc9fd12381583157849995946.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_json.yaypay_contacts",
        "type": "json"
    },
    "trace_context": {
        "parent_id": 6821048005870271808,
        "service_name": "drive-thru",
        "span_id": 1766394742497195712,
        "trace_id": 1630979760149251900
    }
}

running: False
schema_name_id: 1833
start_time: 2026-04-07 07:00:56
success: True
trace_id: 1630979760149251900

Scan 161567299

duration: 0:00:12.818259

exit_message:

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

id: 161567299

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-json-yaypay-prod",
        "hive_path": "s3://sfdl-json-yaypay-prod/raw/contacts/2026-04-06/1775476886",
        "key": "raw/contacts/2026-04-06/1775476886/139018976396192927f3305c-31b0-11f1-b068-81aa839daf7010204730581436844492.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_json.yaypay_contacts",
        "type": "json"
    },
    "trace_context": {
        "parent_id": 9995604607520654871,
        "service_name": "drive-thru",
        "span_id": 12192301663453503480,
        "trace_id": 1943790352945725168
    }
}

running: False
schema_name_id: 1833
start_time: 2026-04-06 07:04:13
success: True
trace_id: 1943790352945725168

Scan 161519934

duration: 0:00:12.698480

exit_message:

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

id: 161519934

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-json-yaypay-prod",
        "hive_path": "s3://sfdl-json-yaypay-prod/raw/contacts/2026-04-05/1775390490",
        "key": "raw/contacts/2026-04-05/1775390490/1303791655807769ff1df2f1-30e6-11f1-aa84-f13b9dae7e544915360103260008585.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_json.yaypay_contacts",
        "type": "json"
    },
    "trace_context": {
        "parent_id": 179298960796380088,
        "service_name": "drive-thru",
        "span_id": 7617186213518956982,
        "trace_id": 10598611707529649105
    }
}

running: False
schema_name_id: 1833
start_time: 2026-04-05 07:01:55
success: True
trace_id: 10598611707529649105

Scan 161466339

duration: 0:00:12.771378

exit_message:

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

id: 161466339

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-json-yaypay-prod",
        "hive_path": "s3://sfdl-json-yaypay-prod/raw/contacts/2026-04-04/1775304085",
        "key": "raw/contacts/2026-04-04/1775304085/1217389655632272d3b5fcfd-301d-11f1-b068-e17e944aff0b5338484069079638254.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_json.yaypay_contacts",
        "type": "json"
    },
    "trace_context": {
        "parent_id": 5569556855399554030,
        "service_name": "drive-thru",
        "span_id": 15639159310838486859,
        "trace_id": 5665826729337005412
    }
}

running: False
schema_name_id: 1833
start_time: 2026-04-04 07:01:56
success: True
trace_id: 5665826729337005412

Scan 161408371

duration: 0:00:12.734922

exit_message:

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

id: 161408371

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-json-yaypay-prod",
        "hive_path": "s3://sfdl-json-yaypay-prod/raw/contacts/2026-04-03/1775217693",
        "key": "raw/contacts/2026-04-03/1775217693/1130985054077975a8e34143-2f54-11f1-b068-e1803b085ffe16039946067060086426.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_json.yaypay_contacts",
        "type": "json"
    },
    "trace_context": {
        "parent_id": 13801119847845819659,
        "service_name": "drive-thru",
        "span_id": 5478303592182361591,
        "trace_id": 13629719653516700846
    }
}

running: False
schema_name_id: 1833
start_time: 2026-04-03 07:01:55
success: True
trace_id: 13629719653516700846

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:35

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_json`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/contacts/2026-04-17/1776427290'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_json.yaypay_contacts`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_json.yaypay_contacts"
}

Server:

hostname: schemamanager-5475496c57-7dpqb
name: schema_manager
process_start: 2026-01-09 11:27:47
sf_env: prod
version: 2112174301

Raw:

{
    "name": {
        "created": "2023-12-05 10:51:01",
        "disabled": false,
        "format": "raw",
        "id": 1833,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_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:35",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_json`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/contacts/2026-04-17/1776427290'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_json.yaypay_contacts`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_json.yaypay_contacts"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}