Schema Info

Schema Name: sfdl_prod_drivethru.hubspot_molo_contact_lists
  • created: 2022-12-01 13:34:11
  • disabled: False
  • format: raw
  • id: 1239
  • is_partitioned: False
  • is_schema_datatyped: False
  • name: 
    {
    "database": "sfdl_prod_drivethru",
    "table": "hubspot_molo_contact_lists"
}
  • type: drivethrujson
Schema Versions: 15
    • created: 2026-04-17 07:22:10
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_contact_lists`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/hubspot_molo_contact_lists/2026-04-17/1776428521'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_contact_lists"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_contact_lists/2026-04-17/1776428521
    • id: 1718121
    • 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: 1239
    • schema_scan_id: 162173161
    • updated: 2026-04-17 07:22:24
    • created: 2026-04-16 07:17:12
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_contact_lists`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/hubspot_molo_contact_lists/2026-04-16/1776341817'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_contact_lists"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_contact_lists/2026-04-16/1776341817
    • id: 1716889
    • 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: 1239
    • schema_scan_id: 162117412
    • updated: 2026-04-16 07:17:26
    • created: 2026-04-15 07:22:50
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_contact_lists`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/hubspot_molo_contact_lists/2026-04-15/1776255749'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_contact_lists"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_contact_lists/2026-04-15/1776255749
    • id: 1715693
    • 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: 1239
    • schema_scan_id: 162061875
    • updated: 2026-04-15 07:23:04
    • created: 2026-04-14 07:16:55
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_contact_lists`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/hubspot_molo_contact_lists/2026-04-14/1776168952'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_contact_lists"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_contact_lists/2026-04-14/1776168952
    • id: 1714503
    • 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: 1239
    • schema_scan_id: 162006451
    • updated: 2026-04-14 07:17:06
    • created: 2026-04-13 07:17:14
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_contact_lists`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/hubspot_molo_contact_lists/2026-04-13/1776082622'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_contact_lists"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_contact_lists/2026-04-13/1776082622
    • id: 1713274
    • 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: 1239
    • schema_scan_id: 161948398
    • updated: 2026-04-13 07:17:25
    • created: 2026-04-12 07:16:09
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_contact_lists`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/hubspot_molo_contact_lists/2026-04-12/1775996158'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_contact_lists"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_contact_lists/2026-04-12/1775996158
    • id: 1712096
    • 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: 1239
    • schema_scan_id: 161899590
    • updated: 2026-04-12 07:16:20
    • created: 2026-04-11 07:15:03
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_contact_lists`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/hubspot_molo_contact_lists/2026-04-11/1775909671'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_contact_lists"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_contact_lists/2026-04-11/1775909671
    • id: 1710877
    • 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: 1239
    • schema_scan_id: 161846902
    • updated: 2026-04-11 07:15:17
    • created: 2026-04-10 07:19:13
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_contact_lists`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/hubspot_molo_contact_lists/2026-04-10/1775823505'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_contact_lists"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_contact_lists/2026-04-10/1775823505
    • id: 1709705
    • 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: 1239
    • schema_scan_id: 161792160
    • updated: 2026-04-10 07:19:24
    • created: 2026-04-09 07:20:15
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_contact_lists`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/hubspot_molo_contact_lists/2026-04-09/1775737203'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_contact_lists"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_contact_lists/2026-04-09/1775737203
    • id: 1708557
    • 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: 1239
    • schema_scan_id: 161736330
    • updated: 2026-04-09 07:20:27
    • created: 2026-04-08 07:17:32
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_contact_lists`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/hubspot_molo_contact_lists/2026-04-08/1775650607'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_contact_lists"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_contact_lists/2026-04-08/1775650607
    • id: 1707376
    • 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: 1239
    • schema_scan_id: 161681506
    • updated: 2026-04-08 07:17:46
    • created: 2026-04-07 07:17:43
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_contact_lists`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/hubspot_molo_contact_lists/2026-04-07/1775564259'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_contact_lists"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_contact_lists/2026-04-07/1775564259
    • id: 1706178
    • 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: 1239
    • schema_scan_id: 161625277
    • updated: 2026-04-07 07:17:57
    • created: 2026-04-06 07:19:48
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_contact_lists`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/hubspot_molo_contact_lists/2026-04-06/1775477969'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_contact_lists"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_contact_lists/2026-04-06/1775477969
    • id: 1704971
    • 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: 1239
    • schema_scan_id: 161567420
    • updated: 2026-04-06 07:20:00
    • created: 2026-04-05 07:20:17
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_contact_lists`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/hubspot_molo_contact_lists/2026-04-05/1775391612'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_contact_lists"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_contact_lists/2026-04-05/1775391612
    • id: 1703731
    • 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: 1239
    • schema_scan_id: 161520032
    • updated: 2026-04-05 07:20:31
    • created: 2026-04-04 07:15:12
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_contact_lists`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/hubspot_molo_contact_lists/2026-04-04/1775304906'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_contact_lists"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_contact_lists/2026-04-04/1775304906
    • id: 1702585
    • 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\"},\"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: 1239
    • schema_scan_id: 161466468
    • updated: 2026-04-04 07:15:58
    • created: 2026-04-03 07:20:19
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_contact_lists`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/hubspot_molo_contact_lists/2026-04-03/1775218810'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_contact_lists"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_contact_lists/2026-04-03/1775218810
    • id: 1701392
    • 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: 1239
    • schema_scan_id: 161408651
    • updated: 2026-04-03 07:20:33
Schema Scans: 15
Last at 2026-04-17 07:22:09
    • duration: 0:00:15.217601
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162173161
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_contact_lists/2026-04-17/1776428521",
        "key": "raw/hubspot_molo_contact_lists/2026-04-17/1776428521/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_contact_lists",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 8150231523737998125,
        "service_name": "drive-thru",
        "span_id": 15292968341677188409,
        "trace_id": 18121244553186438047
    }
}
    • running: False
    • schema_name_id: 1239
    • start_time: 2026-04-17 07:22:09
    • success: True
    • trace_id: 18121244553186438047
    • duration: 0:00:15.238842
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162117412
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_contact_lists/2026-04-16/1776341817",
        "key": "raw/hubspot_molo_contact_lists/2026-04-16/1776341817/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_contact_lists",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 18010419272643753807,
        "service_name": "drive-thru",
        "span_id": 3445606121123653670,
        "trace_id": 14118473371849552912
    }
}
    • running: False
    • schema_name_id: 1239
    • start_time: 2026-04-16 07:17:11
    • success: True
    • trace_id: 14118473371849552912
    • duration: 0:00:15.096646
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162061875
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_contact_lists/2026-04-15/1776255749",
        "key": "raw/hubspot_molo_contact_lists/2026-04-15/1776255749/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_contact_lists",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 111398629855768993,
        "service_name": "drive-thru",
        "span_id": 164187728996116396,
        "trace_id": 14391810826887073601
    }
}
    • running: False
    • schema_name_id: 1239
    • start_time: 2026-04-15 07:22:49
    • success: True
    • trace_id: 14391810826887073601
    • duration: 0:00:12.431883
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162006451
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_contact_lists/2026-04-14/1776168952",
        "key": "raw/hubspot_molo_contact_lists/2026-04-14/1776168952/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_contact_lists",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 4898079392874574775,
        "service_name": "drive-thru",
        "span_id": 17462305720892395583,
        "trace_id": 1661953071318202343
    }
}
    • running: False
    • schema_name_id: 1239
    • start_time: 2026-04-14 07:16:54
    • success: True
    • trace_id: 1661953071318202343
    • duration: 0:00:12.478763
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161948398
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_contact_lists/2026-04-13/1776082622",
        "key": "raw/hubspot_molo_contact_lists/2026-04-13/1776082622/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_contact_lists",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 16878472718100043166,
        "service_name": "drive-thru",
        "span_id": 12746774968884171425,
        "trace_id": 11979173322258750444
    }
}
    • running: False
    • schema_name_id: 1239
    • start_time: 2026-04-13 07:17:13
    • success: True
    • trace_id: 11979173322258750444
    • duration: 0:00:12.339913
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161899590
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_contact_lists/2026-04-12/1775996158",
        "key": "raw/hubspot_molo_contact_lists/2026-04-12/1775996158/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_contact_lists",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 16899162519104121319,
        "service_name": "drive-thru",
        "span_id": 5964426135290602628,
        "trace_id": 8582176509828229907
    }
}
    • running: False
    • schema_name_id: 1239
    • start_time: 2026-04-12 07:16:08
    • success: True
    • trace_id: 8582176509828229907
    • duration: 0:00:14.913720
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161846902
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_contact_lists/2026-04-11/1775909671",
        "key": "raw/hubspot_molo_contact_lists/2026-04-11/1775909671/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_contact_lists",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 6549597652918844617,
        "service_name": "drive-thru",
        "span_id": 12653371687711264934,
        "trace_id": 17033407813105652378
    }
}
    • running: False
    • schema_name_id: 1239
    • start_time: 2026-04-11 07:15:02
    • success: True
    • trace_id: 17033407813105652378
    • duration: 0:00:12.525082
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161792160
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_contact_lists/2026-04-10/1775823505",
        "key": "raw/hubspot_molo_contact_lists/2026-04-10/1775823505/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_contact_lists",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 17013939893760128237,
        "service_name": "drive-thru",
        "span_id": 8806849461684833258,
        "trace_id": 12445818066579749406
    }
}
    • running: False
    • schema_name_id: 1239
    • start_time: 2026-04-10 07:19:12
    • success: True
    • trace_id: 12445818066579749406
    • duration: 0:00:12.427328
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161736330
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_contact_lists/2026-04-09/1775737203",
        "key": "raw/hubspot_molo_contact_lists/2026-04-09/1775737203/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_contact_lists",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 9557359072878444756,
        "service_name": "drive-thru",
        "span_id": 11916302249089257568,
        "trace_id": 13462383785757224700
    }
}
    • running: False
    • schema_name_id: 1239
    • start_time: 2026-04-09 07:20:14
    • success: True
    • trace_id: 13462383785757224700
    • duration: 0:00:15.154358
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161681506
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_contact_lists/2026-04-08/1775650607",
        "key": "raw/hubspot_molo_contact_lists/2026-04-08/1775650607/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_contact_lists",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 6715442179514997923,
        "service_name": "drive-thru",
        "span_id": 14252206733809140487,
        "trace_id": 9416185385863036722
    }
}
    • running: False
    • schema_name_id: 1239
    • start_time: 2026-04-08 07:17:31
    • success: True
    • trace_id: 9416185385863036722
    • duration: 0:00:15.002949
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161625277
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_contact_lists/2026-04-07/1775564259",
        "key": "raw/hubspot_molo_contact_lists/2026-04-07/1775564259/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_contact_lists",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 684409378435721720,
        "service_name": "drive-thru",
        "span_id": 10005324953245896305,
        "trace_id": 16515765658621693107
    }
}
    • running: False
    • schema_name_id: 1239
    • start_time: 2026-04-07 07:17:42
    • success: True
    • trace_id: 16515765658621693107
    • duration: 0:00:12.493003
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161567420
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_contact_lists/2026-04-06/1775477969",
        "key": "raw/hubspot_molo_contact_lists/2026-04-06/1775477969/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_contact_lists",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 1896236418524976015,
        "service_name": "drive-thru",
        "span_id": 15657805450176416506,
        "trace_id": 9117957415049474555
    }
}
    • running: False
    • schema_name_id: 1239
    • start_time: 2026-04-06 07:19:47
    • success: True
    • trace_id: 9117957415049474555
    • duration: 0:00:15.028928
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161520032
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_contact_lists/2026-04-05/1775391612",
        "key": "raw/hubspot_molo_contact_lists/2026-04-05/1775391612/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_contact_lists",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 5625096206307940449,
        "service_name": "drive-thru",
        "span_id": 4882224673426010730,
        "trace_id": 1523592332325188477
    }
}
    • running: False
    • schema_name_id: 1239
    • start_time: 2026-04-05 07:20:16
    • success: True
    • trace_id: 1523592332325188477
    • duration: 0:00:48.032351
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161466468
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_contact_lists/2026-04-04/1775304906",
        "key": "raw/hubspot_molo_contact_lists/2026-04-04/1775304906/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_contact_lists",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 11083299642778952028,
        "service_name": "drive-thru",
        "span_id": 18227556842965631462,
        "trace_id": 9938418618026957004
    }
}
    • running: False
    • schema_name_id: 1239
    • start_time: 2026-04-04 07:15:10
    • success: True
    • trace_id: 9938418618026957004
    • duration: 0:00:15.088763
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161408651
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_contact_lists/2026-04-03/1775218810",
        "key": "raw/hubspot_molo_contact_lists/2026-04-03/1775218810/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_contact_lists",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 1818721150737940488,
        "service_name": "drive-thru",
        "span_id": 14974462475973403795,
        "trace_id": 5597010374081688220
    }
}
    • running: False
    • schema_name_id: 1239
    • start_time: 2026-04-03 07:20:18
    • success: True
    • trace_id: 5597010374081688220
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:22:10
  • ddl: 
    {
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_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-prod/raw/hubspot_molo_contact_lists/2026-04-17/1776428521'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_contact_lists`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_contact_lists"
}
Server:
  • hostname: schemamanager-5475496c57-7dpqb
  • name: schema_manager
  • process_start: 2026-01-09 11:27:47
  • sf_env: prod
  • version: 2112174301
Raw: 
{
    "name": {
        "created": "2022-12-01 13:34:11",
        "disabled": false,
        "format": "raw",
        "id": 1239,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_prod_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:22:10",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_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-prod/raw/hubspot_molo_contact_lists/2026-04-17/1776428521'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_contact_lists`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_contact_lists"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}
©2019 SpareFoot Data Platform