Schema Info

Schema Name: sfdl_prod_drivethru.hubspot_molo_calls_contacts_associations

created: 2023-02-09 16:03:12
disabled: False
format: raw
id: 1514
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrujson

Schema Versions: 15

Version 1718124

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_contacts_associations/2026-04-17/1776428534
id: 1718124
processed: 1

raw_data:

{
    "calls_id": "388966406",
    "contacts_id": "536851",
    "type": "call_to_contact"
}

schema_attributes:

{
    "calls_id": "string",
    "contacts_id": "string",
    "type": "string"
}

schema_name_id: 1514
schema_scan_id: 162173163
updated: 2026-04-17 07:22:33

Version 1716891

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_contacts_associations/2026-04-16/1776341826
id: 1716891
processed: 1

raw_data:

{
    "calls_id": "388966406",
    "contacts_id": "536851",
    "type": "call_to_contact"
}

schema_attributes:

{
    "calls_id": "string",
    "contacts_id": "string",
    "type": "string"
}

schema_name_id: 1514
schema_scan_id: 162117414
updated: 2026-04-16 07:17:33

Version 1715699

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_contacts_associations/2026-04-15/1776255767
id: 1715699
processed: 1

raw_data:

{
    "calls_id": "388966406",
    "contacts_id": "536851",
    "type": "call_to_contact"
}

schema_attributes:

{
    "calls_id": "string",
    "contacts_id": "string",
    "type": "string"
}

schema_name_id: 1514
schema_scan_id: 162061884
updated: 2026-04-15 07:23:36

Version 1714496

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_contacts_associations/2026-04-14/1776168941
id: 1714496
processed: 1

raw_data:

{
    "calls_id": "388966406",
    "contacts_id": "536851",
    "type": "call_to_contact"
}

schema_attributes:

{
    "calls_id": "string",
    "contacts_id": "string",
    "type": "string"
}

schema_name_id: 1514
schema_scan_id: 162006439
updated: 2026-04-14 07:15:59

Version 1713276

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_contacts_associations/2026-04-13/1776082630
id: 1713276
processed: 1

raw_data:

{
    "calls_id": "388966406",
    "contacts_id": "536851",
    "type": "call_to_contact"
}

schema_attributes:

{
    "calls_id": "string",
    "contacts_id": "string",
    "type": "string"
}

schema_name_id: 1514
schema_scan_id: 161948402
updated: 2026-04-13 07:18:07

Version 1712099

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_contacts_associations/2026-04-12/1775996176
id: 1712099
processed: 1

raw_data:

{
    "calls_id": "388966406",
    "contacts_id": "536851",
    "type": "call_to_contact"
}

schema_attributes:

{
    "calls_id": "string",
    "contacts_id": "string",
    "type": "string"
}

schema_name_id: 1514
schema_scan_id: 161899594
updated: 2026-04-12 07:16:35

Version 1710890

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_contacts_associations/2026-04-11/1775910121
id: 1710890
processed: 1

raw_data:

{
    "calls_id": "388966406",
    "contacts_id": "536851",
    "type": "call_to_contact"
}

schema_attributes:

{
    "calls_id": "string",
    "contacts_id": "string",
    "type": "string"
}

schema_name_id: 1514
schema_scan_id: 161846939
updated: 2026-04-11 07:22:55

Version 1709716

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_contacts_associations/2026-04-10/1775823909
id: 1709716
processed: 1

raw_data:

{
    "calls_id": "388966406",
    "contacts_id": "536851",
    "type": "call_to_contact"
}

schema_attributes:

{
    "calls_id": "string",
    "contacts_id": "string",
    "type": "string"
}

schema_name_id: 1514
schema_scan_id: 161792184
updated: 2026-04-10 07:25:30

Version 1708558

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_contacts_associations/2026-04-09/1775737191
id: 1708558
processed: 1

raw_data:

{
    "calls_id": "388966406",
    "contacts_id": "536851",
    "type": "call_to_contact"
}

schema_attributes:

{
    "calls_id": "string",
    "contacts_id": "string",
    "type": "string"
}

schema_name_id: 1514
schema_scan_id: 161736331
updated: 2026-04-09 07:20:33

Version 1707377

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_contacts_associations/2026-04-08/1775650610
id: 1707377
processed: 1

raw_data:

{
    "calls_id": "388966406",
    "contacts_id": "536851",
    "type": "call_to_contact"
}

schema_attributes:

{
    "calls_id": "string",
    "contacts_id": "string",
    "type": "string"
}

schema_name_id: 1514
schema_scan_id: 161681513
updated: 2026-04-08 07:17:55

Version 1706179

created: 2026-04-07 07:17:51

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_contacts_associations/2026-04-07/1775564252
id: 1706179
processed: 1

raw_data:

{
    "calls_id": "388966406",
    "contacts_id": "536851",
    "type": "call_to_contact"
}

schema_attributes:

{
    "calls_id": "string",
    "contacts_id": "string",
    "type": "string"
}

schema_name_id: 1514
schema_scan_id: 161625279
updated: 2026-04-07 07:18:04

Version 1704970

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

ddl:

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

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

raw_data:

{
    "calls_id": "388966406",
    "contacts_id": "536851",
    "type": "call_to_contact"
}

schema_attributes:

{
    "calls_id": "string",
    "contacts_id": "string",
    "type": "string"
}

schema_name_id: 1514
schema_scan_id: 161567419
updated: 2026-04-06 07:19:59

Version 1703734

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_contacts_associations/2026-04-05/1775391599
id: 1703734
processed: 1

raw_data:

{
    "calls_id": "388966406",
    "contacts_id": "536851",
    "type": "call_to_contact"
}

schema_attributes:

{
    "calls_id": "string",
    "contacts_id": "string",
    "type": "string"
}

schema_name_id: 1514
schema_scan_id: 161520034
updated: 2026-04-05 07:20:36

Version 1702600

created: 2026-04-04 07:22:42

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_contacts_associations/2026-04-04/1775305342
id: 1702600
processed: 1

raw_data:

{
    "calls_id": "388966406",
    "contacts_id": "536851",
    "type": "call_to_contact"
}

schema_attributes:

{
    "calls_id": "string",
    "contacts_id": "string",
    "type": "string"
}

schema_name_id: 1514
schema_scan_id: 161466501
updated: 2026-04-04 07:22:56

Version 1701396

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_contacts_associations/2026-04-03/1775218814
id: 1701396
processed: 1

raw_data:

{
    "calls_id": "388966406",
    "contacts_id": "536851",
    "type": "call_to_contact"
}

schema_attributes:

{
    "calls_id": "string",
    "contacts_id": "string",
    "type": "string"
}

schema_name_id: 1514
schema_scan_id: 161408656
updated: 2026-04-03 07:20:43

Schema Scans: 15

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

Scan 162173163

duration: 0:00:14.482382

exit_message:

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

id: 162173163

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_calls_contacts_associations/2026-04-17/1776428534",
        "key": "raw/hubspot_molo_calls_contacts_associations/2026-04-17/1776428534/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 2858367953283275482,
        "service_name": "drive-thru",
        "span_id": 13202522346820645456,
        "trace_id": 3606421105281861335
    }
}

running: False
schema_name_id: 1514
start_time: 2026-04-17 07:22:19
success: True
trace_id: 3606421105281861335

Scan 162117414

duration: 0:00:19.929586

exit_message:

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

id: 162117414

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_calls_contacts_associations/2026-04-16/1776341826",
        "key": "raw/hubspot_molo_calls_contacts_associations/2026-04-16/1776341826/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 13565763481573543497,
        "service_name": "drive-thru",
        "span_id": 3401087358505928504,
        "trace_id": 3085312318163344267
    }
}

running: False
schema_name_id: 1514
start_time: 2026-04-16 07:17:13
success: True
trace_id: 3085312318163344267

Scan 162061884

duration: 0:00:14.929904

exit_message:

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

id: 162061884

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_calls_contacts_associations/2026-04-15/1776255767",
        "key": "raw/hubspot_molo_calls_contacts_associations/2026-04-15/1776255767/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 12172888241143887854,
        "service_name": "drive-thru",
        "span_id": 10384994270300121874,
        "trace_id": 16268099601435930309
    }
}

running: False
schema_name_id: 1514
start_time: 2026-04-15 07:23:21
success: True
trace_id: 16268099601435930309

Scan 162006439

duration: 0:00:14.413061

exit_message:

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

id: 162006439

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_calls_contacts_associations/2026-04-14/1776168941",
        "key": "raw/hubspot_molo_calls_contacts_associations/2026-04-14/1776168941/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 2281256963790579627,
        "service_name": "drive-thru",
        "span_id": 486472386114848515,
        "trace_id": 2390318958828552780
    }
}

running: False
schema_name_id: 1514
start_time: 2026-04-14 07:15:45
success: True
trace_id: 2390318958828552780

Scan 161948402

duration: 0:00:14.512627

exit_message:

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

id: 161948402

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_calls_contacts_associations/2026-04-13/1776082630",
        "key": "raw/hubspot_molo_calls_contacts_associations/2026-04-13/1776082630/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 5627891368714529011,
        "service_name": "drive-thru",
        "span_id": 2565549523680757057,
        "trace_id": 17273131433621699786
    }
}

running: False
schema_name_id: 1514
start_time: 2026-04-13 07:17:53
success: True
trace_id: 17273131433621699786

Scan 161899594

duration: 0:00:14.631313

exit_message:

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

id: 161899594

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_calls_contacts_associations/2026-04-12/1775996176",
        "key": "raw/hubspot_molo_calls_contacts_associations/2026-04-12/1775996176/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 1964284795322856945,
        "service_name": "drive-thru",
        "span_id": 14316608382394468210,
        "trace_id": 10321717338686160199
    }
}

running: False
schema_name_id: 1514
start_time: 2026-04-12 07:16:20
success: True
trace_id: 10321717338686160199

Scan 161846939

duration: 0:00:14.713538

exit_message:

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

id: 161846939

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_calls_contacts_associations/2026-04-11/1775910121",
        "key": "raw/hubspot_molo_calls_contacts_associations/2026-04-11/1775910121/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 17879477678877191201,
        "service_name": "drive-thru",
        "span_id": 3936023083148278300,
        "trace_id": 12255037733179009993
    }
}

running: False
schema_name_id: 1514
start_time: 2026-04-11 07:22:40
success: True
trace_id: 12255037733179009993

Scan 161792184

duration: 0:00:17.047721

exit_message:

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

id: 161792184

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_calls_contacts_associations/2026-04-10/1775823909",
        "key": "raw/hubspot_molo_calls_contacts_associations/2026-04-10/1775823909/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 12958790925344048543,
        "service_name": "drive-thru",
        "span_id": 13924041111319643522,
        "trace_id": 6936762152095175042
    }
}

running: False
schema_name_id: 1514
start_time: 2026-04-10 07:25:13
success: True
trace_id: 6936762152095175042

Scan 161736331

duration: 0:00:17.211829

exit_message:

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

id: 161736331

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_calls_contacts_associations/2026-04-09/1775737191",
        "key": "raw/hubspot_molo_calls_contacts_associations/2026-04-09/1775737191/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 1585361678042605640,
        "service_name": "drive-thru",
        "span_id": 371630080124536163,
        "trace_id": 187873006394486242
    }
}

running: False
schema_name_id: 1514
start_time: 2026-04-09 07:20:16
success: True
trace_id: 187873006394486242

Scan 161681513

duration: 0:00:14.719827

exit_message:

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

id: 161681513

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_calls_contacts_associations/2026-04-08/1775650610",
        "key": "raw/hubspot_molo_calls_contacts_associations/2026-04-08/1775650610/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 4831463787842194812,
        "service_name": "drive-thru",
        "span_id": 16083554455919512415,
        "trace_id": 8914056822380487953
    }
}

running: False
schema_name_id: 1514
start_time: 2026-04-08 07:17:40
success: True
trace_id: 8914056822380487953

Scan 161625279

duration: 0:00:17.051353

exit_message:

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

id: 161625279

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_calls_contacts_associations/2026-04-07/1775564252",
        "key": "raw/hubspot_molo_calls_contacts_associations/2026-04-07/1775564252/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 3235799269887028452,
        "service_name": "drive-thru",
        "span_id": 5747021527011380194,
        "trace_id": 8413264576056607732
    }
}

running: False
schema_name_id: 1514
start_time: 2026-04-07 07:17:47
success: True
trace_id: 8413264576056607732

Scan 161567419

duration: 0:00:14.633837

exit_message:

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

id: 161567419

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_calls_contacts_associations/2026-04-06/1775477979",
        "key": "raw/hubspot_molo_calls_contacts_associations/2026-04-06/1775477979/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 3941917945573843529,
        "service_name": "drive-thru",
        "span_id": 2364367909422047961,
        "trace_id": 5127360720527552516
    }
}

running: False
schema_name_id: 1514
start_time: 2026-04-06 07:19:45
success: True
trace_id: 5127360720527552516

Scan 161520034

duration: 0:00:14.589709

exit_message:

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

id: 161520034

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_calls_contacts_associations/2026-04-05/1775391599",
        "key": "raw/hubspot_molo_calls_contacts_associations/2026-04-05/1775391599/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 7758619777905837737,
        "service_name": "drive-thru",
        "span_id": 2758555406677107003,
        "trace_id": 1877672408045579057
    }
}

running: False
schema_name_id: 1514
start_time: 2026-04-05 07:20:22
success: True
trace_id: 1877672408045579057

Scan 161466501

duration: 0:00:17.289606

exit_message:

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

id: 161466501

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_calls_contacts_associations/2026-04-04/1775305342",
        "key": "raw/hubspot_molo_calls_contacts_associations/2026-04-04/1775305342/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 289398612956680382,
        "service_name": "drive-thru",
        "span_id": 11315068507989481966,
        "trace_id": 1472877875327677470
    }
}

running: False
schema_name_id: 1514
start_time: 2026-04-04 07:22:39
success: True
trace_id: 1472877875327677470

Scan 161408656

duration: 0:00:14.819090

exit_message:

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

id: 161408656

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_calls_contacts_associations/2026-04-03/1775218814",
        "key": "raw/hubspot_molo_calls_contacts_associations/2026-04-03/1775218814/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 15562537130465682160,
        "service_name": "drive-thru",
        "span_id": 9929096186730173007,
        "trace_id": 3277054137177731614
    }
}

running: False
schema_name_id: 1514
start_time: 2026-04-03 07:20:28
success: True
trace_id: 3277054137177731614

Partitions:

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

Schema:

attributes:

{
    "calls_id": "string",
    "contacts_id": "string",
    "type": "string"
}

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

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_calls_contacts_associations`\n(\n`calls_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_calls_contacts_associations/2026-04-17/1776428534'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_calls_contacts_associations`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_calls_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-02-09 16:03:12",
        "disabled": false,
        "format": "raw",
        "id": 1514,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "hubspot_molo_calls_contacts_associations"
        },
        "type": "drivethrujson"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "calls_id": "string",
            "contacts_id": "string",
            "type": "string"
        },
        "created": "2026-04-17 07:22:22",
        "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_calls_contacts_associations`\n(\n`calls_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_calls_contacts_associations/2026-04-17/1776428534'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_calls_contacts_associations`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_calls_contacts_associations"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}