Schema Info

Schema Name: sfdl_prod_drivethru.hubspot_molo_deals_companies_associations

created: 2023-01-23 11:48:20
disabled: False
format: raw
id: 1255
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrujson

Schema Versions: 15

Version 1718122

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_deals_companies_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_deals_companies_associations`\n(\n`deals_id`STRING,`companies_id`STRING,`type`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_companies_associations/2026-04-17/1776428527'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_deals_companies_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_companies_associations/2026-04-17/1776428527
id: 1718122
processed: 1

raw_data:

{
    "companies_id": "482403473",
    "deals_id": "160964128",
    "type": "deal_to_company"
}

schema_attributes:

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

schema_name_id: 1255
schema_scan_id: 162173162
updated: 2026-04-17 07:22:31

Version 1716893

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_deals_companies_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_deals_companies_associations`\n(\n`deals_id`STRING,`companies_id`STRING,`type`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_companies_associations/2026-04-16/1776341836'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_deals_companies_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_companies_associations/2026-04-16/1776341836
id: 1716893
processed: 1

raw_data:

{
    "companies_id": "482403473",
    "deals_id": "160964128",
    "type": "deal_to_company"
}

schema_attributes:

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

schema_name_id: 1255
schema_scan_id: 162117419
updated: 2026-04-16 07:17:42

Version 1715694

created: 2026-04-15 07:22:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_deals_companies_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_deals_companies_associations`\n(\n`deals_id`STRING,`companies_id`STRING,`type`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_companies_associations/2026-04-15/1776255768'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_deals_companies_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_companies_associations/2026-04-15/1776255768
id: 1715694
processed: 1

raw_data:

{
    "companies_id": "482403473",
    "deals_id": "160964128",
    "type": "deal_to_company"
}

schema_attributes:

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

schema_name_id: 1255
schema_scan_id: 162061876
updated: 2026-04-15 07:23:06

Version 1714497

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_deals_companies_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_deals_companies_associations`\n(\n`deals_id`STRING,`companies_id`STRING,`type`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_companies_associations/2026-04-14/1776168955'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_deals_companies_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_companies_associations/2026-04-14/1776168955
id: 1714497
processed: 1

raw_data:

{
    "companies_id": "482403473",
    "deals_id": "160964128",
    "type": "deal_to_company"
}

schema_attributes:

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

schema_name_id: 1255
schema_scan_id: 162006444
updated: 2026-04-14 07:16:19

Version 1713283

created: 2026-04-13 07:21:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_deals_companies_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_deals_companies_associations`\n(\n`deals_id`STRING,`companies_id`STRING,`type`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_companies_associations/2026-04-13/1776082656'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_deals_companies_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_companies_associations/2026-04-13/1776082656
id: 1713283
processed: 1

raw_data:

{
    "companies_id": "482403473",
    "deals_id": "160964128",
    "type": "deal_to_company"
}

schema_attributes:

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

schema_name_id: 1255
schema_scan_id: 161948415
updated: 2026-04-13 07:21:44

Version 1712095

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_deals_companies_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_deals_companies_associations`\n(\n`deals_id`STRING,`companies_id`STRING,`type`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_companies_associations/2026-04-12/1775996151'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_deals_companies_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_companies_associations/2026-04-12/1775996151
id: 1712095
processed: 1

raw_data:

{
    "companies_id": "482403473",
    "deals_id": "160964128",
    "type": "deal_to_company"
}

schema_attributes:

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

schema_name_id: 1255
schema_scan_id: 161899589
updated: 2026-04-12 07:16:20

Version 1710884

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_deals_companies_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_deals_companies_associations`\n(\n`deals_id`STRING,`companies_id`STRING,`type`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_companies_associations/2026-04-11/1775909695'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_deals_companies_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_companies_associations/2026-04-11/1775909695
id: 1710884
processed: 1

raw_data:

{
    "companies_id": "482403473",
    "deals_id": "160964128",
    "type": "deal_to_company"
}

schema_attributes:

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

schema_name_id: 1255
schema_scan_id: 161846920
updated: 2026-04-11 07:19:36

Version 1709700

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_deals_companies_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_deals_companies_associations`\n(\n`deals_id`STRING,`companies_id`STRING,`type`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_companies_associations/2026-04-10/1775823500'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_deals_companies_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_companies_associations/2026-04-10/1775823500
id: 1709700
processed: 1

raw_data:

{
    "companies_id": "482403473",
    "deals_id": "160964128",
    "type": "deal_to_company"
}

schema_attributes:

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

schema_name_id: 1255
schema_scan_id: 161792154
updated: 2026-04-10 07:18:37

Version 1708564

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_deals_companies_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_deals_companies_associations`\n(\n`deals_id`STRING,`companies_id`STRING,`type`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_companies_associations/2026-04-09/1775737211'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_deals_companies_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_companies_associations/2026-04-09/1775737211
id: 1708564
processed: 1

raw_data:

{
    "companies_id": "482403473",
    "deals_id": "160964128",
    "type": "deal_to_company"
}

schema_attributes:

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

schema_name_id: 1255
schema_scan_id: 161736339
updated: 2026-04-09 07:20:56

Version 1707373

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_deals_companies_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_deals_companies_associations`\n(\n`deals_id`STRING,`companies_id`STRING,`type`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_companies_associations/2026-04-08/1775650619'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_deals_companies_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_companies_associations/2026-04-08/1775650619
id: 1707373
processed: 1

raw_data:

{
    "companies_id": "482403473",
    "deals_id": "160964128",
    "type": "deal_to_company"
}

schema_attributes:

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

schema_name_id: 1255
schema_scan_id: 161681500
updated: 2026-04-08 07:17:29

Version 1706181

created: 2026-04-07 07:17:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_deals_companies_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_deals_companies_associations`\n(\n`deals_id`STRING,`companies_id`STRING,`type`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_companies_associations/2026-04-07/1775564272'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_deals_companies_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_companies_associations/2026-04-07/1775564272
id: 1706181
processed: 1

raw_data:

{
    "companies_id": "482403473",
    "deals_id": "160964128",
    "type": "deal_to_company"
}

schema_attributes:

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

schema_name_id: 1255
schema_scan_id: 161625284
updated: 2026-04-07 07:18:09

Version 1704969

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_deals_companies_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_deals_companies_associations`\n(\n`deals_id`STRING,`companies_id`STRING,`type`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_companies_associations/2026-04-06/1775477979'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_deals_companies_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_companies_associations/2026-04-06/1775477979
id: 1704969
processed: 1

raw_data:

{
    "companies_id": "482403473",
    "deals_id": "160964128",
    "type": "deal_to_company"
}

schema_attributes:

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

schema_name_id: 1255
schema_scan_id: 161567418
updated: 2026-04-06 07:19:58

Version 1703736

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_deals_companies_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_deals_companies_associations`\n(\n`deals_id`STRING,`companies_id`STRING,`type`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_companies_associations/2026-04-05/1775391616'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_deals_companies_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_companies_associations/2026-04-05/1775391616
id: 1703736
processed: 1

raw_data:

{
    "companies_id": "482403473",
    "deals_id": "160964128",
    "type": "deal_to_company"
}

schema_attributes:

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

schema_name_id: 1255
schema_scan_id: 161520037
updated: 2026-04-05 07:20:49

Version 1702591

created: 2026-04-04 07:16:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_deals_companies_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_deals_companies_associations`\n(\n`deals_id`STRING,`companies_id`STRING,`type`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_companies_associations/2026-04-04/1775304935'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_deals_companies_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_companies_associations/2026-04-04/1775304935
id: 1702591
processed: 1

raw_data:

{
    "companies_id": "482403473",
    "deals_id": "160964128",
    "type": "deal_to_company"
}

schema_attributes:

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

schema_name_id: 1255
schema_scan_id: 161466478
updated: 2026-04-04 07:17:05

Version 1701398

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_deals_companies_associations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_deals_companies_associations`\n(\n`deals_id`STRING,`companies_id`STRING,`type`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_companies_associations/2026-04-03/1775218821'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_deals_companies_associations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_companies_associations/2026-04-03/1775218821
id: 1701398
processed: 1

raw_data:

{
    "companies_id": "482403473",
    "deals_id": "160964128",
    "type": "deal_to_company"
}

schema_attributes:

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

schema_name_id: 1255
schema_scan_id: 161408659
updated: 2026-04-03 07:20:53

Schema Scans: 15

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

Scan 162173162

duration: 0:00:12.528010

exit_message:

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

id: 162173162

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_companies_associations/2026-04-17/1776428527",
        "key": "raw/hubspot_molo_deals_companies_associations/2026-04-17/1776428527/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_deals_companies_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 2957734269806825019,
        "service_name": "drive-thru",
        "span_id": 9297309850707161211,
        "trace_id": 5845679969883074459
    }
}

running: False
schema_name_id: 1255
start_time: 2026-04-17 07:22:18
success: True
trace_id: 5845679969883074459

Scan 162117419

duration: 0:00:12.434871

exit_message:

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

id: 162117419

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_companies_associations/2026-04-16/1776341836",
        "key": "raw/hubspot_molo_deals_companies_associations/2026-04-16/1776341836/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_deals_companies_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 4502401985573758449,
        "service_name": "drive-thru",
        "span_id": 10406043324711638511,
        "trace_id": 16065422102513214427
    }
}

running: False
schema_name_id: 1255
start_time: 2026-04-16 07:17:30
success: True
trace_id: 16065422102513214427

Scan 162061876

duration: 0:00:14.891233

exit_message:

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

id: 162061876

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_companies_associations/2026-04-15/1776255768",
        "key": "raw/hubspot_molo_deals_companies_associations/2026-04-15/1776255768/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_deals_companies_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 11753896753991007549,
        "service_name": "drive-thru",
        "span_id": 13625626023567755413,
        "trace_id": 13212722067758105316
    }
}

running: False
schema_name_id: 1255
start_time: 2026-04-15 07:22:51
success: True
trace_id: 13212722067758105316

Scan 162006444

duration: 0:00:14.824463

exit_message:

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

id: 162006444

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_companies_associations/2026-04-14/1776168955",
        "key": "raw/hubspot_molo_deals_companies_associations/2026-04-14/1776168955/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_deals_companies_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 871292103083366657,
        "service_name": "drive-thru",
        "span_id": 16944852187741170007,
        "trace_id": 6439911965861824883
    }
}

running: False
schema_name_id: 1255
start_time: 2026-04-14 07:16:04
success: True
trace_id: 6439911965861824883

Scan 161948415

duration: 0:00:12.462042

exit_message:

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

id: 161948415

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_companies_associations/2026-04-13/1776082656",
        "key": "raw/hubspot_molo_deals_companies_associations/2026-04-13/1776082656/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_deals_companies_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 17929533761035397811,
        "service_name": "drive-thru",
        "span_id": 9504191830965777406,
        "trace_id": 2788561658362495865
    }
}

running: False
schema_name_id: 1255
start_time: 2026-04-13 07:21:32
success: True
trace_id: 2788561658362495865

Scan 161899589

duration: 0:00:12.266857

exit_message:

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

id: 161899589

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_companies_associations/2026-04-12/1775996151",
        "key": "raw/hubspot_molo_deals_companies_associations/2026-04-12/1775996151/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_deals_companies_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 4051180643920847567,
        "service_name": "drive-thru",
        "span_id": 6414275457272253302,
        "trace_id": 3021627581970977814
    }
}

running: False
schema_name_id: 1255
start_time: 2026-04-12 07:16:08
success: True
trace_id: 3021627581970977814

Scan 161846920

duration: 0:00:12.299037

exit_message:

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

id: 161846920

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_companies_associations/2026-04-11/1775909695",
        "key": "raw/hubspot_molo_deals_companies_associations/2026-04-11/1775909695/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_deals_companies_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 6510327768798505518,
        "service_name": "drive-thru",
        "span_id": 5194153409510732422,
        "trace_id": 14243914120508541795
    }
}

running: False
schema_name_id: 1255
start_time: 2026-04-11 07:19:24
success: True
trace_id: 14243914120508541795

Scan 161792154

duration: 0:00:14.995086

exit_message:

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

id: 161792154

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_companies_associations/2026-04-10/1775823500",
        "key": "raw/hubspot_molo_deals_companies_associations/2026-04-10/1775823500/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_deals_companies_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 7034927126014445878,
        "service_name": "drive-thru",
        "span_id": 14574148336265260599,
        "trace_id": 17841156271033375718
    }
}

running: False
schema_name_id: 1255
start_time: 2026-04-10 07:18:22
success: True
trace_id: 17841156271033375718

Scan 161736339

duration: 0:00:12.504694

exit_message:

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

id: 161736339

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_companies_associations/2026-04-09/1775737211",
        "key": "raw/hubspot_molo_deals_companies_associations/2026-04-09/1775737211/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_deals_companies_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 17723710048749849406,
        "service_name": "drive-thru",
        "span_id": 1580845487062942117,
        "trace_id": 18124755786813568247
    }
}

running: False
schema_name_id: 1255
start_time: 2026-04-09 07:20:43
success: True
trace_id: 18124755786813568247

Scan 161681500

duration: 0:00:15.055565

exit_message:

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

id: 161681500

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_companies_associations/2026-04-08/1775650619",
        "key": "raw/hubspot_molo_deals_companies_associations/2026-04-08/1775650619/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_deals_companies_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 9912687334041863330,
        "service_name": "drive-thru",
        "span_id": 12983138310072153454,
        "trace_id": 13306185010473825092
    }
}

running: False
schema_name_id: 1255
start_time: 2026-04-08 07:17:14
success: True
trace_id: 13306185010473825092

Scan 161625284

duration: 0:00:12.269586

exit_message:

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

id: 161625284

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_companies_associations/2026-04-07/1775564272",
        "key": "raw/hubspot_molo_deals_companies_associations/2026-04-07/1775564272/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_deals_companies_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 11480827679967424762,
        "service_name": "drive-thru",
        "span_id": 13722344126006200588,
        "trace_id": 3888892425652086614
    }
}

running: False
schema_name_id: 1255
start_time: 2026-04-07 07:17:57
success: True
trace_id: 3888892425652086614

Scan 161567418

duration: 0:00:15.007351

exit_message:

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

id: 161567418

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_companies_associations/2026-04-06/1775477979",
        "key": "raw/hubspot_molo_deals_companies_associations/2026-04-06/1775477979/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_deals_companies_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 16710721114430298129,
        "service_name": "drive-thru",
        "span_id": 10911670771709261646,
        "trace_id": 10065523113875027301
    }
}

running: False
schema_name_id: 1255
start_time: 2026-04-06 07:19:43
success: True
trace_id: 10065523113875027301

Scan 161520037

duration: 0:00:12.251892

exit_message:

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

id: 161520037

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_companies_associations/2026-04-05/1775391616",
        "key": "raw/hubspot_molo_deals_companies_associations/2026-04-05/1775391616/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_deals_companies_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 10839291430531383223,
        "service_name": "drive-thru",
        "span_id": 8744578012004132798,
        "trace_id": 2980695136427149457
    }
}

running: False
schema_name_id: 1255
start_time: 2026-04-05 07:20:37
success: True
trace_id: 2980695136427149457

Scan 161466478

duration: 0:00:14.962246

exit_message:

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

id: 161466478

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_companies_associations/2026-04-04/1775304935",
        "key": "raw/hubspot_molo_deals_companies_associations/2026-04-04/1775304935/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_deals_companies_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 4979957393780625933,
        "service_name": "drive-thru",
        "span_id": 5440129182005121463,
        "trace_id": 8997095405726920703
    }
}

running: False
schema_name_id: 1255
start_time: 2026-04-04 07:16:50
success: True
trace_id: 8997095405726920703

Scan 161408659

duration: 0:00:12.330661

exit_message:

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

id: 161408659

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_companies_associations/2026-04-03/1775218821",
        "key": "raw/hubspot_molo_deals_companies_associations/2026-04-03/1775218821/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_deals_companies_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 1398892201872695737,
        "service_name": "drive-thru",
        "span_id": 5685054291648626144,
        "trace_id": 16429400823080771852
    }
}

running: False
schema_name_id: 1255
start_time: 2026-04-03 07:20:40
success: True
trace_id: 16429400823080771852

Partitions:

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

Schema:

attributes:

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

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_deals_companies_associations`\n(\n`deals_id`STRING,`companies_id`STRING,`type`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_companies_associations/2026-04-17/1776428527'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_deals_companies_associations`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_deals_companies_associations"
}

Server:

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

Raw:

{
    "name": {
        "created": "2023-01-23 11:48:20",
        "disabled": false,
        "format": "raw",
        "id": 1255,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "hubspot_molo_deals_companies_associations"
        },
        "type": "drivethrujson"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "category": "string",
            "companies_id": "string",
            "deals_id": "string",
            "label": "string",
            "type": "string",
            "type_id": "string"
        },
        "created": "2026-04-17 07:22:19",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_deals_companies_associations`\n(\n`deals_id`STRING,`companies_id`STRING,`type`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_companies_associations/2026-04-17/1776428527'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_deals_companies_associations`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_deals_companies_associations"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}