Schema Info

Schema Name: sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations

created: 2023-01-23 12:21:27
disabled: False
format: raw
id: 1256
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrujson

Schema Versions: 15

Version 1718119

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations`\n(\n`companies_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_companies_contacts_associations/2026-04-17/1776428512'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_companies_contacts_associations/2026-04-17/1776428512
id: 1718119
processed: 1

raw_data:

{
    "companies_id": "482395256",
    "contacts_id": "1940651",
    "type": "company_to_contact"
}

schema_attributes:

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

schema_name_id: 1256
schema_scan_id: 162173159
updated: 2026-04-17 07:22:12

Version 1716888

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations`\n(\n`companies_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_companies_contacts_associations/2026-04-16/1776341814'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_companies_contacts_associations/2026-04-16/1776341814
id: 1716888
processed: 1

raw_data:

{
    "companies_id": "482395256",
    "contacts_id": "1940651",
    "type": "company_to_contact"
}

schema_attributes:

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

schema_name_id: 1256
schema_scan_id: 162117410
updated: 2026-04-16 07:17:28

Version 1715697

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations`\n(\n`companies_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_companies_contacts_associations/2026-04-15/1776255764'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_companies_contacts_associations/2026-04-15/1776255764
id: 1715697
processed: 1

raw_data:

{
    "companies_id": "482395256",
    "contacts_id": "1940651",
    "type": "company_to_contact"
}

schema_attributes:

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

schema_name_id: 1256
schema_scan_id: 162061881
updated: 2026-04-15 07:23:22

Version 1714504

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations`\n(\n`companies_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_companies_contacts_associations/2026-04-14/1776168978'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_companies_contacts_associations/2026-04-14/1776168978
id: 1714504
processed: 1

raw_data:

{
    "companies_id": "482395256",
    "contacts_id": "1940651",
    "type": "company_to_contact"
}

schema_attributes:

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

schema_name_id: 1256
schema_scan_id: 162006452
updated: 2026-04-14 07:17:15

Version 1713280

created: 2026-04-13 07:19:00

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations`\n(\n`companies_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_companies_contacts_associations/2026-04-13/1776082640'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_companies_contacts_associations/2026-04-13/1776082640
id: 1713280
processed: 1

raw_data:

{
    "companies_id": "482395256",
    "contacts_id": "1940651",
    "type": "company_to_contact"
}

schema_attributes:

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

schema_name_id: 1256
schema_scan_id: 161948406
updated: 2026-04-13 07:19:11

Version 1712097

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations`\n(\n`companies_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_companies_contacts_associations/2026-04-12/1775996162'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_companies_contacts_associations/2026-04-12/1775996162
id: 1712097
processed: 1

raw_data:

{
    "companies_id": "482395256",
    "contacts_id": "1940651",
    "type": "company_to_contact"
}

schema_attributes:

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

schema_name_id: 1256
schema_scan_id: 161899588
updated: 2026-04-12 07:16:24

Version 1710885

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations`\n(\n`companies_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_companies_contacts_associations/2026-04-11/1775909674'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_companies_contacts_associations/2026-04-11/1775909674
id: 1710885
processed: 1

raw_data:

{
    "companies_id": "482395256",
    "contacts_id": "1940651",
    "type": "company_to_contact"
}

schema_attributes:

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

schema_name_id: 1256
schema_scan_id: 161846919
updated: 2026-04-11 07:19:38

Version 1709704

created: 2026-04-10 07:18:59

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations`\n(\n`companies_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_companies_contacts_associations/2026-04-10/1775823523'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_companies_contacts_associations/2026-04-10/1775823523
id: 1709704
processed: 1

raw_data:

{
    "companies_id": "482395256",
    "contacts_id": "1940651",
    "type": "company_to_contact"
}

schema_attributes:

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

schema_name_id: 1256
schema_scan_id: 161792156
updated: 2026-04-10 07:19:12

Version 1708566

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations`\n(\n`companies_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_companies_contacts_associations/2026-04-09/1775737254'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_companies_contacts_associations/2026-04-09/1775737254
id: 1708566
processed: 1

raw_data:

{
    "companies_id": "482395256",
    "contacts_id": "1940651",
    "type": "company_to_contact"
}

schema_attributes:

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

schema_name_id: 1256
schema_scan_id: 161736341
updated: 2026-04-09 07:21:16

Version 1707378

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations`\n(\n`companies_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_companies_contacts_associations/2026-04-08/1775650623'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_companies_contacts_associations/2026-04-08/1775650623
id: 1707378
processed: 1

raw_data:

{
    "companies_id": "482395256",
    "contacts_id": "1940651",
    "type": "company_to_contact"
}

schema_attributes:

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

schema_name_id: 1256
schema_scan_id: 161681516
updated: 2026-04-08 07:18:06

Version 1706182

created: 2026-04-07 07:18:03

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations`\n(\n`companies_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_companies_contacts_associations/2026-04-07/1775564266'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_companies_contacts_associations/2026-04-07/1775564266
id: 1706182
processed: 1

raw_data:

{
    "companies_id": "482395256",
    "contacts_id": "1940651",
    "type": "company_to_contact"
}

schema_attributes:

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

schema_name_id: 1256
schema_scan_id: 161625283
updated: 2026-04-07 07:18:14

Version 1704974

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations`\n(\n`companies_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_companies_contacts_associations/2026-04-06/1775477976'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_companies_contacts_associations/2026-04-06/1775477976
id: 1704974
processed: 1

raw_data:

{
    "companies_id": "482395256",
    "contacts_id": "1940651",
    "type": "company_to_contact"
}

schema_attributes:

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

schema_name_id: 1256
schema_scan_id: 161567425
updated: 2026-04-06 07:20:24

Version 1703735

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations`\n(\n`companies_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_companies_contacts_associations/2026-04-05/1775391603'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_companies_contacts_associations/2026-04-05/1775391603
id: 1703735
processed: 1

raw_data:

{
    "companies_id": "482395256",
    "contacts_id": "1940651",
    "type": "company_to_contact"
}

schema_attributes:

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

schema_name_id: 1256
schema_scan_id: 161520035
updated: 2026-04-05 07:20:48

Version 1702592

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations`\n(\n`companies_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_companies_contacts_associations/2026-04-04/1775304941'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_companies_contacts_associations/2026-04-04/1775304941
id: 1702592
processed: 1

raw_data:

{
    "companies_id": "482395256",
    "contacts_id": "1940651",
    "type": "company_to_contact"
}

schema_attributes:

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

schema_name_id: 1256
schema_scan_id: 161466479
updated: 2026-04-04 07:17:21

Version 1701400

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations`\n(\n`companies_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_companies_contacts_associations/2026-04-03/1775218817'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_companies_contacts_associations/2026-04-03/1775218817
id: 1701400
processed: 1

raw_data:

{
    "companies_id": "482395256",
    "contacts_id": "1940651",
    "type": "company_to_contact"
}

schema_attributes:

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

schema_name_id: 1256
schema_scan_id: 161408658
updated: 2026-04-03 07:20:57

Schema Scans: 15

Last at 2026-04-17 07:21:55

Scan 162173159

duration: 0:00:17.011400

exit_message:

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

id: 162173159

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_companies_contacts_associations/2026-04-17/1776428512",
        "key": "raw/hubspot_molo_companies_contacts_associations/2026-04-17/1776428512/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 1371064667275500723,
        "service_name": "drive-thru",
        "span_id": 6052542510044899507,
        "trace_id": 2512893548038921
    }
}

running: False
schema_name_id: 1256
start_time: 2026-04-17 07:21:55
success: True
trace_id: 2512893548038921

Scan 162117410

duration: 0:00:24.794517

exit_message:

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

id: 162117410

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_companies_contacts_associations/2026-04-16/1776341814",
        "key": "raw/hubspot_molo_companies_contacts_associations/2026-04-16/1776341814/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 17635537723894750494,
        "service_name": "drive-thru",
        "span_id": 104640209931487211,
        "trace_id": 14694482482756890041
    }
}

running: False
schema_name_id: 1256
start_time: 2026-04-16 07:17:03
success: True
trace_id: 14694482482756890041

Scan 162061881

duration: 0:00:17.293739

exit_message:

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

id: 162061881

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_companies_contacts_associations/2026-04-15/1776255764",
        "key": "raw/hubspot_molo_companies_contacts_associations/2026-04-15/1776255764/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 3733461012821628738,
        "service_name": "drive-thru",
        "span_id": 9103747838542886804,
        "trace_id": 9543679116058312689
    }
}

running: False
schema_name_id: 1256
start_time: 2026-04-15 07:23:04
success: True
trace_id: 9543679116058312689

Scan 162006452

duration: 0:00:20.187182

exit_message:

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

id: 162006452

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_companies_contacts_associations/2026-04-14/1776168978",
        "key": "raw/hubspot_molo_companies_contacts_associations/2026-04-14/1776168978/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 13208459130038314576,
        "service_name": "drive-thru",
        "span_id": 2590384343984418588,
        "trace_id": 5583692811149857425
    }
}

running: False
schema_name_id: 1256
start_time: 2026-04-14 07:16:55
success: True
trace_id: 5583692811149857425

Scan 161948406

duration: 0:00:17.440837

exit_message:

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

id: 161948406

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_companies_contacts_associations/2026-04-13/1776082640",
        "key": "raw/hubspot_molo_companies_contacts_associations/2026-04-13/1776082640/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 1212574726141324260,
        "service_name": "drive-thru",
        "span_id": 8426970507703965859,
        "trace_id": 16167355555090667251
    }
}

running: False
schema_name_id: 1256
start_time: 2026-04-13 07:18:54
success: True
trace_id: 16167355555090667251

Scan 161899588

duration: 0:00:18.614685

exit_message:

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

id: 161899588

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_companies_contacts_associations/2026-04-12/1775996162",
        "key": "raw/hubspot_molo_companies_contacts_associations/2026-04-12/1775996162/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 17751437459096957464,
        "service_name": "drive-thru",
        "span_id": 3304288562594659434,
        "trace_id": 7431101501802765758
    }
}

running: False
schema_name_id: 1256
start_time: 2026-04-12 07:16:06
success: True
trace_id: 7431101501802765758

Scan 161846919

duration: 0:00:16.913339

exit_message:

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

id: 161846919

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_companies_contacts_associations/2026-04-11/1775909674",
        "key": "raw/hubspot_molo_companies_contacts_associations/2026-04-11/1775909674/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 3500559604384081867,
        "service_name": "drive-thru",
        "span_id": 6808466733226109898,
        "trace_id": 13817424037925044773
    }
}

running: False
schema_name_id: 1256
start_time: 2026-04-11 07:19:21
success: True
trace_id: 13817424037925044773

Scan 161792156

duration: 0:00:19.974673

exit_message:

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

id: 161792156

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_companies_contacts_associations/2026-04-10/1775823523",
        "key": "raw/hubspot_molo_companies_contacts_associations/2026-04-10/1775823523/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 1993318384879020472,
        "service_name": "drive-thru",
        "span_id": 6765621787613452360,
        "trace_id": 1259620127148339028
    }
}

running: False
schema_name_id: 1256
start_time: 2026-04-10 07:18:52
success: True
trace_id: 1259620127148339028

Scan 161736341

duration: 0:00:19.411380

exit_message:

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

id: 161736341

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_companies_contacts_associations/2026-04-09/1775737254",
        "key": "raw/hubspot_molo_companies_contacts_associations/2026-04-09/1775737254/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 17724357420163639737,
        "service_name": "drive-thru",
        "span_id": 481713027928483784,
        "trace_id": 11856843975269467070
    }
}

running: False
schema_name_id: 1256
start_time: 2026-04-09 07:20:57
success: True
trace_id: 11856843975269467070

Scan 161681516

duration: 0:00:20.079242

exit_message:

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

id: 161681516

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_companies_contacts_associations/2026-04-08/1775650623",
        "key": "raw/hubspot_molo_companies_contacts_associations/2026-04-08/1775650623/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 13479011045993901967,
        "service_name": "drive-thru",
        "span_id": 3388487953937577576,
        "trace_id": 8851959063884424188
    }
}

running: False
schema_name_id: 1256
start_time: 2026-04-08 07:17:46
success: True
trace_id: 8851959063884424188

Scan 161625283

duration: 0:00:16.947550

exit_message:

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

id: 161625283

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_companies_contacts_associations/2026-04-07/1775564266",
        "key": "raw/hubspot_molo_companies_contacts_associations/2026-04-07/1775564266/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 11629542548375952028,
        "service_name": "drive-thru",
        "span_id": 4283288927896366325,
        "trace_id": 9922556475111483460
    }
}

running: False
schema_name_id: 1256
start_time: 2026-04-07 07:17:57
success: True
trace_id: 9922556475111483460

Scan 161567425

duration: 0:00:19.370221

exit_message:

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

id: 161567425

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_companies_contacts_associations/2026-04-06/1775477976",
        "key": "raw/hubspot_molo_companies_contacts_associations/2026-04-06/1775477976/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 10165300127783012868,
        "service_name": "drive-thru",
        "span_id": 18112629519028565674,
        "trace_id": 10410656824587232206
    }
}

running: False
schema_name_id: 1256
start_time: 2026-04-06 07:20:05
success: True
trace_id: 10410656824587232206

Scan 161520035

duration: 0:00:17.254857

exit_message:

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

id: 161520035

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_companies_contacts_associations/2026-04-05/1775391603",
        "key": "raw/hubspot_molo_companies_contacts_associations/2026-04-05/1775391603/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 6330791943219636229,
        "service_name": "drive-thru",
        "span_id": 9546388884510374484,
        "trace_id": 1573283047932796975
    }
}

running: False
schema_name_id: 1256
start_time: 2026-04-05 07:20:31
success: True
trace_id: 1573283047932796975

Scan 161466479

duration: 0:00:20.093947

exit_message:

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

id: 161466479

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_companies_contacts_associations/2026-04-04/1775304941",
        "key": "raw/hubspot_molo_companies_contacts_associations/2026-04-04/1775304941/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 7754153082405004308,
        "service_name": "drive-thru",
        "span_id": 14132072086285642706,
        "trace_id": 6015246113150008779
    }
}

running: False
schema_name_id: 1256
start_time: 2026-04-04 07:17:01
success: True
trace_id: 6015246113150008779

Scan 161408658

duration: 0:00:17.430859

exit_message:

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

id: 161408658

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_companies_contacts_associations/2026-04-03/1775218817",
        "key": "raw/hubspot_molo_companies_contacts_associations/2026-04-03/1775218817/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 12510928584312244741,
        "service_name": "drive-thru",
        "span_id": 7916205934193965747,
        "trace_id": 18036467670790131516
    }
}

running: False
schema_name_id: 1256
start_time: 2026-04-03 07:20:40
success: True
trace_id: 18036467670790131516

Partitions:

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

Schema:

attributes:

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

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

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_companies_contacts_associations`\n(\n`companies_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_companies_contacts_associations/2026-04-17/1776428512'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_companies_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 12:21:27",
        "disabled": false,
        "format": "raw",
        "id": 1256,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "hubspot_molo_companies_contacts_associations"
        },
        "type": "drivethrujson"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "category": "string",
            "companies_id": "string",
            "contacts_id": "string",
            "label": "string",
            "type": "string",
            "type_id": "string"
        },
        "created": "2026-04-17 07:22:01",
        "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_companies_contacts_associations`\n(\n`companies_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_companies_contacts_associations/2026-04-17/1776428512'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_companies_contacts_associations"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}