Schema Info

Schema Name: sfdl_prod_drivethru.hubspot_molo_deals_properties

created: 2022-12-01 13:35:35
disabled: False
format: raw
id: 1244
is_partitioned: False
is_schema_datatyped: False

name:

{
    "database": "sfdl_prod_drivethru",
    "table": "hubspot_molo_deals_properties"
}

type: drivethrujson

Schema Versions: 15

Version 1718120

created: 2026-04-17 07:22:08

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_properties/2026-04-17/1776428517
id: 1718120
processed: 1

raw_data:

{
    "archived": false,
    "calculated": false,
    "calculationFormula": "if is_present(hs_exchange_rate) then (amount * hs_exchange_rate) else amount",
    "createdAt": "2022-07-01T17:53:21.312Z",
    "createdUserId": "44200137",
    "currencyPropertyName": "deal_currency_code",
    "dataSensitivity": "non_sensitive",
    "dateDisplayHint": "time_since",
    "description": "",
    "displayOrder": -1,
    "externalOptions": false,
    "fieldType": "booleancheckbox",
    "formField": true,
    "groupName": "dealinformation",
    "hasUniqueValue": false,
    "hidden": false,
    "hubspotDefined": true,
    "label": "Accounting Integration Desired",
    "modificationMetadata": {
        "archivable": true,
        "readOnlyDefinition": true,
        "readOnlyOptions": false,
        "readOnlyValue": false
    },
    "name": "accounting_integration_desired",
    "numberDisplayHint": "formatted",
    "options": [
        {
            "description": "",
            "displayOrder": 1,
            "hidden": false,
            "label": "Cash",
            "value": "Cash"
        }
    ],
    "referencedObjectType": "OWNER",
    "showCurrencySymbol": false,
    "type": "enumeration",
    "updatedAt": "2022-07-01T17:53:21.312Z",
    "updatedUserId": "44200137"
}

schema_attributes:

{
    "archived": "string",
    "calculated": "string",
    "calculationFormula": "string",
    "createdAt": "string",
    "createdUserId": "string",
    "currencyPropertyName": "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: 1244
schema_scan_id: 162173160
updated: 2026-04-17 07:22:19

Version 1716894

created: 2026-04-16 07:17:34

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_properties/2026-04-16/1776341850
id: 1716894
processed: 1

raw_data:

{
    "archived": false,
    "calculated": false,
    "calculationFormula": "if is_present(hs_exchange_rate) then (amount * hs_exchange_rate) else amount",
    "createdAt": "2022-07-01T17:53:21.312Z",
    "createdUserId": "44200137",
    "currencyPropertyName": "deal_currency_code",
    "dataSensitivity": "non_sensitive",
    "dateDisplayHint": "time_since",
    "description": "",
    "displayOrder": -1,
    "externalOptions": false,
    "fieldType": "booleancheckbox",
    "formField": true,
    "groupName": "dealinformation",
    "hasUniqueValue": false,
    "hidden": false,
    "hubspotDefined": true,
    "label": "Accounting Integration Desired",
    "modificationMetadata": {
        "archivable": true,
        "readOnlyDefinition": true,
        "readOnlyOptions": false,
        "readOnlyValue": false
    },
    "name": "accounting_integration_desired",
    "numberDisplayHint": "formatted",
    "options": [
        {
            "description": "",
            "displayOrder": 1,
            "hidden": false,
            "label": "Cash",
            "value": "Cash"
        }
    ],
    "referencedObjectType": "OWNER",
    "showCurrencySymbol": false,
    "type": "enumeration",
    "updatedAt": "2022-07-01T17:53:21.312Z",
    "updatedUserId": "44200137"
}

schema_attributes:

{
    "archived": "string",
    "calculated": "string",
    "calculationFormula": "string",
    "createdAt": "string",
    "createdUserId": "string",
    "currencyPropertyName": "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: 1244
schema_scan_id: 162117420
updated: 2026-04-16 07:17:46

Version 1715692

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_deals_properties`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_deals_properties`\n(\n`updatedAt`STRING,`createdAt`STRING,`name`STRING,`label`STRING,`type`STRING,`fieldType`STRING,`description`STRING,`groupName`STRING,`options`array>,`createdUserId`STRING,`updatedUserId`STRING,`displayOrder`STRING,`calculated`STRING,`externalOptions`STRING,`archived`STRING,`hasUniqueValue`STRING,`hidden`STRING,`showCurrencySymbol`STRING,`modificationMetadata`struct<`archivable`:STRING,`readOnlyDefinition`:STRING,`readOnlyValue`:STRING,`readOnlyOptions`:STRING>,`formField`STRING,`numberDisplayHint`STRING,`dataSensitivity`STRING,`hubspotDefined`STRING,`currencyPropertyName`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-prod/raw/hubspot_molo_deals_properties/2026-04-15/1776255753'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_deals_properties"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_properties/2026-04-15/1776255753
id: 1715692
processed: 1

raw_data:

{
    "archived": false,
    "calculated": false,
    "calculationFormula": "if is_present(hs_exchange_rate) then (amount * hs_exchange_rate) else amount",
    "createdAt": "2022-07-01T17:53:21.312Z",
    "createdUserId": "44200137",
    "currencyPropertyName": "deal_currency_code",
    "dataSensitivity": "non_sensitive",
    "dateDisplayHint": "time_since",
    "description": "",
    "displayOrder": -1,
    "externalOptions": false,
    "fieldType": "booleancheckbox",
    "formField": true,
    "groupName": "dealinformation",
    "hasUniqueValue": false,
    "hidden": false,
    "hubspotDefined": true,
    "label": "Accounting Integration Desired",
    "modificationMetadata": {
        "archivable": true,
        "readOnlyDefinition": true,
        "readOnlyOptions": false,
        "readOnlyValue": false
    },
    "name": "accounting_integration_desired",
    "numberDisplayHint": "formatted",
    "options": [
        {
            "description": "",
            "displayOrder": 1,
            "hidden": false,
            "label": "Cash",
            "value": "Cash"
        }
    ],
    "referencedObjectType": "OWNER",
    "showCurrencySymbol": false,
    "type": "enumeration",
    "updatedAt": "2022-07-01T17:53:21.312Z",
    "updatedUserId": "44200137"
}

schema_attributes:

{
    "archived": "string",
    "calculated": "string",
    "calculationFormula": "string",
    "createdAt": "string",
    "createdUserId": "string",
    "currencyPropertyName": "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: 1244
schema_scan_id: 162061874
updated: 2026-04-15 07:23:04

Version 1714505

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_properties/2026-04-14/1776168982
id: 1714505
processed: 1

raw_data:

{
    "archived": false,
    "calculated": false,
    "calculationFormula": "if is_present(hs_exchange_rate) then (amount * hs_exchange_rate) else amount",
    "createdAt": "2022-07-01T17:53:21.312Z",
    "createdUserId": "44200137",
    "currencyPropertyName": "deal_currency_code",
    "dataSensitivity": "non_sensitive",
    "dateDisplayHint": "time_since",
    "description": "",
    "displayOrder": -1,
    "externalOptions": false,
    "fieldType": "booleancheckbox",
    "formField": true,
    "groupName": "dealinformation",
    "hasUniqueValue": false,
    "hidden": false,
    "hubspotDefined": true,
    "label": "Accounting Integration Desired",
    "modificationMetadata": {
        "archivable": true,
        "readOnlyDefinition": true,
        "readOnlyOptions": false,
        "readOnlyValue": false
    },
    "name": "accounting_integration_desired",
    "numberDisplayHint": "formatted",
    "options": [
        {
            "description": "",
            "displayOrder": 1,
            "hidden": false,
            "label": "Cash",
            "value": "Cash"
        }
    ],
    "referencedObjectType": "OWNER",
    "showCurrencySymbol": false,
    "type": "enumeration",
    "updatedAt": "2022-07-01T17:53:21.312Z",
    "updatedUserId": "44200137"
}

schema_attributes:

{
    "archived": "string",
    "calculated": "string",
    "calculationFormula": "string",
    "createdAt": "string",
    "createdUserId": "string",
    "currencyPropertyName": "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: 1244
schema_scan_id: 162006453
updated: 2026-04-14 07:17:19

Version 1713281

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_properties/2026-04-13/1776082654
id: 1713281
processed: 1

raw_data:

{
    "archived": false,
    "calculated": false,
    "calculationFormula": "if is_present(hs_exchange_rate) then (amount * hs_exchange_rate) else amount",
    "createdAt": "2022-07-01T17:53:21.312Z",
    "createdUserId": "44200137",
    "currencyPropertyName": "deal_currency_code",
    "dataSensitivity": "non_sensitive",
    "dateDisplayHint": "time_since",
    "description": "",
    "displayOrder": -1,
    "externalOptions": false,
    "fieldType": "booleancheckbox",
    "formField": true,
    "groupName": "dealinformation",
    "hasUniqueValue": false,
    "hidden": false,
    "hubspotDefined": true,
    "label": "Accounting Integration Desired",
    "modificationMetadata": {
        "archivable": true,
        "readOnlyDefinition": true,
        "readOnlyOptions": false,
        "readOnlyValue": false
    },
    "name": "accounting_integration_desired",
    "numberDisplayHint": "formatted",
    "options": [
        {
            "description": "",
            "displayOrder": 1,
            "hidden": false,
            "label": "Cash",
            "value": "Cash"
        }
    ],
    "referencedObjectType": "OWNER",
    "showCurrencySymbol": false,
    "type": "enumeration",
    "updatedAt": "2022-07-01T17:53:21.312Z",
    "updatedUserId": "44200137"
}

schema_attributes:

{
    "archived": "string",
    "calculated": "string",
    "calculationFormula": "string",
    "createdAt": "string",
    "createdUserId": "string",
    "currencyPropertyName": "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: 1244
schema_scan_id: 161948408
updated: 2026-04-13 07:19:25

Version 1712091

created: 2026-04-12 07:15:52

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_properties/2026-04-12/1775996140
id: 1712091
processed: 1

raw_data:

{
    "archived": false,
    "calculated": false,
    "calculationFormula": "if is_present(hs_exchange_rate) then (amount * hs_exchange_rate) else amount",
    "createdAt": "2022-07-01T17:53:21.312Z",
    "createdUserId": "44200137",
    "currencyPropertyName": "deal_currency_code",
    "dataSensitivity": "non_sensitive",
    "dateDisplayHint": "time_since",
    "description": "",
    "displayOrder": -1,
    "externalOptions": false,
    "fieldType": "booleancheckbox",
    "formField": true,
    "groupName": "dealinformation",
    "hasUniqueValue": false,
    "hidden": false,
    "hubspotDefined": true,
    "label": "Accounting Integration Desired",
    "modificationMetadata": {
        "archivable": true,
        "readOnlyDefinition": true,
        "readOnlyOptions": false,
        "readOnlyValue": false
    },
    "name": "accounting_integration_desired",
    "numberDisplayHint": "formatted",
    "options": [
        {
            "description": "",
            "displayOrder": 1,
            "hidden": false,
            "label": "Cash",
            "value": "Cash"
        }
    ],
    "referencedObjectType": "OWNER",
    "showCurrencySymbol": false,
    "type": "enumeration",
    "updatedAt": "2022-07-01T17:53:21.312Z",
    "updatedUserId": "44200137"
}

schema_attributes:

{
    "archived": "string",
    "calculated": "string",
    "calculationFormula": "string",
    "createdAt": "string",
    "createdUserId": "string",
    "currencyPropertyName": "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: 1244
schema_scan_id: 161899582
updated: 2026-04-12 07:16:03

Version 1710883

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_properties/2026-04-11/1775909689
id: 1710883
processed: 1

raw_data:

{
    "archived": false,
    "calculated": false,
    "calculationFormula": "if is_present(hs_exchange_rate) then (amount * hs_exchange_rate) else amount",
    "createdAt": "2022-07-01T17:53:21.312Z",
    "createdUserId": "44200137",
    "currencyPropertyName": "deal_currency_code",
    "dataSensitivity": "non_sensitive",
    "dateDisplayHint": "time_since",
    "description": "",
    "displayOrder": -1,
    "externalOptions": false,
    "fieldType": "booleancheckbox",
    "formField": true,
    "groupName": "dealinformation",
    "hasUniqueValue": false,
    "hidden": false,
    "hubspotDefined": true,
    "label": "Accounting Integration Desired",
    "modificationMetadata": {
        "archivable": true,
        "readOnlyDefinition": true,
        "readOnlyOptions": false,
        "readOnlyValue": false
    },
    "name": "accounting_integration_desired",
    "numberDisplayHint": "formatted",
    "options": [
        {
            "description": "",
            "displayOrder": 1,
            "hidden": false,
            "label": "Cash",
            "value": "Cash"
        }
    ],
    "referencedObjectType": "OWNER",
    "showCurrencySymbol": false,
    "type": "enumeration",
    "updatedAt": "2022-07-01T17:53:21.312Z",
    "updatedUserId": "44200137"
}

schema_attributes:

{
    "archived": "string",
    "calculated": "string",
    "calculationFormula": "string",
    "createdAt": "string",
    "createdUserId": "string",
    "currencyPropertyName": "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: 1244
schema_scan_id: 161846918
updated: 2026-04-11 07:19:24

Version 1709703

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_properties/2026-04-10/1775823530
id: 1709703
processed: 1

raw_data:

{
    "archived": false,
    "calculated": false,
    "calculationFormula": "if is_present(hs_exchange_rate) then (amount * hs_exchange_rate) else amount",
    "createdAt": "2022-07-01T17:53:21.312Z",
    "createdUserId": "44200137",
    "currencyPropertyName": "deal_currency_code",
    "dataSensitivity": "non_sensitive",
    "dateDisplayHint": "time_since",
    "description": "",
    "displayOrder": -1,
    "externalOptions": false,
    "fieldType": "booleancheckbox",
    "formField": true,
    "groupName": "dealinformation",
    "hasUniqueValue": false,
    "hidden": false,
    "hubspotDefined": true,
    "label": "Accounting Integration Desired",
    "modificationMetadata": {
        "archivable": true,
        "readOnlyDefinition": true,
        "readOnlyOptions": false,
        "readOnlyValue": false
    },
    "name": "accounting_integration_desired",
    "numberDisplayHint": "formatted",
    "options": [
        {
            "description": "",
            "displayOrder": 1,
            "hidden": false,
            "label": "Cash",
            "value": "Cash"
        }
    ],
    "referencedObjectType": "OWNER",
    "showCurrencySymbol": false,
    "type": "enumeration",
    "updatedAt": "2022-07-01T17:53:21.312Z",
    "updatedUserId": "44200137"
}

schema_attributes:

{
    "archived": "string",
    "calculated": "string",
    "calculationFormula": "string",
    "createdAt": "string",
    "createdUserId": "string",
    "currencyPropertyName": "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: 1244
schema_scan_id: 161792157
updated: 2026-04-10 07:19:06

Version 1708556

created: 2026-04-09 07:20:03

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_properties/2026-04-09/1775737187
id: 1708556
processed: 1

raw_data:

{
    "archived": false,
    "calculated": false,
    "calculationFormula": "if is_present(hs_exchange_rate) then (amount * hs_exchange_rate) else amount",
    "createdAt": "2022-07-01T17:53:21.312Z",
    "createdUserId": "44200137",
    "currencyPropertyName": "deal_currency_code",
    "dataSensitivity": "non_sensitive",
    "dateDisplayHint": "time_since",
    "description": "",
    "displayOrder": -1,
    "externalOptions": false,
    "fieldType": "booleancheckbox",
    "formField": true,
    "groupName": "dealinformation",
    "hasUniqueValue": false,
    "hidden": false,
    "hubspotDefined": true,
    "label": "Accounting Integration Desired",
    "modificationMetadata": {
        "archivable": true,
        "readOnlyDefinition": true,
        "readOnlyOptions": false,
        "readOnlyValue": false
    },
    "name": "accounting_integration_desired",
    "numberDisplayHint": "formatted",
    "options": [
        {
            "description": "",
            "displayOrder": 1,
            "hidden": false,
            "label": "Cash",
            "value": "Cash"
        }
    ],
    "referencedObjectType": "OWNER",
    "showCurrencySymbol": false,
    "type": "enumeration",
    "updatedAt": "2022-07-01T17:53:21.312Z",
    "updatedUserId": "44200137"
}

schema_attributes:

{
    "archived": "string",
    "calculated": "string",
    "calculationFormula": "string",
    "createdAt": "string",
    "createdUserId": "string",
    "currencyPropertyName": "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: 1244
schema_scan_id: 161736327
updated: 2026-04-09 07:20:14

Version 1707368

created: 2026-04-08 07:16:43

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_properties/2026-04-08/1775650590
id: 1707368
processed: 1

raw_data:

{
    "archived": false,
    "calculated": false,
    "calculationFormula": "if is_present(hs_exchange_rate) then (amount * hs_exchange_rate) else amount",
    "createdAt": "2022-07-01T17:53:21.312Z",
    "createdUserId": "44200137",
    "currencyPropertyName": "deal_currency_code",
    "dataSensitivity": "non_sensitive",
    "dateDisplayHint": "time_since",
    "description": "",
    "displayOrder": -1,
    "externalOptions": false,
    "fieldType": "booleancheckbox",
    "formField": true,
    "groupName": "dealinformation",
    "hasUniqueValue": false,
    "hidden": false,
    "hubspotDefined": true,
    "label": "Accounting Integration Desired",
    "modificationMetadata": {
        "archivable": true,
        "readOnlyDefinition": true,
        "readOnlyOptions": false,
        "readOnlyValue": false
    },
    "name": "accounting_integration_desired",
    "numberDisplayHint": "formatted",
    "options": [
        {
            "description": "",
            "displayOrder": 1,
            "hidden": false,
            "label": "Cash",
            "value": "Cash"
        }
    ],
    "referencedObjectType": "OWNER",
    "showCurrencySymbol": false,
    "type": "enumeration",
    "updatedAt": "2022-07-01T17:53:21.312Z",
    "updatedUserId": "44200137"
}

schema_attributes:

{
    "archived": "string",
    "calculated": "string",
    "calculationFormula": "string",
    "createdAt": "string",
    "createdUserId": "string",
    "currencyPropertyName": "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: 1244
schema_scan_id: 161681494
updated: 2026-04-08 07:16:57

Version 1706177

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_deals_properties`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_deals_properties`\n(\n`updatedAt`STRING,`createdAt`STRING,`name`STRING,`label`STRING,`type`STRING,`fieldType`STRING,`description`STRING,`groupName`STRING,`options`array>,`createdUserId`STRING,`updatedUserId`STRING,`displayOrder`STRING,`calculated`STRING,`externalOptions`STRING,`archived`STRING,`hasUniqueValue`STRING,`hidden`STRING,`showCurrencySymbol`STRING,`modificationMetadata`struct<`archivable`:STRING,`readOnlyDefinition`:STRING,`readOnlyValue`:STRING,`readOnlyOptions`:STRING>,`formField`STRING,`numberDisplayHint`STRING,`dataSensitivity`STRING,`hubspotDefined`STRING,`currencyPropertyName`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-prod/raw/hubspot_molo_deals_properties/2026-04-07/1775564249'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_deals_properties"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_properties/2026-04-07/1775564249
id: 1706177
processed: 1

raw_data:

{
    "archived": false,
    "calculated": false,
    "calculationFormula": "if is_present(hs_exchange_rate) then (amount * hs_exchange_rate) else amount",
    "createdAt": "2022-07-01T17:53:21.312Z",
    "createdUserId": "44200137",
    "currencyPropertyName": "deal_currency_code",
    "dataSensitivity": "non_sensitive",
    "dateDisplayHint": "time_since",
    "description": "",
    "displayOrder": -1,
    "externalOptions": false,
    "fieldType": "booleancheckbox",
    "formField": true,
    "groupName": "dealinformation",
    "hasUniqueValue": false,
    "hidden": false,
    "hubspotDefined": true,
    "label": "Accounting Integration Desired",
    "modificationMetadata": {
        "archivable": true,
        "readOnlyDefinition": true,
        "readOnlyOptions": false,
        "readOnlyValue": false
    },
    "name": "accounting_integration_desired",
    "numberDisplayHint": "formatted",
    "options": [
        {
            "description": "",
            "displayOrder": 1,
            "hidden": false,
            "label": "Cash",
            "value": "Cash"
        }
    ],
    "referencedObjectType": "OWNER",
    "showCurrencySymbol": false,
    "type": "enumeration",
    "updatedAt": "2022-07-01T17:53:21.312Z",
    "updatedUserId": "44200137"
}

schema_attributes:

{
    "archived": "string",
    "calculated": "string",
    "calculationFormula": "string",
    "createdAt": "string",
    "createdUserId": "string",
    "currencyPropertyName": "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: 1244
schema_scan_id: 161625276
updated: 2026-04-07 07:17:57

Version 1704966

created: 2026-04-06 07:19:21

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_properties/2026-04-06/1775477957
id: 1704966
processed: 1

raw_data:

{
    "archived": false,
    "calculated": false,
    "calculationFormula": "if is_present(hs_exchange_rate) then (amount * hs_exchange_rate) else amount",
    "createdAt": "2022-07-01T17:53:21.312Z",
    "createdUserId": "44200137",
    "currencyPropertyName": "deal_currency_code",
    "dataSensitivity": "non_sensitive",
    "dateDisplayHint": "time_since",
    "description": "",
    "displayOrder": -1,
    "externalOptions": false,
    "fieldType": "booleancheckbox",
    "formField": true,
    "groupName": "dealinformation",
    "hasUniqueValue": false,
    "hidden": false,
    "hubspotDefined": true,
    "label": "Accounting Integration Desired",
    "modificationMetadata": {
        "archivable": true,
        "readOnlyDefinition": true,
        "readOnlyOptions": false,
        "readOnlyValue": false
    },
    "name": "accounting_integration_desired",
    "numberDisplayHint": "formatted",
    "options": [
        {
            "description": "",
            "displayOrder": 1,
            "hidden": false,
            "label": "Cash",
            "value": "Cash"
        }
    ],
    "referencedObjectType": "OWNER",
    "showCurrencySymbol": false,
    "type": "enumeration",
    "updatedAt": "2022-07-01T17:53:21.312Z",
    "updatedUserId": "44200137"
}

schema_attributes:

{
    "archived": "string",
    "calculated": "string",
    "calculationFormula": "string",
    "createdAt": "string",
    "createdUserId": "string",
    "currencyPropertyName": "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: 1244
schema_scan_id: 161567414
updated: 2026-04-06 07:19:32

Version 1703732

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_properties/2026-04-05/1775391585
id: 1703732
processed: 1

raw_data:

{
    "archived": false,
    "calculated": false,
    "calculationFormula": "if is_present(hs_exchange_rate) then (amount * hs_exchange_rate) else amount",
    "createdAt": "2022-07-01T17:53:21.312Z",
    "createdUserId": "44200137",
    "currencyPropertyName": "deal_currency_code",
    "dataSensitivity": "non_sensitive",
    "dateDisplayHint": "time_since",
    "description": "",
    "displayOrder": -1,
    "externalOptions": false,
    "fieldType": "booleancheckbox",
    "formField": true,
    "groupName": "dealinformation",
    "hasUniqueValue": false,
    "hidden": false,
    "hubspotDefined": true,
    "label": "Accounting Integration Desired",
    "modificationMetadata": {
        "archivable": true,
        "readOnlyDefinition": true,
        "readOnlyOptions": false,
        "readOnlyValue": false
    },
    "name": "accounting_integration_desired",
    "numberDisplayHint": "formatted",
    "options": [
        {
            "description": "",
            "displayOrder": 1,
            "hidden": false,
            "label": "Cash",
            "value": "Cash"
        }
    ],
    "referencedObjectType": "OWNER",
    "showCurrencySymbol": false,
    "type": "enumeration",
    "updatedAt": "2022-07-01T17:53:21.312Z",
    "updatedUserId": "44200137"
}

schema_attributes:

{
    "archived": "string",
    "calculated": "string",
    "calculationFormula": "string",
    "createdAt": "string",
    "createdUserId": "string",
    "currencyPropertyName": "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: 1244
schema_scan_id: 161520033
updated: 2026-04-05 07:20:31

Version 1702589

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_properties/2026-04-04/1775304944
id: 1702589
processed: 1

raw_data:

{
    "archived": false,
    "calculated": false,
    "calculationFormula": "if is_present(hs_exchange_rate) then (amount * hs_exchange_rate) else amount",
    "createdAt": "2022-07-01T17:53:21.312Z",
    "createdUserId": "44200137",
    "currencyPropertyName": "deal_currency_code",
    "dataSensitivity": "non_sensitive",
    "dateDisplayHint": "time_since",
    "description": "",
    "displayOrder": -1,
    "externalOptions": false,
    "fieldType": "booleancheckbox",
    "formField": true,
    "groupName": "dealinformation",
    "hasUniqueValue": false,
    "hidden": false,
    "hubspotDefined": true,
    "label": "Accounting Integration Desired",
    "modificationMetadata": {
        "archivable": true,
        "readOnlyDefinition": true,
        "readOnlyOptions": false,
        "readOnlyValue": false
    },
    "name": "accounting_integration_desired",
    "numberDisplayHint": "formatted",
    "options": [
        {
            "description": "",
            "displayOrder": 1,
            "hidden": false,
            "label": "Cash",
            "value": "Cash"
        }
    ],
    "referencedObjectType": "OWNER",
    "showCurrencySymbol": false,
    "type": "enumeration",
    "updatedAt": "2022-07-01T17:53:21.312Z",
    "updatedUserId": "44200137"
}

schema_attributes:

{
    "archived": "string",
    "calculated": "string",
    "calculationFormula": "string",
    "createdAt": "string",
    "createdUserId": "string",
    "currencyPropertyName": "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: 1244
schema_scan_id: 161466474
updated: 2026-04-04 07:16:49

Version 1701401

created: 2026-04-03 07:20:49

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_deals_properties/2026-04-03/1775218831
id: 1701401
processed: 1

raw_data:

{
    "archived": false,
    "calculated": false,
    "calculationFormula": "if is_present(hs_exchange_rate) then (amount * hs_exchange_rate) else amount",
    "createdAt": "2022-07-01T17:53:21.312Z",
    "createdUserId": "44200137",
    "currencyPropertyName": "deal_currency_code",
    "dataSensitivity": "non_sensitive",
    "dateDisplayHint": "time_since",
    "description": "",
    "displayOrder": -1,
    "externalOptions": false,
    "fieldType": "booleancheckbox",
    "formField": true,
    "groupName": "dealinformation",
    "hasUniqueValue": false,
    "hidden": false,
    "hubspotDefined": true,
    "label": "Accounting Integration Desired",
    "modificationMetadata": {
        "archivable": true,
        "readOnlyDefinition": true,
        "readOnlyOptions": false,
        "readOnlyValue": false
    },
    "name": "accounting_integration_desired",
    "numberDisplayHint": "formatted",
    "options": [
        {
            "description": "",
            "displayOrder": 1,
            "hidden": false,
            "label": "Cash",
            "value": "Cash"
        }
    ],
    "referencedObjectType": "OWNER",
    "showCurrencySymbol": false,
    "type": "enumeration",
    "updatedAt": "2022-07-01T17:53:21.312Z",
    "updatedUserId": "44200137"
}

schema_attributes:

{
    "archived": "string",
    "calculated": "string",
    "calculationFormula": "string",
    "createdAt": "string",
    "createdUserId": "string",
    "currencyPropertyName": "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: 1244
schema_scan_id: 161408661
updated: 2026-04-03 07:21:01

Schema Scans: 15

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

Scan 162173160

duration: 0:00:12.716412

exit_message:

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

id: 162173160

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_deals_properties/2026-04-17/1776428517",
        "key": "raw/hubspot_molo_deals_properties/2026-04-17/1776428517/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_deals_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 9878040725531196824,
        "service_name": "drive-thru",
        "span_id": 12696801847502174232,
        "trace_id": 6840414300751667503
    }
}

running: False
schema_name_id: 1244
start_time: 2026-04-17 07:22:07
success: True
trace_id: 6840414300751667503

Scan 162117420

duration: 0:00:12.882878

exit_message:

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

id: 162117420

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_deals_properties/2026-04-16/1776341850",
        "key": "raw/hubspot_molo_deals_properties/2026-04-16/1776341850/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_deals_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 13472865468762440125,
        "service_name": "drive-thru",
        "span_id": 14947990900438568420,
        "trace_id": 6064179412587340472
    }
}

running: False
schema_name_id: 1244
start_time: 2026-04-16 07:17:33
success: True
trace_id: 6064179412587340472

Scan 162061874

duration: 0:00:15.171820

exit_message:

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

id: 162061874

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_deals_properties/2026-04-15/1776255753",
        "key": "raw/hubspot_molo_deals_properties/2026-04-15/1776255753/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_deals_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 17979070533396928884,
        "service_name": "drive-thru",
        "span_id": 3905867197970033784,
        "trace_id": 10340840059730833487
    }
}

running: False
schema_name_id: 1244
start_time: 2026-04-15 07:22:49
success: True
trace_id: 10340840059730833487

Scan 162006453

duration: 0:00:12.563545

exit_message:

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

id: 162006453

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_deals_properties/2026-04-14/1776168982",
        "key": "raw/hubspot_molo_deals_properties/2026-04-14/1776168982/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_deals_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 12848474329949396191,
        "service_name": "drive-thru",
        "span_id": 7351943128319781337,
        "trace_id": 15101019897647909693
    }
}

running: False
schema_name_id: 1244
start_time: 2026-04-14 07:17:06
success: True
trace_id: 15101019897647909693

Scan 161948408

duration: 0:00:12.528508

exit_message:

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

id: 161948408

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_deals_properties/2026-04-13/1776082654",
        "key": "raw/hubspot_molo_deals_properties/2026-04-13/1776082654/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_deals_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 15371008911392499858,
        "service_name": "drive-thru",
        "span_id": 3480791262266406419,
        "trace_id": 597343574204491978
    }
}

running: False
schema_name_id: 1244
start_time: 2026-04-13 07:19:12
success: True
trace_id: 597343574204491978

Scan 161899582

duration: 0:00:12.451816

exit_message:

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

id: 161899582

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_deals_properties/2026-04-12/1775996140",
        "key": "raw/hubspot_molo_deals_properties/2026-04-12/1775996140/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_deals_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 17666531544882040295,
        "service_name": "drive-thru",
        "span_id": 3941600455329295494,
        "trace_id": 13485690935755273735
    }
}

running: False
schema_name_id: 1244
start_time: 2026-04-12 07:15:51
success: True
trace_id: 13485690935755273735

Scan 161846918

duration: 0:00:12.639925

exit_message:

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

id: 161846918

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_deals_properties/2026-04-11/1775909689",
        "key": "raw/hubspot_molo_deals_properties/2026-04-11/1775909689/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_deals_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 9259765981681323880,
        "service_name": "drive-thru",
        "span_id": 14651660788629481860,
        "trace_id": 12535880539695854145
    }
}

running: False
schema_name_id: 1244
start_time: 2026-04-11 07:19:11
success: True
trace_id: 12535880539695854145

Scan 161792157

duration: 0:00:12.656807

exit_message:

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

id: 161792157

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_deals_properties/2026-04-10/1775823530",
        "key": "raw/hubspot_molo_deals_properties/2026-04-10/1775823530/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_deals_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 30309416872235623,
        "service_name": "drive-thru",
        "span_id": 3039131404428479735,
        "trace_id": 6362821812042170442
    }
}

running: False
schema_name_id: 1244
start_time: 2026-04-10 07:18:54
success: True
trace_id: 6362821812042170442

Scan 161736327

duration: 0:00:12.538318

exit_message:

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

id: 161736327

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_deals_properties/2026-04-09/1775737187",
        "key": "raw/hubspot_molo_deals_properties/2026-04-09/1775737187/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_deals_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 7301000255683192192,
        "service_name": "drive-thru",
        "span_id": 4977624740420430110,
        "trace_id": 12671030557932214548
    }
}

running: False
schema_name_id: 1244
start_time: 2026-04-09 07:20:02
success: True
trace_id: 12671030557932214548

Scan 161681494

duration: 0:00:15.066831

exit_message:

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

id: 161681494

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_deals_properties/2026-04-08/1775650590",
        "key": "raw/hubspot_molo_deals_properties/2026-04-08/1775650590/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_deals_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 10772308525054102526,
        "service_name": "drive-thru",
        "span_id": 4886369132909201944,
        "trace_id": 16406235689817087895
    }
}

running: False
schema_name_id: 1244
start_time: 2026-04-08 07:16:42
success: True
trace_id: 16406235689817087895

Scan 161625276

duration: 0:00:15.174331

exit_message:

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

id: 161625276

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_deals_properties/2026-04-07/1775564249",
        "key": "raw/hubspot_molo_deals_properties/2026-04-07/1775564249/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_deals_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 8985398551600220234,
        "service_name": "drive-thru",
        "span_id": 7628039564285984742,
        "trace_id": 9425078585829859789
    }
}

running: False
schema_name_id: 1244
start_time: 2026-04-07 07:17:42
success: True
trace_id: 9425078585829859789

Scan 161567414

duration: 0:00:12.606655

exit_message:

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

id: 161567414

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_deals_properties/2026-04-06/1775477957",
        "key": "raw/hubspot_molo_deals_properties/2026-04-06/1775477957/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_deals_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 18191041033103421724,
        "service_name": "drive-thru",
        "span_id": 13338224930648655030,
        "trace_id": 10000202725963843846
    }
}

running: False
schema_name_id: 1244
start_time: 2026-04-06 07:19:20
success: True
trace_id: 10000202725963843846

Scan 161520033

duration: 0:00:12.770683

exit_message:

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

id: 161520033

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_deals_properties/2026-04-05/1775391585",
        "key": "raw/hubspot_molo_deals_properties/2026-04-05/1775391585/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_deals_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 14672032634185400309,
        "service_name": "drive-thru",
        "span_id": 12624187584372234630,
        "trace_id": 10228032539657834991
    }
}

running: False
schema_name_id: 1244
start_time: 2026-04-05 07:20:19
success: True
trace_id: 10228032539657834991

Scan 161466474

duration: 0:00:12.484373

exit_message:

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

id: 161466474

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_deals_properties/2026-04-04/1775304944",
        "key": "raw/hubspot_molo_deals_properties/2026-04-04/1775304944/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_deals_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 6045569434102035376,
        "service_name": "drive-thru",
        "span_id": 18252162589701081054,
        "trace_id": 13876232019243818118
    }
}

running: False
schema_name_id: 1244
start_time: 2026-04-04 07:16:36
success: True
trace_id: 13876232019243818118

Scan 161408661

duration: 0:00:12.700454

exit_message:

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

id: 161408661

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_deals_properties/2026-04-03/1775218831",
        "key": "raw/hubspot_molo_deals_properties/2026-04-03/1775218831/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_deals_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 4405539302362602089,
        "service_name": "drive-thru",
        "span_id": 17221557547210956001,
        "trace_id": 11817101390197902473
    }
}

running: False
schema_name_id: 1244
start_time: 2026-04-03 07:20:48
success: True
trace_id: 11817101390197902473

Partitions:

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

Schema:

attributes:

{
    "archived": "string",
    "calculated": "string",
    "calculationFormula": "string",
    "createdAt": "string",
    "createdUserId": "string",
    "currencyPropertyName": "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:22:08

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

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:35:35",
        "disabled": false,
        "format": "raw",
        "id": 1244,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "hubspot_molo_deals_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",
            "currencyPropertyName": "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:22:08",
        "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_deals_properties`\n(\n`updatedAt`STRING,`createdAt`STRING,`name`STRING,`label`STRING,`type`STRING,`fieldType`STRING,`description`STRING,`groupName`STRING,`options`array>,`createdUserId`STRING,`updatedUserId`STRING,`displayOrder`STRING,`calculated`STRING,`externalOptions`STRING,`archived`STRING,`hasUniqueValue`STRING,`hidden`STRING,`showCurrencySymbol`STRING,`modificationMetadata`struct<`archivable`:STRING,`readOnlyDefinition`:STRING,`readOnlyValue`:STRING,`readOnlyOptions`:STRING>,`formField`STRING,`numberDisplayHint`STRING,`dataSensitivity`STRING,`hubspotDefined`STRING,`currencyPropertyName`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-prod/raw/hubspot_molo_deals_properties/2026-04-17/1776428517'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_deals_properties`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_deals_properties"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}