Schema Info

Schema Name: sfdl_stage_drivethru.hubspot_molo_contact_lists
  • created: 2022-11-30 13:43:05
  • disabled: False
  • format: raw
  • id: 1513
  • is_partitioned: False
  • is_schema_datatyped: False
  • name: 
    {
    "database": "sfdl_stage_drivethru",
    "table": "hubspot_molo_contact_lists"
}
  • type: drivethrujson
Schema Versions: 15
    • created: 2026-04-17 07:19:04
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_contact_lists`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_contact_lists`\n(\n`portalId`STRING,`listId`STRING,`createdAt`STRING,`updatedAt`STRING,`name`STRING,`listType`STRING,`authorId`STRING,`filters`array,`metaData`struct<`size`:STRING,`lastSizeChangeAt`:STRING,`processing`:STRING,`lastProcessingStateChangeAt`:STRING,`error`:STRING,`listReferencesCount`:STRING,`parentFolderId`:STRING>,`archived`STRING,`teamIds`array,`ilsFilterBranch`STRING,`dynamic`STRING,`internal`STRING,`readOnly`STRING,`limitExempt`STRING,`parentId`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_contact_lists/2026-04-17/1776428301'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_contact_lists"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_contact_lists/2026-04-17/1776428301
    • id: 906675
    • processed: 1
    • raw_data: 
      {
    "archived": false,
    "authorId": 68170421,
    "createdAt": 1762804209067,
    "dynamic": true,
    "filters": [],
    "ilsFilterBranch": "{\"filterBranchOperator\":\"OR\",\"filters\":[],\"filterBranches\":[{\"filterBranchOperator\":\"AND\",\"filters\":[{\"frameworkFilterId\":null,\"filterInsightsId\":null,\"operator\":\"IN_LIST\",\"listId\":504,\"coalescingRefineBy\":{\"setType\":\"ANY\",\"type\":\"SetOccurrencesRefineBy\"},\"associationTypeId\":1,\"associationCategory\":\"HUBSPOT_DEFINED\",\"toObjectTypeId\":\"0-2\",\"toObjectType\":\"COMPANY\",\"filterType\":\"ASSOCIATION\"},{\"filterType\":\"PROPERTY\",\"property\":\"email\",\"operation\":{\"propertyType\":\"alltypes\",\"operator\":\"IS_KNOWN\",\"defaultValue\":null,\"includeObjectsWithNoValueSet\":false,\"pruningRefineBy\":null,\"coalescingRefineBy\":{\"setType\":\"ANY\",\"type\":\"SetOccurrencesRefineBy\"},\"operatorName\":\"IS_KNOWN\",\"operationType\":\"alltypes\"},\"frameworkFilterId\":null,\"filterInsightsId\":null,\"context\":null}],\"filterBranches\":[],\"filterInsightsId\":null,\"filterBranchType\":\"AND\"}],\"filterInsightsId\":null,\"filterBranchType\":\"OR\"}",
    "internal": false,
    "limitExempt": false,
    "listId": 1079,
    "listType": "DYNAMIC",
    "metaData": {
        "error": "",
        "lastProcessingStateChangeAt": 1627911678541,
        "lastSizeChangeAt": 1776121163056,
        "listReferencesCount": null,
        "parentFolderId": null,
        "processing": "DONE",
        "size": 217
    },
    "name": "All Marketing Contacts - Prospects",
    "parentId": 226604176,
    "portalId": 2753955,
    "readOnly": false,
    "teamIds": [],
    "updatedAt": 1765316665325
}
    • schema_attributes: 
      {
    "archived": "string",
    "authorId": "string",
    "createdAt": "string",
    "dynamic": "string",
    "filters": [
        "string"
    ],
    "ilsFilterBranch": "string",
    "internal": "string",
    "limitExempt": "string",
    "listId": "string",
    "listType": "string",
    "metaData.error": "string",
    "metaData.lastProcessingStateChangeAt": "string",
    "metaData.lastSizeChangeAt": "string",
    "metaData.listReferencesCount": "string",
    "metaData.parentFolderId": "string",
    "metaData.processing": "string",
    "metaData.size": "string",
    "name": "string",
    "parentId": "string",
    "portalId": "string",
    "readOnly": "string",
    "teamIds": [
        "string"
    ],
    "updatedAt": "string"
}
    • schema_name_id: 1513
    • schema_scan_id: 6415293
    • updated: 2026-04-17 07:19:15
    • created: 2026-04-16 07:13:44
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_contact_lists`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_contact_lists`\n(\n`portalId`STRING,`listId`STRING,`createdAt`STRING,`updatedAt`STRING,`name`STRING,`listType`STRING,`authorId`STRING,`filters`array,`metaData`struct<`size`:STRING,`lastSizeChangeAt`:STRING,`processing`:STRING,`lastProcessingStateChangeAt`:STRING,`error`:STRING,`listReferencesCount`:STRING,`parentFolderId`:STRING>,`archived`STRING,`teamIds`array,`ilsFilterBranch`STRING,`dynamic`STRING,`internal`STRING,`readOnly`STRING,`limitExempt`STRING,`parentId`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_contact_lists/2026-04-16/1776341599'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_contact_lists"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_contact_lists/2026-04-16/1776341599
    • id: 906450
    • processed: 1
    • raw_data: 
      {
    "archived": false,
    "authorId": 68170421,
    "createdAt": 1762804209067,
    "dynamic": true,
    "filters": [],
    "ilsFilterBranch": "{\"filterBranchOperator\":\"OR\",\"filters\":[],\"filterBranches\":[{\"filterBranchOperator\":\"AND\",\"filters\":[{\"frameworkFilterId\":null,\"filterInsightsId\":null,\"operator\":\"IN_LIST\",\"listId\":504,\"coalescingRefineBy\":{\"setType\":\"ANY\",\"type\":\"SetOccurrencesRefineBy\"},\"associationTypeId\":1,\"associationCategory\":\"HUBSPOT_DEFINED\",\"filterType\":\"ASSOCIATION\",\"toObjectTypeId\":\"0-2\",\"toObjectType\":\"COMPANY\"},{\"filterType\":\"PROPERTY\",\"property\":\"email\",\"operation\":{\"propertyType\":\"alltypes\",\"operator\":\"IS_KNOWN\",\"defaultValue\":null,\"includeObjectsWithNoValueSet\":false,\"pruningRefineBy\":null,\"coalescingRefineBy\":{\"setType\":\"ANY\",\"type\":\"SetOccurrencesRefineBy\"},\"operatorName\":\"IS_KNOWN\",\"operationType\":\"alltypes\"},\"frameworkFilterId\":null,\"filterInsightsId\":null,\"context\":null}],\"filterBranches\":[],\"filterInsightsId\":null,\"filterBranchType\":\"AND\"}],\"filterInsightsId\":null,\"filterBranchType\":\"OR\"}",
    "internal": false,
    "limitExempt": false,
    "listId": 1079,
    "listType": "DYNAMIC",
    "metaData": {
        "error": "",
        "lastProcessingStateChangeAt": 1627911678541,
        "lastSizeChangeAt": 1776121163056,
        "listReferencesCount": null,
        "parentFolderId": null,
        "processing": "DONE",
        "size": 217
    },
    "name": "All Marketing Contacts - Prospects",
    "parentId": 226604176,
    "portalId": 2753955,
    "readOnly": false,
    "teamIds": [],
    "updatedAt": 1765316665325
}
    • schema_attributes: 
      {
    "archived": "string",
    "authorId": "string",
    "createdAt": "string",
    "dynamic": "string",
    "filters": [
        "string"
    ],
    "ilsFilterBranch": "string",
    "internal": "string",
    "limitExempt": "string",
    "listId": "string",
    "listType": "string",
    "metaData.error": "string",
    "metaData.lastProcessingStateChangeAt": "string",
    "metaData.lastSizeChangeAt": "string",
    "metaData.listReferencesCount": "string",
    "metaData.parentFolderId": "string",
    "metaData.processing": "string",
    "metaData.size": "string",
    "name": "string",
    "parentId": "string",
    "portalId": "string",
    "readOnly": "string",
    "teamIds": [
        "string"
    ],
    "updatedAt": "string"
}
    • schema_name_id: 1513
    • schema_scan_id: 6414735
    • updated: 2026-04-16 07:13:55
    • created: 2026-04-15 07:20:31
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_contact_lists`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_contact_lists`\n(\n`portalId`STRING,`listId`STRING,`createdAt`STRING,`updatedAt`STRING,`name`STRING,`listType`STRING,`authorId`STRING,`filters`array,`metaData`struct<`size`:STRING,`lastSizeChangeAt`:STRING,`processing`:STRING,`lastProcessingStateChangeAt`:STRING,`error`:STRING,`listReferencesCount`:STRING,`parentFolderId`:STRING>,`archived`STRING,`teamIds`array,`ilsFilterBranch`STRING,`dynamic`STRING,`internal`STRING,`readOnly`STRING,`limitExempt`STRING,`parentId`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_contact_lists/2026-04-15/1776255594'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_contact_lists"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_contact_lists/2026-04-15/1776255594
    • id: 906247
    • processed: 1
    • raw_data: 
      {
    "archived": false,
    "authorId": 68170421,
    "createdAt": 1762804209067,
    "dynamic": true,
    "filters": [],
    "ilsFilterBranch": "{\"filterBranchOperator\":\"OR\",\"filters\":[],\"filterBranches\":[{\"filterBranchOperator\":\"AND\",\"filters\":[{\"frameworkFilterId\":null,\"filterInsightsId\":null,\"operator\":\"IN_LIST\",\"listId\":504,\"coalescingRefineBy\":{\"setType\":\"ANY\",\"type\":\"SetOccurrencesRefineBy\"},\"associationTypeId\":1,\"associationCategory\":\"HUBSPOT_DEFINED\",\"toObjectTypeId\":\"0-2\",\"toObjectType\":\"COMPANY\",\"filterType\":\"ASSOCIATION\"},{\"filterType\":\"PROPERTY\",\"property\":\"email\",\"operation\":{\"propertyType\":\"alltypes\",\"operator\":\"IS_KNOWN\",\"defaultValue\":null,\"includeObjectsWithNoValueSet\":false,\"pruningRefineBy\":null,\"coalescingRefineBy\":{\"setType\":\"ANY\",\"type\":\"SetOccurrencesRefineBy\"},\"operationType\":\"alltypes\",\"operatorName\":\"IS_KNOWN\"},\"frameworkFilterId\":null,\"filterInsightsId\":null,\"context\":null}],\"filterBranches\":[],\"filterInsightsId\":null,\"filterBranchType\":\"AND\"}],\"filterInsightsId\":null,\"filterBranchType\":\"OR\"}",
    "internal": false,
    "limitExempt": false,
    "listId": 1079,
    "listType": "DYNAMIC",
    "metaData": {
        "error": "",
        "lastProcessingStateChangeAt": 1627911678541,
        "lastSizeChangeAt": 1776121163056,
        "listReferencesCount": null,
        "parentFolderId": null,
        "processing": "DONE",
        "size": 217
    },
    "name": "All Marketing Contacts - Prospects",
    "parentId": 226604176,
    "portalId": 2753955,
    "readOnly": false,
    "teamIds": [],
    "updatedAt": 1765316665325
}
    • schema_attributes: 
      {
    "archived": "string",
    "authorId": "string",
    "createdAt": "string",
    "dynamic": "string",
    "filters": [
        "string"
    ],
    "ilsFilterBranch": "string",
    "internal": "string",
    "limitExempt": "string",
    "listId": "string",
    "listType": "string",
    "metaData.error": "string",
    "metaData.lastProcessingStateChangeAt": "string",
    "metaData.lastSizeChangeAt": "string",
    "metaData.listReferencesCount": "string",
    "metaData.parentFolderId": "string",
    "metaData.processing": "string",
    "metaData.size": "string",
    "name": "string",
    "parentId": "string",
    "portalId": "string",
    "readOnly": "string",
    "teamIds": [
        "string"
    ],
    "updatedAt": "string"
}
    • schema_name_id: 1513
    • schema_scan_id: 6414258
    • updated: 2026-04-15 07:20:42
    • created: 2026-04-14 07:15:59
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_contact_lists`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_contact_lists`\n(\n`portalId`STRING,`listId`STRING,`createdAt`STRING,`updatedAt`STRING,`name`STRING,`listType`STRING,`authorId`STRING,`filters`array,`metaData`struct<`size`:STRING,`lastSizeChangeAt`:STRING,`processing`:STRING,`lastProcessingStateChangeAt`:STRING,`error`:STRING,`listReferencesCount`:STRING,`parentFolderId`:STRING>,`archived`STRING,`teamIds`array,`ilsFilterBranch`STRING,`dynamic`STRING,`internal`STRING,`readOnly`STRING,`limitExempt`STRING,`parentId`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_contact_lists/2026-04-14/1776168945'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_contact_lists"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_contact_lists/2026-04-14/1776168945
    • id: 906025
    • processed: 1
    • raw_data: 
      {
    "archived": false,
    "authorId": 68170421,
    "createdAt": 1762804209067,
    "dynamic": true,
    "filters": [],
    "ilsFilterBranch": "{\"filterBranchOperator\":\"OR\",\"filters\":[],\"filterBranches\":[{\"filterBranchOperator\":\"AND\",\"filters\":[{\"frameworkFilterId\":null,\"filterInsightsId\":null,\"operator\":\"IN_LIST\",\"listId\":504,\"coalescingRefineBy\":{\"setType\":\"ANY\",\"type\":\"SetOccurrencesRefineBy\"},\"associationTypeId\":1,\"associationCategory\":\"HUBSPOT_DEFINED\",\"toObjectType\":\"COMPANY\",\"toObjectTypeId\":\"0-2\",\"filterType\":\"ASSOCIATION\"},{\"filterType\":\"PROPERTY\",\"property\":\"email\",\"operation\":{\"propertyType\":\"alltypes\",\"operator\":\"IS_KNOWN\",\"defaultValue\":null,\"includeObjectsWithNoValueSet\":false,\"pruningRefineBy\":null,\"coalescingRefineBy\":{\"setType\":\"ANY\",\"type\":\"SetOccurrencesRefineBy\"},\"operatorName\":\"IS_KNOWN\",\"operationType\":\"alltypes\"},\"frameworkFilterId\":null,\"filterInsightsId\":null,\"context\":null}],\"filterBranches\":[],\"filterInsightsId\":null,\"filterBranchType\":\"AND\"}],\"filterInsightsId\":null,\"filterBranchType\":\"OR\"}",
    "internal": false,
    "limitExempt": false,
    "listId": 1079,
    "listType": "DYNAMIC",
    "metaData": {
        "error": "",
        "lastProcessingStateChangeAt": 1627911678541,
        "lastSizeChangeAt": 1776121163056,
        "listReferencesCount": null,
        "parentFolderId": null,
        "processing": "DONE",
        "size": 217
    },
    "name": "All Marketing Contacts - Prospects",
    "parentId": 226604176,
    "portalId": 2753955,
    "readOnly": false,
    "teamIds": [],
    "updatedAt": 1765316665325
}
    • schema_attributes: 
      {
    "archived": "string",
    "authorId": "string",
    "createdAt": "string",
    "dynamic": "string",
    "filters": [
        "string"
    ],
    "ilsFilterBranch": "string",
    "internal": "string",
    "limitExempt": "string",
    "listId": "string",
    "listType": "string",
    "metaData.error": "string",
    "metaData.lastProcessingStateChangeAt": "string",
    "metaData.lastSizeChangeAt": "string",
    "metaData.listReferencesCount": "string",
    "metaData.parentFolderId": "string",
    "metaData.processing": "string",
    "metaData.size": "string",
    "name": "string",
    "parentId": "string",
    "portalId": "string",
    "readOnly": "string",
    "teamIds": [
        "string"
    ],
    "updatedAt": "string"
}
    • schema_name_id: 1513
    • schema_scan_id: 6413756
    • updated: 2026-04-14 07:16:10
    • created: 2026-04-13 07:19:37
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_contact_lists`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_contact_lists`\n(\n`portalId`STRING,`listId`STRING,`createdAt`STRING,`updatedAt`STRING,`name`STRING,`listType`STRING,`authorId`STRING,`filters`array,`metaData`struct<`size`:STRING,`lastSizeChangeAt`:STRING,`processing`:STRING,`lastProcessingStateChangeAt`:STRING,`error`:STRING,`listReferencesCount`:STRING,`parentFolderId`:STRING>,`archived`STRING,`teamIds`array,`ilsFilterBranch`STRING,`dynamic`STRING,`internal`STRING,`readOnly`STRING,`limitExempt`STRING,`parentId`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_contact_lists/2026-04-13/1776082712'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_contact_lists"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_contact_lists/2026-04-13/1776082712
    • id: 905817
    • processed: 1
    • raw_data: 
      {
    "archived": false,
    "authorId": 68170421,
    "createdAt": 1762804209067,
    "dynamic": true,
    "filters": [],
    "ilsFilterBranch": "{\"filterBranchOperator\":\"OR\",\"filters\":[],\"filterBranches\":[{\"filterBranchOperator\":\"AND\",\"filters\":[{\"frameworkFilterId\":null,\"filterInsightsId\":null,\"operator\":\"IN_LIST\",\"listId\":504,\"coalescingRefineBy\":{\"setType\":\"ANY\",\"type\":\"SetOccurrencesRefineBy\"},\"associationTypeId\":1,\"associationCategory\":\"HUBSPOT_DEFINED\",\"filterType\":\"ASSOCIATION\",\"toObjectTypeId\":\"0-2\",\"toObjectType\":\"COMPANY\"},{\"filterType\":\"PROPERTY\",\"property\":\"email\",\"operation\":{\"propertyType\":\"alltypes\",\"operator\":\"IS_KNOWN\",\"defaultValue\":null,\"includeObjectsWithNoValueSet\":false,\"pruningRefineBy\":null,\"coalescingRefineBy\":{\"setType\":\"ANY\",\"type\":\"SetOccurrencesRefineBy\"},\"operatorName\":\"IS_KNOWN\",\"operationType\":\"alltypes\"},\"frameworkFilterId\":null,\"filterInsightsId\":null,\"context\":null}],\"filterBranches\":[],\"filterInsightsId\":null,\"filterBranchType\":\"AND\"}],\"filterInsightsId\":null,\"filterBranchType\":\"OR\"}",
    "internal": false,
    "limitExempt": false,
    "listId": 1079,
    "listType": "DYNAMIC",
    "metaData": {
        "error": "",
        "lastProcessingStateChangeAt": 1627911678541,
        "lastSizeChangeAt": 1773957016632,
        "listReferencesCount": null,
        "parentFolderId": null,
        "processing": "DONE",
        "size": 216
    },
    "name": "All Marketing Contacts - Prospects",
    "parentId": 226604176,
    "portalId": 2753955,
    "readOnly": false,
    "teamIds": [],
    "updatedAt": 1765316665325
}
    • schema_attributes: 
      {
    "archived": "string",
    "authorId": "string",
    "createdAt": "string",
    "dynamic": "string",
    "filters": [
        "string"
    ],
    "ilsFilterBranch": "string",
    "internal": "string",
    "limitExempt": "string",
    "listId": "string",
    "listType": "string",
    "metaData.error": "string",
    "metaData.lastProcessingStateChangeAt": "string",
    "metaData.lastSizeChangeAt": "string",
    "metaData.listReferencesCount": "string",
    "metaData.parentFolderId": "string",
    "metaData.processing": "string",
    "metaData.size": "string",
    "name": "string",
    "parentId": "string",
    "portalId": "string",
    "readOnly": "string",
    "teamIds": [
        "string"
    ],
    "updatedAt": "string"
}
    • schema_name_id: 1513
    • schema_scan_id: 6413212
    • updated: 2026-04-13 07:19:48
    • created: 2026-04-12 07:16:06
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_contact_lists`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_contact_lists`\n(\n`portalId`STRING,`listId`STRING,`createdAt`STRING,`updatedAt`STRING,`name`STRING,`listType`STRING,`authorId`STRING,`filters`array,`metaData`struct<`size`:STRING,`lastSizeChangeAt`:STRING,`processing`:STRING,`lastProcessingStateChangeAt`:STRING,`error`:STRING,`listReferencesCount`:STRING,`parentFolderId`:STRING>,`archived`STRING,`teamIds`array,`ilsFilterBranch`STRING,`dynamic`STRING,`internal`STRING,`readOnly`STRING,`limitExempt`STRING,`parentId`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_contact_lists/2026-04-12/1775996135'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_contact_lists"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_contact_lists/2026-04-12/1775996135
    • id: 905610
    • processed: 1
    • raw_data: 
      {
    "archived": false,
    "authorId": 68170421,
    "createdAt": 1762804209067,
    "dynamic": true,
    "filters": [],
    "ilsFilterBranch": "{\"filterBranchOperator\":\"OR\",\"filters\":[],\"filterBranches\":[{\"filterBranchOperator\":\"AND\",\"filters\":[{\"frameworkFilterId\":null,\"filterInsightsId\":null,\"operator\":\"IN_LIST\",\"listId\":504,\"coalescingRefineBy\":{\"setType\":\"ANY\",\"type\":\"SetOccurrencesRefineBy\"},\"associationTypeId\":1,\"associationCategory\":\"HUBSPOT_DEFINED\",\"toObjectType\":\"COMPANY\",\"toObjectTypeId\":\"0-2\",\"filterType\":\"ASSOCIATION\"},{\"filterType\":\"PROPERTY\",\"property\":\"email\",\"operation\":{\"propertyType\":\"alltypes\",\"operator\":\"IS_KNOWN\",\"defaultValue\":null,\"includeObjectsWithNoValueSet\":false,\"pruningRefineBy\":null,\"coalescingRefineBy\":{\"setType\":\"ANY\",\"type\":\"SetOccurrencesRefineBy\"},\"operatorName\":\"IS_KNOWN\",\"operationType\":\"alltypes\"},\"frameworkFilterId\":null,\"filterInsightsId\":null,\"context\":null}],\"filterBranches\":[],\"filterInsightsId\":null,\"filterBranchType\":\"AND\"}],\"filterInsightsId\":null,\"filterBranchType\":\"OR\"}",
    "internal": false,
    "limitExempt": false,
    "listId": 1079,
    "listType": "DYNAMIC",
    "metaData": {
        "error": "",
        "lastProcessingStateChangeAt": 1627911678541,
        "lastSizeChangeAt": 1773957016632,
        "listReferencesCount": null,
        "parentFolderId": null,
        "processing": "DONE",
        "size": 216
    },
    "name": "All Marketing Contacts - Prospects",
    "parentId": 226604176,
    "portalId": 2753955,
    "readOnly": false,
    "teamIds": [],
    "updatedAt": 1765316665325
}
    • schema_attributes: 
      {
    "archived": "string",
    "authorId": "string",
    "createdAt": "string",
    "dynamic": "string",
    "filters": [
        "string"
    ],
    "ilsFilterBranch": "string",
    "internal": "string",
    "limitExempt": "string",
    "listId": "string",
    "listType": "string",
    "metaData.error": "string",
    "metaData.lastProcessingStateChangeAt": "string",
    "metaData.lastSizeChangeAt": "string",
    "metaData.listReferencesCount": "string",
    "metaData.parentFolderId": "string",
    "metaData.processing": "string",
    "metaData.size": "string",
    "name": "string",
    "parentId": "string",
    "portalId": "string",
    "readOnly": "string",
    "teamIds": [
        "string"
    ],
    "updatedAt": "string"
}
    • schema_name_id: 1513
    • schema_scan_id: 6412793
    • updated: 2026-04-12 07:16:20
    • created: 2026-04-11 07:14:19
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_contact_lists`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_contact_lists`\n(\n`portalId`STRING,`listId`STRING,`createdAt`STRING,`updatedAt`STRING,`name`STRING,`listType`STRING,`authorId`STRING,`filters`array,`metaData`struct<`size`:STRING,`lastSizeChangeAt`:STRING,`processing`:STRING,`lastProcessingStateChangeAt`:STRING,`error`:STRING,`listReferencesCount`:STRING,`parentFolderId`:STRING>,`archived`STRING,`teamIds`array,`ilsFilterBranch`STRING,`dynamic`STRING,`internal`STRING,`readOnly`STRING,`limitExempt`STRING,`parentId`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_contact_lists/2026-04-11/1775909630'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_contact_lists"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_contact_lists/2026-04-11/1775909630
    • id: 905410
    • processed: 1
    • raw_data: 
      {
    "archived": false,
    "authorId": 68170421,
    "createdAt": 1762804209067,
    "dynamic": true,
    "filters": [],
    "ilsFilterBranch": "{\"filterBranchOperator\":\"OR\",\"filters\":[],\"filterBranches\":[{\"filterBranchOperator\":\"AND\",\"filters\":[{\"frameworkFilterId\":null,\"filterInsightsId\":null,\"operator\":\"IN_LIST\",\"listId\":504,\"coalescingRefineBy\":{\"setType\":\"ANY\",\"type\":\"SetOccurrencesRefineBy\"},\"associationTypeId\":1,\"associationCategory\":\"HUBSPOT_DEFINED\",\"toObjectType\":\"COMPANY\",\"toObjectTypeId\":\"0-2\",\"filterType\":\"ASSOCIATION\"},{\"filterType\":\"PROPERTY\",\"property\":\"email\",\"operation\":{\"propertyType\":\"alltypes\",\"operator\":\"IS_KNOWN\",\"defaultValue\":null,\"includeObjectsWithNoValueSet\":false,\"pruningRefineBy\":null,\"coalescingRefineBy\":{\"setType\":\"ANY\",\"type\":\"SetOccurrencesRefineBy\"},\"operatorName\":\"IS_KNOWN\",\"operationType\":\"alltypes\"},\"frameworkFilterId\":null,\"filterInsightsId\":null,\"context\":null}],\"filterBranches\":[],\"filterInsightsId\":null,\"filterBranchType\":\"AND\"}],\"filterInsightsId\":null,\"filterBranchType\":\"OR\"}",
    "internal": false,
    "limitExempt": false,
    "listId": 1079,
    "listType": "DYNAMIC",
    "metaData": {
        "error": "",
        "lastProcessingStateChangeAt": 1627911678541,
        "lastSizeChangeAt": 1773957016632,
        "listReferencesCount": null,
        "parentFolderId": null,
        "processing": "DONE",
        "size": 216
    },
    "name": "All Marketing Contacts - Prospects",
    "parentId": 226604176,
    "portalId": 2753955,
    "readOnly": false,
    "teamIds": [],
    "updatedAt": 1765316665325
}
    • schema_attributes: 
      {
    "archived": "string",
    "authorId": "string",
    "createdAt": "string",
    "dynamic": "string",
    "filters": [
        "string"
    ],
    "ilsFilterBranch": "string",
    "internal": "string",
    "limitExempt": "string",
    "listId": "string",
    "listType": "string",
    "metaData.error": "string",
    "metaData.lastProcessingStateChangeAt": "string",
    "metaData.lastSizeChangeAt": "string",
    "metaData.listReferencesCount": "string",
    "metaData.parentFolderId": "string",
    "metaData.processing": "string",
    "metaData.size": "string",
    "name": "string",
    "parentId": "string",
    "portalId": "string",
    "readOnly": "string",
    "teamIds": [
        "string"
    ],
    "updatedAt": "string"
}
    • schema_name_id: 1513
    • schema_scan_id: 6412416
    • updated: 2026-04-11 07:14:33
    • created: 2026-04-10 07:12:27
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_contact_lists`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_contact_lists`\n(\n`portalId`STRING,`listId`STRING,`createdAt`STRING,`updatedAt`STRING,`name`STRING,`listType`STRING,`authorId`STRING,`filters`array,`metaData`struct<`size`:STRING,`lastSizeChangeAt`:STRING,`processing`:STRING,`lastProcessingStateChangeAt`:STRING,`error`:STRING,`listReferencesCount`:STRING,`parentFolderId`:STRING>,`archived`STRING,`teamIds`array,`ilsFilterBranch`STRING,`dynamic`STRING,`internal`STRING,`readOnly`STRING,`limitExempt`STRING,`parentId`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_contact_lists/2026-04-10/1775823118'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_contact_lists"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_contact_lists/2026-04-10/1775823118
    • id: 905196
    • processed: 1
    • raw_data: 
      {
    "archived": false,
    "authorId": 68170421,
    "createdAt": 1762804209067,
    "dynamic": true,
    "filters": [],
    "ilsFilterBranch": "{\"filterBranchOperator\":\"OR\",\"filters\":[],\"filterBranches\":[{\"filterBranchOperator\":\"AND\",\"filters\":[{\"frameworkFilterId\":null,\"filterInsightsId\":null,\"operator\":\"IN_LIST\",\"listId\":504,\"coalescingRefineBy\":{\"setType\":\"ANY\",\"type\":\"SetOccurrencesRefineBy\"},\"associationTypeId\":1,\"associationCategory\":\"HUBSPOT_DEFINED\",\"toObjectType\":\"COMPANY\",\"filterType\":\"ASSOCIATION\",\"toObjectTypeId\":\"0-2\"},{\"filterType\":\"PROPERTY\",\"property\":\"email\",\"operation\":{\"propertyType\":\"alltypes\",\"operator\":\"IS_KNOWN\",\"defaultValue\":null,\"includeObjectsWithNoValueSet\":false,\"pruningRefineBy\":null,\"coalescingRefineBy\":{\"setType\":\"ANY\",\"type\":\"SetOccurrencesRefineBy\"},\"operationType\":\"alltypes\",\"operatorName\":\"IS_KNOWN\"},\"frameworkFilterId\":null,\"filterInsightsId\":null,\"context\":null}],\"filterBranches\":[],\"filterInsightsId\":null,\"filterBranchType\":\"AND\"}],\"filterInsightsId\":null,\"filterBranchType\":\"OR\"}",
    "internal": false,
    "limitExempt": false,
    "listId": 1079,
    "listType": "DYNAMIC",
    "metaData": {
        "error": "",
        "lastProcessingStateChangeAt": 1627911678541,
        "lastSizeChangeAt": 1773957016632,
        "listReferencesCount": null,
        "parentFolderId": null,
        "processing": "DONE",
        "size": 216
    },
    "name": "All Marketing Contacts - Prospects",
    "parentId": 226604176,
    "portalId": 2753955,
    "readOnly": false,
    "teamIds": [],
    "updatedAt": 1765316665325
}
    • schema_attributes: 
      {
    "archived": "string",
    "authorId": "string",
    "createdAt": "string",
    "dynamic": "string",
    "filters": [
        "string"
    ],
    "ilsFilterBranch": "string",
    "internal": "string",
    "limitExempt": "string",
    "listId": "string",
    "listType": "string",
    "metaData.error": "string",
    "metaData.lastProcessingStateChangeAt": "string",
    "metaData.lastSizeChangeAt": "string",
    "metaData.listReferencesCount": "string",
    "metaData.parentFolderId": "string",
    "metaData.processing": "string",
    "metaData.size": "string",
    "name": "string",
    "parentId": "string",
    "portalId": "string",
    "readOnly": "string",
    "teamIds": [
        "string"
    ],
    "updatedAt": "string"
}
    • schema_name_id: 1513
    • schema_scan_id: 6411943
    • updated: 2026-04-10 07:12:41
    • created: 2026-04-09 07:12:16
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_contact_lists`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_contact_lists`\n(\n`portalId`STRING,`listId`STRING,`createdAt`STRING,`updatedAt`STRING,`name`STRING,`listType`STRING,`authorId`STRING,`filters`array,`metaData`struct<`size`:STRING,`lastSizeChangeAt`:STRING,`processing`:STRING,`lastProcessingStateChangeAt`:STRING,`error`:STRING,`listReferencesCount`:STRING,`parentFolderId`:STRING>,`archived`STRING,`teamIds`array,`ilsFilterBranch`STRING,`dynamic`STRING,`internal`STRING,`readOnly`STRING,`limitExempt`STRING,`parentId`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_contact_lists/2026-04-09/1775736729'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_contact_lists"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_contact_lists/2026-04-09/1775736729
    • id: 904984
    • processed: 1
    • raw_data: 
      {
    "archived": false,
    "authorId": 68170421,
    "createdAt": 1762804209067,
    "dynamic": true,
    "filters": [],
    "ilsFilterBranch": "{\"filterBranchOperator\":\"OR\",\"filters\":[],\"filterBranches\":[{\"filterBranchOperator\":\"AND\",\"filters\":[{\"frameworkFilterId\":null,\"filterInsightsId\":null,\"operator\":\"IN_LIST\",\"listId\":504,\"coalescingRefineBy\":{\"setType\":\"ANY\",\"type\":\"SetOccurrencesRefineBy\"},\"associationTypeId\":1,\"associationCategory\":\"HUBSPOT_DEFINED\",\"toObjectTypeId\":\"0-2\",\"toObjectType\":\"COMPANY\",\"filterType\":\"ASSOCIATION\"},{\"filterType\":\"PROPERTY\",\"property\":\"email\",\"operation\":{\"propertyType\":\"alltypes\",\"operator\":\"IS_KNOWN\",\"defaultValue\":null,\"includeObjectsWithNoValueSet\":false,\"pruningRefineBy\":null,\"coalescingRefineBy\":{\"setType\":\"ANY\",\"type\":\"SetOccurrencesRefineBy\"},\"operatorName\":\"IS_KNOWN\",\"operationType\":\"alltypes\"},\"frameworkFilterId\":null,\"filterInsightsId\":null,\"context\":null}],\"filterBranches\":[],\"filterInsightsId\":null,\"filterBranchType\":\"AND\"}],\"filterInsightsId\":null,\"filterBranchType\":\"OR\"}",
    "internal": false,
    "limitExempt": false,
    "listId": 1079,
    "listType": "DYNAMIC",
    "metaData": {
        "error": "",
        "lastProcessingStateChangeAt": 1627911678541,
        "lastSizeChangeAt": 1773957016632,
        "listReferencesCount": null,
        "parentFolderId": null,
        "processing": "DONE",
        "size": 216
    },
    "name": "All Marketing Contacts - Prospects",
    "parentId": 226604176,
    "portalId": 2753955,
    "readOnly": false,
    "teamIds": [],
    "updatedAt": 1765316665325
}
    • schema_attributes: 
      {
    "archived": "string",
    "authorId": "string",
    "createdAt": "string",
    "dynamic": "string",
    "filters": [
        "string"
    ],
    "ilsFilterBranch": "string",
    "internal": "string",
    "limitExempt": "string",
    "listId": "string",
    "listType": "string",
    "metaData.error": "string",
    "metaData.lastProcessingStateChangeAt": "string",
    "metaData.lastSizeChangeAt": "string",
    "metaData.listReferencesCount": "string",
    "metaData.parentFolderId": "string",
    "metaData.processing": "string",
    "metaData.size": "string",
    "name": "string",
    "parentId": "string",
    "portalId": "string",
    "readOnly": "string",
    "teamIds": [
        "string"
    ],
    "updatedAt": "string"
}
    • schema_name_id: 1513
    • schema_scan_id: 6411432
    • updated: 2026-04-09 07:12:27
    • created: 2026-04-08 07:13:40
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_contact_lists`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_contact_lists`\n(\n`portalId`STRING,`listId`STRING,`createdAt`STRING,`updatedAt`STRING,`name`STRING,`listType`STRING,`authorId`STRING,`filters`array,`metaData`struct<`size`:STRING,`lastSizeChangeAt`:STRING,`processing`:STRING,`lastProcessingStateChangeAt`:STRING,`error`:STRING,`listReferencesCount`:STRING,`parentFolderId`:STRING>,`archived`STRING,`teamIds`array,`ilsFilterBranch`STRING,`dynamic`STRING,`internal`STRING,`readOnly`STRING,`limitExempt`STRING,`parentId`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_contact_lists/2026-04-08/1775650396'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_contact_lists"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_contact_lists/2026-04-08/1775650396
    • id: 904767
    • processed: 1
    • raw_data: 
      {
    "archived": false,
    "authorId": 68170421,
    "createdAt": 1762804209067,
    "dynamic": true,
    "filters": [],
    "ilsFilterBranch": "{\"filterBranchOperator\":\"OR\",\"filters\":[],\"filterBranches\":[{\"filterBranchOperator\":\"AND\",\"filters\":[{\"frameworkFilterId\":null,\"filterInsightsId\":null,\"operator\":\"IN_LIST\",\"listId\":504,\"coalescingRefineBy\":{\"setType\":\"ANY\",\"type\":\"SetOccurrencesRefineBy\"},\"associationTypeId\":1,\"associationCategory\":\"HUBSPOT_DEFINED\",\"toObjectTypeId\":\"0-2\",\"toObjectType\":\"COMPANY\",\"filterType\":\"ASSOCIATION\"},{\"filterType\":\"PROPERTY\",\"property\":\"email\",\"operation\":{\"propertyType\":\"alltypes\",\"operator\":\"IS_KNOWN\",\"defaultValue\":null,\"includeObjectsWithNoValueSet\":false,\"pruningRefineBy\":null,\"coalescingRefineBy\":{\"setType\":\"ANY\",\"type\":\"SetOccurrencesRefineBy\"},\"operatorName\":\"IS_KNOWN\",\"operationType\":\"alltypes\"},\"frameworkFilterId\":null,\"filterInsightsId\":null,\"context\":null}],\"filterBranches\":[],\"filterInsightsId\":null,\"filterBranchType\":\"AND\"}],\"filterInsightsId\":null,\"filterBranchType\":\"OR\"}",
    "internal": false,
    "limitExempt": false,
    "listId": 1079,
    "listType": "DYNAMIC",
    "metaData": {
        "error": "",
        "lastProcessingStateChangeAt": 1627911678541,
        "lastSizeChangeAt": 1773957016632,
        "listReferencesCount": null,
        "parentFolderId": null,
        "processing": "DONE",
        "size": 216
    },
    "name": "All Marketing Contacts - Prospects",
    "parentId": 226604176,
    "portalId": 2753955,
    "readOnly": false,
    "teamIds": [],
    "updatedAt": 1765316665325
}
    • schema_attributes: 
      {
    "archived": "string",
    "authorId": "string",
    "createdAt": "string",
    "dynamic": "string",
    "filters": [
        "string"
    ],
    "ilsFilterBranch": "string",
    "internal": "string",
    "limitExempt": "string",
    "listId": "string",
    "listType": "string",
    "metaData.error": "string",
    "metaData.lastProcessingStateChangeAt": "string",
    "metaData.lastSizeChangeAt": "string",
    "metaData.listReferencesCount": "string",
    "metaData.parentFolderId": "string",
    "metaData.processing": "string",
    "metaData.size": "string",
    "name": "string",
    "parentId": "string",
    "portalId": "string",
    "readOnly": "string",
    "teamIds": [
        "string"
    ],
    "updatedAt": "string"
}
    • schema_name_id: 1513
    • schema_scan_id: 6410925
    • updated: 2026-04-08 07:13:51
    • created: 2026-04-07 07:17:22
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_contact_lists`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_contact_lists`\n(\n`portalId`STRING,`listId`STRING,`createdAt`STRING,`updatedAt`STRING,`name`STRING,`listType`STRING,`authorId`STRING,`filters`array,`metaData`struct<`size`:STRING,`lastSizeChangeAt`:STRING,`processing`:STRING,`lastProcessingStateChangeAt`:STRING,`error`:STRING,`listReferencesCount`:STRING,`parentFolderId`:STRING>,`archived`STRING,`teamIds`array,`ilsFilterBranch`STRING,`dynamic`STRING,`internal`STRING,`readOnly`STRING,`limitExempt`STRING,`parentId`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_contact_lists/2026-04-07/1775564207'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_contact_lists"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_contact_lists/2026-04-07/1775564207
    • id: 904555
    • processed: 1
    • raw_data: 
      {
    "archived": false,
    "authorId": 68170421,
    "createdAt": 1762804209067,
    "dynamic": true,
    "filters": [],
    "ilsFilterBranch": "{\"filterBranchOperator\":\"OR\",\"filters\":[],\"filterBranches\":[{\"filterBranchOperator\":\"AND\",\"filters\":[{\"frameworkFilterId\":null,\"filterInsightsId\":null,\"operator\":\"IN_LIST\",\"listId\":504,\"coalescingRefineBy\":{\"setType\":\"ANY\",\"type\":\"SetOccurrencesRefineBy\"},\"associationTypeId\":1,\"associationCategory\":\"HUBSPOT_DEFINED\",\"toObjectTypeId\":\"0-2\",\"toObjectType\":\"COMPANY\",\"filterType\":\"ASSOCIATION\"},{\"filterType\":\"PROPERTY\",\"property\":\"email\",\"operation\":{\"propertyType\":\"alltypes\",\"operator\":\"IS_KNOWN\",\"defaultValue\":null,\"includeObjectsWithNoValueSet\":false,\"pruningRefineBy\":null,\"coalescingRefineBy\":{\"setType\":\"ANY\",\"type\":\"SetOccurrencesRefineBy\"},\"operatorName\":\"IS_KNOWN\",\"operationType\":\"alltypes\"},\"frameworkFilterId\":null,\"filterInsightsId\":null,\"context\":null}],\"filterBranches\":[],\"filterInsightsId\":null,\"filterBranchType\":\"AND\"}],\"filterInsightsId\":null,\"filterBranchType\":\"OR\"}",
    "internal": false,
    "limitExempt": false,
    "listId": 1079,
    "listType": "DYNAMIC",
    "metaData": {
        "error": "",
        "lastProcessingStateChangeAt": 1627911678541,
        "lastSizeChangeAt": 1773957016632,
        "listReferencesCount": null,
        "parentFolderId": null,
        "processing": "DONE",
        "size": 216
    },
    "name": "All Marketing Contacts - Prospects",
    "parentId": 226604176,
    "portalId": 2753955,
    "readOnly": false,
    "teamIds": [],
    "updatedAt": 1765316665325
}
    • schema_attributes: 
      {
    "archived": "string",
    "authorId": "string",
    "createdAt": "string",
    "dynamic": "string",
    "filters": [
        "string"
    ],
    "ilsFilterBranch": "string",
    "internal": "string",
    "limitExempt": "string",
    "listId": "string",
    "listType": "string",
    "metaData.error": "string",
    "metaData.lastProcessingStateChangeAt": "string",
    "metaData.lastSizeChangeAt": "string",
    "metaData.listReferencesCount": "string",
    "metaData.parentFolderId": "string",
    "metaData.processing": "string",
    "metaData.size": "string",
    "name": "string",
    "parentId": "string",
    "portalId": "string",
    "readOnly": "string",
    "teamIds": [
        "string"
    ],
    "updatedAt": "string"
}
    • schema_name_id: 1513
    • schema_scan_id: 6410418
    • updated: 2026-04-07 07:17:36
    • created: 2026-04-06 07:18:42
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_contact_lists`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_contact_lists`\n(\n`portalId`STRING,`listId`STRING,`createdAt`STRING,`updatedAt`STRING,`name`STRING,`listType`STRING,`authorId`STRING,`filters`array,`metaData`struct<`size`:STRING,`lastSizeChangeAt`:STRING,`processing`:STRING,`lastProcessingStateChangeAt`:STRING,`error`:STRING,`listReferencesCount`:STRING,`parentFolderId`:STRING>,`archived`STRING,`teamIds`array,`ilsFilterBranch`STRING,`dynamic`STRING,`internal`STRING,`readOnly`STRING,`limitExempt`STRING,`parentId`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_contact_lists/2026-04-06/1775477873'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_contact_lists"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_contact_lists/2026-04-06/1775477873
    • id: 904341
    • processed: 1
    • raw_data: 
      {
    "archived": false,
    "authorId": 68170421,
    "createdAt": 1762804209067,
    "dynamic": true,
    "filters": [],
    "ilsFilterBranch": "{\"filterBranchOperator\":\"OR\",\"filters\":[],\"filterBranches\":[{\"filterBranchOperator\":\"AND\",\"filters\":[{\"frameworkFilterId\":null,\"filterInsightsId\":null,\"operator\":\"IN_LIST\",\"listId\":504,\"coalescingRefineBy\":{\"setType\":\"ANY\",\"type\":\"SetOccurrencesRefineBy\"},\"associationTypeId\":1,\"associationCategory\":\"HUBSPOT_DEFINED\",\"toObjectTypeId\":\"0-2\",\"toObjectType\":\"COMPANY\",\"filterType\":\"ASSOCIATION\"},{\"filterType\":\"PROPERTY\",\"property\":\"email\",\"operation\":{\"propertyType\":\"alltypes\",\"operator\":\"IS_KNOWN\",\"defaultValue\":null,\"includeObjectsWithNoValueSet\":false,\"pruningRefineBy\":null,\"coalescingRefineBy\":{\"setType\":\"ANY\",\"type\":\"SetOccurrencesRefineBy\"},\"operatorName\":\"IS_KNOWN\",\"operationType\":\"alltypes\"},\"frameworkFilterId\":null,\"filterInsightsId\":null,\"context\":null}],\"filterBranches\":[],\"filterInsightsId\":null,\"filterBranchType\":\"AND\"}],\"filterInsightsId\":null,\"filterBranchType\":\"OR\"}",
    "internal": false,
    "limitExempt": false,
    "listId": 1079,
    "listType": "DYNAMIC",
    "metaData": {
        "error": "",
        "lastProcessingStateChangeAt": 1627911678541,
        "lastSizeChangeAt": 1773957016632,
        "listReferencesCount": null,
        "parentFolderId": null,
        "processing": "DONE",
        "size": 216
    },
    "name": "All Marketing Contacts - Prospects",
    "parentId": 226604176,
    "portalId": 2753955,
    "readOnly": false,
    "teamIds": [],
    "updatedAt": 1765316665325
}
    • schema_attributes: 
      {
    "archived": "string",
    "authorId": "string",
    "createdAt": "string",
    "dynamic": "string",
    "filters": [
        "string"
    ],
    "ilsFilterBranch": "string",
    "internal": "string",
    "limitExempt": "string",
    "listId": "string",
    "listType": "string",
    "metaData.error": "string",
    "metaData.lastProcessingStateChangeAt": "string",
    "metaData.lastSizeChangeAt": "string",
    "metaData.listReferencesCount": "string",
    "metaData.parentFolderId": "string",
    "metaData.processing": "string",
    "metaData.size": "string",
    "name": "string",
    "parentId": "string",
    "portalId": "string",
    "readOnly": "string",
    "teamIds": [
        "string"
    ],
    "updatedAt": "string"
}
    • schema_name_id: 1513
    • schema_scan_id: 6409874
    • updated: 2026-04-06 07:18:56
    • created: 2026-04-05 07:13:44
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_contact_lists`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_contact_lists`\n(\n`portalId`STRING,`listId`STRING,`createdAt`STRING,`updatedAt`STRING,`name`STRING,`listType`STRING,`authorId`STRING,`filters`array,`metaData`struct<`size`:STRING,`lastSizeChangeAt`:STRING,`processing`:STRING,`lastProcessingStateChangeAt`:STRING,`error`:STRING,`listReferencesCount`:STRING,`parentFolderId`:STRING>,`archived`STRING,`teamIds`array,`ilsFilterBranch`STRING,`dynamic`STRING,`internal`STRING,`readOnly`STRING,`limitExempt`STRING,`parentId`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_contact_lists/2026-04-05/1775391168'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_contact_lists"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_contact_lists/2026-04-05/1775391168
    • id: 904139
    • processed: 1
    • raw_data: 
      {
    "archived": false,
    "authorId": 68170421,
    "createdAt": 1762804209067,
    "dynamic": true,
    "filters": [],
    "ilsFilterBranch": "{\"filterBranchOperator\":\"OR\",\"filters\":[],\"filterBranches\":[{\"filterBranchOperator\":\"AND\",\"filters\":[{\"frameworkFilterId\":null,\"filterInsightsId\":null,\"operator\":\"IN_LIST\",\"listId\":504,\"coalescingRefineBy\":{\"setType\":\"ANY\",\"type\":\"SetOccurrencesRefineBy\"},\"associationTypeId\":1,\"associationCategory\":\"HUBSPOT_DEFINED\",\"toObjectTypeId\":\"0-2\",\"toObjectType\":\"COMPANY\",\"filterType\":\"ASSOCIATION\"},{\"filterType\":\"PROPERTY\",\"property\":\"email\",\"operation\":{\"propertyType\":\"alltypes\",\"operator\":\"IS_KNOWN\",\"defaultValue\":null,\"includeObjectsWithNoValueSet\":false,\"pruningRefineBy\":null,\"coalescingRefineBy\":{\"setType\":\"ANY\",\"type\":\"SetOccurrencesRefineBy\"},\"operationType\":\"alltypes\",\"operatorName\":\"IS_KNOWN\"},\"frameworkFilterId\":null,\"filterInsightsId\":null,\"context\":null}],\"filterBranches\":[],\"filterInsightsId\":null,\"filterBranchType\":\"AND\"}],\"filterInsightsId\":null,\"filterBranchType\":\"OR\"}",
    "internal": false,
    "limitExempt": false,
    "listId": 1079,
    "listType": "DYNAMIC",
    "metaData": {
        "error": "",
        "lastProcessingStateChangeAt": 1627911678541,
        "lastSizeChangeAt": 1773957016632,
        "listReferencesCount": null,
        "parentFolderId": null,
        "processing": "DONE",
        "size": 216
    },
    "name": "All Marketing Contacts - Prospects",
    "parentId": 226604176,
    "portalId": 2753955,
    "readOnly": false,
    "teamIds": [],
    "updatedAt": 1765316665325
}
    • schema_attributes: 
      {
    "archived": "string",
    "authorId": "string",
    "createdAt": "string",
    "dynamic": "string",
    "filters": [
        "string"
    ],
    "ilsFilterBranch": "string",
    "internal": "string",
    "limitExempt": "string",
    "listId": "string",
    "listType": "string",
    "metaData.error": "string",
    "metaData.lastProcessingStateChangeAt": "string",
    "metaData.lastSizeChangeAt": "string",
    "metaData.listReferencesCount": "string",
    "metaData.parentFolderId": "string",
    "metaData.processing": "string",
    "metaData.size": "string",
    "name": "string",
    "parentId": "string",
    "portalId": "string",
    "readOnly": "string",
    "teamIds": [
        "string"
    ],
    "updatedAt": "string"
}
    • schema_name_id: 1513
    • schema_scan_id: 6409466
    • updated: 2026-04-05 07:13:56
    • created: 2026-04-04 07:14:30
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_contact_lists`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_contact_lists`\n(\n`portalId`STRING,`listId`STRING,`createdAt`STRING,`updatedAt`STRING,`name`STRING,`listType`STRING,`authorId`STRING,`filters`array,`metaData`struct<`size`:STRING,`lastSizeChangeAt`:STRING,`processing`:STRING,`lastProcessingStateChangeAt`:STRING,`error`:STRING,`listReferencesCount`:STRING,`parentFolderId`:STRING>,`archived`STRING,`teamIds`array,`ilsFilterBranch`STRING,`dynamic`STRING,`internal`STRING,`readOnly`STRING,`limitExempt`STRING,`parentId`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_contact_lists/2026-04-04/1775304854'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_contact_lists"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_contact_lists/2026-04-04/1775304854
    • id: 903931
    • processed: 1
    • raw_data: 
      {
    "archived": false,
    "authorId": 68170421,
    "createdAt": 1762804209067,
    "dynamic": true,
    "filters": [],
    "ilsFilterBranch": "{\"filterBranchOperator\":\"OR\",\"filters\":[],\"filterBranches\":[{\"filterBranchOperator\":\"AND\",\"filters\":[{\"frameworkFilterId\":null,\"filterInsightsId\":null,\"operator\":\"IN_LIST\",\"listId\":504,\"coalescingRefineBy\":{\"setType\":\"ANY\",\"type\":\"SetOccurrencesRefineBy\"},\"associationTypeId\":1,\"associationCategory\":\"HUBSPOT_DEFINED\",\"toObjectTypeId\":\"0-2\",\"toObjectType\":\"COMPANY\",\"filterType\":\"ASSOCIATION\"},{\"filterType\":\"PROPERTY\",\"property\":\"email\",\"operation\":{\"propertyType\":\"alltypes\",\"operator\":\"IS_KNOWN\",\"defaultValue\":null,\"includeObjectsWithNoValueSet\":false,\"pruningRefineBy\":null,\"coalescingRefineBy\":{\"setType\":\"ANY\",\"type\":\"SetOccurrencesRefineBy\"},\"operatorName\":\"IS_KNOWN\",\"operationType\":\"alltypes\"},\"frameworkFilterId\":null,\"filterInsightsId\":null,\"context\":null}],\"filterBranches\":[],\"filterInsightsId\":null,\"filterBranchType\":\"AND\"}],\"filterInsightsId\":null,\"filterBranchType\":\"OR\"}",
    "internal": false,
    "limitExempt": false,
    "listId": 1079,
    "listType": "DYNAMIC",
    "metaData": {
        "error": "",
        "lastProcessingStateChangeAt": 1627911678541,
        "lastSizeChangeAt": 1773957016632,
        "listReferencesCount": null,
        "parentFolderId": null,
        "processing": "DONE",
        "size": 216
    },
    "name": "All Marketing Contacts - Prospects",
    "parentId": 226604176,
    "portalId": 2753955,
    "readOnly": false,
    "teamIds": [],
    "updatedAt": 1765316665325
}
    • schema_attributes: 
      {
    "archived": "string",
    "authorId": "string",
    "createdAt": "string",
    "dynamic": "string",
    "filters": [
        "string"
    ],
    "ilsFilterBranch": "string",
    "internal": "string",
    "limitExempt": "string",
    "listId": "string",
    "listType": "string",
    "metaData.error": "string",
    "metaData.lastProcessingStateChangeAt": "string",
    "metaData.lastSizeChangeAt": "string",
    "metaData.listReferencesCount": "string",
    "metaData.parentFolderId": "string",
    "metaData.processing": "string",
    "metaData.size": "string",
    "name": "string",
    "parentId": "string",
    "portalId": "string",
    "readOnly": "string",
    "teamIds": [
        "string"
    ],
    "updatedAt": "string"
}
    • schema_name_id: 1513
    • schema_scan_id: 6409081
    • updated: 2026-04-04 07:14:42
    • created: 2026-04-03 07:16:40
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_contact_lists`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_contact_lists`\n(\n`portalId`STRING,`listId`STRING,`createdAt`STRING,`updatedAt`STRING,`name`STRING,`listType`STRING,`authorId`STRING,`filters`array,`metaData`struct<`size`:STRING,`lastSizeChangeAt`:STRING,`processing`:STRING,`lastProcessingStateChangeAt`:STRING,`error`:STRING,`listReferencesCount`:STRING,`parentFolderId`:STRING>,`archived`STRING,`teamIds`array,`ilsFilterBranch`STRING,`dynamic`STRING,`internal`STRING,`readOnly`STRING,`limitExempt`STRING,`parentId`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_contact_lists/2026-04-03/1775218578'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_contact_lists"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_contact_lists/2026-04-03/1775218578
    • id: 903717
    • processed: 1
    • raw_data: 
      {
    "archived": false,
    "authorId": 68170421,
    "createdAt": 1762804209067,
    "dynamic": true,
    "filters": [],
    "ilsFilterBranch": "{\"filterBranchOperator\":\"OR\",\"filters\":[],\"filterBranches\":[{\"filterBranchOperator\":\"AND\",\"filters\":[{\"frameworkFilterId\":null,\"filterInsightsId\":null,\"operator\":\"IN_LIST\",\"listId\":504,\"coalescingRefineBy\":{\"setType\":\"ANY\",\"type\":\"SetOccurrencesRefineBy\"},\"associationTypeId\":1,\"associationCategory\":\"HUBSPOT_DEFINED\",\"toObjectTypeId\":\"0-2\",\"toObjectType\":\"COMPANY\",\"filterType\":\"ASSOCIATION\"},{\"filterType\":\"PROPERTY\",\"property\":\"email\",\"operation\":{\"propertyType\":\"alltypes\",\"operator\":\"IS_KNOWN\",\"defaultValue\":null,\"includeObjectsWithNoValueSet\":false,\"pruningRefineBy\":null,\"coalescingRefineBy\":{\"setType\":\"ANY\",\"type\":\"SetOccurrencesRefineBy\"},\"operatorName\":\"IS_KNOWN\",\"operationType\":\"alltypes\"},\"frameworkFilterId\":null,\"filterInsightsId\":null,\"context\":null}],\"filterBranches\":[],\"filterInsightsId\":null,\"filterBranchType\":\"AND\"}],\"filterInsightsId\":null,\"filterBranchType\":\"OR\"}",
    "internal": false,
    "limitExempt": false,
    "listId": 1079,
    "listType": "DYNAMIC",
    "metaData": {
        "error": "",
        "lastProcessingStateChangeAt": 1627911678541,
        "lastSizeChangeAt": 1773957016632,
        "listReferencesCount": null,
        "parentFolderId": null,
        "processing": "DONE",
        "size": 216
    },
    "name": "All Marketing Contacts - Prospects",
    "parentId": 226604176,
    "portalId": 2753955,
    "readOnly": false,
    "teamIds": [],
    "updatedAt": 1765316665325
}
    • schema_attributes: 
      {
    "archived": "string",
    "authorId": "string",
    "createdAt": "string",
    "dynamic": "string",
    "filters": [
        "string"
    ],
    "ilsFilterBranch": "string",
    "internal": "string",
    "limitExempt": "string",
    "listId": "string",
    "listType": "string",
    "metaData.error": "string",
    "metaData.lastProcessingStateChangeAt": "string",
    "metaData.lastSizeChangeAt": "string",
    "metaData.listReferencesCount": "string",
    "metaData.parentFolderId": "string",
    "metaData.processing": "string",
    "metaData.size": "string",
    "name": "string",
    "parentId": "string",
    "portalId": "string",
    "readOnly": "string",
    "teamIds": [
        "string"
    ],
    "updatedAt": "string"
}
    • schema_name_id: 1513
    • schema_scan_id: 6408607
    • updated: 2026-04-03 07:16:53
Schema Scans: 15
Last at 2026-04-17 07:19:02
    • duration: 0:00:12.801845
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6415293
    • 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_contact_lists/2026-04-17/1776428301",
        "key": "raw/hubspot_molo_contact_lists/2026-04-17/1776428301/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_contact_lists",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 432734776214219252,
        "service_name": "drive-thru",
        "span_id": 7526042822436507098,
        "trace_id": 16620522038579743803
    }
}
    • running: False
    • schema_name_id: 1513
    • start_time: 2026-04-17 07:19:02
    • success: True
    • trace_id: 16620522038579743803
    • duration: 0:00:12.703776
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6414735
    • 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_contact_lists/2026-04-16/1776341599",
        "key": "raw/hubspot_molo_contact_lists/2026-04-16/1776341599/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_contact_lists",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 6158983512872258587,
        "service_name": "drive-thru",
        "span_id": 11617316791013736500,
        "trace_id": 3500239434393288727
    }
}
    • running: False
    • schema_name_id: 1513
    • start_time: 2026-04-16 07:13:43
    • success: True
    • trace_id: 3500239434393288727
    • duration: 0:00:12.608824
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6414258
    • 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_contact_lists/2026-04-15/1776255594",
        "key": "raw/hubspot_molo_contact_lists/2026-04-15/1776255594/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_contact_lists",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 6660006082607814976,
        "service_name": "drive-thru",
        "span_id": 3598288839992202163,
        "trace_id": 12296044110322887699
    }
}
    • running: False
    • schema_name_id: 1513
    • start_time: 2026-04-15 07:20:29
    • success: True
    • trace_id: 12296044110322887699
    • duration: 0:00:12.483009
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6413756
    • 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_contact_lists/2026-04-14/1776168945",
        "key": "raw/hubspot_molo_contact_lists/2026-04-14/1776168945/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_contact_lists",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 6758583433500002438,
        "service_name": "drive-thru",
        "span_id": 6234555875533059284,
        "trace_id": 14475057083177916318
    }
}
    • running: False
    • schema_name_id: 1513
    • start_time: 2026-04-14 07:15:58
    • success: True
    • trace_id: 14475057083177916318
    • duration: 0:00:12.580523
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6413212
    • 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_contact_lists/2026-04-13/1776082712",
        "key": "raw/hubspot_molo_contact_lists/2026-04-13/1776082712/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_contact_lists",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 944164172228667872,
        "service_name": "drive-thru",
        "span_id": 15410917317150874001,
        "trace_id": 7615207969859804949
    }
}
    • running: False
    • schema_name_id: 1513
    • start_time: 2026-04-13 07:19:35
    • success: True
    • trace_id: 7615207969859804949
    • duration: 0:00:15.191503
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6412793
    • 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_contact_lists/2026-04-12/1775996135",
        "key": "raw/hubspot_molo_contact_lists/2026-04-12/1775996135/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_contact_lists",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 3093496798983319546,
        "service_name": "drive-thru",
        "span_id": 8375291699751917106,
        "trace_id": 17361947501925101427
    }
}
    • running: False
    • schema_name_id: 1513
    • start_time: 2026-04-12 07:16:05
    • success: True
    • trace_id: 17361947501925101427
    • duration: 0:00:15.185601
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6412416
    • 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_contact_lists/2026-04-11/1775909630",
        "key": "raw/hubspot_molo_contact_lists/2026-04-11/1775909630/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_contact_lists",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 1482914525869026213,
        "service_name": "drive-thru",
        "span_id": 2002769350875871287,
        "trace_id": 10820114645453305664
    }
}
    • running: False
    • schema_name_id: 1513
    • start_time: 2026-04-11 07:14:18
    • success: True
    • trace_id: 10820114645453305664
    • duration: 0:00:15.184234
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6411943
    • 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_contact_lists/2026-04-10/1775823118",
        "key": "raw/hubspot_molo_contact_lists/2026-04-10/1775823118/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_contact_lists",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 4252591454231391723,
        "service_name": "drive-thru",
        "span_id": 18319997001967430197,
        "trace_id": 7504888615810267816
    }
}
    • running: False
    • schema_name_id: 1513
    • start_time: 2026-04-10 07:12:26
    • success: True
    • trace_id: 7504888615810267816
    • duration: 0:00:12.551511
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6411432
    • 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_contact_lists/2026-04-09/1775736729",
        "key": "raw/hubspot_molo_contact_lists/2026-04-09/1775736729/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_contact_lists",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 6809784684741858373,
        "service_name": "drive-thru",
        "span_id": 8246509432166005548,
        "trace_id": 4163122615725120692
    }
}
    • running: False
    • schema_name_id: 1513
    • start_time: 2026-04-09 07:12:14
    • success: True
    • trace_id: 4163122615725120692
    • duration: 0:00:12.818586
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6410925
    • 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_contact_lists/2026-04-08/1775650396",
        "key": "raw/hubspot_molo_contact_lists/2026-04-08/1775650396/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_contact_lists",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 8694418137072639100,
        "service_name": "drive-thru",
        "span_id": 14775477657249437217,
        "trace_id": 11047682777299660099
    }
}
    • running: False
    • schema_name_id: 1513
    • start_time: 2026-04-08 07:13:38
    • success: True
    • trace_id: 11047682777299660099
    • duration: 0:00:15.198527
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6410418
    • 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_contact_lists/2026-04-07/1775564207",
        "key": "raw/hubspot_molo_contact_lists/2026-04-07/1775564207/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_contact_lists",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 9595685454359505868,
        "service_name": "drive-thru",
        "span_id": 8361736102131527547,
        "trace_id": 5670941370010641316
    }
}
    • running: False
    • schema_name_id: 1513
    • start_time: 2026-04-07 07:17:20
    • success: True
    • trace_id: 5670941370010641316
    • duration: 0:00:15.089231
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6409874
    • 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_contact_lists/2026-04-06/1775477873",
        "key": "raw/hubspot_molo_contact_lists/2026-04-06/1775477873/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_contact_lists",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 6764915006673247495,
        "service_name": "drive-thru",
        "span_id": 1697361027756652204,
        "trace_id": 6061750728536069828
    }
}
    • running: False
    • schema_name_id: 1513
    • start_time: 2026-04-06 07:18:41
    • success: True
    • trace_id: 6061750728536069828
    • duration: 0:00:12.614674
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6409466
    • 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_contact_lists/2026-04-05/1775391168",
        "key": "raw/hubspot_molo_contact_lists/2026-04-05/1775391168/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_contact_lists",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 15826733250421608394,
        "service_name": "drive-thru",
        "span_id": 4815855305421291678,
        "trace_id": 18107337384488878874
    }
}
    • running: False
    • schema_name_id: 1513
    • start_time: 2026-04-05 07:13:43
    • success: True
    • trace_id: 18107337384488878874
    • duration: 0:00:12.595520
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6409081
    • 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_contact_lists/2026-04-04/1775304854",
        "key": "raw/hubspot_molo_contact_lists/2026-04-04/1775304854/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_contact_lists",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 9566830099941062595,
        "service_name": "drive-thru",
        "span_id": 12860705265293265668,
        "trace_id": 15171121488658996478
    }
}
    • running: False
    • schema_name_id: 1513
    • start_time: 2026-04-04 07:14:29
    • success: True
    • trace_id: 15171121488658996478
    • duration: 0:00:15.183688
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6408607
    • 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_contact_lists/2026-04-03/1775218578",
        "key": "raw/hubspot_molo_contact_lists/2026-04-03/1775218578/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_contact_lists",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 16154572380627714700,
        "service_name": "drive-thru",
        "span_id": 4458545427864801111,
        "trace_id": 16605048751215621366
    }
}
    • running: False
    • schema_name_id: 1513
    • start_time: 2026-04-03 07:16:38
    • success: True
    • trace_id: 16605048751215621366
Partitions:
  • count: 0
  • ddl: None
  • name: None
  • state: 
    []
  • type: None
Schema:
  • attributes: 
    {
    "archived": "string",
    "authorId": "string",
    "createdAt": "string",
    "dynamic": "string",
    "filters": [
        "string"
    ],
    "ilsFilterBranch": "string",
    "internal": "string",
    "limitExempt": "string",
    "listId": "string",
    "listType": "string",
    "metaData.error": "string",
    "metaData.lastProcessingStateChangeAt": "string",
    "metaData.lastSizeChangeAt": "string",
    "metaData.listReferencesCount": "string",
    "metaData.parentFolderId": "string",
    "metaData.processing": "string",
    "metaData.size": "string",
    "name": "string",
    "parentId": "string",
    "portalId": "string",
    "readOnly": "string",
    "teamIds": [
        "string"
    ],
    "updatedAt": "string"
}
  • created: 2026-04-17 07:19:04
  • 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_contact_lists`\n(\n`portalId`STRING,`listId`STRING,`createdAt`STRING,`updatedAt`STRING,`name`STRING,`listType`STRING,`authorId`STRING,`filters`array,`metaData`struct<`size`:STRING,`lastSizeChangeAt`:STRING,`processing`:STRING,`lastProcessingStateChangeAt`:STRING,`error`:STRING,`listReferencesCount`:STRING,`parentFolderId`:STRING>,`archived`STRING,`teamIds`array,`ilsFilterBranch`STRING,`dynamic`STRING,`internal`STRING,`readOnly`STRING,`limitExempt`STRING,`parentId`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_contact_lists/2026-04-17/1776428301'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_contact_lists`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_contact_lists"
}
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:05",
        "disabled": false,
        "format": "raw",
        "id": 1513,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_stage_drivethru",
            "table": "hubspot_molo_contact_lists"
        },
        "type": "drivethrujson"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "archived": "string",
            "authorId": "string",
            "createdAt": "string",
            "dynamic": "string",
            "filters": [
                "string"
            ],
            "ilsFilterBranch": "string",
            "internal": "string",
            "limitExempt": "string",
            "listId": "string",
            "listType": "string",
            "metaData.error": "string",
            "metaData.lastProcessingStateChangeAt": "string",
            "metaData.lastSizeChangeAt": "string",
            "metaData.listReferencesCount": "string",
            "metaData.parentFolderId": "string",
            "metaData.processing": "string",
            "metaData.size": "string",
            "name": "string",
            "parentId": "string",
            "portalId": "string",
            "readOnly": "string",
            "teamIds": [
                "string"
            ],
            "updatedAt": "string"
        },
        "created": "2026-04-17 07:19:04",
        "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_contact_lists`\n(\n`portalId`STRING,`listId`STRING,`createdAt`STRING,`updatedAt`STRING,`name`STRING,`listType`STRING,`authorId`STRING,`filters`array,`metaData`struct<`size`:STRING,`lastSizeChangeAt`:STRING,`processing`:STRING,`lastProcessingStateChangeAt`:STRING,`error`:STRING,`listReferencesCount`:STRING,`parentFolderId`:STRING>,`archived`STRING,`teamIds`array,`ilsFilterBranch`STRING,`dynamic`STRING,`internal`STRING,`readOnly`STRING,`limitExempt`STRING,`parentId`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_contact_lists/2026-04-17/1776428301'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_contact_lists`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_contact_lists"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}
©2019 SpareFoot Data Platform