Schema Info

Schema Name: sfdl_stage_drivethru.hubspot_molo_deals_properties

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

name:

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

type: drivethrujson

Schema Versions: 15

Version 906676

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_deals_properties`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/hubspot_molo_deals_properties/2026-04-17/1776428298'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_deals_properties"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_deals_properties/2026-04-17/1776428298
id: 906676
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: 1507
schema_scan_id: 6415294
updated: 2026-04-17 07:19:24

Version 906455

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_deals_properties`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/hubspot_molo_deals_properties/2026-04-16/1776341623'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_deals_properties"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_deals_properties/2026-04-16/1776341623
id: 906455
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: 1507
schema_scan_id: 6414742
updated: 2026-04-16 07:14:38

Version 906246

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_deals_properties`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/hubspot_molo_deals_properties/2026-04-15/1776255591'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_deals_properties"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_deals_properties/2026-04-15/1776255591
id: 906246
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: 1507
schema_scan_id: 6414257
updated: 2026-04-15 07:20:37

Version 906029

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_deals_properties`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/hubspot_molo_deals_properties/2026-04-14/1776168966'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_deals_properties"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_deals_properties/2026-04-14/1776168966
id: 906029
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: 1507
schema_scan_id: 6413762
updated: 2026-04-14 07:16:39

Version 905815

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_deals_properties`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/hubspot_molo_deals_properties/2026-04-13/1776082709'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_deals_properties"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_deals_properties/2026-04-13/1776082709
id: 905815
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: 1507
schema_scan_id: 6413210
updated: 2026-04-13 07:19:35

Version 905613

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_deals_properties`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/hubspot_molo_deals_properties/2026-04-12/1775996129'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_deals_properties"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_deals_properties/2026-04-12/1775996129
id: 905613
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: 1507
schema_scan_id: 6412798
updated: 2026-04-12 07:16:39

Version 905402

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_deals_properties`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/hubspot_molo_deals_properties/2026-04-11/1775909609'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_deals_properties"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_deals_properties/2026-04-11/1775909609
id: 905402
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: 1507
schema_scan_id: 6412406
updated: 2026-04-11 07:13:51

Version 905197

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_deals_properties`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/hubspot_molo_deals_properties/2026-04-10/1775823105'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_deals_properties"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_deals_properties/2026-04-10/1775823105
id: 905197
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: 1507
schema_scan_id: 6411944
updated: 2026-04-10 07:12:40

Version 904978

created: 2026-04-09 07:11:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_deals_properties`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/hubspot_molo_deals_properties/2026-04-09/1775736705'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_deals_properties"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_deals_properties/2026-04-09/1775736705
id: 904978
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: 1507
schema_scan_id: 6411426
updated: 2026-04-09 07:12:07

Version 904769

created: 2026-04-08 07:13:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_deals_properties`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/hubspot_molo_deals_properties/2026-04-08/1775650369'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_deals_properties"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_deals_properties/2026-04-08/1775650369
id: 904769
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: 1507
schema_scan_id: 6410927
updated: 2026-04-08 07:13:59

Version 904556

created: 2026-04-07 07:17:26

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_deals_properties`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/hubspot_molo_deals_properties/2026-04-07/1775564179'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_deals_properties"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_deals_properties/2026-04-07/1775564179
id: 904556
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: 1507
schema_scan_id: 6410420
updated: 2026-04-07 07:17:37

Version 904340

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_deals_properties`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/hubspot_molo_deals_properties/2026-04-06/1775477884'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_deals_properties"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_deals_properties/2026-04-06/1775477884
id: 904340
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: 1507
schema_scan_id: 6409872
updated: 2026-04-06 07:18:45

Version 904134

created: 2026-04-05 07:13:10

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_deals_properties`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/hubspot_molo_deals_properties/2026-04-05/1775391149'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_deals_properties"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_deals_properties/2026-04-05/1775391149
id: 904134
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: 1507
schema_scan_id: 6409460
updated: 2026-04-05 07:13:21

Version 903936

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_deals_properties`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/hubspot_molo_deals_properties/2026-04-04/1775304861'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_deals_properties"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_deals_properties/2026-04-04/1775304861
id: 903936
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: 1507
schema_scan_id: 6409087
updated: 2026-04-04 07:16:21

Version 903719

created: 2026-04-03 07:16:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_deals_properties`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/hubspot_molo_deals_properties/2026-04-03/1775218595'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_deals_properties"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_deals_properties/2026-04-03/1775218595
id: 903719
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: 1507
schema_scan_id: 6408611
updated: 2026-04-03 07:17:08

Schema Scans: 15

Last at 2026-04-17 07:19:12

Scan 6415294

duration: 0:00:12.710822

exit_message:

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

id: 6415294

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_deals_properties/2026-04-17/1776428298",
        "key": "raw/hubspot_molo_deals_properties/2026-04-17/1776428298/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_deals_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 1675361142905393286,
        "service_name": "drive-thru",
        "span_id": 11393496204390700962,
        "trace_id": 7979772841473689045
    }
}

running: False
schema_name_id: 1507
start_time: 2026-04-17 07:19:12
success: True
trace_id: 7979772841473689045

Scan 6414742

duration: 0:00:15.465164

exit_message:

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

id: 6414742

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_deals_properties/2026-04-16/1776341623",
        "key": "raw/hubspot_molo_deals_properties/2026-04-16/1776341623/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_deals_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 9567073992752227330,
        "service_name": "drive-thru",
        "span_id": 1922087638580678917,
        "trace_id": 2128296468127202204
    }
}

running: False
schema_name_id: 1507
start_time: 2026-04-16 07:14:23
success: True
trace_id: 2128296468127202204

Scan 6414257

duration: 0:00:15.248459

exit_message:

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

id: 6414257

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_deals_properties/2026-04-15/1776255591",
        "key": "raw/hubspot_molo_deals_properties/2026-04-15/1776255591/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_deals_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 5619346181089799591,
        "service_name": "drive-thru",
        "span_id": 11501985019691489033,
        "trace_id": 11069310090493756451
    }
}

running: False
schema_name_id: 1507
start_time: 2026-04-15 07:20:22
success: True
trace_id: 11069310090493756451

Scan 6413762

duration: 0:00:15.198480

exit_message:

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

id: 6413762

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_deals_properties/2026-04-14/1776168966",
        "key": "raw/hubspot_molo_deals_properties/2026-04-14/1776168966/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_deals_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 17743338974588625086,
        "service_name": "drive-thru",
        "span_id": 5881321741795948421,
        "trace_id": 17656218883342493568
    }
}

running: False
schema_name_id: 1507
start_time: 2026-04-14 07:16:23
success: True
trace_id: 17656218883342493568

Scan 6413210

duration: 0:00:15.360055

exit_message:

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

id: 6413210

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_deals_properties/2026-04-13/1776082709",
        "key": "raw/hubspot_molo_deals_properties/2026-04-13/1776082709/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_deals_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 7952991622817443949,
        "service_name": "drive-thru",
        "span_id": 6644847199992479027,
        "trace_id": 14695489709577095775
    }
}

running: False
schema_name_id: 1507
start_time: 2026-04-13 07:19:20
success: True
trace_id: 14695489709577095775

Scan 6412798

duration: 0:00:15.286836

exit_message:

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

id: 6412798

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_deals_properties/2026-04-12/1775996129",
        "key": "raw/hubspot_molo_deals_properties/2026-04-12/1775996129/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_deals_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 6087806904951587546,
        "service_name": "drive-thru",
        "span_id": 14652895800881505544,
        "trace_id": 15190862822972523780
    }
}

running: False
schema_name_id: 1507
start_time: 2026-04-12 07:16:24
success: True
trace_id: 15190862822972523780

Scan 6412406

duration: 0:00:15.283553

exit_message:

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

id: 6412406

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_deals_properties/2026-04-11/1775909609",
        "key": "raw/hubspot_molo_deals_properties/2026-04-11/1775909609/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_deals_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 9480576013211019150,
        "service_name": "drive-thru",
        "span_id": 11588083224384363618,
        "trace_id": 18296460088128606131
    }
}

running: False
schema_name_id: 1507
start_time: 2026-04-11 07:13:36
success: True
trace_id: 18296460088128606131

Scan 6411944

duration: 0:00:12.773239

exit_message:

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

id: 6411944

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_deals_properties/2026-04-10/1775823105",
        "key": "raw/hubspot_molo_deals_properties/2026-04-10/1775823105/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_deals_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 14862038089515658662,
        "service_name": "drive-thru",
        "span_id": 4279083001358211182,
        "trace_id": 6853460710809152315
    }
}

running: False
schema_name_id: 1507
start_time: 2026-04-10 07:12:28
success: True
trace_id: 6853460710809152315

Scan 6411426

duration: 0:00:15.303633

exit_message:

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

id: 6411426

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_deals_properties/2026-04-09/1775736705",
        "key": "raw/hubspot_molo_deals_properties/2026-04-09/1775736705/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_deals_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 17022775887137631501,
        "service_name": "drive-thru",
        "span_id": 14638602759303611,
        "trace_id": 15656616721721081346
    }
}

running: False
schema_name_id: 1507
start_time: 2026-04-09 07:11:52
success: True
trace_id: 15656616721721081346

Scan 6410927

duration: 0:00:12.731833

exit_message:

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

id: 6410927

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_deals_properties/2026-04-08/1775650369",
        "key": "raw/hubspot_molo_deals_properties/2026-04-08/1775650369/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_deals_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 6352774535367375461,
        "service_name": "drive-thru",
        "span_id": 9178351991932063774,
        "trace_id": 7763312720097398317
    }
}

running: False
schema_name_id: 1507
start_time: 2026-04-08 07:13:46
success: True
trace_id: 7763312720097398317

Scan 6410420

duration: 0:00:12.756011

exit_message:

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

id: 6410420

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_deals_properties/2026-04-07/1775564179",
        "key": "raw/hubspot_molo_deals_properties/2026-04-07/1775564179/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_deals_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 16532393261894580042,
        "service_name": "drive-thru",
        "span_id": 17510074478788555784,
        "trace_id": 11753201504344537460
    }
}

running: False
schema_name_id: 1507
start_time: 2026-04-07 07:17:24
success: True
trace_id: 11753201504344537460

Scan 6409872

duration: 0:00:15.208880

exit_message:

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

id: 6409872

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_deals_properties/2026-04-06/1775477884",
        "key": "raw/hubspot_molo_deals_properties/2026-04-06/1775477884/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_deals_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 15281822344057144999,
        "service_name": "drive-thru",
        "span_id": 12648010732559997863,
        "trace_id": 15746049720577928346
    }
}

running: False
schema_name_id: 1507
start_time: 2026-04-06 07:18:30
success: True
trace_id: 15746049720577928346

Scan 6409460

duration: 0:00:13.050604

exit_message:

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

id: 6409460

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_deals_properties/2026-04-05/1775391149",
        "key": "raw/hubspot_molo_deals_properties/2026-04-05/1775391149/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_deals_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 14170734359061620320,
        "service_name": "drive-thru",
        "span_id": 9178867397254418013,
        "trace_id": 887312062551354110
    }
}

running: False
schema_name_id: 1507
start_time: 2026-04-05 07:13:08
success: True
trace_id: 887312062551354110

Scan 6409087

duration: 0:00:15.292245

exit_message:

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

id: 6409087

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_deals_properties/2026-04-04/1775304861",
        "key": "raw/hubspot_molo_deals_properties/2026-04-04/1775304861/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_deals_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 11723746927145958905,
        "service_name": "drive-thru",
        "span_id": 482825180463488661,
        "trace_id": 11295667058706195943
    }
}

running: False
schema_name_id: 1507
start_time: 2026-04-04 07:16:05
success: True
trace_id: 11295667058706195943

Scan 6408611

duration: 0:00:12.646090

exit_message:

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

id: 6408611

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_deals_properties/2026-04-03/1775218595",
        "key": "raw/hubspot_molo_deals_properties/2026-04-03/1775218595/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_deals_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 5616128331352031435,
        "service_name": "drive-thru",
        "span_id": 5118530256205771633,
        "trace_id": 2243623278188363505
    }
}

running: False
schema_name_id: 1507
start_time: 2026-04-03 07:16:56
success: True
trace_id: 2243623278188363505

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:19:13

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_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-stage/raw/hubspot_molo_deals_properties/2026-04-17/1776428298'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_deals_properties`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_deals_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:07",
        "disabled": false,
        "format": "raw",
        "id": 1507,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_stage_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:19:13",
        "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_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-stage/raw/hubspot_molo_deals_properties/2026-04-17/1776428298'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_deals_properties`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_deals_properties"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}