Schema Info

Schema Name: sfdl_stage_drivethru.hubspot_molo_all_contact_list_members

created: 2022-11-30 13:43:52
disabled: False
format: raw
id: 1514
is_partitioned: False
is_schema_datatyped: False

name:

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

type: drivethrujson

Schema Versions: 15

Version 906681

created: 2026-04-17 07:32:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_all_contact_list_members`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_all_contact_list_members`\n(\n`list_id`STRING,`contact_id`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_all_contact_list_members/2026-04-17/1776429131'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_all_contact_list_members"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_all_contact_list_members/2026-04-17/1776429131
id: 906681
processed: 1

raw_data:

{
    "contact_id": 477051,
    "list_id": 138
}

schema_attributes:

{
    "contact_id": "string",
    "list_id": "string"
}

schema_name_id: 1514
schema_scan_id: 6415299
updated: 2026-04-17 07:33:11

Version 906463

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_all_contact_list_members`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_all_contact_list_members`\n(\n`list_id`STRING,`contact_id`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_all_contact_list_members/2026-04-16/1776343293'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_all_contact_list_members"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_all_contact_list_members/2026-04-16/1776343293
id: 906463
processed: 1

raw_data:

{
    "contact_id": 477051,
    "list_id": 138
}

schema_attributes:

{
    "contact_id": "string",
    "list_id": "string"
}

schema_name_id: 1514
schema_scan_id: 6414751
updated: 2026-04-16 07:42:35

Version 906250

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_all_contact_list_members`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_all_contact_list_members`\n(\n`list_id`STRING,`contact_id`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_all_contact_list_members/2026-04-15/1776256352'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_all_contact_list_members"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_all_contact_list_members/2026-04-15/1776256352
id: 906250
processed: 1

raw_data:

{
    "contact_id": 477051,
    "list_id": 138
}

schema_attributes:

{
    "contact_id": "string",
    "list_id": "string"
}

schema_name_id: 1514
schema_scan_id: 6414262
updated: 2026-04-15 07:33:32

Version 906037

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_all_contact_list_members`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_all_contact_list_members`\n(\n`list_id`STRING,`contact_id`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_all_contact_list_members/2026-04-14/1776169794'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_all_contact_list_members"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_all_contact_list_members/2026-04-14/1776169794
id: 906037
processed: 1

raw_data:

{
    "contact_id": 477051,
    "list_id": 138
}

schema_attributes:

{
    "contact_id": "string",
    "list_id": "string"
}

schema_name_id: 1514
schema_scan_id: 6413770
updated: 2026-04-14 07:31:01

Version 905821

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_all_contact_list_members`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_all_contact_list_members`\n(\n`list_id`STRING,`contact_id`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_all_contact_list_members/2026-04-13/1776083336'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_all_contact_list_members"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_all_contact_list_members/2026-04-13/1776083336
id: 905821
processed: 1

raw_data:

{
    "contact_id": 477051,
    "list_id": 138
}

schema_attributes:

{
    "contact_id": "string",
    "list_id": "string"
}

schema_name_id: 1514
schema_scan_id: 6413216
updated: 2026-04-13 07:29:48

Version 905617

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_all_contact_list_members`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_all_contact_list_members`\n(\n`list_id`STRING,`contact_id`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_all_contact_list_members/2026-04-12/1775997465'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_all_contact_list_members"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_all_contact_list_members/2026-04-12/1775997465
id: 905617
processed: 1

raw_data:

{
    "contact_id": 477051,
    "list_id": 138
}

schema_attributes:

{
    "contact_id": "string",
    "list_id": "string"
}

schema_name_id: 1514
schema_scan_id: 6412801
updated: 2026-04-12 07:38:55

Version 905415

created: 2026-04-11 07:26:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_all_contact_list_members`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_all_contact_list_members`\n(\n`list_id`STRING,`contact_id`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_all_contact_list_members/2026-04-11/1775910315'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_all_contact_list_members"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_all_contact_list_members/2026-04-11/1775910315
id: 905415
processed: 1

raw_data:

{
    "contact_id": 477051,
    "list_id": 138
}

schema_attributes:

{
    "contact_id": "string",
    "list_id": "string"
}

schema_name_id: 1514
schema_scan_id: 6412421
updated: 2026-04-11 07:26:46

Version 905203

created: 2026-04-10 07:40:30

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_all_contact_list_members`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_all_contact_list_members`\n(\n`list_id`STRING,`contact_id`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_all_contact_list_members/2026-04-10/1775824780'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_all_contact_list_members"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_all_contact_list_members/2026-04-10/1775824780
id: 905203
processed: 1

raw_data:

{
    "contact_id": 477051,
    "list_id": 138
}

schema_attributes:

{
    "contact_id": "string",
    "list_id": "string"
}

schema_name_id: 1514
schema_scan_id: 6411951
updated: 2026-04-10 07:40:44

Version 904989

created: 2026-04-09 07:38:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_all_contact_list_members`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_all_contact_list_members`\n(\n`list_id`STRING,`contact_id`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_all_contact_list_members/2026-04-09/1775738273'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_all_contact_list_members"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_all_contact_list_members/2026-04-09/1775738273
id: 904989
processed: 1

raw_data:

{
    "contact_id": 477051,
    "list_id": 138
}

schema_attributes:

{
    "contact_id": "string",
    "list_id": "string"
}

schema_name_id: 1514
schema_scan_id: 6411437
updated: 2026-04-09 07:38:54

Version 904775

created: 2026-04-08 07:38:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_all_contact_list_members`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_all_contact_list_members`\n(\n`list_id`STRING,`contact_id`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_all_contact_list_members/2026-04-08/1775651889'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_all_contact_list_members"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_all_contact_list_members/2026-04-08/1775651889
id: 904775
processed: 1

raw_data:

{
    "contact_id": 477051,
    "list_id": 138
}

schema_attributes:

{
    "contact_id": "string",
    "list_id": "string"
}

schema_name_id: 1514
schema_scan_id: 6410934
updated: 2026-04-08 07:39:11

Version 904561

created: 2026-04-07 07:33:10

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_all_contact_list_members`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_all_contact_list_members`\n(\n`list_id`STRING,`contact_id`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_all_contact_list_members/2026-04-07/1775565137'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_all_contact_list_members"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_all_contact_list_members/2026-04-07/1775565137
id: 904561
processed: 1

raw_data:

{
    "contact_id": 477051,
    "list_id": 138
}

schema_attributes:

{
    "contact_id": "string",
    "list_id": "string"
}

schema_name_id: 1514
schema_scan_id: 6410424
updated: 2026-04-07 07:33:21

Version 904347

created: 2026-04-06 07:30:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_all_contact_list_members`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_all_contact_list_members`\n(\n`list_id`STRING,`contact_id`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_all_contact_list_members/2026-04-06/1775478557'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_all_contact_list_members"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_all_contact_list_members/2026-04-06/1775478557
id: 904347
processed: 1

raw_data:

{
    "contact_id": 477051,
    "list_id": 138
}

schema_attributes:

{
    "contact_id": "string",
    "list_id": "string"
}

schema_name_id: 1514
schema_scan_id: 6409880
updated: 2026-04-06 07:30:16

Version 904143

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_all_contact_list_members`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_all_contact_list_members`\n(\n`list_id`STRING,`contact_id`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_all_contact_list_members/2026-04-05/1775392475'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_all_contact_list_members"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_all_contact_list_members/2026-04-05/1775392475
id: 904143
processed: 1

raw_data:

{
    "contact_id": 477051,
    "list_id": 138
}

schema_attributes:

{
    "contact_id": "string",
    "list_id": "string"
}

schema_name_id: 1514
schema_scan_id: 6409471
updated: 2026-04-05 07:35:31

Version 903941

created: 2026-04-04 07:28:01

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_all_contact_list_members`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_all_contact_list_members`\n(\n`list_id`STRING,`contact_id`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_all_contact_list_members/2026-04-04/1775305640'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_all_contact_list_members"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_all_contact_list_members/2026-04-04/1775305640
id: 903941
processed: 1

raw_data:

{
    "contact_id": 477051,
    "list_id": 138
}

schema_attributes:

{
    "contact_id": "string",
    "list_id": "string"
}

schema_name_id: 1514
schema_scan_id: 6409091
updated: 2026-04-04 07:28:15

Version 903729

created: 2026-04-03 07:38:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_all_contact_list_members`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_all_contact_list_members`\n(\n`list_id`STRING,`contact_id`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_all_contact_list_members/2026-04-03/1775219874'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_all_contact_list_members"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_all_contact_list_members/2026-04-03/1775219874
id: 903729
processed: 1

raw_data:

{
    "contact_id": 477051,
    "list_id": 138
}

schema_attributes:

{
    "contact_id": "string",
    "list_id": "string"
}

schema_name_id: 1514
schema_scan_id: 6408620
updated: 2026-04-03 07:38:56

Schema Scans: 15

Last at 2026-04-17 07:32:25

Scan 6415299

duration: 0:00:45.996617

exit_message:

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

id: 6415299

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_all_contact_list_members/2026-04-17/1776429131",
        "key": "raw/hubspot_molo_all_contact_list_members/2026-04-17/1776429131/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_all_contact_list_members",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 14356596479518872832,
        "service_name": "drive-thru",
        "span_id": 15219836638456334640,
        "trace_id": 4560840446928167142
    }
}

running: False
schema_name_id: 1514
start_time: 2026-04-17 07:32:25
success: True
trace_id: 4560840446928167142

Scan 6414751

duration: 0:00:46.925429

exit_message:

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

id: 6414751

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_all_contact_list_members/2026-04-16/1776343293",
        "key": "raw/hubspot_molo_all_contact_list_members/2026-04-16/1776343293/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_all_contact_list_members",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 2444701237427325446,
        "service_name": "drive-thru",
        "span_id": 13737677009561157586,
        "trace_id": 6328725570185065549
    }
}

running: False
schema_name_id: 1514
start_time: 2026-04-16 07:41:48
success: True
trace_id: 6328725570185065549

Scan 6414262

duration: 0:00:45.145187

exit_message:

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

id: 6414262

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_all_contact_list_members/2026-04-15/1776256352",
        "key": "raw/hubspot_molo_all_contact_list_members/2026-04-15/1776256352/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_all_contact_list_members",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 5693695662801537819,
        "service_name": "drive-thru",
        "span_id": 12688455471106472767,
        "trace_id": 7271252212903479558
    }
}

running: False
schema_name_id: 1514
start_time: 2026-04-15 07:32:46
success: True
trace_id: 7271252212903479558

Scan 6413770

duration: 0:00:48.460297

exit_message:

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

id: 6413770

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_all_contact_list_members/2026-04-14/1776169794",
        "key": "raw/hubspot_molo_all_contact_list_members/2026-04-14/1776169794/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_all_contact_list_members",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 7788188082560018412,
        "service_name": "drive-thru",
        "span_id": 17726583612529300138,
        "trace_id": 12559244376331075431
    }
}

running: False
schema_name_id: 1514
start_time: 2026-04-14 07:30:13
success: True
trace_id: 12559244376331075431

Scan 6413216

duration: 0:00:44.719050

exit_message:

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

id: 6413216

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_all_contact_list_members/2026-04-13/1776083336",
        "key": "raw/hubspot_molo_all_contact_list_members/2026-04-13/1776083336/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_all_contact_list_members",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 5670903082608937068,
        "service_name": "drive-thru",
        "span_id": 15451657240925430585,
        "trace_id": 543978879520602198
    }
}

running: False
schema_name_id: 1514
start_time: 2026-04-13 07:29:04
success: True
trace_id: 543978879520602198

Scan 6412801

duration: 0:00:48.080182

exit_message:

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

id: 6412801

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_all_contact_list_members/2026-04-12/1775997465",
        "key": "raw/hubspot_molo_all_contact_list_members/2026-04-12/1775997465/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_all_contact_list_members",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 17088690437716447959,
        "service_name": "drive-thru",
        "span_id": 13251846999719683443,
        "trace_id": 12356226096717230437
    }
}

running: False
schema_name_id: 1514
start_time: 2026-04-12 07:38:07
success: True
trace_id: 12356226096717230437

Scan 6412421

duration: 0:01:14.645631

exit_message:

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

id: 6412421

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_all_contact_list_members/2026-04-11/1775910315",
        "key": "raw/hubspot_molo_all_contact_list_members/2026-04-11/1775910315/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_all_contact_list_members",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 17853290653715974553,
        "service_name": "drive-thru",
        "span_id": 11378930566072899283,
        "trace_id": 6418833105753235983
    }
}

running: False
schema_name_id: 1514
start_time: 2026-04-11 07:25:31
success: True
trace_id: 6418833105753235983

Scan 6411951

duration: 0:00:48.519895

exit_message:

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

id: 6411951

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_all_contact_list_members/2026-04-10/1775824780",
        "key": "raw/hubspot_molo_all_contact_list_members/2026-04-10/1775824780/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_all_contact_list_members",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 13047346989772620035,
        "service_name": "drive-thru",
        "span_id": 3025281567356999608,
        "trace_id": 8153551241459489030
    }
}

running: False
schema_name_id: 1514
start_time: 2026-04-10 07:39:56
success: True
trace_id: 8153551241459489030

Scan 6411437

duration: 0:00:48.372755

exit_message:

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

id: 6411437

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_all_contact_list_members/2026-04-09/1775738273",
        "key": "raw/hubspot_molo_all_contact_list_members/2026-04-09/1775738273/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_all_contact_list_members",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 10471538654367182760,
        "service_name": "drive-thru",
        "span_id": 3325909810716390387,
        "trace_id": 9062851497033925670
    }
}

running: False
schema_name_id: 1514
start_time: 2026-04-09 07:38:05
success: True
trace_id: 9062851497033925670

Scan 6410934

duration: 0:00:47.448999

exit_message:

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

id: 6410934

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_all_contact_list_members/2026-04-08/1775651889",
        "key": "raw/hubspot_molo_all_contact_list_members/2026-04-08/1775651889/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_all_contact_list_members",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 15035552003347110677,
        "service_name": "drive-thru",
        "span_id": 5709942605695874233,
        "trace_id": 1236792918587365593
    }
}

running: False
schema_name_id: 1514
start_time: 2026-04-08 07:38:24
success: True
trace_id: 1236792918587365593

Scan 6410424

duration: 0:00:44.056647

exit_message:

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

id: 6410424

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_all_contact_list_members/2026-04-07/1775565137",
        "key": "raw/hubspot_molo_all_contact_list_members/2026-04-07/1775565137/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_all_contact_list_members",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 17918154487787555815,
        "service_name": "drive-thru",
        "span_id": 3311317538159469477,
        "trace_id": 11267510359887779052
    }
}

running: False
schema_name_id: 1514
start_time: 2026-04-07 07:32:37
success: True
trace_id: 11267510359887779052

Scan 6409880

duration: 0:00:49.678593

exit_message:

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

id: 6409880

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_all_contact_list_members/2026-04-06/1775478557",
        "key": "raw/hubspot_molo_all_contact_list_members/2026-04-06/1775478557/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_all_contact_list_members",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 2856450785079461227,
        "service_name": "drive-thru",
        "span_id": 11551849189519877565,
        "trace_id": 8221349109831693824
    }
}

running: False
schema_name_id: 1514
start_time: 2026-04-06 07:29:27
success: True
trace_id: 8221349109831693824

Scan 6409471

duration: 0:00:45.627339

exit_message:

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

id: 6409471

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_all_contact_list_members/2026-04-05/1775392475",
        "key": "raw/hubspot_molo_all_contact_list_members/2026-04-05/1775392475/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_all_contact_list_members",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 6126961827917642829,
        "service_name": "drive-thru",
        "span_id": 4180938272246069988,
        "trace_id": 17298875896141771160
    }
}

running: False
schema_name_id: 1514
start_time: 2026-04-05 07:34:46
success: True
trace_id: 17298875896141771160

Scan 6409091

duration: 0:00:46.294656

exit_message:

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

id: 6409091

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_all_contact_list_members/2026-04-04/1775305640",
        "key": "raw/hubspot_molo_all_contact_list_members/2026-04-04/1775305640/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_all_contact_list_members",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 11431424989651566259,
        "service_name": "drive-thru",
        "span_id": 7747639981279854724,
        "trace_id": 5765988977168501460
    }
}

running: False
schema_name_id: 1514
start_time: 2026-04-04 07:27:28
success: True
trace_id: 5765988977168501460

Scan 6408620

duration: 0:00:48.027068

exit_message:

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

id: 6408620

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_all_contact_list_members/2026-04-03/1775219874",
        "key": "raw/hubspot_molo_all_contact_list_members/2026-04-03/1775219874/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_all_contact_list_members",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 15841441634073741698,
        "service_name": "drive-thru",
        "span_id": 13755296290197140461,
        "trace_id": 4511661268228837655
    }
}

running: False
schema_name_id: 1514
start_time: 2026-04-03 07:38:08
success: True
trace_id: 4511661268228837655

Partitions:

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

Schema:

attributes:

{
    "contact_id": "string",
    "list_id": "string"
}

created: 2026-04-17 07:32:57

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_all_contact_list_members`\n(\n`list_id`STRING,`contact_id`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_all_contact_list_members/2026-04-17/1776429131'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_all_contact_list_members`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_all_contact_list_members"
}

Server:

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

Raw:

{
    "name": {
        "created": "2022-11-30 13:43:52",
        "disabled": false,
        "format": "raw",
        "id": 1514,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_stage_drivethru",
            "table": "hubspot_molo_all_contact_list_members"
        },
        "type": "drivethrujson"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "contact_id": "string",
            "list_id": "string"
        },
        "created": "2026-04-17 07:32:57",
        "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_all_contact_list_members`\n(\n`list_id`STRING,`contact_id`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_all_contact_list_members/2026-04-17/1776429131'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_all_contact_list_members`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_all_contact_list_members"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}