Schema Info

Schema Name: sfdl_stage_drivethru.hubspot_molo_calls_companies_associations

created: 2023-02-09 07:15:11
disabled: False
format: raw
id: 1785
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrujson

Schema Versions: 15

Version 906679

created: 2026-04-17 07:24:41

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_companies_associations/2026-04-17/1776428644
id: 906679
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: 1785
schema_scan_id: 6415297
updated: 2026-04-17 07:24:55

Version 906454

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_companies_associations/2026-04-16/1776341628
id: 906454
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: 1785
schema_scan_id: 6414740
updated: 2026-04-16 07:14:36

Version 906244

created: 2026-04-15 07:20:15

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_companies_associations/2026-04-15/1776255588
id: 906244
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: 1785
schema_scan_id: 6414252
updated: 2026-04-15 07:20:29

Version 906033

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_companies_associations/2026-04-14/1776168962
id: 906033
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: 1785
schema_scan_id: 6413765
updated: 2026-04-14 07:17:23

Version 905811

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_companies_associations/2026-04-13/1776082678
id: 905811
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: 1785
schema_scan_id: 6413204
updated: 2026-04-13 07:19:05

Version 905607

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_companies_associations/2026-04-12/1775996120
id: 905607
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: 1785
schema_scan_id: 6412788
updated: 2026-04-12 07:16:04

Version 905409

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_companies_associations/2026-04-11/1775909625
id: 905409
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: 1785
schema_scan_id: 6412410
updated: 2026-04-11 07:14:37

Version 905198

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_companies_associations/2026-04-10/1775823125
id: 905198
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: 1785
schema_scan_id: 6411940
updated: 2026-04-10 07:12:49

Version 904986

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_companies_associations/2026-04-09/1775736714
id: 904986
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: 1785
schema_scan_id: 6411430
updated: 2026-04-09 07:12:41

Version 904773

created: 2026-04-08 07:21:19

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_companies_associations/2026-04-08/1775650849
id: 904773
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: 1785
schema_scan_id: 6410931
updated: 2026-04-08 07:21:33

Version 904551

created: 2026-04-07 07:16:57

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_companies_associations/2026-04-07/1775564184
id: 904551
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: 1785
schema_scan_id: 6410411
updated: 2026-04-07 07:17:11

Version 904344

created: 2026-04-06 07:22:04

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_companies_associations/2026-04-06/1775478090
id: 904344
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: 1785
schema_scan_id: 6409879
updated: 2026-04-06 07:22:15

Version 904138

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_companies_associations/2026-04-05/1775391178
id: 904138
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: 1785
schema_scan_id: 6409461
updated: 2026-04-05 07:13:51

Version 903937

created: 2026-04-04 07:16:24

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_companies_associations/2026-04-04/1775304863
id: 903937
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: 1785
schema_scan_id: 6409086
updated: 2026-04-04 07:16:38

Version 903722

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_companies_associations/2026-04-03/1775218583
id: 903722
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: 1785
schema_scan_id: 6408609
updated: 2026-04-03 07:17:26

Schema Scans: 15

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

Scan 6415297

duration: 0:00:36.610142

exit_message:

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

id: 6415297

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_companies_associations/2026-04-17/1776428644",
        "key": "raw/hubspot_molo_calls_companies_associations/2026-04-17/1776428644/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls_companies_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 9301773046554454075,
        "service_name": "drive-thru",
        "span_id": 9336156761029660917,
        "trace_id": 16950414179777877348
    }
}

running: False
schema_name_id: 1785
start_time: 2026-04-17 07:24:18
success: True
trace_id: 16950414179777877348

Scan 6414740

duration: 0:00:36.702747

exit_message:

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

id: 6414740

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_companies_associations/2026-04-16/1776341628",
        "key": "raw/hubspot_molo_calls_companies_associations/2026-04-16/1776341628/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls_companies_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 15514101037353590342,
        "service_name": "drive-thru",
        "span_id": 2388582326170489300,
        "trace_id": 16077857964428235511
    }
}

running: False
schema_name_id: 1785
start_time: 2026-04-16 07:14:00
success: True
trace_id: 16077857964428235511

Scan 6414252

duration: 0:00:35.989204

exit_message:

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

id: 6414252

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_companies_associations/2026-04-15/1776255588",
        "key": "raw/hubspot_molo_calls_companies_associations/2026-04-15/1776255588/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls_companies_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 3970089443275662522,
        "service_name": "drive-thru",
        "span_id": 3679924807177186303,
        "trace_id": 11431279074729253364
    }
}

running: False
schema_name_id: 1785
start_time: 2026-04-15 07:19:53
success: True
trace_id: 11431279074729253364

Scan 6413765

duration: 0:00:37.629067

exit_message:

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

id: 6413765

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_companies_associations/2026-04-14/1776168962",
        "key": "raw/hubspot_molo_calls_companies_associations/2026-04-14/1776168962/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls_companies_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 3440676398669959703,
        "service_name": "drive-thru",
        "span_id": 14563151833832830904,
        "trace_id": 13394213708954830487
    }
}

running: False
schema_name_id: 1785
start_time: 2026-04-14 07:16:46
success: True
trace_id: 13394213708954830487

Scan 6413204

duration: 0:00:34.483379

exit_message:

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

id: 6413204

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_companies_associations/2026-04-13/1776082678",
        "key": "raw/hubspot_molo_calls_companies_associations/2026-04-13/1776082678/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls_companies_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 9403383639299270908,
        "service_name": "drive-thru",
        "span_id": 7544955003121237424,
        "trace_id": 10983423794359901997
    }
}

running: False
schema_name_id: 1785
start_time: 2026-04-13 07:18:31
success: True
trace_id: 10983423794359901997

Scan 6412788

duration: 0:00:34.273967

exit_message:

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

id: 6412788

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_companies_associations/2026-04-12/1775996120",
        "key": "raw/hubspot_molo_calls_companies_associations/2026-04-12/1775996120/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls_companies_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 3797812709098400986,
        "service_name": "drive-thru",
        "span_id": 14087532608718377602,
        "trace_id": 6123763945596808350
    }
}

running: False
schema_name_id: 1785
start_time: 2026-04-12 07:15:30
success: True
trace_id: 6123763945596808350

Scan 6412410

duration: 0:00:42.133263

exit_message:

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

id: 6412410

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_companies_associations/2026-04-11/1775909625",
        "key": "raw/hubspot_molo_calls_companies_associations/2026-04-11/1775909625/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls_companies_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 17551510661025394458,
        "service_name": "drive-thru",
        "span_id": 13066089015738096384,
        "trace_id": 14761672271747641943
    }
}

running: False
schema_name_id: 1785
start_time: 2026-04-11 07:13:55
success: True
trace_id: 14761672271747641943

Scan 6411940

duration: 0:00:36.041181

exit_message:

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

id: 6411940

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_companies_associations/2026-04-10/1775823125",
        "key": "raw/hubspot_molo_calls_companies_associations/2026-04-10/1775823125/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls_companies_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 3078832593309380533,
        "service_name": "drive-thru",
        "span_id": 100815204343040201,
        "trace_id": 5470671459557090076
    }
}

running: False
schema_name_id: 1785
start_time: 2026-04-10 07:12:13
success: True
trace_id: 5470671459557090076

Scan 6411430

duration: 0:00:33.174878

exit_message:

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

id: 6411430

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_companies_associations/2026-04-09/1775736714",
        "key": "raw/hubspot_molo_calls_companies_associations/2026-04-09/1775736714/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls_companies_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 4804322947276196931,
        "service_name": "drive-thru",
        "span_id": 2637141085936068283,
        "trace_id": 2320703689911705286
    }
}

running: False
schema_name_id: 1785
start_time: 2026-04-09 07:12:08
success: True
trace_id: 2320703689911705286

Scan 6410931

duration: 0:00:36.149513

exit_message:

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

id: 6410931

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_companies_associations/2026-04-08/1775650849",
        "key": "raw/hubspot_molo_calls_companies_associations/2026-04-08/1775650849/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls_companies_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 5011515331790212941,
        "service_name": "drive-thru",
        "span_id": 1471191129497184644,
        "trace_id": 18031827632258446061
    }
}

running: False
schema_name_id: 1785
start_time: 2026-04-08 07:20:57
success: True
trace_id: 18031827632258446061

Scan 6410411

duration: 0:00:35.716561

exit_message:

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

id: 6410411

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_companies_associations/2026-04-07/1775564184",
        "key": "raw/hubspot_molo_calls_companies_associations/2026-04-07/1775564184/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls_companies_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 6339168602817837817,
        "service_name": "drive-thru",
        "span_id": 17846942328962604122,
        "trace_id": 18366020125599493027
    }
}

running: False
schema_name_id: 1785
start_time: 2026-04-07 07:16:35
success: True
trace_id: 18366020125599493027

Scan 6409879

duration: 0:00:33.653331

exit_message:

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

id: 6409879

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_companies_associations/2026-04-06/1775478090",
        "key": "raw/hubspot_molo_calls_companies_associations/2026-04-06/1775478090/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls_companies_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 9339619065935858988,
        "service_name": "drive-thru",
        "span_id": 991105064184435718,
        "trace_id": 9365090393042585613
    }
}

running: False
schema_name_id: 1785
start_time: 2026-04-06 07:21:41
success: True
trace_id: 9365090393042585613

Scan 6409461

duration: 0:00:38.071138

exit_message:

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

id: 6409461

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_companies_associations/2026-04-05/1775391178",
        "key": "raw/hubspot_molo_calls_companies_associations/2026-04-05/1775391178/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls_companies_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 6624458098785155244,
        "service_name": "drive-thru",
        "span_id": 3545001396655101086,
        "trace_id": 3177138554381302816
    }
}

running: False
schema_name_id: 1785
start_time: 2026-04-05 07:13:13
success: True
trace_id: 3177138554381302816

Scan 6409086

duration: 0:00:35.869306

exit_message:

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

id: 6409086

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_companies_associations/2026-04-04/1775304863",
        "key": "raw/hubspot_molo_calls_companies_associations/2026-04-04/1775304863/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls_companies_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 5163837907499289318,
        "service_name": "drive-thru",
        "span_id": 10408974627360123077,
        "trace_id": 6680694230122682752
    }
}

running: False
schema_name_id: 1785
start_time: 2026-04-04 07:16:02
success: True
trace_id: 6680694230122682752

Scan 6408609

duration: 0:00:37.826602

exit_message:

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

id: 6408609

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_companies_associations/2026-04-03/1775218583",
        "key": "raw/hubspot_molo_calls_companies_associations/2026-04-03/1775218583/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls_companies_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 13572845004131739741,
        "service_name": "drive-thru",
        "span_id": 7157566264566640316,
        "trace_id": 4294978563151780892
    }
}

running: False
schema_name_id: 1785
start_time: 2026-04-03 07:16:48
success: True
trace_id: 4294978563151780892

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:24:41

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_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-stage/raw/hubspot_molo_calls_companies_associations/2026-04-17/1776428644'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_calls_companies_associations`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_calls_companies_associations"
}

Server:

hostname: schemamanager-5c55c886bf-h2ts4
name: schema_manager
process_start: 2025-10-21 13:03:27
sf_env: stage
version: 2112174301

Raw:

{
    "name": {
        "created": "2023-02-09 07:15:11",
        "disabled": false,
        "format": "raw",
        "id": 1785,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_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:24:41",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_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-stage/raw/hubspot_molo_calls_companies_associations/2026-04-17/1776428644'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_calls_companies_associations`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_calls_companies_associations"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}