Schema Info

Schema Name: sfdl_stage_drivethru.hubspot_molo_deals_contacts_associations

created: 2023-01-23 09:54:58
disabled: False
format: raw
id: 1528
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrujson

Schema Versions: 15

Version 906672

created: 2026-04-17 07:18:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_deals_contacts_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/hubspot_molo_deals_contacts_associations/2026-04-17/1776428268'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_deals_contacts_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_deals_contacts_associations/2026-04-17/1776428268
id: 906672
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: 1528
schema_scan_id: 6415290
updated: 2026-04-17 07:18:56

Version 906453

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_deals_contacts_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/hubspot_molo_deals_contacts_associations/2026-04-16/1776341619'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_deals_contacts_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_deals_contacts_associations/2026-04-16/1776341619
id: 906453
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: 1528
schema_scan_id: 6414741
updated: 2026-04-16 07:14:23

Version 906237

created: 2026-04-15 07:19:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_deals_contacts_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/hubspot_molo_deals_contacts_associations/2026-04-15/1776255564'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_deals_contacts_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_deals_contacts_associations/2026-04-15/1776255564
id: 906237
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: 1528
schema_scan_id: 6414247
updated: 2026-04-15 07:19:41

Version 906024

created: 2026-04-14 07:15:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_deals_contacts_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/hubspot_molo_deals_contacts_associations/2026-04-14/1776168936'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_deals_contacts_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_deals_contacts_associations/2026-04-14/1776168936
id: 906024
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: 1528
schema_scan_id: 6413755
updated: 2026-04-14 07:15:58

Version 905808

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_deals_contacts_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/hubspot_molo_deals_contacts_associations/2026-04-13/1776082681'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_deals_contacts_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_deals_contacts_associations/2026-04-13/1776082681
id: 905808
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: 1528
schema_scan_id: 6413202
updated: 2026-04-13 07:18:31

Version 905611

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_deals_contacts_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/hubspot_molo_deals_contacts_associations/2026-04-12/1775996113'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_deals_contacts_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_deals_contacts_associations/2026-04-12/1775996113
id: 905611
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: 1528
schema_scan_id: 6412795
updated: 2026-04-12 07:16:24

Version 905403

created: 2026-04-11 07:13:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_deals_contacts_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/hubspot_molo_deals_contacts_associations/2026-04-11/1775909612'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_deals_contacts_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_deals_contacts_associations/2026-04-11/1775909612
id: 905403
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: 1528
schema_scan_id: 6412407
updated: 2026-04-11 07:13:56

Version 905194

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_deals_contacts_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/hubspot_molo_deals_contacts_associations/2026-04-10/1775823102'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_deals_contacts_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_deals_contacts_associations/2026-04-10/1775823102
id: 905194
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: 1528
schema_scan_id: 6411941
updated: 2026-04-10 07:12:27

Version 904982

created: 2026-04-09 07:12:08

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_deals_contacts_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/hubspot_molo_deals_contacts_associations/2026-04-09/1775736697'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_deals_contacts_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_deals_contacts_associations/2026-04-09/1775736697
id: 904982
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: 1528
schema_scan_id: 6411429
updated: 2026-04-09 07:12:22

Version 904765

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_deals_contacts_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/hubspot_molo_deals_contacts_associations/2026-04-08/1775650372'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_deals_contacts_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_deals_contacts_associations/2026-04-08/1775650372
id: 904765
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: 1528
schema_scan_id: 6410923
updated: 2026-04-08 07:13:40

Version 904553

created: 2026-04-07 07:17:10

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_deals_contacts_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/hubspot_molo_deals_contacts_associations/2026-04-07/1775564195'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_deals_contacts_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_deals_contacts_associations/2026-04-07/1775564195
id: 904553
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: 1528
schema_scan_id: 6410416
updated: 2026-04-07 07:17:24

Version 904334

created: 2026-04-06 07:17:55

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_deals_contacts_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/hubspot_molo_deals_contacts_associations/2026-04-06/1775477864'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_deals_contacts_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_deals_contacts_associations/2026-04-06/1775477864
id: 904334
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: 1528
schema_scan_id: 6409864
updated: 2026-04-06 07:18:09

Version 904131

created: 2026-04-05 07:12:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_deals_contacts_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/hubspot_molo_deals_contacts_associations/2026-04-05/1775391153'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_deals_contacts_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_deals_contacts_associations/2026-04-05/1775391153
id: 904131
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: 1528
schema_scan_id: 6409456
updated: 2026-04-05 07:12:58

Version 903928

created: 2026-04-04 07:13:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_deals_contacts_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/hubspot_molo_deals_contacts_associations/2026-04-04/1775304829'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_deals_contacts_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_deals_contacts_associations/2026-04-04/1775304829
id: 903928
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: 1528
schema_scan_id: 6409076
updated: 2026-04-04 07:14:05

Version 903726

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_deals_contacts_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/hubspot_molo_deals_contacts_associations/2026-04-03/1775218588'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_deals_contacts_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_deals_contacts_associations/2026-04-03/1775218588
id: 903726
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: 1528
schema_scan_id: 6408617
updated: 2026-04-03 07:17:47

Schema Scans: 15

Last at 2026-04-17 07:18:42

Scan 6415290

duration: 0:00:14.471853

exit_message:

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

id: 6415290

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_deals_contacts_associations/2026-04-17/1776428268",
        "key": "raw/hubspot_molo_deals_contacts_associations/2026-04-17/1776428268/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_deals_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 13917916791620223870,
        "service_name": "drive-thru",
        "span_id": 7490685130355596135,
        "trace_id": 18366834647356456171
    }
}

running: False
schema_name_id: 1528
start_time: 2026-04-17 07:18:42
success: True
trace_id: 18366834647356456171

Scan 6414741

duration: 0:00:12.316854

exit_message:

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

id: 6414741

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_deals_contacts_associations/2026-04-16/1776341619",
        "key": "raw/hubspot_molo_deals_contacts_associations/2026-04-16/1776341619/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_deals_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 3128260766436470109,
        "service_name": "drive-thru",
        "span_id": 9934267958560333373,
        "trace_id": 16164341772741830268
    }
}

running: False
schema_name_id: 1528
start_time: 2026-04-16 07:14:11
success: True
trace_id: 16164341772741830268

Scan 6414247

duration: 0:00:11.955545

exit_message:

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

id: 6414247

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_deals_contacts_associations/2026-04-15/1776255564",
        "key": "raw/hubspot_molo_deals_contacts_associations/2026-04-15/1776255564/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_deals_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 785155574033774871,
        "service_name": "drive-thru",
        "span_id": 3283113083221292124,
        "trace_id": 15142465310488129407
    }
}

running: False
schema_name_id: 1528
start_time: 2026-04-15 07:19:29
success: True
trace_id: 15142465310488129407

Scan 6413755

duration: 0:00:11.933739

exit_message:

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

id: 6413755

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_deals_contacts_associations/2026-04-14/1776168936",
        "key": "raw/hubspot_molo_deals_contacts_associations/2026-04-14/1776168936/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_deals_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 3540950303682567148,
        "service_name": "drive-thru",
        "span_id": 3516645184919788015,
        "trace_id": 14684238958703744607
    }
}

running: False
schema_name_id: 1528
start_time: 2026-04-14 07:15:46
success: True
trace_id: 14684238958703744607

Scan 6413202

duration: 0:00:14.438138

exit_message:

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

id: 6413202

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_deals_contacts_associations/2026-04-13/1776082681",
        "key": "raw/hubspot_molo_deals_contacts_associations/2026-04-13/1776082681/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_deals_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 7800752372065773646,
        "service_name": "drive-thru",
        "span_id": 17027496642452514759,
        "trace_id": 2989538644908811861
    }
}

running: False
schema_name_id: 1528
start_time: 2026-04-13 07:18:16
success: True
trace_id: 2989538644908811861

Scan 6412795

duration: 0:00:14.488162

exit_message:

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

id: 6412795

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_deals_contacts_associations/2026-04-12/1775996113",
        "key": "raw/hubspot_molo_deals_contacts_associations/2026-04-12/1775996113/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_deals_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 18398523420936444070,
        "service_name": "drive-thru",
        "span_id": 1038393108649737787,
        "trace_id": 7239776566818556329
    }
}

running: False
schema_name_id: 1528
start_time: 2026-04-12 07:16:09
success: True
trace_id: 7239776566818556329

Scan 6412407

duration: 0:00:14.433749

exit_message:

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

id: 6412407

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_deals_contacts_associations/2026-04-11/1775909612",
        "key": "raw/hubspot_molo_deals_contacts_associations/2026-04-11/1775909612/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_deals_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 2491610019097238976,
        "service_name": "drive-thru",
        "span_id": 4429824413132686427,
        "trace_id": 3509281620248302323
    }
}

running: False
schema_name_id: 1528
start_time: 2026-04-11 07:13:42
success: True
trace_id: 3509281620248302323

Scan 6411941

duration: 0:00:12.091814

exit_message:

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

id: 6411941

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_deals_contacts_associations/2026-04-10/1775823102",
        "key": "raw/hubspot_molo_deals_contacts_associations/2026-04-10/1775823102/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_deals_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 3862521917294660682,
        "service_name": "drive-thru",
        "span_id": 463586188681958592,
        "trace_id": 8371961730524634269
    }
}

running: False
schema_name_id: 1528
start_time: 2026-04-10 07:12:15
success: True
trace_id: 8371961730524634269

Scan 6411429

duration: 0:00:14.674457

exit_message:

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

id: 6411429

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_deals_contacts_associations/2026-04-09/1775736697",
        "key": "raw/hubspot_molo_deals_contacts_associations/2026-04-09/1775736697/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_deals_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 4364815077411244952,
        "service_name": "drive-thru",
        "span_id": 732976792834622157,
        "trace_id": 2470144235280532250
    }
}

running: False
schema_name_id: 1528
start_time: 2026-04-09 07:12:07
success: True
trace_id: 2470144235280532250

Scan 6410923

duration: 0:00:12.023359

exit_message:

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

id: 6410923

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_deals_contacts_associations/2026-04-08/1775650372",
        "key": "raw/hubspot_molo_deals_contacts_associations/2026-04-08/1775650372/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_deals_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 9522003552711132643,
        "service_name": "drive-thru",
        "span_id": 7504238732590256099,
        "trace_id": 17717321967213322107
    }
}

running: False
schema_name_id: 1528
start_time: 2026-04-08 07:13:28
success: True
trace_id: 17717321967213322107

Scan 6410416

duration: 0:00:14.577792

exit_message:

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

id: 6410416

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_deals_contacts_associations/2026-04-07/1775564195",
        "key": "raw/hubspot_molo_deals_contacts_associations/2026-04-07/1775564195/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_deals_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 3268631450179501743,
        "service_name": "drive-thru",
        "span_id": 12224770334632111131,
        "trace_id": 8056659918827473813
    }
}

running: False
schema_name_id: 1528
start_time: 2026-04-07 07:17:09
success: True
trace_id: 8056659918827473813

Scan 6409864

duration: 0:00:14.523595

exit_message:

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

id: 6409864

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_deals_contacts_associations/2026-04-06/1775477864",
        "key": "raw/hubspot_molo_deals_contacts_associations/2026-04-06/1775477864/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_deals_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 15003095084645199901,
        "service_name": "drive-thru",
        "span_id": 7410868193479206269,
        "trace_id": 17940579085914035031
    }
}

running: False
schema_name_id: 1528
start_time: 2026-04-06 07:17:54
success: True
trace_id: 17940579085914035031

Scan 6409456

duration: 0:00:14.499551

exit_message:

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

id: 6409456

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_deals_contacts_associations/2026-04-05/1775391153",
        "key": "raw/hubspot_molo_deals_contacts_associations/2026-04-05/1775391153/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_deals_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 17307116444022721513,
        "service_name": "drive-thru",
        "span_id": 18134884253401142332,
        "trace_id": 1119626768961746781
    }
}

running: False
schema_name_id: 1528
start_time: 2026-04-05 07:12:44
success: True
trace_id: 1119626768961746781

Scan 6409076

duration: 0:00:12.161642

exit_message:

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

id: 6409076

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_deals_contacts_associations/2026-04-04/1775304829",
        "key": "raw/hubspot_molo_deals_contacts_associations/2026-04-04/1775304829/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_deals_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 7005556521124878652,
        "service_name": "drive-thru",
        "span_id": 626688044351776774,
        "trace_id": 10190434369638731973
    }
}

running: False
schema_name_id: 1528
start_time: 2026-04-04 07:13:53
success: True
trace_id: 10190434369638731973

Scan 6408617

duration: 0:00:14.707853

exit_message:

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

id: 6408617

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_deals_contacts_associations/2026-04-03/1775218588",
        "key": "raw/hubspot_molo_deals_contacts_associations/2026-04-03/1775218588/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_deals_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 2399491162224137003,
        "service_name": "drive-thru",
        "span_id": 13976154320078939618,
        "trace_id": 17050013506611005008
    }
}

running: False
schema_name_id: 1528
start_time: 2026-04-03 07:17:33
success: True
trace_id: 17050013506611005008

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:18:43

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/hubspot_molo_deals_contacts_associations/2026-04-17/1776428268'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_deals_contacts_associations`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_deals_contacts_associations"
}

Server:

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

Raw:

{
    "name": {
        "created": "2023-01-23 09:54:58",
        "disabled": false,
        "format": "raw",
        "id": 1528,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_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:18:43",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/hubspot_molo_deals_contacts_associations/2026-04-17/1776428268'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_deals_contacts_associations`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_deals_contacts_associations"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}