Schema Info

Schema Name: sfdl_prod_drivethru.hubspot_molo_calls_companies_associations

created: 2023-02-09 16:08:07
disabled: False
format: raw
id: 1515
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrujson

Schema Versions: 15

Version 1718128

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_companies_associations/2026-04-17/1776428538
id: 1718128
processed: 1

raw_data:

{
    "calls_id": "388966406",
    "companies_id": "485154087",
    "type": "call_to_company"
}

schema_attributes:

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

schema_name_id: 1515
schema_scan_id: 162173165
updated: 2026-04-17 07:22:58

Version 1716908

created: 2026-04-16 07:26:55

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_companies_associations/2026-04-16/1776342392
id: 1716908
processed: 1

raw_data:

{
    "calls_id": "388966406",
    "companies_id": "485154087",
    "type": "call_to_company"
}

schema_attributes:

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

schema_name_id: 1515
schema_scan_id: 162117462
updated: 2026-04-16 07:27:09

Version 1715698

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

ddl:

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

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

raw_data:

{
    "calls_id": "388966406",
    "companies_id": "485154087",
    "type": "call_to_company"
}

schema_attributes:

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

schema_name_id: 1515
schema_scan_id: 162061878
updated: 2026-04-15 07:23:29

Version 1714511

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_companies_associations/2026-04-14/1776169375
id: 1714511
processed: 1

raw_data:

{
    "calls_id": "388966406",
    "companies_id": "485154087",
    "type": "call_to_company"
}

schema_attributes:

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

schema_name_id: 1515
schema_scan_id: 162006476
updated: 2026-04-14 07:23:47

Version 1713286

created: 2026-04-13 07:23:36

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_companies_associations/2026-04-13/1776082978
id: 1713286
processed: 1

raw_data:

{
    "calls_id": "388966406",
    "companies_id": "485154087",
    "type": "call_to_company"
}

schema_attributes:

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

schema_name_id: 1515
schema_scan_id: 161948428
updated: 2026-04-13 07:23:49

Version 1712100

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_companies_associations/2026-04-12/1775996170
id: 1712100
processed: 1

raw_data:

{
    "calls_id": "388966406",
    "companies_id": "485154087",
    "type": "call_to_company"
}

schema_attributes:

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

schema_name_id: 1515
schema_scan_id: 161899591
updated: 2026-04-12 07:16:49

Version 1710876

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_companies_associations/2026-04-11/1775909667
id: 1710876
processed: 1

raw_data:

{
    "calls_id": "388966406",
    "companies_id": "485154087",
    "type": "call_to_company"
}

schema_attributes:

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

schema_name_id: 1515
schema_scan_id: 161846901
updated: 2026-04-11 07:15:02

Version 1709701

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_companies_associations/2026-04-10/1775823493
id: 1709701
processed: 1

raw_data:

{
    "calls_id": "388966406",
    "companies_id": "485154087",
    "type": "call_to_company"
}

schema_attributes:

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

schema_name_id: 1515
schema_scan_id: 161792153
updated: 2026-04-10 07:18:48

Version 1708563

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_companies_associations/2026-04-09/1775737207
id: 1708563
processed: 1

raw_data:

{
    "calls_id": "388966406",
    "companies_id": "485154087",
    "type": "call_to_company"
}

schema_attributes:

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

schema_name_id: 1515
schema_scan_id: 161736333
updated: 2026-04-09 07:20:52

Version 1707387

created: 2026-04-08 07:26:32

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_companies_associations/2026-04-08/1775651166
id: 1707387
processed: 1

raw_data:

{
    "calls_id": "388966406",
    "companies_id": "485154087",
    "type": "call_to_company"
}

schema_attributes:

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

schema_name_id: 1515
schema_scan_id: 161681565
updated: 2026-04-08 07:26:43

Version 1706183

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_companies_associations/2026-04-07/1775564269
id: 1706183
processed: 1

raw_data:

{
    "calls_id": "388966406",
    "companies_id": "485154087",
    "type": "call_to_company"
}

schema_attributes:

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

schema_name_id: 1515
schema_scan_id: 161625285
updated: 2026-04-07 07:18:31

Version 1704975

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_companies_associations/2026-04-06/1775477972
id: 1704975
processed: 1

raw_data:

{
    "calls_id": "388966406",
    "companies_id": "485154087",
    "type": "call_to_company"
}

schema_attributes:

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

schema_name_id: 1515
schema_scan_id: 161567422
updated: 2026-04-06 07:20:32

Version 1703733

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_companies_associations/2026-04-05/1775391591
id: 1703733
processed: 1

raw_data:

{
    "calls_id": "388966406",
    "companies_id": "485154087",
    "type": "call_to_company"
}

schema_attributes:

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

schema_name_id: 1515
schema_scan_id: 161520029
updated: 2026-04-05 07:20:37

Version 1702586

created: 2026-04-04 07:16:19

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_companies_associations/2026-04-04/1775304918
id: 1702586
processed: 1

raw_data:

{
    "calls_id": "388966406",
    "companies_id": "485154087",
    "type": "call_to_company"
}

schema_attributes:

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

schema_name_id: 1515
schema_scan_id: 161466469
updated: 2026-04-04 07:16:33

Version 1701394

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_companies_associations/2026-04-03/1775218793
id: 1701394
processed: 1

raw_data:

{
    "calls_id": "388966406",
    "companies_id": "485154087",
    "type": "call_to_company"
}

schema_attributes:

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

schema_name_id: 1515
schema_scan_id: 161408648
updated: 2026-04-03 07:20:40

Schema Scans: 15

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

Scan 162173165

duration: 0:00:33.747666

exit_message:

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

id: 162173165

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_companies_associations/2026-04-17/1776428538",
        "key": "raw/hubspot_molo_calls_companies_associations/2026-04-17/1776428538/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls_companies_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 14288571021013640627,
        "service_name": "drive-thru",
        "span_id": 16450773156326923967,
        "trace_id": 1204460077105716399
    }
}

running: False
schema_name_id: 1515
start_time: 2026-04-17 07:22:24
success: True
trace_id: 1204460077105716399

Scan 162117462

duration: 0:00:33.754079

exit_message:

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

id: 162117462

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_companies_associations/2026-04-16/1776342392",
        "key": "raw/hubspot_molo_calls_companies_associations/2026-04-16/1776342392/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls_companies_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 9990922050057689809,
        "service_name": "drive-thru",
        "span_id": 4601194386298331992,
        "trace_id": 1875250648280008068
    }
}

running: False
schema_name_id: 1515
start_time: 2026-04-16 07:26:35
success: True
trace_id: 1875250648280008068

Scan 162061878

duration: 0:00:33.746236

exit_message:

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

id: 162061878

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_companies_associations/2026-04-15/1776255764",
        "key": "raw/hubspot_molo_calls_companies_associations/2026-04-15/1776255764/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls_companies_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 941334560682197324,
        "service_name": "drive-thru",
        "span_id": 2780331295456829976,
        "trace_id": 3044024947685115116
    }
}

running: False
schema_name_id: 1515
start_time: 2026-04-15 07:22:55
success: True
trace_id: 3044024947685115116

Scan 162006476

duration: 0:00:33.852689

exit_message:

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

id: 162006476

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_companies_associations/2026-04-14/1776169375",
        "key": "raw/hubspot_molo_calls_companies_associations/2026-04-14/1776169375/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls_companies_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 12284398732520757528,
        "service_name": "drive-thru",
        "span_id": 3983545557986791399,
        "trace_id": 6112658748144364001
    }
}

running: False
schema_name_id: 1515
start_time: 2026-04-14 07:23:13
success: True
trace_id: 6112658748144364001

Scan 161948428

duration: 0:00:33.992671

exit_message:

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

id: 161948428

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_companies_associations/2026-04-13/1776082978",
        "key": "raw/hubspot_molo_calls_companies_associations/2026-04-13/1776082978/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls_companies_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 10927823245863683865,
        "service_name": "drive-thru",
        "span_id": 5124126965264092754,
        "trace_id": 17164392398298747
    }
}

running: False
schema_name_id: 1515
start_time: 2026-04-13 07:23:15
success: True
trace_id: 17164392398298747

Scan 161899591

duration: 0:00:33.656321

exit_message:

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

id: 161899591

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_companies_associations/2026-04-12/1775996170",
        "key": "raw/hubspot_molo_calls_companies_associations/2026-04-12/1775996170/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls_companies_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 5007887555201089278,
        "service_name": "drive-thru",
        "span_id": 12156751207704662938,
        "trace_id": 15384282200390514168
    }
}

running: False
schema_name_id: 1515
start_time: 2026-04-12 07:16:16
success: True
trace_id: 15384282200390514168

Scan 161846901

duration: 0:00:31.075398

exit_message:

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

id: 161846901

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_companies_associations/2026-04-11/1775909667",
        "key": "raw/hubspot_molo_calls_companies_associations/2026-04-11/1775909667/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls_companies_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 2747835665933521622,
        "service_name": "drive-thru",
        "span_id": 12720927746939167818,
        "trace_id": 15451372771804271013
    }
}

running: False
schema_name_id: 1515
start_time: 2026-04-11 07:14:31
success: True
trace_id: 15451372771804271013

Scan 161792153

duration: 0:00:31.136813

exit_message:

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

id: 161792153

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_companies_associations/2026-04-10/1775823493",
        "key": "raw/hubspot_molo_calls_companies_associations/2026-04-10/1775823493/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls_companies_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 8399946401350415747,
        "service_name": "drive-thru",
        "span_id": 7333026487051741686,
        "trace_id": 15391668356590739043
    }
}

running: False
schema_name_id: 1515
start_time: 2026-04-10 07:18:16
success: True
trace_id: 15391668356590739043

Scan 161736333

duration: 0:00:31.936151

exit_message:

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

id: 161736333

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_companies_associations/2026-04-09/1775737207",
        "key": "raw/hubspot_molo_calls_companies_associations/2026-04-09/1775737207/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls_companies_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 391890577216240111,
        "service_name": "drive-thru",
        "span_id": 10146792381364112678,
        "trace_id": 3838957988064014109
    }
}

running: False
schema_name_id: 1515
start_time: 2026-04-09 07:20:21
success: True
trace_id: 3838957988064014109

Scan 161681565

duration: 0:00:33.941318

exit_message:

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

id: 161681565

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_companies_associations/2026-04-08/1775651166",
        "key": "raw/hubspot_molo_calls_companies_associations/2026-04-08/1775651166/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls_companies_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 12397615737295039487,
        "service_name": "drive-thru",
        "span_id": 11969034573131928945,
        "trace_id": 2301473639012924309
    }
}

running: False
schema_name_id: 1515
start_time: 2026-04-08 07:26:09
success: True
trace_id: 2301473639012924309

Scan 161625285

duration: 0:00:33.984140

exit_message:

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

id: 161625285

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_companies_associations/2026-04-07/1775564269",
        "key": "raw/hubspot_molo_calls_companies_associations/2026-04-07/1775564269/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls_companies_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 16247030436477808607,
        "service_name": "drive-thru",
        "span_id": 18238047437702750417,
        "trace_id": 13038114654062537679
    }
}

running: False
schema_name_id: 1515
start_time: 2026-04-07 07:17:57
success: True
trace_id: 13038114654062537679

Scan 161567422

duration: 0:00:34.093577

exit_message:

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

id: 161567422

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_companies_associations/2026-04-06/1775477972",
        "key": "raw/hubspot_molo_calls_companies_associations/2026-04-06/1775477972/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls_companies_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 8014458446215846961,
        "service_name": "drive-thru",
        "span_id": 8210950209799420379,
        "trace_id": 11807362393147182116
    }
}

running: False
schema_name_id: 1515
start_time: 2026-04-06 07:19:58
success: True
trace_id: 11807362393147182116

Scan 161520029

duration: 0:00:34.296057

exit_message:

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

id: 161520029

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_companies_associations/2026-04-05/1775391591",
        "key": "raw/hubspot_molo_calls_companies_associations/2026-04-05/1775391591/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls_companies_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 10603664276559516344,
        "service_name": "drive-thru",
        "span_id": 4356935661060000428,
        "trace_id": 16069894157061924333
    }
}

running: False
schema_name_id: 1515
start_time: 2026-04-05 07:20:03
success: True
trace_id: 16069894157061924333

Scan 161466469

duration: 0:00:34.351964

exit_message:

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

id: 161466469

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_companies_associations/2026-04-04/1775304918",
        "key": "raw/hubspot_molo_calls_companies_associations/2026-04-04/1775304918/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls_companies_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 20591155540434326,
        "service_name": "drive-thru",
        "span_id": 3418220280462441778,
        "trace_id": 4559752702144220615
    }
}

running: False
schema_name_id: 1515
start_time: 2026-04-04 07:15:59
success: True
trace_id: 4559752702144220615

Scan 161408648

duration: 0:00:35.931939

exit_message:

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

id: 161408648

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_companies_associations/2026-04-03/1775218793",
        "key": "raw/hubspot_molo_calls_companies_associations/2026-04-03/1775218793/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls_companies_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 13417870293654286780,
        "service_name": "drive-thru",
        "span_id": 12328183130267553753,
        "trace_id": 8133500752560101585
    }
}

running: False
schema_name_id: 1515
start_time: 2026-04-03 07:20:04
success: True
trace_id: 8133500752560101585

Partitions:

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

Schema:

attributes:

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

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

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