Schema Info

Schema Name: sfdl_stage_drivethru.hubspot_molo_companies_properties

created: 2022-11-30 13:40:13
disabled: False
format: raw
id: 1508
is_partitioned: False
is_schema_datatyped: False

name:

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

type: drivethrujson

Schema Versions: 15

Version 906669

created: 2026-04-17 07:18:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_companies_properties`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_companies_properties`\n(\n`updatedAt`STRING,`createdAt`STRING,`name`STRING,`label`STRING,`type`STRING,`fieldType`STRING,`description`STRING,`groupName`STRING,`options`array>,`displayOrder`STRING,`calculated`STRING,`externalOptions`STRING,`hasUniqueValue`STRING,`hidden`STRING,`hubspotDefined`STRING,`modificationMetadata`struct<`archivable`:STRING,`readOnlyDefinition`:STRING,`readOnlyValue`:STRING,`readOnlyOptions`:STRING>,`formField`STRING,`dataSensitivity`STRING,`createdUserId`STRING,`updatedUserId`STRING,`archived`STRING,`showCurrencySymbol`STRING,`numberDisplayHint`STRING,`calculationFormula`STRING,`referencedObjectType`STRING,`dateDisplayHint`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_companies_properties/2026-04-17/1776428271'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_companies_properties"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_companies_properties/2026-04-17/1776428271
id: 906669
processed: 1

raw_data:

{
    "archived": false,
    "calculated": false,
    "calculationFormula": "if (closedate - createdate) >= 0 then round_down(((closedate - createdate) / 86400000), 0) endif",
    "createdAt": "2023-05-05T15:39:21.490Z",
    "createdUserId": "47074899",
    "dataSensitivity": "non_sensitive",
    "dateDisplayHint": "time_since",
    "description": "If you have a lead you are still working and do not want it re-assigned to the team, check this box.  If you are no longer working it, uncheck the box and it will be removed from your queue.",
    "displayOrder": -1,
    "externalOptions": false,
    "fieldType": "booleancheckbox",
    "formField": false,
    "groupName": "companyinformation",
    "hasUniqueValue": false,
    "hidden": false,
    "hubspotDefined": true,
    "label": "Meaningful Contact",
    "modificationMetadata": {
        "archivable": true,
        "readOnlyDefinition": true,
        "readOnlyOptions": false,
        "readOnlyValue": false
    },
    "name": "actively_working_lead",
    "numberDisplayHint": "formatted",
    "options": [
        {
            "description": "",
            "displayOrder": 1,
            "hidden": false,
            "label": "Peek",
            "value": "Peek"
        }
    ],
    "referencedObjectType": "COMPANY",
    "showCurrencySymbol": false,
    "type": "enumeration",
    "updatedAt": "2023-08-10T19:49:37.090Z",
    "updatedUserId": "47074899"
}

schema_attributes:

{
    "archived": "string",
    "calculated": "string",
    "calculationFormula": "string",
    "createdAt": "string",
    "createdUserId": "string",
    "dataSensitivity": "string",
    "dateDisplayHint": "string",
    "description": "string",
    "displayOrder": "string",
    "externalOptions": "string",
    "fieldType": "string",
    "formField": "string",
    "groupName": "string",
    "hasUniqueValue": "string",
    "hidden": "string",
    "hubspotDefined": "string",
    "label": "string",
    "modificationMetadata.archivable": "string",
    "modificationMetadata.readOnlyDefinition": "string",
    "modificationMetadata.readOnlyOptions": "string",
    "modificationMetadata.readOnlyValue": "string",
    "name": "string",
    "numberDisplayHint": "string",
    "options": [
        {
            "description": "string",
            "displayOrder": "string",
            "hidden": "string",
            "label": "string",
            "value": "string"
        }
    ],
    "referencedObjectType": "string",
    "showCurrencySymbol": "string",
    "type": "string",
    "updatedAt": "string",
    "updatedUserId": "string"
}

schema_name_id: 1508
schema_scan_id: 6415286
updated: 2026-04-17 07:18:31

Version 906456

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_companies_properties`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_companies_properties`\n(\n`updatedAt`STRING,`createdAt`STRING,`name`STRING,`label`STRING,`type`STRING,`fieldType`STRING,`description`STRING,`groupName`STRING,`options`array>,`displayOrder`STRING,`calculated`STRING,`externalOptions`STRING,`hasUniqueValue`STRING,`hidden`STRING,`hubspotDefined`STRING,`modificationMetadata`struct<`archivable`:STRING,`readOnlyDefinition`:STRING,`readOnlyValue`:STRING,`readOnlyOptions`:STRING>,`formField`STRING,`dataSensitivity`STRING,`createdUserId`STRING,`updatedUserId`STRING,`archived`STRING,`showCurrencySymbol`STRING,`numberDisplayHint`STRING,`calculationFormula`STRING,`referencedObjectType`STRING,`dateDisplayHint`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_companies_properties/2026-04-16/1776341636'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_companies_properties"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_companies_properties/2026-04-16/1776341636
id: 906456
processed: 1

raw_data:

{
    "archived": false,
    "calculated": false,
    "calculationFormula": "if (closedate - createdate) >= 0 then round_down(((closedate - createdate) / 86400000), 0) endif",
    "createdAt": "2023-05-05T15:39:21.490Z",
    "createdUserId": "47074899",
    "dataSensitivity": "non_sensitive",
    "dateDisplayHint": "time_since",
    "description": "If you have a lead you are still working and do not want it re-assigned to the team, check this box.  If you are no longer working it, uncheck the box and it will be removed from your queue.",
    "displayOrder": -1,
    "externalOptions": false,
    "fieldType": "booleancheckbox",
    "formField": false,
    "groupName": "companyinformation",
    "hasUniqueValue": false,
    "hidden": false,
    "hubspotDefined": true,
    "label": "Meaningful Contact",
    "modificationMetadata": {
        "archivable": true,
        "readOnlyDefinition": true,
        "readOnlyOptions": false,
        "readOnlyValue": false
    },
    "name": "actively_working_lead",
    "numberDisplayHint": "formatted",
    "options": [
        {
            "description": "",
            "displayOrder": 1,
            "hidden": false,
            "label": "Peek",
            "value": "Peek"
        }
    ],
    "referencedObjectType": "COMPANY",
    "showCurrencySymbol": false,
    "type": "enumeration",
    "updatedAt": "2023-08-10T19:49:37.090Z",
    "updatedUserId": "47074899"
}

schema_attributes:

{
    "archived": "string",
    "calculated": "string",
    "calculationFormula": "string",
    "createdAt": "string",
    "createdUserId": "string",
    "dataSensitivity": "string",
    "dateDisplayHint": "string",
    "description": "string",
    "displayOrder": "string",
    "externalOptions": "string",
    "fieldType": "string",
    "formField": "string",
    "groupName": "string",
    "hasUniqueValue": "string",
    "hidden": "string",
    "hubspotDefined": "string",
    "label": "string",
    "modificationMetadata.archivable": "string",
    "modificationMetadata.readOnlyDefinition": "string",
    "modificationMetadata.readOnlyOptions": "string",
    "modificationMetadata.readOnlyValue": "string",
    "name": "string",
    "numberDisplayHint": "string",
    "options": [
        {
            "description": "string",
            "displayOrder": "string",
            "hidden": "string",
            "label": "string",
            "value": "string"
        }
    ],
    "referencedObjectType": "string",
    "showCurrencySymbol": "string",
    "type": "string",
    "updatedAt": "string",
    "updatedUserId": "string"
}

schema_name_id: 1508
schema_scan_id: 6414743
updated: 2026-04-16 07:14:52

Version 906245

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_companies_properties`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_companies_properties`\n(\n`updatedAt`STRING,`createdAt`STRING,`name`STRING,`label`STRING,`type`STRING,`fieldType`STRING,`description`STRING,`groupName`STRING,`options`array>,`displayOrder`STRING,`calculated`STRING,`externalOptions`STRING,`hasUniqueValue`STRING,`hidden`STRING,`hubspotDefined`STRING,`modificationMetadata`struct<`archivable`:STRING,`readOnlyDefinition`:STRING,`readOnlyValue`:STRING,`readOnlyOptions`:STRING>,`formField`STRING,`dataSensitivity`STRING,`createdUserId`STRING,`updatedUserId`STRING,`archived`STRING,`showCurrencySymbol`STRING,`numberDisplayHint`STRING,`calculationFormula`STRING,`referencedObjectType`STRING,`dateDisplayHint`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_companies_properties/2026-04-15/1776255585'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_companies_properties"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_companies_properties/2026-04-15/1776255585
id: 906245
processed: 1

raw_data:

{
    "archived": false,
    "calculated": false,
    "calculationFormula": "if (closedate - createdate) >= 0 then round_down(((closedate - createdate) / 86400000), 0) endif",
    "createdAt": "2023-05-05T15:39:21.490Z",
    "createdUserId": "47074899",
    "dataSensitivity": "non_sensitive",
    "dateDisplayHint": "time_since",
    "description": "If you have a lead you are still working and do not want it re-assigned to the team, check this box.  If you are no longer working it, uncheck the box and it will be removed from your queue.",
    "displayOrder": -1,
    "externalOptions": false,
    "fieldType": "booleancheckbox",
    "formField": false,
    "groupName": "companyinformation",
    "hasUniqueValue": false,
    "hidden": false,
    "hubspotDefined": true,
    "label": "Meaningful Contact",
    "modificationMetadata": {
        "archivable": true,
        "readOnlyDefinition": true,
        "readOnlyOptions": false,
        "readOnlyValue": false
    },
    "name": "actively_working_lead",
    "numberDisplayHint": "formatted",
    "options": [
        {
            "description": "",
            "displayOrder": 1,
            "hidden": false,
            "label": "Peek",
            "value": "Peek"
        }
    ],
    "referencedObjectType": "COMPANY",
    "showCurrencySymbol": false,
    "type": "enumeration",
    "updatedAt": "2023-08-10T19:49:37.090Z",
    "updatedUserId": "47074899"
}

schema_attributes:

{
    "archived": "string",
    "calculated": "string",
    "calculationFormula": "string",
    "createdAt": "string",
    "createdUserId": "string",
    "dataSensitivity": "string",
    "dateDisplayHint": "string",
    "description": "string",
    "displayOrder": "string",
    "externalOptions": "string",
    "fieldType": "string",
    "formField": "string",
    "groupName": "string",
    "hasUniqueValue": "string",
    "hidden": "string",
    "hubspotDefined": "string",
    "label": "string",
    "modificationMetadata.archivable": "string",
    "modificationMetadata.readOnlyDefinition": "string",
    "modificationMetadata.readOnlyOptions": "string",
    "modificationMetadata.readOnlyValue": "string",
    "name": "string",
    "numberDisplayHint": "string",
    "options": [
        {
            "description": "string",
            "displayOrder": "string",
            "hidden": "string",
            "label": "string",
            "value": "string"
        }
    ],
    "referencedObjectType": "string",
    "showCurrencySymbol": "string",
    "type": "string",
    "updatedAt": "string",
    "updatedUserId": "string"
}

schema_name_id: 1508
schema_scan_id: 6414256
updated: 2026-04-15 07:20:30

Version 906031

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_companies_properties`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_companies_properties`\n(\n`updatedAt`STRING,`createdAt`STRING,`name`STRING,`label`STRING,`type`STRING,`fieldType`STRING,`description`STRING,`groupName`STRING,`options`array>,`displayOrder`STRING,`calculated`STRING,`externalOptions`STRING,`hasUniqueValue`STRING,`hidden`STRING,`hubspotDefined`STRING,`modificationMetadata`struct<`archivable`:STRING,`readOnlyDefinition`:STRING,`readOnlyValue`:STRING,`readOnlyOptions`:STRING>,`formField`STRING,`dataSensitivity`STRING,`createdUserId`STRING,`updatedUserId`STRING,`archived`STRING,`showCurrencySymbol`STRING,`numberDisplayHint`STRING,`calculationFormula`STRING,`referencedObjectType`STRING,`dateDisplayHint`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_companies_properties/2026-04-14/1776168968'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_companies_properties"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_companies_properties/2026-04-14/1776168968
id: 906031
processed: 1

raw_data:

{
    "archived": false,
    "calculated": false,
    "calculationFormula": "if (closedate - createdate) >= 0 then round_down(((closedate - createdate) / 86400000), 0) endif",
    "createdAt": "2023-05-05T15:39:21.490Z",
    "createdUserId": "47074899",
    "dataSensitivity": "non_sensitive",
    "dateDisplayHint": "time_since",
    "description": "If you have a lead you are still working and do not want it re-assigned to the team, check this box.  If you are no longer working it, uncheck the box and it will be removed from your queue.",
    "displayOrder": -1,
    "externalOptions": false,
    "fieldType": "booleancheckbox",
    "formField": false,
    "groupName": "companyinformation",
    "hasUniqueValue": false,
    "hidden": false,
    "hubspotDefined": true,
    "label": "Meaningful Contact",
    "modificationMetadata": {
        "archivable": true,
        "readOnlyDefinition": true,
        "readOnlyOptions": false,
        "readOnlyValue": false
    },
    "name": "actively_working_lead",
    "numberDisplayHint": "formatted",
    "options": [
        {
            "description": "",
            "displayOrder": 1,
            "hidden": false,
            "label": "Peek",
            "value": "Peek"
        }
    ],
    "referencedObjectType": "COMPANY",
    "showCurrencySymbol": false,
    "type": "enumeration",
    "updatedAt": "2023-08-10T19:49:37.090Z",
    "updatedUserId": "47074899"
}

schema_attributes:

{
    "archived": "string",
    "calculated": "string",
    "calculationFormula": "string",
    "createdAt": "string",
    "createdUserId": "string",
    "dataSensitivity": "string",
    "dateDisplayHint": "string",
    "description": "string",
    "displayOrder": "string",
    "externalOptions": "string",
    "fieldType": "string",
    "formField": "string",
    "groupName": "string",
    "hasUniqueValue": "string",
    "hidden": "string",
    "hubspotDefined": "string",
    "label": "string",
    "modificationMetadata.archivable": "string",
    "modificationMetadata.readOnlyDefinition": "string",
    "modificationMetadata.readOnlyOptions": "string",
    "modificationMetadata.readOnlyValue": "string",
    "name": "string",
    "numberDisplayHint": "string",
    "options": [
        {
            "description": "string",
            "displayOrder": "string",
            "hidden": "string",
            "label": "string",
            "value": "string"
        }
    ],
    "referencedObjectType": "string",
    "showCurrencySymbol": "string",
    "type": "string",
    "updatedAt": "string",
    "updatedUserId": "string"
}

schema_name_id: 1508
schema_scan_id: 6413764
updated: 2026-04-14 07:16:54

Version 905814

created: 2026-04-13 07:19:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_companies_properties`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_companies_properties`\n(\n`updatedAt`STRING,`createdAt`STRING,`name`STRING,`label`STRING,`type`STRING,`fieldType`STRING,`description`STRING,`groupName`STRING,`options`array>,`displayOrder`STRING,`calculated`STRING,`externalOptions`STRING,`hasUniqueValue`STRING,`hidden`STRING,`hubspotDefined`STRING,`modificationMetadata`struct<`archivable`:STRING,`readOnlyDefinition`:STRING,`readOnlyValue`:STRING,`readOnlyOptions`:STRING>,`formField`STRING,`dataSensitivity`STRING,`createdUserId`STRING,`updatedUserId`STRING,`archived`STRING,`showCurrencySymbol`STRING,`numberDisplayHint`STRING,`calculationFormula`STRING,`referencedObjectType`STRING,`dateDisplayHint`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_companies_properties/2026-04-13/1776082702'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_companies_properties"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_companies_properties/2026-04-13/1776082702
id: 905814
processed: 1

raw_data:

{
    "archived": false,
    "calculated": false,
    "calculationFormula": "if (closedate - createdate) >= 0 then round_down(((closedate - createdate) / 86400000), 0) endif",
    "createdAt": "2023-05-05T15:39:21.490Z",
    "createdUserId": "47074899",
    "dataSensitivity": "non_sensitive",
    "dateDisplayHint": "time_since",
    "description": "If you have a lead you are still working and do not want it re-assigned to the team, check this box.  If you are no longer working it, uncheck the box and it will be removed from your queue.",
    "displayOrder": -1,
    "externalOptions": false,
    "fieldType": "booleancheckbox",
    "formField": false,
    "groupName": "companyinformation",
    "hasUniqueValue": false,
    "hidden": false,
    "hubspotDefined": true,
    "label": "Meaningful Contact",
    "modificationMetadata": {
        "archivable": true,
        "readOnlyDefinition": true,
        "readOnlyOptions": false,
        "readOnlyValue": false
    },
    "name": "actively_working_lead",
    "numberDisplayHint": "formatted",
    "options": [
        {
            "description": "",
            "displayOrder": 1,
            "hidden": false,
            "label": "Peek",
            "value": "Peek"
        }
    ],
    "referencedObjectType": "COMPANY",
    "showCurrencySymbol": false,
    "type": "enumeration",
    "updatedAt": "2023-08-10T19:49:37.090Z",
    "updatedUserId": "47074899"
}

schema_attributes:

{
    "archived": "string",
    "calculated": "string",
    "calculationFormula": "string",
    "createdAt": "string",
    "createdUserId": "string",
    "dataSensitivity": "string",
    "dateDisplayHint": "string",
    "description": "string",
    "displayOrder": "string",
    "externalOptions": "string",
    "fieldType": "string",
    "formField": "string",
    "groupName": "string",
    "hasUniqueValue": "string",
    "hidden": "string",
    "hubspotDefined": "string",
    "label": "string",
    "modificationMetadata.archivable": "string",
    "modificationMetadata.readOnlyDefinition": "string",
    "modificationMetadata.readOnlyOptions": "string",
    "modificationMetadata.readOnlyValue": "string",
    "name": "string",
    "numberDisplayHint": "string",
    "options": [
        {
            "description": "string",
            "displayOrder": "string",
            "hidden": "string",
            "label": "string",
            "value": "string"
        }
    ],
    "referencedObjectType": "string",
    "showCurrencySymbol": "string",
    "type": "string",
    "updatedAt": "string",
    "updatedUserId": "string"
}

schema_name_id: 1508
schema_scan_id: 6413209
updated: 2026-04-13 07:19:31

Version 905612

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_companies_properties`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_companies_properties`\n(\n`updatedAt`STRING,`createdAt`STRING,`name`STRING,`label`STRING,`type`STRING,`fieldType`STRING,`description`STRING,`groupName`STRING,`options`array>,`displayOrder`STRING,`calculated`STRING,`externalOptions`STRING,`hasUniqueValue`STRING,`hidden`STRING,`hubspotDefined`STRING,`modificationMetadata`struct<`archivable`:STRING,`readOnlyDefinition`:STRING,`readOnlyValue`:STRING,`readOnlyOptions`:STRING>,`formField`STRING,`dataSensitivity`STRING,`createdUserId`STRING,`updatedUserId`STRING,`archived`STRING,`showCurrencySymbol`STRING,`numberDisplayHint`STRING,`calculationFormula`STRING,`referencedObjectType`STRING,`dateDisplayHint`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_companies_properties/2026-04-12/1775996138'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_companies_properties"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_companies_properties/2026-04-12/1775996138
id: 905612
processed: 1

raw_data:

{
    "archived": false,
    "calculated": false,
    "calculationFormula": "if (closedate - createdate) >= 0 then round_down(((closedate - createdate) / 86400000), 0) endif",
    "createdAt": "2023-05-05T15:39:21.490Z",
    "createdUserId": "47074899",
    "dataSensitivity": "non_sensitive",
    "dateDisplayHint": "time_since",
    "description": "If you have a lead you are still working and do not want it re-assigned to the team, check this box.  If you are no longer working it, uncheck the box and it will be removed from your queue.",
    "displayOrder": -1,
    "externalOptions": false,
    "fieldType": "booleancheckbox",
    "formField": false,
    "groupName": "companyinformation",
    "hasUniqueValue": false,
    "hidden": false,
    "hubspotDefined": true,
    "label": "Meaningful Contact",
    "modificationMetadata": {
        "archivable": true,
        "readOnlyDefinition": true,
        "readOnlyOptions": false,
        "readOnlyValue": false
    },
    "name": "actively_working_lead",
    "numberDisplayHint": "formatted",
    "options": [
        {
            "description": "",
            "displayOrder": 1,
            "hidden": false,
            "label": "Peek",
            "value": "Peek"
        }
    ],
    "referencedObjectType": "COMPANY",
    "showCurrencySymbol": false,
    "type": "enumeration",
    "updatedAt": "2023-08-10T19:49:37.090Z",
    "updatedUserId": "47074899"
}

schema_attributes:

{
    "archived": "string",
    "calculated": "string",
    "calculationFormula": "string",
    "createdAt": "string",
    "createdUserId": "string",
    "dataSensitivity": "string",
    "dateDisplayHint": "string",
    "description": "string",
    "displayOrder": "string",
    "externalOptions": "string",
    "fieldType": "string",
    "formField": "string",
    "groupName": "string",
    "hasUniqueValue": "string",
    "hidden": "string",
    "hubspotDefined": "string",
    "label": "string",
    "modificationMetadata.archivable": "string",
    "modificationMetadata.readOnlyDefinition": "string",
    "modificationMetadata.readOnlyOptions": "string",
    "modificationMetadata.readOnlyValue": "string",
    "name": "string",
    "numberDisplayHint": "string",
    "options": [
        {
            "description": "string",
            "displayOrder": "string",
            "hidden": "string",
            "label": "string",
            "value": "string"
        }
    ],
    "referencedObjectType": "string",
    "showCurrencySymbol": "string",
    "type": "string",
    "updatedAt": "string",
    "updatedUserId": "string"
}

schema_name_id: 1508
schema_scan_id: 6412797
updated: 2026-04-12 07:16:35

Version 905407

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_companies_properties`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_companies_properties`\n(\n`updatedAt`STRING,`createdAt`STRING,`name`STRING,`label`STRING,`type`STRING,`fieldType`STRING,`description`STRING,`groupName`STRING,`options`array>,`displayOrder`STRING,`calculated`STRING,`externalOptions`STRING,`hasUniqueValue`STRING,`hidden`STRING,`hubspotDefined`STRING,`modificationMetadata`struct<`archivable`:STRING,`readOnlyDefinition`:STRING,`readOnlyValue`:STRING,`readOnlyOptions`:STRING>,`formField`STRING,`dataSensitivity`STRING,`createdUserId`STRING,`updatedUserId`STRING,`archived`STRING,`showCurrencySymbol`STRING,`numberDisplayHint`STRING,`calculationFormula`STRING,`referencedObjectType`STRING,`dateDisplayHint`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_companies_properties/2026-04-11/1775909622'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_companies_properties"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_companies_properties/2026-04-11/1775909622
id: 905407
processed: 1

raw_data:

{
    "archived": false,
    "calculated": false,
    "calculationFormula": "if (closedate - createdate) >= 0 then round_down(((closedate - createdate) / 86400000), 0) endif",
    "createdAt": "2023-05-05T15:39:21.490Z",
    "createdUserId": "47074899",
    "dataSensitivity": "non_sensitive",
    "dateDisplayHint": "time_since",
    "description": "If you have a lead you are still working and do not want it re-assigned to the team, check this box.  If you are no longer working it, uncheck the box and it will be removed from your queue.",
    "displayOrder": -1,
    "externalOptions": false,
    "fieldType": "booleancheckbox",
    "formField": false,
    "groupName": "companyinformation",
    "hasUniqueValue": false,
    "hidden": false,
    "hubspotDefined": true,
    "label": "Meaningful Contact",
    "modificationMetadata": {
        "archivable": true,
        "readOnlyDefinition": true,
        "readOnlyOptions": false,
        "readOnlyValue": false
    },
    "name": "actively_working_lead",
    "numberDisplayHint": "formatted",
    "options": [
        {
            "description": "",
            "displayOrder": 1,
            "hidden": false,
            "label": "Peek",
            "value": "Peek"
        }
    ],
    "referencedObjectType": "COMPANY",
    "showCurrencySymbol": false,
    "type": "enumeration",
    "updatedAt": "2023-08-10T19:49:37.090Z",
    "updatedUserId": "47074899"
}

schema_attributes:

{
    "archived": "string",
    "calculated": "string",
    "calculationFormula": "string",
    "createdAt": "string",
    "createdUserId": "string",
    "dataSensitivity": "string",
    "dateDisplayHint": "string",
    "description": "string",
    "displayOrder": "string",
    "externalOptions": "string",
    "fieldType": "string",
    "formField": "string",
    "groupName": "string",
    "hasUniqueValue": "string",
    "hidden": "string",
    "hubspotDefined": "string",
    "label": "string",
    "modificationMetadata.archivable": "string",
    "modificationMetadata.readOnlyDefinition": "string",
    "modificationMetadata.readOnlyOptions": "string",
    "modificationMetadata.readOnlyValue": "string",
    "name": "string",
    "numberDisplayHint": "string",
    "options": [
        {
            "description": "string",
            "displayOrder": "string",
            "hidden": "string",
            "label": "string",
            "value": "string"
        }
    ],
    "referencedObjectType": "string",
    "showCurrencySymbol": "string",
    "type": "string",
    "updatedAt": "string",
    "updatedUserId": "string"
}

schema_name_id: 1508
schema_scan_id: 6412413
updated: 2026-04-11 07:14:18

Version 905191

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_companies_properties`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_companies_properties`\n(\n`updatedAt`STRING,`createdAt`STRING,`name`STRING,`label`STRING,`type`STRING,`fieldType`STRING,`description`STRING,`groupName`STRING,`options`array>,`displayOrder`STRING,`calculated`STRING,`externalOptions`STRING,`hasUniqueValue`STRING,`hidden`STRING,`hubspotDefined`STRING,`modificationMetadata`struct<`archivable`:STRING,`readOnlyDefinition`:STRING,`readOnlyValue`:STRING,`readOnlyOptions`:STRING>,`formField`STRING,`dataSensitivity`STRING,`createdUserId`STRING,`updatedUserId`STRING,`archived`STRING,`showCurrencySymbol`STRING,`numberDisplayHint`STRING,`calculationFormula`STRING,`referencedObjectType`STRING,`dateDisplayHint`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_companies_properties/2026-04-10/1775823095'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_companies_properties"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_companies_properties/2026-04-10/1775823095
id: 905191
processed: 1

raw_data:

{
    "archived": false,
    "calculated": false,
    "calculationFormula": "if (closedate - createdate) >= 0 then round_down(((closedate - createdate) / 86400000), 0) endif",
    "createdAt": "2023-05-05T15:39:21.490Z",
    "createdUserId": "47074899",
    "dataSensitivity": "non_sensitive",
    "dateDisplayHint": "time_since",
    "description": "If you have a lead you are still working and do not want it re-assigned to the team, check this box.  If you are no longer working it, uncheck the box and it will be removed from your queue.",
    "displayOrder": -1,
    "externalOptions": false,
    "fieldType": "booleancheckbox",
    "formField": false,
    "groupName": "companyinformation",
    "hasUniqueValue": false,
    "hidden": false,
    "hubspotDefined": true,
    "label": "Meaningful Contact",
    "modificationMetadata": {
        "archivable": true,
        "readOnlyDefinition": true,
        "readOnlyOptions": false,
        "readOnlyValue": false
    },
    "name": "actively_working_lead",
    "numberDisplayHint": "formatted",
    "options": [
        {
            "description": "",
            "displayOrder": 1,
            "hidden": false,
            "label": "Peek",
            "value": "Peek"
        }
    ],
    "referencedObjectType": "COMPANY",
    "showCurrencySymbol": false,
    "type": "enumeration",
    "updatedAt": "2023-08-10T19:49:37.090Z",
    "updatedUserId": "47074899"
}

schema_attributes:

{
    "archived": "string",
    "calculated": "string",
    "calculationFormula": "string",
    "createdAt": "string",
    "createdUserId": "string",
    "dataSensitivity": "string",
    "dateDisplayHint": "string",
    "description": "string",
    "displayOrder": "string",
    "externalOptions": "string",
    "fieldType": "string",
    "formField": "string",
    "groupName": "string",
    "hasUniqueValue": "string",
    "hidden": "string",
    "hubspotDefined": "string",
    "label": "string",
    "modificationMetadata.archivable": "string",
    "modificationMetadata.readOnlyDefinition": "string",
    "modificationMetadata.readOnlyOptions": "string",
    "modificationMetadata.readOnlyValue": "string",
    "name": "string",
    "numberDisplayHint": "string",
    "options": [
        {
            "description": "string",
            "displayOrder": "string",
            "hidden": "string",
            "label": "string",
            "value": "string"
        }
    ],
    "referencedObjectType": "string",
    "showCurrencySymbol": "string",
    "type": "string",
    "updatedAt": "string",
    "updatedUserId": "string"
}

schema_name_id: 1508
schema_scan_id: 6411937
updated: 2026-04-10 07:12:15

Version 904985

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_companies_properties`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_companies_properties`\n(\n`updatedAt`STRING,`createdAt`STRING,`name`STRING,`label`STRING,`type`STRING,`fieldType`STRING,`description`STRING,`groupName`STRING,`options`array>,`displayOrder`STRING,`calculated`STRING,`externalOptions`STRING,`hasUniqueValue`STRING,`hidden`STRING,`hubspotDefined`STRING,`modificationMetadata`struct<`archivable`:STRING,`readOnlyDefinition`:STRING,`readOnlyValue`:STRING,`readOnlyOptions`:STRING>,`formField`STRING,`dataSensitivity`STRING,`createdUserId`STRING,`updatedUserId`STRING,`archived`STRING,`showCurrencySymbol`STRING,`numberDisplayHint`STRING,`calculationFormula`STRING,`referencedObjectType`STRING,`dateDisplayHint`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_companies_properties/2026-04-09/1775736717'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_companies_properties"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_companies_properties/2026-04-09/1775736717
id: 904985
processed: 1

raw_data:

{
    "archived": false,
    "calculated": false,
    "calculationFormula": "if (closedate - createdate) >= 0 then round_down(((closedate - createdate) / 86400000), 0) endif",
    "createdAt": "2023-05-05T15:39:21.490Z",
    "createdUserId": "47074899",
    "dataSensitivity": "non_sensitive",
    "dateDisplayHint": "time_since",
    "description": "If you have a lead you are still working and do not want it re-assigned to the team, check this box.  If you are no longer working it, uncheck the box and it will be removed from your queue.",
    "displayOrder": -1,
    "externalOptions": false,
    "fieldType": "booleancheckbox",
    "formField": false,
    "groupName": "companyinformation",
    "hasUniqueValue": false,
    "hidden": false,
    "hubspotDefined": true,
    "label": "Meaningful Contact",
    "modificationMetadata": {
        "archivable": true,
        "readOnlyDefinition": true,
        "readOnlyOptions": false,
        "readOnlyValue": false
    },
    "name": "actively_working_lead",
    "numberDisplayHint": "formatted",
    "options": [
        {
            "description": "",
            "displayOrder": 1,
            "hidden": false,
            "label": "Peek",
            "value": "Peek"
        }
    ],
    "referencedObjectType": "COMPANY",
    "showCurrencySymbol": false,
    "type": "enumeration",
    "updatedAt": "2023-08-10T19:49:37.090Z",
    "updatedUserId": "47074899"
}

schema_attributes:

{
    "archived": "string",
    "calculated": "string",
    "calculationFormula": "string",
    "createdAt": "string",
    "createdUserId": "string",
    "dataSensitivity": "string",
    "dateDisplayHint": "string",
    "description": "string",
    "displayOrder": "string",
    "externalOptions": "string",
    "fieldType": "string",
    "formField": "string",
    "groupName": "string",
    "hasUniqueValue": "string",
    "hidden": "string",
    "hubspotDefined": "string",
    "label": "string",
    "modificationMetadata.archivable": "string",
    "modificationMetadata.readOnlyDefinition": "string",
    "modificationMetadata.readOnlyOptions": "string",
    "modificationMetadata.readOnlyValue": "string",
    "name": "string",
    "numberDisplayHint": "string",
    "options": [
        {
            "description": "string",
            "displayOrder": "string",
            "hidden": "string",
            "label": "string",
            "value": "string"
        }
    ],
    "referencedObjectType": "string",
    "showCurrencySymbol": "string",
    "type": "string",
    "updatedAt": "string",
    "updatedUserId": "string"
}

schema_name_id: 1508
schema_scan_id: 6411434
updated: 2026-04-09 07:12:42

Version 904771

created: 2026-04-08 07:14:00

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_companies_properties`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_companies_properties`\n(\n`updatedAt`STRING,`createdAt`STRING,`name`STRING,`label`STRING,`type`STRING,`fieldType`STRING,`description`STRING,`groupName`STRING,`options`array>,`displayOrder`STRING,`calculated`STRING,`externalOptions`STRING,`hasUniqueValue`STRING,`hidden`STRING,`hubspotDefined`STRING,`modificationMetadata`struct<`archivable`:STRING,`readOnlyDefinition`:STRING,`readOnlyValue`:STRING,`readOnlyOptions`:STRING>,`formField`STRING,`dataSensitivity`STRING,`createdUserId`STRING,`updatedUserId`STRING,`archived`STRING,`showCurrencySymbol`STRING,`numberDisplayHint`STRING,`calculationFormula`STRING,`referencedObjectType`STRING,`dateDisplayHint`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_companies_properties/2026-04-08/1775650399'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_companies_properties"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_companies_properties/2026-04-08/1775650399
id: 904771
processed: 1

raw_data:

{
    "archived": false,
    "calculated": false,
    "calculationFormula": "if (closedate - createdate) >= 0 then round_down(((closedate - createdate) / 86400000), 0) endif",
    "createdAt": "2023-05-05T15:39:21.490Z",
    "createdUserId": "47074899",
    "dataSensitivity": "non_sensitive",
    "dateDisplayHint": "time_since",
    "description": "If you have a lead you are still working and do not want it re-assigned to the team, check this box.  If you are no longer working it, uncheck the box and it will be removed from your queue.",
    "displayOrder": -1,
    "externalOptions": false,
    "fieldType": "booleancheckbox",
    "formField": false,
    "groupName": "companyinformation",
    "hasUniqueValue": false,
    "hidden": false,
    "hubspotDefined": true,
    "label": "Meaningful Contact",
    "modificationMetadata": {
        "archivable": true,
        "readOnlyDefinition": true,
        "readOnlyOptions": false,
        "readOnlyValue": false
    },
    "name": "actively_working_lead",
    "numberDisplayHint": "formatted",
    "options": [
        {
            "description": "",
            "displayOrder": 1,
            "hidden": false,
            "label": "Peek",
            "value": "Peek"
        }
    ],
    "referencedObjectType": "COMPANY",
    "showCurrencySymbol": false,
    "type": "enumeration",
    "updatedAt": "2023-08-10T19:49:37.090Z",
    "updatedUserId": "47074899"
}

schema_attributes:

{
    "archived": "string",
    "calculated": "string",
    "calculationFormula": "string",
    "createdAt": "string",
    "createdUserId": "string",
    "dataSensitivity": "string",
    "dateDisplayHint": "string",
    "description": "string",
    "displayOrder": "string",
    "externalOptions": "string",
    "fieldType": "string",
    "formField": "string",
    "groupName": "string",
    "hasUniqueValue": "string",
    "hidden": "string",
    "hubspotDefined": "string",
    "label": "string",
    "modificationMetadata.archivable": "string",
    "modificationMetadata.readOnlyDefinition": "string",
    "modificationMetadata.readOnlyOptions": "string",
    "modificationMetadata.readOnlyValue": "string",
    "name": "string",
    "numberDisplayHint": "string",
    "options": [
        {
            "description": "string",
            "displayOrder": "string",
            "hidden": "string",
            "label": "string",
            "value": "string"
        }
    ],
    "referencedObjectType": "string",
    "showCurrencySymbol": "string",
    "type": "string",
    "updatedAt": "string",
    "updatedUserId": "string"
}

schema_name_id: 1508
schema_scan_id: 6410930
updated: 2026-04-08 07:14:14

Version 904554

created: 2026-04-07 07:17:13

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_companies_properties`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_companies_properties`\n(\n`updatedAt`STRING,`createdAt`STRING,`name`STRING,`label`STRING,`type`STRING,`fieldType`STRING,`description`STRING,`groupName`STRING,`options`array>,`displayOrder`STRING,`calculated`STRING,`externalOptions`STRING,`hasUniqueValue`STRING,`hidden`STRING,`hubspotDefined`STRING,`modificationMetadata`struct<`archivable`:STRING,`readOnlyDefinition`:STRING,`readOnlyValue`:STRING,`readOnlyOptions`:STRING>,`formField`STRING,`dataSensitivity`STRING,`createdUserId`STRING,`updatedUserId`STRING,`archived`STRING,`showCurrencySymbol`STRING,`numberDisplayHint`STRING,`calculationFormula`STRING,`referencedObjectType`STRING,`dateDisplayHint`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_companies_properties/2026-04-07/1775564201'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_companies_properties"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_companies_properties/2026-04-07/1775564201
id: 904554
processed: 1

raw_data:

{
    "archived": false,
    "calculated": false,
    "calculationFormula": "if (closedate - createdate) >= 0 then round_down(((closedate - createdate) / 86400000), 0) endif",
    "createdAt": "2023-05-05T15:39:21.490Z",
    "createdUserId": "47074899",
    "dataSensitivity": "non_sensitive",
    "dateDisplayHint": "time_since",
    "description": "If you have a lead you are still working and do not want it re-assigned to the team, check this box.  If you are no longer working it, uncheck the box and it will be removed from your queue.",
    "displayOrder": -1,
    "externalOptions": false,
    "fieldType": "booleancheckbox",
    "formField": false,
    "groupName": "companyinformation",
    "hasUniqueValue": false,
    "hidden": false,
    "hubspotDefined": true,
    "label": "Meaningful Contact",
    "modificationMetadata": {
        "archivable": true,
        "readOnlyDefinition": true,
        "readOnlyOptions": false,
        "readOnlyValue": false
    },
    "name": "actively_working_lead",
    "numberDisplayHint": "formatted",
    "options": [
        {
            "description": "",
            "displayOrder": 1,
            "hidden": false,
            "label": "Peek",
            "value": "Peek"
        }
    ],
    "referencedObjectType": "COMPANY",
    "showCurrencySymbol": false,
    "type": "enumeration",
    "updatedAt": "2023-08-10T19:49:37.090Z",
    "updatedUserId": "47074899"
}

schema_attributes:

{
    "archived": "string",
    "calculated": "string",
    "calculationFormula": "string",
    "createdAt": "string",
    "createdUserId": "string",
    "dataSensitivity": "string",
    "dateDisplayHint": "string",
    "description": "string",
    "displayOrder": "string",
    "externalOptions": "string",
    "fieldType": "string",
    "formField": "string",
    "groupName": "string",
    "hasUniqueValue": "string",
    "hidden": "string",
    "hubspotDefined": "string",
    "label": "string",
    "modificationMetadata.archivable": "string",
    "modificationMetadata.readOnlyDefinition": "string",
    "modificationMetadata.readOnlyOptions": "string",
    "modificationMetadata.readOnlyValue": "string",
    "name": "string",
    "numberDisplayHint": "string",
    "options": [
        {
            "description": "string",
            "displayOrder": "string",
            "hidden": "string",
            "label": "string",
            "value": "string"
        }
    ],
    "referencedObjectType": "string",
    "showCurrencySymbol": "string",
    "type": "string",
    "updatedAt": "string",
    "updatedUserId": "string"
}

schema_name_id: 1508
schema_scan_id: 6410417
updated: 2026-04-07 07:17:24

Version 904335

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_companies_properties`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_companies_properties`\n(\n`updatedAt`STRING,`createdAt`STRING,`name`STRING,`label`STRING,`type`STRING,`fieldType`STRING,`description`STRING,`groupName`STRING,`options`array>,`displayOrder`STRING,`calculated`STRING,`externalOptions`STRING,`hasUniqueValue`STRING,`hidden`STRING,`hubspotDefined`STRING,`modificationMetadata`struct<`archivable`:STRING,`readOnlyDefinition`:STRING,`readOnlyValue`:STRING,`readOnlyOptions`:STRING>,`formField`STRING,`dataSensitivity`STRING,`createdUserId`STRING,`updatedUserId`STRING,`archived`STRING,`showCurrencySymbol`STRING,`numberDisplayHint`STRING,`calculationFormula`STRING,`referencedObjectType`STRING,`dateDisplayHint`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_companies_properties/2026-04-06/1775477861'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_companies_properties"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_companies_properties/2026-04-06/1775477861
id: 904335
processed: 1

raw_data:

{
    "archived": false,
    "calculated": false,
    "calculationFormula": "if (closedate - createdate) >= 0 then round_down(((closedate - createdate) / 86400000), 0) endif",
    "createdAt": "2023-05-05T15:39:21.490Z",
    "createdUserId": "47074899",
    "dataSensitivity": "non_sensitive",
    "dateDisplayHint": "time_since",
    "description": "If you have a lead you are still working and do not want it re-assigned to the team, check this box.  If you are no longer working it, uncheck the box and it will be removed from your queue.",
    "displayOrder": -1,
    "externalOptions": false,
    "fieldType": "booleancheckbox",
    "formField": false,
    "groupName": "companyinformation",
    "hasUniqueValue": false,
    "hidden": false,
    "hubspotDefined": true,
    "label": "Meaningful Contact",
    "modificationMetadata": {
        "archivable": true,
        "readOnlyDefinition": true,
        "readOnlyOptions": false,
        "readOnlyValue": false
    },
    "name": "actively_working_lead",
    "numberDisplayHint": "formatted",
    "options": [
        {
            "description": "",
            "displayOrder": 1,
            "hidden": false,
            "label": "Peek",
            "value": "Peek"
        }
    ],
    "referencedObjectType": "COMPANY",
    "showCurrencySymbol": false,
    "type": "enumeration",
    "updatedAt": "2023-08-10T19:49:37.090Z",
    "updatedUserId": "47074899"
}

schema_attributes:

{
    "archived": "string",
    "calculated": "string",
    "calculationFormula": "string",
    "createdAt": "string",
    "createdUserId": "string",
    "dataSensitivity": "string",
    "dateDisplayHint": "string",
    "description": "string",
    "displayOrder": "string",
    "externalOptions": "string",
    "fieldType": "string",
    "formField": "string",
    "groupName": "string",
    "hasUniqueValue": "string",
    "hidden": "string",
    "hubspotDefined": "string",
    "label": "string",
    "modificationMetadata.archivable": "string",
    "modificationMetadata.readOnlyDefinition": "string",
    "modificationMetadata.readOnlyOptions": "string",
    "modificationMetadata.readOnlyValue": "string",
    "name": "string",
    "numberDisplayHint": "string",
    "options": [
        {
            "description": "string",
            "displayOrder": "string",
            "hidden": "string",
            "label": "string",
            "value": "string"
        }
    ],
    "referencedObjectType": "string",
    "showCurrencySymbol": "string",
    "type": "string",
    "updatedAt": "string",
    "updatedUserId": "string"
}

schema_name_id: 1508
schema_scan_id: 6409867
updated: 2026-04-06 07:18:23

Version 904133

created: 2026-04-05 07:12:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_companies_properties`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_companies_properties`\n(\n`updatedAt`STRING,`createdAt`STRING,`name`STRING,`label`STRING,`type`STRING,`fieldType`STRING,`description`STRING,`groupName`STRING,`options`array>,`displayOrder`STRING,`calculated`STRING,`externalOptions`STRING,`hasUniqueValue`STRING,`hidden`STRING,`hubspotDefined`STRING,`modificationMetadata`struct<`archivable`:STRING,`readOnlyDefinition`:STRING,`readOnlyValue`:STRING,`readOnlyOptions`:STRING>,`formField`STRING,`dataSensitivity`STRING,`createdUserId`STRING,`updatedUserId`STRING,`archived`STRING,`showCurrencySymbol`STRING,`numberDisplayHint`STRING,`calculationFormula`STRING,`referencedObjectType`STRING,`dateDisplayHint`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_companies_properties/2026-04-05/1775391147'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_companies_properties"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_companies_properties/2026-04-05/1775391147
id: 904133
processed: 1

raw_data:

{
    "archived": false,
    "calculated": false,
    "calculationFormula": "if (closedate - createdate) >= 0 then round_down(((closedate - createdate) / 86400000), 0) endif",
    "createdAt": "2023-05-05T15:39:21.490Z",
    "createdUserId": "47074899",
    "dataSensitivity": "non_sensitive",
    "dateDisplayHint": "time_since",
    "description": "If you have a lead you are still working and do not want it re-assigned to the team, check this box.  If you are no longer working it, uncheck the box and it will be removed from your queue.",
    "displayOrder": -1,
    "externalOptions": false,
    "fieldType": "booleancheckbox",
    "formField": false,
    "groupName": "companyinformation",
    "hasUniqueValue": false,
    "hidden": false,
    "hubspotDefined": true,
    "label": "Meaningful Contact",
    "modificationMetadata": {
        "archivable": true,
        "readOnlyDefinition": true,
        "readOnlyOptions": false,
        "readOnlyValue": false
    },
    "name": "actively_working_lead",
    "numberDisplayHint": "formatted",
    "options": [
        {
            "description": "",
            "displayOrder": 1,
            "hidden": false,
            "label": "Peek",
            "value": "Peek"
        }
    ],
    "referencedObjectType": "COMPANY",
    "showCurrencySymbol": false,
    "type": "enumeration",
    "updatedAt": "2023-08-10T19:49:37.090Z",
    "updatedUserId": "47074899"
}

schema_attributes:

{
    "archived": "string",
    "calculated": "string",
    "calculationFormula": "string",
    "createdAt": "string",
    "createdUserId": "string",
    "dataSensitivity": "string",
    "dateDisplayHint": "string",
    "description": "string",
    "displayOrder": "string",
    "externalOptions": "string",
    "fieldType": "string",
    "formField": "string",
    "groupName": "string",
    "hasUniqueValue": "string",
    "hidden": "string",
    "hubspotDefined": "string",
    "label": "string",
    "modificationMetadata.archivable": "string",
    "modificationMetadata.readOnlyDefinition": "string",
    "modificationMetadata.readOnlyOptions": "string",
    "modificationMetadata.readOnlyValue": "string",
    "name": "string",
    "numberDisplayHint": "string",
    "options": [
        {
            "description": "string",
            "displayOrder": "string",
            "hidden": "string",
            "label": "string",
            "value": "string"
        }
    ],
    "referencedObjectType": "string",
    "showCurrencySymbol": "string",
    "type": "string",
    "updatedAt": "string",
    "updatedUserId": "string"
}

schema_name_id: 1508
schema_scan_id: 6409459
updated: 2026-04-05 07:13:08

Version 903934

created: 2026-04-04 07:15:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_companies_properties`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_companies_properties`\n(\n`updatedAt`STRING,`createdAt`STRING,`name`STRING,`label`STRING,`type`STRING,`fieldType`STRING,`description`STRING,`groupName`STRING,`options`array>,`displayOrder`STRING,`calculated`STRING,`externalOptions`STRING,`hasUniqueValue`STRING,`hidden`STRING,`hubspotDefined`STRING,`modificationMetadata`struct<`archivable`:STRING,`readOnlyDefinition`:STRING,`readOnlyValue`:STRING,`readOnlyOptions`:STRING>,`formField`STRING,`dataSensitivity`STRING,`createdUserId`STRING,`updatedUserId`STRING,`archived`STRING,`showCurrencySymbol`STRING,`numberDisplayHint`STRING,`calculationFormula`STRING,`referencedObjectType`STRING,`dateDisplayHint`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_companies_properties/2026-04-04/1775304847'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_companies_properties"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_companies_properties/2026-04-04/1775304847
id: 903934
processed: 1

raw_data:

{
    "archived": false,
    "calculated": false,
    "calculationFormula": "if (closedate - createdate) >= 0 then round_down(((closedate - createdate) / 86400000), 0) endif",
    "createdAt": "2023-05-05T15:39:21.490Z",
    "createdUserId": "47074899",
    "dataSensitivity": "non_sensitive",
    "dateDisplayHint": "time_since",
    "description": "If you have a lead you are still working and do not want it re-assigned to the team, check this box.  If you are no longer working it, uncheck the box and it will be removed from your queue.",
    "displayOrder": -1,
    "externalOptions": false,
    "fieldType": "booleancheckbox",
    "formField": false,
    "groupName": "companyinformation",
    "hasUniqueValue": false,
    "hidden": false,
    "hubspotDefined": true,
    "label": "Meaningful Contact",
    "modificationMetadata": {
        "archivable": true,
        "readOnlyDefinition": true,
        "readOnlyOptions": false,
        "readOnlyValue": false
    },
    "name": "actively_working_lead",
    "numberDisplayHint": "formatted",
    "options": [
        {
            "description": "",
            "displayOrder": 1,
            "hidden": false,
            "label": "Peek",
            "value": "Peek"
        }
    ],
    "referencedObjectType": "COMPANY",
    "showCurrencySymbol": false,
    "type": "enumeration",
    "updatedAt": "2023-08-10T19:49:37.090Z",
    "updatedUserId": "47074899"
}

schema_attributes:

{
    "archived": "string",
    "calculated": "string",
    "calculationFormula": "string",
    "createdAt": "string",
    "createdUserId": "string",
    "dataSensitivity": "string",
    "dateDisplayHint": "string",
    "description": "string",
    "displayOrder": "string",
    "externalOptions": "string",
    "fieldType": "string",
    "formField": "string",
    "groupName": "string",
    "hasUniqueValue": "string",
    "hidden": "string",
    "hubspotDefined": "string",
    "label": "string",
    "modificationMetadata.archivable": "string",
    "modificationMetadata.readOnlyDefinition": "string",
    "modificationMetadata.readOnlyOptions": "string",
    "modificationMetadata.readOnlyValue": "string",
    "name": "string",
    "numberDisplayHint": "string",
    "options": [
        {
            "description": "string",
            "displayOrder": "string",
            "hidden": "string",
            "label": "string",
            "value": "string"
        }
    ],
    "referencedObjectType": "string",
    "showCurrencySymbol": "string",
    "type": "string",
    "updatedAt": "string",
    "updatedUserId": "string"
}

schema_name_id: 1508
schema_scan_id: 6409084
updated: 2026-04-04 07:16:01

Version 903724

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_companies_properties`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_companies_properties`\n(\n`updatedAt`STRING,`createdAt`STRING,`name`STRING,`label`STRING,`type`STRING,`fieldType`STRING,`description`STRING,`groupName`STRING,`options`array>,`displayOrder`STRING,`calculated`STRING,`externalOptions`STRING,`hasUniqueValue`STRING,`hidden`STRING,`hubspotDefined`STRING,`modificationMetadata`struct<`archivable`:STRING,`readOnlyDefinition`:STRING,`readOnlyValue`:STRING,`readOnlyOptions`:STRING>,`formField`STRING,`dataSensitivity`STRING,`createdUserId`STRING,`updatedUserId`STRING,`archived`STRING,`showCurrencySymbol`STRING,`numberDisplayHint`STRING,`calculationFormula`STRING,`referencedObjectType`STRING,`dateDisplayHint`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_companies_properties/2026-04-03/1775218600'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_companies_properties"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_companies_properties/2026-04-03/1775218600
id: 903724
processed: 1

raw_data:

{
    "archived": false,
    "calculated": false,
    "calculationFormula": "if (closedate - createdate) >= 0 then round_down(((closedate - createdate) / 86400000), 0) endif",
    "createdAt": "2023-05-05T15:39:21.490Z",
    "createdUserId": "47074899",
    "dataSensitivity": "non_sensitive",
    "dateDisplayHint": "time_since",
    "description": "If you have a lead you are still working and do not want it re-assigned to the team, check this box.  If you are no longer working it, uncheck the box and it will be removed from your queue.",
    "displayOrder": -1,
    "externalOptions": false,
    "fieldType": "booleancheckbox",
    "formField": false,
    "groupName": "companyinformation",
    "hasUniqueValue": false,
    "hidden": false,
    "hubspotDefined": true,
    "label": "Meaningful Contact",
    "modificationMetadata": {
        "archivable": true,
        "readOnlyDefinition": true,
        "readOnlyOptions": false,
        "readOnlyValue": false
    },
    "name": "actively_working_lead",
    "numberDisplayHint": "formatted",
    "options": [
        {
            "description": "",
            "displayOrder": 1,
            "hidden": false,
            "label": "Peek",
            "value": "Peek"
        }
    ],
    "referencedObjectType": "COMPANY",
    "showCurrencySymbol": false,
    "type": "enumeration",
    "updatedAt": "2023-08-10T19:49:37.090Z",
    "updatedUserId": "47074899"
}

schema_attributes:

{
    "archived": "string",
    "calculated": "string",
    "calculationFormula": "string",
    "createdAt": "string",
    "createdUserId": "string",
    "dataSensitivity": "string",
    "dateDisplayHint": "string",
    "description": "string",
    "displayOrder": "string",
    "externalOptions": "string",
    "fieldType": "string",
    "formField": "string",
    "groupName": "string",
    "hasUniqueValue": "string",
    "hidden": "string",
    "hubspotDefined": "string",
    "label": "string",
    "modificationMetadata.archivable": "string",
    "modificationMetadata.readOnlyDefinition": "string",
    "modificationMetadata.readOnlyOptions": "string",
    "modificationMetadata.readOnlyValue": "string",
    "name": "string",
    "numberDisplayHint": "string",
    "options": [
        {
            "description": "string",
            "displayOrder": "string",
            "hidden": "string",
            "label": "string",
            "value": "string"
        }
    ],
    "referencedObjectType": "string",
    "showCurrencySymbol": "string",
    "type": "string",
    "updatedAt": "string",
    "updatedUserId": "string"
}

schema_name_id: 1508
schema_scan_id: 6408615
updated: 2026-04-03 07:17:36

Schema Scans: 15

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

Scan 6415286

duration: 0:00:12.779247

exit_message:

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

id: 6415286

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_companies_properties/2026-04-17/1776428271",
        "key": "raw/hubspot_molo_companies_properties/2026-04-17/1776428271/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_companies_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 4378868386500757149,
        "service_name": "drive-thru",
        "span_id": 4538836465066639550,
        "trace_id": 2441079818979715244
    }
}

running: False
schema_name_id: 1508
start_time: 2026-04-17 07:18:18
success: True
trace_id: 2441079818979715244

Scan 6414743

duration: 0:00:15.702597

exit_message:

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

id: 6414743

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_companies_properties/2026-04-16/1776341636",
        "key": "raw/hubspot_molo_companies_properties/2026-04-16/1776341636/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_companies_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 14436053041385998896,
        "service_name": "drive-thru",
        "span_id": 6796153965258419387,
        "trace_id": 12268369419676269123
    }
}

running: False
schema_name_id: 1508
start_time: 2026-04-16 07:14:37
success: True
trace_id: 12268369419676269123

Scan 6414256

duration: 0:00:13.085382

exit_message:

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

id: 6414256

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_companies_properties/2026-04-15/1776255585",
        "key": "raw/hubspot_molo_companies_properties/2026-04-15/1776255585/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_companies_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 4196479403296422001,
        "service_name": "drive-thru",
        "span_id": 10347923352631559293,
        "trace_id": 10781301866757609246
    }
}

running: False
schema_name_id: 1508
start_time: 2026-04-15 07:20:17
success: True
trace_id: 10781301866757609246

Scan 6413764

duration: 0:00:15.471386

exit_message:

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

id: 6413764

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_companies_properties/2026-04-14/1776168968",
        "key": "raw/hubspot_molo_companies_properties/2026-04-14/1776168968/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_companies_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 8768481570374157155,
        "service_name": "drive-thru",
        "span_id": 8454281707561920356,
        "trace_id": 16283597948977994158
    }
}

running: False
schema_name_id: 1508
start_time: 2026-04-14 07:16:39
success: True
trace_id: 16283597948977994158

Scan 6413209

duration: 0:00:12.866333

exit_message:

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

id: 6413209

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_companies_properties/2026-04-13/1776082702",
        "key": "raw/hubspot_molo_companies_properties/2026-04-13/1776082702/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_companies_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 11117980007359724399,
        "service_name": "drive-thru",
        "span_id": 5089527890496518844,
        "trace_id": 4782211442493617023
    }
}

running: False
schema_name_id: 1508
start_time: 2026-04-13 07:19:18
success: True
trace_id: 4782211442493617023

Scan 6412797

duration: 0:00:15.409273

exit_message:

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

id: 6412797

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_companies_properties/2026-04-12/1775996138",
        "key": "raw/hubspot_molo_companies_properties/2026-04-12/1775996138/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_companies_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 8898022581245161031,
        "service_name": "drive-thru",
        "span_id": 4746184312664522052,
        "trace_id": 7276826569708437574
    }
}

running: False
schema_name_id: 1508
start_time: 2026-04-12 07:16:20
success: True
trace_id: 7276826569708437574

Scan 6412413

duration: 0:00:12.896668

exit_message:

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

id: 6412413

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_companies_properties/2026-04-11/1775909622",
        "key": "raw/hubspot_molo_companies_properties/2026-04-11/1775909622/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_companies_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 2605151145163679236,
        "service_name": "drive-thru",
        "span_id": 11130309460142831752,
        "trace_id": 14523836574965688085
    }
}

running: False
schema_name_id: 1508
start_time: 2026-04-11 07:14:05
success: True
trace_id: 14523836574965688085

Scan 6411937

duration: 0:00:13.160397

exit_message:

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

id: 6411937

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_companies_properties/2026-04-10/1775823095",
        "key": "raw/hubspot_molo_companies_properties/2026-04-10/1775823095/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_companies_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 2783470238935600959,
        "service_name": "drive-thru",
        "span_id": 15132246224055554889,
        "trace_id": 12329259678468621338
    }
}

running: False
schema_name_id: 1508
start_time: 2026-04-10 07:12:02
success: True
trace_id: 12329259678468621338

Scan 6411434

duration: 0:00:15.352976

exit_message:

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

id: 6411434

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_companies_properties/2026-04-09/1775736717",
        "key": "raw/hubspot_molo_companies_properties/2026-04-09/1775736717/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_companies_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 6604999380533813708,
        "service_name": "drive-thru",
        "span_id": 4081515386579466002,
        "trace_id": 2179210673494500725
    }
}

running: False
schema_name_id: 1508
start_time: 2026-04-09 07:12:26
success: True
trace_id: 2179210673494500725

Scan 6410930

duration: 0:00:15.692753

exit_message:

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

id: 6410930

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_companies_properties/2026-04-08/1775650399",
        "key": "raw/hubspot_molo_companies_properties/2026-04-08/1775650399/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_companies_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 10939439984754951116,
        "service_name": "drive-thru",
        "span_id": 15708016383943067586,
        "trace_id": 6906773907864378780
    }
}

running: False
schema_name_id: 1508
start_time: 2026-04-08 07:13:59
success: True
trace_id: 6906773907864378780

Scan 6410417

duration: 0:00:13.095793

exit_message:

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

id: 6410417

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_companies_properties/2026-04-07/1775564201",
        "key": "raw/hubspot_molo_companies_properties/2026-04-07/1775564201/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_companies_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 17962289716812354460,
        "service_name": "drive-thru",
        "span_id": 496835955093394472,
        "trace_id": 14968310127984076260
    }
}

running: False
schema_name_id: 1508
start_time: 2026-04-07 07:17:11
success: True
trace_id: 14968310127984076260

Scan 6409867

duration: 0:00:15.363501

exit_message:

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

id: 6409867

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_companies_properties/2026-04-06/1775477861",
        "key": "raw/hubspot_molo_companies_properties/2026-04-06/1775477861/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_companies_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 10749234260360518916,
        "service_name": "drive-thru",
        "span_id": 803710784086610536,
        "trace_id": 6591229178851758592
    }
}

running: False
schema_name_id: 1508
start_time: 2026-04-06 07:18:08
success: True
trace_id: 6591229178851758592

Scan 6409459

duration: 0:00:12.941514

exit_message:

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

id: 6409459

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_companies_properties/2026-04-05/1775391147",
        "key": "raw/hubspot_molo_companies_properties/2026-04-05/1775391147/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_companies_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 9869935066779224085,
        "service_name": "drive-thru",
        "span_id": 16612778945671161291,
        "trace_id": 5246425496313737126
    }
}

running: False
schema_name_id: 1508
start_time: 2026-04-05 07:12:55
success: True
trace_id: 5246425496313737126

Scan 6409084

duration: 0:00:12.952937

exit_message:

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

id: 6409084

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_companies_properties/2026-04-04/1775304847",
        "key": "raw/hubspot_molo_companies_properties/2026-04-04/1775304847/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_companies_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 16224869056299051104,
        "service_name": "drive-thru",
        "span_id": 3274626046632594056,
        "trace_id": 3244834363018859941
    }
}

running: False
schema_name_id: 1508
start_time: 2026-04-04 07:15:49
success: True
trace_id: 3244834363018859941

Scan 6408615

duration: 0:00:15.428356

exit_message:

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

id: 6408615

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_companies_properties/2026-04-03/1775218600",
        "key": "raw/hubspot_molo_companies_properties/2026-04-03/1775218600/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_companies_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 6072922425139961752,
        "service_name": "drive-thru",
        "span_id": 15665690034822195067,
        "trace_id": 13441848729329083525
    }
}

running: False
schema_name_id: 1508
start_time: 2026-04-03 07:17:21
success: True
trace_id: 13441848729329083525

Partitions:

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

Schema:

attributes:

{
    "archived": "string",
    "calculated": "string",
    "calculationFormula": "string",
    "createdAt": "string",
    "createdUserId": "string",
    "dataSensitivity": "string",
    "dateDisplayHint": "string",
    "description": "string",
    "displayOrder": "string",
    "externalOptions": "string",
    "fieldType": "string",
    "formField": "string",
    "groupName": "string",
    "hasUniqueValue": "string",
    "hidden": "string",
    "hubspotDefined": "string",
    "label": "string",
    "modificationMetadata.archivable": "string",
    "modificationMetadata.readOnlyDefinition": "string",
    "modificationMetadata.readOnlyOptions": "string",
    "modificationMetadata.readOnlyValue": "string",
    "name": "string",
    "numberDisplayHint": "string",
    "options": [
        {
            "description": "string",
            "displayOrder": "string",
            "hidden": "string",
            "label": "string",
            "value": "string"
        }
    ],
    "referencedObjectType": "string",
    "showCurrencySymbol": "string",
    "type": "string",
    "updatedAt": "string",
    "updatedUserId": "string"
}

created: 2026-04-17 07:18:20

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_companies_properties`\n(\n`updatedAt`STRING,`createdAt`STRING,`name`STRING,`label`STRING,`type`STRING,`fieldType`STRING,`description`STRING,`groupName`STRING,`options`array>,`displayOrder`STRING,`calculated`STRING,`externalOptions`STRING,`hasUniqueValue`STRING,`hidden`STRING,`hubspotDefined`STRING,`modificationMetadata`struct<`archivable`:STRING,`readOnlyDefinition`:STRING,`readOnlyValue`:STRING,`readOnlyOptions`:STRING>,`formField`STRING,`dataSensitivity`STRING,`createdUserId`STRING,`updatedUserId`STRING,`archived`STRING,`showCurrencySymbol`STRING,`numberDisplayHint`STRING,`calculationFormula`STRING,`referencedObjectType`STRING,`dateDisplayHint`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_companies_properties/2026-04-17/1776428271'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_companies_properties`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_companies_properties"
}

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:40:13",
        "disabled": false,
        "format": "raw",
        "id": 1508,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_stage_drivethru",
            "table": "hubspot_molo_companies_properties"
        },
        "type": "drivethrujson"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "archived": "string",
            "calculated": "string",
            "calculationFormula": "string",
            "createdAt": "string",
            "createdUserId": "string",
            "dataSensitivity": "string",
            "dateDisplayHint": "string",
            "description": "string",
            "displayOrder": "string",
            "externalOptions": "string",
            "fieldType": "string",
            "formField": "string",
            "groupName": "string",
            "hasUniqueValue": "string",
            "hidden": "string",
            "hubspotDefined": "string",
            "label": "string",
            "modificationMetadata.archivable": "string",
            "modificationMetadata.readOnlyDefinition": "string",
            "modificationMetadata.readOnlyOptions": "string",
            "modificationMetadata.readOnlyValue": "string",
            "name": "string",
            "numberDisplayHint": "string",
            "options": [
                {
                    "description": "string",
                    "displayOrder": "string",
                    "hidden": "string",
                    "label": "string",
                    "value": "string"
                }
            ],
            "referencedObjectType": "string",
            "showCurrencySymbol": "string",
            "type": "string",
            "updatedAt": "string",
            "updatedUserId": "string"
        },
        "created": "2026-04-17 07:18:20",
        "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_companies_properties`\n(\n`updatedAt`STRING,`createdAt`STRING,`name`STRING,`label`STRING,`type`STRING,`fieldType`STRING,`description`STRING,`groupName`STRING,`options`array>,`displayOrder`STRING,`calculated`STRING,`externalOptions`STRING,`hasUniqueValue`STRING,`hidden`STRING,`hubspotDefined`STRING,`modificationMetadata`struct<`archivable`:STRING,`readOnlyDefinition`:STRING,`readOnlyValue`:STRING,`readOnlyOptions`:STRING>,`formField`STRING,`dataSensitivity`STRING,`createdUserId`STRING,`updatedUserId`STRING,`archived`STRING,`showCurrencySymbol`STRING,`numberDisplayHint`STRING,`calculationFormula`STRING,`referencedObjectType`STRING,`dateDisplayHint`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_companies_properties/2026-04-17/1776428271'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_companies_properties`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_companies_properties"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}