Schema Info

Schema Name: sfdl_stage_drivethru.hubspot_molo_calls_contacts_associations

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

name:

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

type: drivethrujson

Schema Versions: 15

Version 906677

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_contacts_associations/2026-04-17/1776428305
id: 906677
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: 1786
schema_scan_id: 6415295
updated: 2026-04-17 07:19:30

Version 906461

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_contacts_associations/2026-04-16/1776341951
id: 906461
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: 1786
schema_scan_id: 6414747
updated: 2026-04-16 07:19:55

Version 906240

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_contacts_associations/2026-04-15/1776255572
id: 906240
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: 1786
schema_scan_id: 6414250
updated: 2026-04-15 07:19:58

Version 906036

created: 2026-04-14 07:24:36

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_contacts_associations/2026-04-14/1776169463
id: 906036
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: 1786
schema_scan_id: 6413768
updated: 2026-04-14 07:24:50

Version 905818

created: 2026-04-13 07:20:30

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_contacts_associations/2026-04-13/1776082823
id: 905818
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: 1786
schema_scan_id: 6413214
updated: 2026-04-13 07:20:41

Version 905615

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_contacts_associations/2026-04-12/1775996408
id: 905615
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: 1786
schema_scan_id: 6412799
updated: 2026-04-12 07:20:36

Version 905414

created: 2026-04-11 07:21:42

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_contacts_associations/2026-04-11/1775910074
id: 905414
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: 1786
schema_scan_id: 6412420
updated: 2026-04-11 07:21:56

Version 905200

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_contacts_associations/2026-04-10/1775823112
id: 905200
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: 1786
schema_scan_id: 6411948
updated: 2026-04-10 07:13:00

Version 904983

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_contacts_associations/2026-04-09/1775736720
id: 904983
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: 1786
schema_scan_id: 6411431
updated: 2026-04-09 07:12:26

Version 904764

created: 2026-04-08 07:13:24

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_contacts_associations/2026-04-08/1775650382
id: 904764
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: 1786
schema_scan_id: 6410922
updated: 2026-04-08 07:13:38

Version 904560

created: 2026-04-07 07:25:46

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_contacts_associations/2026-04-07/1775564736
id: 904560
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: 1786
schema_scan_id: 6410423
updated: 2026-04-07 07:25:58

Version 904339

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_contacts_associations/2026-04-06/1775477879
id: 904339
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: 1786
schema_scan_id: 6409870
updated: 2026-04-06 07:18:41

Version 904141

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_contacts_associations/2026-04-05/1775391443
id: 904141
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: 1786
schema_scan_id: 6409468
updated: 2026-04-05 07:17:49

Version 903940

created: 2026-04-04 07:22:43

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_contacts_associations/2026-04-04/1775305344
id: 903940
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: 1786
schema_scan_id: 6409089
updated: 2026-04-04 07:22:57

Version 903725

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_contacts_associations/2026-04-03/1775218603
id: 903725
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: 1786
schema_scan_id: 6408616
updated: 2026-04-03 07:17:42

Schema Scans: 15

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

Scan 6415295

duration: 0:00:15.066677

exit_message:

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

id: 6415295

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_contacts_associations/2026-04-17/1776428305",
        "key": "raw/hubspot_molo_calls_contacts_associations/2026-04-17/1776428305/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 2306142470566532594,
        "service_name": "drive-thru",
        "span_id": 4347720986188584171,
        "trace_id": 16336941802504035691
    }
}

running: False
schema_name_id: 1786
start_time: 2026-04-17 07:19:15
success: True
trace_id: 16336941802504035691

Scan 6414747

duration: 0:00:17.656587

exit_message:

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

id: 6414747

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_contacts_associations/2026-04-16/1776341951",
        "key": "raw/hubspot_molo_calls_contacts_associations/2026-04-16/1776341951/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 17421310432518907465,
        "service_name": "drive-thru",
        "span_id": 16150624658457086727,
        "trace_id": 8943638719466070614
    }
}

running: False
schema_name_id: 1786
start_time: 2026-04-16 07:19:38
success: True
trace_id: 8943638719466070614

Scan 6414250

duration: 0:00:15.088584

exit_message:

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

id: 6414250

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_contacts_associations/2026-04-15/1776255572",
        "key": "raw/hubspot_molo_calls_contacts_associations/2026-04-15/1776255572/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 15418599141569169192,
        "service_name": "drive-thru",
        "span_id": 631373868091551530,
        "trace_id": 6606304031346457039
    }
}

running: False
schema_name_id: 1786
start_time: 2026-04-15 07:19:43
success: True
trace_id: 6606304031346457039

Scan 6413768

duration: 0:00:17.632691

exit_message:

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

id: 6413768

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_contacts_associations/2026-04-14/1776169463",
        "key": "raw/hubspot_molo_calls_contacts_associations/2026-04-14/1776169463/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 12172896680777636429,
        "service_name": "drive-thru",
        "span_id": 15095148297489185918,
        "trace_id": 17874550182265956562
    }
}

running: False
schema_name_id: 1786
start_time: 2026-04-14 07:24:32
success: True
trace_id: 17874550182265956562

Scan 6413214

duration: 0:00:15.042067

exit_message:

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

id: 6413214

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_contacts_associations/2026-04-13/1776082823",
        "key": "raw/hubspot_molo_calls_contacts_associations/2026-04-13/1776082823/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 4349208866434953650,
        "service_name": "drive-thru",
        "span_id": 2420652915580014092,
        "trace_id": 7771299998804429328
    }
}

running: False
schema_name_id: 1786
start_time: 2026-04-13 07:20:26
success: True
trace_id: 7771299998804429328

Scan 6412799

duration: 0:00:15.137939

exit_message:

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

id: 6412799

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_contacts_associations/2026-04-12/1775996408",
        "key": "raw/hubspot_molo_calls_contacts_associations/2026-04-12/1775996408/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 5454155152971191249,
        "service_name": "drive-thru",
        "span_id": 17730722831646272740,
        "trace_id": 3900804598447729667
    }
}

running: False
schema_name_id: 1786
start_time: 2026-04-12 07:20:21
success: True
trace_id: 3900804598447729667

Scan 6412420

duration: 0:00:17.661251

exit_message:

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

id: 6412420

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_contacts_associations/2026-04-11/1775910074",
        "key": "raw/hubspot_molo_calls_contacts_associations/2026-04-11/1775910074/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 10806760642821841764,
        "service_name": "drive-thru",
        "span_id": 836553425929343838,
        "trace_id": 4578820899711439796
    }
}

running: False
schema_name_id: 1786
start_time: 2026-04-11 07:21:38
success: True
trace_id: 4578820899711439796

Scan 6411948

duration: 0:00:15.003056

exit_message:

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

id: 6411948

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_contacts_associations/2026-04-10/1775823112",
        "key": "raw/hubspot_molo_calls_contacts_associations/2026-04-10/1775823112/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 16534757088268844297,
        "service_name": "drive-thru",
        "span_id": 6646619794126549298,
        "trace_id": 15383212550773095762
    }
}

running: False
schema_name_id: 1786
start_time: 2026-04-10 07:12:45
success: True
trace_id: 15383212550773095762

Scan 6411431

duration: 0:00:17.773802

exit_message:

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

id: 6411431

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_contacts_associations/2026-04-09/1775736720",
        "key": "raw/hubspot_molo_calls_contacts_associations/2026-04-09/1775736720/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 1723759001220230141,
        "service_name": "drive-thru",
        "span_id": 11149038474857529410,
        "trace_id": 3285326234604716280
    }
}

running: False
schema_name_id: 1786
start_time: 2026-04-09 07:12:08
success: True
trace_id: 3285326234604716280

Scan 6410922

duration: 0:00:17.716915

exit_message:

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

id: 6410922

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_contacts_associations/2026-04-08/1775650382",
        "key": "raw/hubspot_molo_calls_contacts_associations/2026-04-08/1775650382/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 9089566811674047345,
        "service_name": "drive-thru",
        "span_id": 1150596885502054484,
        "trace_id": 1106052253419650715
    }
}

running: False
schema_name_id: 1786
start_time: 2026-04-08 07:13:20
success: True
trace_id: 1106052253419650715

Scan 6410423

duration: 0:00:14.987987

exit_message:

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

id: 6410423

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_contacts_associations/2026-04-07/1775564736",
        "key": "raw/hubspot_molo_calls_contacts_associations/2026-04-07/1775564736/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 10019402782053752616,
        "service_name": "drive-thru",
        "span_id": 6107945894731851770,
        "trace_id": 4642887264222501650
    }
}

running: False
schema_name_id: 1786
start_time: 2026-04-07 07:25:43
success: True
trace_id: 4642887264222501650

Scan 6409870

duration: 0:00:17.467785

exit_message:

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

id: 6409870

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_contacts_associations/2026-04-06/1775477879",
        "key": "raw/hubspot_molo_calls_contacts_associations/2026-04-06/1775477879/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 11145146320064268102,
        "service_name": "drive-thru",
        "span_id": 6873479705179267218,
        "trace_id": 1921705145197499953
    }
}

running: False
schema_name_id: 1786
start_time: 2026-04-06 07:18:24
success: True
trace_id: 1921705145197499953

Scan 6409468

duration: 0:00:17.593594

exit_message:

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

id: 6409468

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_contacts_associations/2026-04-05/1775391443",
        "key": "raw/hubspot_molo_calls_contacts_associations/2026-04-05/1775391443/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 13721853659192989903,
        "service_name": "drive-thru",
        "span_id": 5226255142098128406,
        "trace_id": 8547024687178412466
    }
}

running: False
schema_name_id: 1786
start_time: 2026-04-05 07:17:31
success: True
trace_id: 8547024687178412466

Scan 6409089

duration: 0:00:17.725257

exit_message:

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

id: 6409089

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_contacts_associations/2026-04-04/1775305344",
        "key": "raw/hubspot_molo_calls_contacts_associations/2026-04-04/1775305344/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 6943916820194268001,
        "service_name": "drive-thru",
        "span_id": 4645406254704006697,
        "trace_id": 253405560232623668
    }
}

running: False
schema_name_id: 1786
start_time: 2026-04-04 07:22:40
success: True
trace_id: 253405560232623668

Scan 6408616

duration: 0:00:15.214248

exit_message:

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

id: 6408616

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_contacts_associations/2026-04-03/1775218603",
        "key": "raw/hubspot_molo_calls_contacts_associations/2026-04-03/1775218603/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls_contacts_associations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 9527836579482545975,
        "service_name": "drive-thru",
        "span_id": 12561235820179853580,
        "trace_id": 12866898361579957459
    }
}

running: False
schema_name_id: 1786
start_time: 2026-04-03 07:17:26
success: True
trace_id: 12866898361579957459

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:19:19

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_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-stage/raw/hubspot_molo_calls_contacts_associations/2026-04-17/1776428305'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_calls_contacts_associations`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_calls_contacts_associations"
}

Server:

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

Raw:

{
    "name": {
        "created": "2023-02-09 07:15:37",
        "disabled": false,
        "format": "raw",
        "id": 1786,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_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:19:19",
        "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_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-stage/raw/hubspot_molo_calls_contacts_associations/2026-04-17/1776428305'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_calls_contacts_associations`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_calls_contacts_associations"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}