Schema Info

Schema Name: sfdl_stage_drivethru.hubspot_molo_companies_contacts_associations

created: 2023-01-23 10:24:56
disabled: False
format: raw
id: 1530
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrujson

Schema Versions: 15

Version 906671

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_companies_contacts_associations/2026-04-17/1776428274
id: 906671
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: 1530
schema_scan_id: 6415288
updated: 2026-04-17 07:18:49

Version 906459

created: 2026-04-16 07:15:00

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_companies_contacts_associations/2026-04-16/1776341616
id: 906459
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: 1530
schema_scan_id: 6414746
updated: 2026-04-16 07:15:22

Version 906238

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_companies_contacts_associations/2026-04-15/1776255558
id: 906238
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: 1530
schema_scan_id: 6414248
updated: 2026-04-15 07:19:53

Version 906026

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_companies_contacts_associations/2026-04-14/1776168943
id: 906026
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: 1530
schema_scan_id: 6413757
updated: 2026-04-14 07:16:17

Version 905810

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_companies_contacts_associations/2026-04-13/1776082690
id: 905810
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: 1530
schema_scan_id: 6413206
updated: 2026-04-13 07:19:03

Version 905606

created: 2026-04-12 07:15:51

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_companies_contacts_associations/2026-04-12/1775996107
id: 905606
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: 1530
schema_scan_id: 6412791
updated: 2026-04-12 07:16:04

Version 905406

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_companies_contacts_associations/2026-04-11/1775909606
id: 905406
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: 1530
schema_scan_id: 6412411
updated: 2026-04-11 07:14:16

Version 905193

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_companies_contacts_associations/2026-04-10/1775823098
id: 905193
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: 1530
schema_scan_id: 6411938
updated: 2026-04-10 07:12:26

Version 904979

created: 2026-04-09 07:11:54

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_companies_contacts_associations/2026-04-09/1775736701
id: 904979
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: 1530
schema_scan_id: 6411425
updated: 2026-04-09 07:12:08

Version 904762

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_companies_contacts_associations/2026-04-08/1775650366
id: 904762
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: 1530
schema_scan_id: 6410919
updated: 2026-04-08 07:13:13

Version 904548

created: 2026-04-07 07:16:40

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_companies_contacts_associations/2026-04-07/1775564181
id: 904548
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: 1530
schema_scan_id: 6410410
updated: 2026-04-07 07:16:54

Version 904337

created: 2026-04-06 07:18:16

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_companies_contacts_associations/2026-04-06/1775477858
id: 904337
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: 1530
schema_scan_id: 6409868
updated: 2026-04-06 07:18:30

Version 904130

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_companies_contacts_associations/2026-04-05/1775391144
id: 904130
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: 1530
schema_scan_id: 6409455
updated: 2026-04-05 07:12:46

Version 903930

created: 2026-04-04 07:14:23

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_companies_contacts_associations/2026-04-04/1775304834
id: 903930
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: 1530
schema_scan_id: 6409080
updated: 2026-04-04 07:14:35

Version 903720

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_companies_contacts_associations/2026-04-03/1775218586
id: 903720
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: 1530
schema_scan_id: 6408612
updated: 2026-04-03 07:17:18

Schema Scans: 15

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

Scan 6415288

duration: 0:00:18.327692

exit_message:

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

id: 6415288

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_companies_contacts_associations/2026-04-17/1776428274",
        "key": "raw/hubspot_molo_companies_contacts_associations/2026-04-17/1776428274/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_companies_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 871963984357449748,
        "service_name": "drive-thru",
        "span_id": 8192215701668729449,
        "trace_id": 5846275811202738983
    }
}

running: False
schema_name_id: 1530
start_time: 2026-04-17 07:18:31
success: True
trace_id: 5846275811202738983

Scan 6414746

duration: 0:00:29.698489

exit_message:

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

id: 6414746

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_companies_contacts_associations/2026-04-16/1776341616",
        "key": "raw/hubspot_molo_companies_contacts_associations/2026-04-16/1776341616/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_companies_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 13395069848647496647,
        "service_name": "drive-thru",
        "span_id": 2407155503999954943,
        "trace_id": 10859207957562948482
    }
}

running: False
schema_name_id: 1530
start_time: 2026-04-16 07:14:52
success: True
trace_id: 10859207957562948482

Scan 6414248

duration: 0:00:18.260862

exit_message:

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

id: 6414248

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_companies_contacts_associations/2026-04-15/1776255558",
        "key": "raw/hubspot_molo_companies_contacts_associations/2026-04-15/1776255558/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_companies_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 13435131609031704443,
        "service_name": "drive-thru",
        "span_id": 7628922306187027910,
        "trace_id": 7732136875987408173
    }
}

running: False
schema_name_id: 1530
start_time: 2026-04-15 07:19:35
success: True
trace_id: 7732136875987408173

Scan 6413757

duration: 0:00:18.894095

exit_message:

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

id: 6413757

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_companies_contacts_associations/2026-04-14/1776168943",
        "key": "raw/hubspot_molo_companies_contacts_associations/2026-04-14/1776168943/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_companies_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 17925944738200472276,
        "service_name": "drive-thru",
        "span_id": 9601642459618238106,
        "trace_id": 4726571096264841064
    }
}

running: False
schema_name_id: 1530
start_time: 2026-04-14 07:15:58
success: True
trace_id: 4726571096264841064

Scan 6413206

duration: 0:00:18.750707

exit_message:

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

id: 6413206

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_companies_contacts_associations/2026-04-13/1776082690",
        "key": "raw/hubspot_molo_companies_contacts_associations/2026-04-13/1776082690/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_companies_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 13617367628446581543,
        "service_name": "drive-thru",
        "span_id": 3221473093888157827,
        "trace_id": 3196949732416259439
    }
}

running: False
schema_name_id: 1530
start_time: 2026-04-13 07:18:44
success: True
trace_id: 3196949732416259439

Scan 6412791

duration: 0:00:20.535468

exit_message:

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

id: 6412791

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_companies_contacts_associations/2026-04-12/1775996107",
        "key": "raw/hubspot_molo_companies_contacts_associations/2026-04-12/1775996107/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_companies_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 6868587951960820936,
        "service_name": "drive-thru",
        "span_id": 15384067114863861847,
        "trace_id": 10364678510071372462
    }
}

running: False
schema_name_id: 1530
start_time: 2026-04-12 07:15:44
success: True
trace_id: 10364678510071372462

Scan 6412411

duration: 0:00:20.439769

exit_message:

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

id: 6412411

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_companies_contacts_associations/2026-04-11/1775909606",
        "key": "raw/hubspot_molo_companies_contacts_associations/2026-04-11/1775909606/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_companies_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 4670212810359950714,
        "service_name": "drive-thru",
        "span_id": 2413798055935163627,
        "trace_id": 6930948146035601852
    }
}

running: False
schema_name_id: 1530
start_time: 2026-04-11 07:13:56
success: True
trace_id: 6930948146035601852

Scan 6411938

duration: 0:00:20.884370

exit_message:

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

id: 6411938

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_companies_contacts_associations/2026-04-10/1775823098",
        "key": "raw/hubspot_molo_companies_contacts_associations/2026-04-10/1775823098/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_companies_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 220214465777894605,
        "service_name": "drive-thru",
        "span_id": 16794870148807883048,
        "trace_id": 18238698531417129837
    }
}

running: False
schema_name_id: 1530
start_time: 2026-04-10 07:12:05
success: True
trace_id: 18238698531417129837

Scan 6411425

duration: 0:00:20.823353

exit_message:

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

id: 6411425

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_companies_contacts_associations/2026-04-09/1775736701",
        "key": "raw/hubspot_molo_companies_contacts_associations/2026-04-09/1775736701/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_companies_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 5574016348780431338,
        "service_name": "drive-thru",
        "span_id": 17187257048138863545,
        "trace_id": 1777021927255078840
    }
}

running: False
schema_name_id: 1530
start_time: 2026-04-09 07:11:47
success: True
trace_id: 1777021927255078840

Scan 6410919

duration: 0:00:20.765562

exit_message:

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

id: 6410919

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_companies_contacts_associations/2026-04-08/1775650366",
        "key": "raw/hubspot_molo_companies_contacts_associations/2026-04-08/1775650366/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_companies_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 5966078267957994890,
        "service_name": "drive-thru",
        "span_id": 4335472218096486758,
        "trace_id": 10934040214479367503
    }
}

running: False
schema_name_id: 1530
start_time: 2026-04-08 07:12:52
success: True
trace_id: 10934040214479367503

Scan 6410410

duration: 0:00:20.691813

exit_message:

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

id: 6410410

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_companies_contacts_associations/2026-04-07/1775564181",
        "key": "raw/hubspot_molo_companies_contacts_associations/2026-04-07/1775564181/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_companies_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 1378293639580846978,
        "service_name": "drive-thru",
        "span_id": 10518538249229249993,
        "trace_id": 12790126138103911799
    }
}

running: False
schema_name_id: 1530
start_time: 2026-04-07 07:16:33
success: True
trace_id: 12790126138103911799

Scan 6409868

duration: 0:00:20.853340

exit_message:

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

id: 6409868

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_companies_contacts_associations/2026-04-06/1775477858",
        "key": "raw/hubspot_molo_companies_contacts_associations/2026-04-06/1775477858/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_companies_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 5868400376279656161,
        "service_name": "drive-thru",
        "span_id": 11947405434885359673,
        "trace_id": 15851617716239748634
    }
}

running: False
schema_name_id: 1530
start_time: 2026-04-06 07:18:09
success: True
trace_id: 15851617716239748634

Scan 6409455

duration: 0:00:17.783836

exit_message:

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

id: 6409455

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_companies_contacts_associations/2026-04-05/1775391144",
        "key": "raw/hubspot_molo_companies_contacts_associations/2026-04-05/1775391144/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_companies_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 15845889994348868297,
        "service_name": "drive-thru",
        "span_id": 5001957704666131717,
        "trace_id": 7592551867296714882
    }
}

running: False
schema_name_id: 1530
start_time: 2026-04-05 07:12:29
success: True
trace_id: 7592551867296714882

Scan 6409080

duration: 0:00:18.172499

exit_message:

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

id: 6409080

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_companies_contacts_associations/2026-04-04/1775304834",
        "key": "raw/hubspot_molo_companies_contacts_associations/2026-04-04/1775304834/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_companies_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 9266607756702543624,
        "service_name": "drive-thru",
        "span_id": 10802394886400764547,
        "trace_id": 8265374303611585746
    }
}

running: False
schema_name_id: 1530
start_time: 2026-04-04 07:14:17
success: True
trace_id: 8265374303611585746

Scan 6408612

duration: 0:00:20.351123

exit_message:

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

id: 6408612

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_companies_contacts_associations/2026-04-03/1775218586",
        "key": "raw/hubspot_molo_companies_contacts_associations/2026-04-03/1775218586/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_companies_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 15255556322222813513,
        "service_name": "drive-thru",
        "span_id": 15460217124085518409,
        "trace_id": 9911515138011354407
    }
}

running: False
schema_name_id: 1530
start_time: 2026-04-03 07:16:57
success: True
trace_id: 9911515138011354407

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

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_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-stage/raw/hubspot_molo_companies_contacts_associations/2026-04-17/1776428274'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_companies_contacts_associations`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_companies_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 10:24:56",
        "disabled": false,
        "format": "raw",
        "id": 1530,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_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:18:38",
        "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_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-stage/raw/hubspot_molo_companies_contacts_associations/2026-04-17/1776428274'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_companies_contacts_associations`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_companies_contacts_associations"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}