Schema Info

Schema Name: sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations

created: 2023-01-23 11:47:56
disabled: False
format: raw
id: 1254
is_partitioned: False
is_schema_datatyped: True

name:

{
    "database": "sfdl_prod_drivethru",
    "table": "hubspot_molo_deals_contacts_associations"
}

type: drivethrujson

Schema Versions: 15

Version 1718123

created: 2026-04-17 07:22:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations`\n(\n`deals_id`STRING,`contacts_id`STRING,`type`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-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_contacts_associations/2026-04-17/1776428531'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_contacts_associations/2026-04-17/1776428531
id: 1718123
processed: 1

raw_data:

{
    "contacts_id": "532906",
    "deals_id": "161059224",
    "type": "deal_to_contact"
}

schema_attributes:

{
    "category": "string",
    "contacts_id": "string",
    "deals_id": "string",
    "label": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 1254
schema_scan_id: 162173164
updated: 2026-04-17 07:22:31

Version 1716898

created: 2026-04-16 07:17:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations`\n(\n`deals_id`STRING,`contacts_id`STRING,`type`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-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_contacts_associations/2026-04-16/1776341839'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_contacts_associations/2026-04-16/1776341839
id: 1716898
processed: 1

raw_data:

{
    "contacts_id": "532906",
    "deals_id": "161059224",
    "type": "deal_to_contact"
}

schema_attributes:

{
    "category": "string",
    "contacts_id": "string",
    "deals_id": "string",
    "label": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 1254
schema_scan_id: 162117423
updated: 2026-04-16 07:18:00

Version 1715696

created: 2026-04-15 07:23:07

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations`\n(\n`deals_id`STRING,`contacts_id`STRING,`type`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-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_contacts_associations/2026-04-15/1776255758'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_contacts_associations/2026-04-15/1776255758
id: 1715696
processed: 1

raw_data:

{
    "contacts_id": "532906",
    "deals_id": "161059224",
    "type": "deal_to_contact"
}

schema_attributes:

{
    "category": "string",
    "contacts_id": "string",
    "deals_id": "string",
    "label": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 1254
schema_scan_id: 162061882
updated: 2026-04-15 07:23:21

Version 1714501

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations`\n(\n`deals_id`STRING,`contacts_id`STRING,`type`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-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_contacts_associations/2026-04-14/1776168958'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_contacts_associations/2026-04-14/1776168958
id: 1714501
processed: 1

raw_data:

{
    "contacts_id": "532906",
    "deals_id": "161059224",
    "type": "deal_to_contact"
}

schema_attributes:

{
    "category": "string",
    "contacts_id": "string",
    "deals_id": "string",
    "label": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 1254
schema_scan_id: 162006448
updated: 2026-04-14 07:16:46

Version 1713277

created: 2026-04-13 07:18:08

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations`\n(\n`deals_id`STRING,`contacts_id`STRING,`type`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-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_contacts_associations/2026-04-13/1776082626'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_contacts_associations/2026-04-13/1776082626
id: 1713277
processed: 1

raw_data:

{
    "contacts_id": "532906",
    "deals_id": "161059224",
    "type": "deal_to_contact"
}

schema_attributes:

{
    "category": "string",
    "contacts_id": "string",
    "deals_id": "string",
    "label": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 1254
schema_scan_id: 161948403
updated: 2026-04-13 07:18:21

Version 1712094

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations`\n(\n`deals_id`STRING,`contacts_id`STRING,`type`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-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_contacts_associations/2026-04-12/1775996155'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_contacts_associations/2026-04-12/1775996155
id: 1712094
processed: 1

raw_data:

{
    "contacts_id": "532906",
    "deals_id": "161059224",
    "type": "deal_to_contact"
}

schema_attributes:

{
    "category": "string",
    "contacts_id": "string",
    "deals_id": "string",
    "label": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 1254
schema_scan_id: 161899586
updated: 2026-04-12 07:16:17

Version 1710886

created: 2026-04-11 07:19:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations`\n(\n`deals_id`STRING,`contacts_id`STRING,`type`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-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_contacts_associations/2026-04-11/1775909678'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_contacts_associations/2026-04-11/1775909678
id: 1710886
processed: 1

raw_data:

{
    "contacts_id": "532906",
    "deals_id": "161059224",
    "type": "deal_to_contact"
}

schema_attributes:

{
    "category": "string",
    "contacts_id": "string",
    "deals_id": "string",
    "label": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 1254
schema_scan_id: 161846925
updated: 2026-04-11 07:19:55

Version 1709707

created: 2026-04-10 07:19:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations`\n(\n`deals_id`STRING,`contacts_id`STRING,`type`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-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_contacts_associations/2026-04-10/1775823551'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_contacts_associations/2026-04-10/1775823551
id: 1709707
processed: 1

raw_data:

{
    "contacts_id": "532906",
    "deals_id": "161059224",
    "type": "deal_to_contact"
}

schema_attributes:

{
    "category": "string",
    "contacts_id": "string",
    "deals_id": "string",
    "label": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 1254
schema_scan_id: 161792162
updated: 2026-04-10 07:19:39

Version 1708560

created: 2026-04-09 07:20:28

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations`\n(\n`deals_id`STRING,`contacts_id`STRING,`type`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-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_contacts_associations/2026-04-09/1775737217'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_contacts_associations/2026-04-09/1775737217
id: 1708560
processed: 1

raw_data:

{
    "contacts_id": "532906",
    "deals_id": "161059224",
    "type": "deal_to_contact"
}

schema_attributes:

{
    "category": "string",
    "contacts_id": "string",
    "deals_id": "string",
    "label": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 1254
schema_scan_id: 161736335
updated: 2026-04-09 07:20:42

Version 1707375

created: 2026-04-08 07:17:27

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations`\n(\n`deals_id`STRING,`contacts_id`STRING,`type`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-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_contacts_associations/2026-04-08/1775650603'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_contacts_associations/2026-04-08/1775650603
id: 1707375
processed: 1

raw_data:

{
    "contacts_id": "532906",
    "deals_id": "161059224",
    "type": "deal_to_contact"
}

schema_attributes:

{
    "category": "string",
    "contacts_id": "string",
    "deals_id": "string",
    "label": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 1254
schema_scan_id: 161681503
updated: 2026-04-08 07:17:41

Version 1706180

created: 2026-04-07 07:17:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations`\n(\n`deals_id`STRING,`contacts_id`STRING,`type`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-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_contacts_associations/2026-04-07/1775564263'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_contacts_associations/2026-04-07/1775564263
id: 1706180
processed: 1

raw_data:

{
    "contacts_id": "532906",
    "deals_id": "161059224",
    "type": "deal_to_contact"
}

schema_attributes:

{
    "category": "string",
    "contacts_id": "string",
    "deals_id": "string",
    "label": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 1254
schema_scan_id: 161625280
updated: 2026-04-07 07:18:03

Version 1704973

created: 2026-04-06 07:20:00

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations`\n(\n`deals_id`STRING,`contacts_id`STRING,`type`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-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_contacts_associations/2026-04-06/1775477973'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_contacts_associations/2026-04-06/1775477973
id: 1704973
processed: 1

raw_data:

{
    "contacts_id": "532906",
    "deals_id": "161059224",
    "type": "deal_to_contact"
}

schema_attributes:

{
    "category": "string",
    "contacts_id": "string",
    "deals_id": "string",
    "label": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 1254
schema_scan_id: 161567423
updated: 2026-04-06 07:20:14

Version 1703738

created: 2026-04-05 07:20:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations`\n(\n`deals_id`STRING,`contacts_id`STRING,`type`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-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_contacts_associations/2026-04-05/1775391620'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_contacts_associations/2026-04-05/1775391620
id: 1703738
processed: 1

raw_data:

{
    "contacts_id": "532906",
    "deals_id": "161059224",
    "type": "deal_to_contact"
}

schema_attributes:

{
    "category": "string",
    "contacts_id": "string",
    "deals_id": "string",
    "label": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 1254
schema_scan_id: 161520039
updated: 2026-04-05 07:21:00

Version 1702590

created: 2026-04-04 07:16:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations`\n(\n`deals_id`STRING,`contacts_id`STRING,`type`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-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_contacts_associations/2026-04-04/1775304928'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_contacts_associations/2026-04-04/1775304928
id: 1702590
processed: 1

raw_data:

{
    "contacts_id": "532906",
    "deals_id": "161059224",
    "type": "deal_to_contact"
}

schema_attributes:

{
    "category": "string",
    "contacts_id": "string",
    "deals_id": "string",
    "label": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 1254
schema_scan_id: 161466476
updated: 2026-04-04 07:17:01

Version 1701399

created: 2026-04-03 07:20:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations`\n(\n`deals_id`STRING,`contacts_id`STRING,`type`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-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_contacts_associations/2026-04-03/1775218824'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_contacts_associations/2026-04-03/1775218824
id: 1701399
processed: 1

raw_data:

{
    "contacts_id": "532906",
    "deals_id": "161059224",
    "type": "deal_to_contact"
}

schema_attributes:

{
    "category": "string",
    "contacts_id": "string",
    "deals_id": "string",
    "label": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 1254
schema_scan_id: 161408660
updated: 2026-04-03 07:20:57

Schema Scans: 15

Last at 2026-04-17 07:22:19

Scan 162173164

duration: 0:00:12.018632

exit_message:

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

id: 162173164

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_contacts_associations/2026-04-17/1776428531",
        "key": "raw/hubspot_molo_deals_contacts_associations/2026-04-17/1776428531/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 13424118370591775294,
        "service_name": "drive-thru",
        "span_id": 6971428742070737388,
        "trace_id": 5235286764556998914
    }
}

running: False
schema_name_id: 1254
start_time: 2026-04-17 07:22:19
success: True
trace_id: 5235286764556998914

Scan 162117423

duration: 0:00:14.510523

exit_message:

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

id: 162117423

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_contacts_associations/2026-04-16/1776341839",
        "key": "raw/hubspot_molo_deals_contacts_associations/2026-04-16/1776341839/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 5622675379014888063,
        "service_name": "drive-thru",
        "span_id": 7159495932474142228,
        "trace_id": 5949469668571618417
    }
}

running: False
schema_name_id: 1254
start_time: 2026-04-16 07:17:46
success: True
trace_id: 5949469668571618417

Scan 162061882

duration: 0:00:14.499121

exit_message:

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

id: 162061882

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_contacts_associations/2026-04-15/1776255758",
        "key": "raw/hubspot_molo_deals_contacts_associations/2026-04-15/1776255758/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 8560610111729106323,
        "service_name": "drive-thru",
        "span_id": 857054352668271335,
        "trace_id": 8901753572865001928
    }
}

running: False
schema_name_id: 1254
start_time: 2026-04-15 07:23:06
success: True
trace_id: 8901753572865001928

Scan 162006448

duration: 0:00:14.386530

exit_message:

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

id: 162006448

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_contacts_associations/2026-04-14/1776168958",
        "key": "raw/hubspot_molo_deals_contacts_associations/2026-04-14/1776168958/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 15747699677037227766,
        "service_name": "drive-thru",
        "span_id": 7415091805479176481,
        "trace_id": 900118794766454356
    }
}

running: False
schema_name_id: 1254
start_time: 2026-04-14 07:16:32
success: True
trace_id: 900118794766454356

Scan 161948403

duration: 0:00:14.428409

exit_message:

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

id: 161948403

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_contacts_associations/2026-04-13/1776082626",
        "key": "raw/hubspot_molo_deals_contacts_associations/2026-04-13/1776082626/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 17733738071943907027,
        "service_name": "drive-thru",
        "span_id": 6850588301604947550,
        "trace_id": 16243934027600225436
    }
}

running: False
schema_name_id: 1254
start_time: 2026-04-13 07:18:07
success: True
trace_id: 16243934027600225436

Scan 161899586

duration: 0:00:14.666155

exit_message:

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

id: 161899586

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_contacts_associations/2026-04-12/1775996155",
        "key": "raw/hubspot_molo_deals_contacts_associations/2026-04-12/1775996155/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 2157635139692255159,
        "service_name": "drive-thru",
        "span_id": 1699667069838906515,
        "trace_id": 8247639512228814162
    }
}

running: False
schema_name_id: 1254
start_time: 2026-04-12 07:16:03
success: True
trace_id: 8247639512228814162

Scan 161846925

duration: 0:00:11.798781

exit_message:

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

id: 161846925

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_contacts_associations/2026-04-11/1775909678",
        "key": "raw/hubspot_molo_deals_contacts_associations/2026-04-11/1775909678/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 14138662161287155136,
        "service_name": "drive-thru",
        "span_id": 4325318206331470267,
        "trace_id": 7121651355865732047
    }
}

running: False
schema_name_id: 1254
start_time: 2026-04-11 07:19:43
success: True
trace_id: 7121651355865732047

Scan 161792162

duration: 0:00:14.579032

exit_message:

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

id: 161792162

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_contacts_associations/2026-04-10/1775823551",
        "key": "raw/hubspot_molo_deals_contacts_associations/2026-04-10/1775823551/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 1086703712327080166,
        "service_name": "drive-thru",
        "span_id": 14569610660309821998,
        "trace_id": 2790289777887522617
    }
}

running: False
schema_name_id: 1254
start_time: 2026-04-10 07:19:24
success: True
trace_id: 2790289777887522617

Scan 161736335

duration: 0:00:14.487564

exit_message:

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

id: 161736335

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_contacts_associations/2026-04-09/1775737217",
        "key": "raw/hubspot_molo_deals_contacts_associations/2026-04-09/1775737217/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 17290326016381764874,
        "service_name": "drive-thru",
        "span_id": 10517142482990280146,
        "trace_id": 2524103233161428539
    }
}

running: False
schema_name_id: 1254
start_time: 2026-04-09 07:20:27
success: True
trace_id: 2524103233161428539

Scan 161681503

duration: 0:00:14.313856

exit_message:

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

id: 161681503

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_contacts_associations/2026-04-08/1775650603",
        "key": "raw/hubspot_molo_deals_contacts_associations/2026-04-08/1775650603/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 6998632311014090194,
        "service_name": "drive-thru",
        "span_id": 3595328474048787156,
        "trace_id": 11808305599531107077
    }
}

running: False
schema_name_id: 1254
start_time: 2026-04-08 07:17:27
success: True
trace_id: 11808305599531107077

Scan 161625280

duration: 0:00:11.906622

exit_message:

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

id: 161625280

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_contacts_associations/2026-04-07/1775564263",
        "key": "raw/hubspot_molo_deals_contacts_associations/2026-04-07/1775564263/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 8002826985629036319,
        "service_name": "drive-thru",
        "span_id": 12572191599241187642,
        "trace_id": 1721602959963069588
    }
}

running: False
schema_name_id: 1254
start_time: 2026-04-07 07:17:51
success: True
trace_id: 1721602959963069588

Scan 161567423

duration: 0:00:14.451395

exit_message:

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

id: 161567423

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_contacts_associations/2026-04-06/1775477973",
        "key": "raw/hubspot_molo_deals_contacts_associations/2026-04-06/1775477973/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 5596649848274827429,
        "service_name": "drive-thru",
        "span_id": 885811930369713720,
        "trace_id": 6874293883549447
    }
}

running: False
schema_name_id: 1254
start_time: 2026-04-06 07:19:59
success: True
trace_id: 6874293883549447

Scan 161520039

duration: 0:00:11.879548

exit_message:

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

id: 161520039

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_contacts_associations/2026-04-05/1775391620",
        "key": "raw/hubspot_molo_deals_contacts_associations/2026-04-05/1775391620/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 11546677424029766805,
        "service_name": "drive-thru",
        "span_id": 16280658584223787719,
        "trace_id": 5947197366201174283
    }
}

running: False
schema_name_id: 1254
start_time: 2026-04-05 07:20:48
success: True
trace_id: 5947197366201174283

Scan 161466476

duration: 0:00:14.428632

exit_message:

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

id: 161466476

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_contacts_associations/2026-04-04/1775304928",
        "key": "raw/hubspot_molo_deals_contacts_associations/2026-04-04/1775304928/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 7494507373233480585,
        "service_name": "drive-thru",
        "span_id": 13784165717252560645,
        "trace_id": 10666660598212157811
    }
}

running: False
schema_name_id: 1254
start_time: 2026-04-04 07:16:47
success: True
trace_id: 10666660598212157811

Scan 161408660

duration: 0:00:14.406915

exit_message:

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

id: 161408660

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_contacts_associations/2026-04-03/1775218824",
        "key": "raw/hubspot_molo_deals_contacts_associations/2026-04-03/1775218824/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 15771865890898701862,
        "service_name": "drive-thru",
        "span_id": 11409777983084960660,
        "trace_id": 16234210008974724024
    }
}

running: False
schema_name_id: 1254
start_time: 2026-04-03 07:20:43
success: True
trace_id: 16234210008974724024

Partitions:

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

Schema:

attributes:

{
    "category": "string",
    "contacts_id": "string",
    "deals_id": "string",
    "label": "string",
    "type": "string",
    "type_id": "string"
}

created: 2026-04-17 07:22:20

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations`\n(\n`deals_id`STRING,`contacts_id`STRING,`type`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-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_contacts_associations/2026-04-17/1776428531'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations"
}

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-01-23 11:47:56",
        "disabled": false,
        "format": "raw",
        "id": 1254,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "hubspot_molo_deals_contacts_associations"
        },
        "type": "drivethrujson"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "category": "string",
            "contacts_id": "string",
            "deals_id": "string",
            "label": "string",
            "type": "string",
            "type_id": "string"
        },
        "created": "2026-04-17 07:22:20",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations`\n(\n`deals_id`STRING,`contacts_id`STRING,`type`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-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_contacts_associations/2026-04-17/1776428531'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_deals_contacts_associations"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}