Schema Info

Schema Name: sfdl_stage_drivethru.hubspot_molo_calls_properties

created: 2023-02-09 07:16:10
disabled: False
format: raw
id: 1787
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrujson

Schema Versions: 15

Version 906674

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_properties/2026-04-17/1776428291
id: 906674
processed: 1

raw_data:

{
    "calculated": false,
    "calculationFormula": "extract_most_recent_email_reply_text(string(hs_call_body))",
    "createdAt": "2019-12-12T14:41:18.828Z",
    "dataSensitivity": "non_sensitive",
    "description": "The activity type of the engagement",
    "displayOrder": -1,
    "externalOptions": false,
    "fieldType": "select",
    "formField": false,
    "groupName": "engagement",
    "hasUniqueValue": false,
    "hidden": false,
    "hubspotDefined": true,
    "label": "Call and meeting type",
    "modificationMetadata": {
        "archivable": true,
        "readOnlyDefinition": true,
        "readOnlyValue": false
    },
    "name": "hs_activity_type",
    "numberDisplayHint": "unformatted",
    "options": [
        {
            "description": "",
            "displayOrder": 1,
            "hidden": false,
            "label": "True",
            "value": "true"
        }
    ],
    "referencedObjectType": "OWNER",
    "type": "enumeration",
    "updatedAt": "2025-12-04T15:44:07.347Z"
}

schema_attributes:

{
    "calculated": "string",
    "calculationFormula": "string",
    "createdAt": "string",
    "dataSensitivity": "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.readOnlyValue": "string",
    "name": "string",
    "numberDisplayHint": "string",
    "options": [
        {
            "description": "string",
            "displayOrder": "string",
            "hidden": "string",
            "label": "string",
            "value": "string"
        }
    ],
    "referencedObjectType": "string",
    "type": "string",
    "updatedAt": "string"
}

schema_name_id: 1787
schema_scan_id: 6415292
updated: 2026-04-17 07:19:11

Version 906451

created: 2026-04-16 07:13:48

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_properties/2026-04-16/1776341602
id: 906451
processed: 1

raw_data:

{
    "calculated": false,
    "calculationFormula": "extract_most_recent_email_reply_text(string(hs_call_body))",
    "createdAt": "2019-12-12T14:41:18.828Z",
    "dataSensitivity": "non_sensitive",
    "description": "The activity type of the engagement",
    "displayOrder": -1,
    "externalOptions": false,
    "fieldType": "select",
    "formField": false,
    "groupName": "engagement",
    "hasUniqueValue": false,
    "hidden": false,
    "hubspotDefined": true,
    "label": "Call and meeting type",
    "modificationMetadata": {
        "archivable": true,
        "readOnlyDefinition": true,
        "readOnlyValue": false
    },
    "name": "hs_activity_type",
    "numberDisplayHint": "unformatted",
    "options": [
        {
            "description": "",
            "displayOrder": 1,
            "hidden": false,
            "label": "True",
            "value": "true"
        }
    ],
    "referencedObjectType": "OWNER",
    "type": "enumeration",
    "updatedAt": "2025-12-04T15:44:07.347Z"
}

schema_attributes:

{
    "calculated": "string",
    "calculationFormula": "string",
    "createdAt": "string",
    "dataSensitivity": "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.readOnlyValue": "string",
    "name": "string",
    "numberDisplayHint": "string",
    "options": [
        {
            "description": "string",
            "displayOrder": "string",
            "hidden": "string",
            "label": "string",
            "value": "string"
        }
    ],
    "referencedObjectType": "string",
    "type": "string",
    "updatedAt": "string"
}

schema_name_id: 1787
schema_scan_id: 6414737
updated: 2026-04-16 07:13:59

Version 906243

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_properties/2026-04-15/1776255579
id: 906243
processed: 1

raw_data:

{
    "calculated": false,
    "calculationFormula": "extract_most_recent_email_reply_text(string(hs_call_body))",
    "createdAt": "2019-12-12T14:41:18.828Z",
    "dataSensitivity": "non_sensitive",
    "description": "The activity type of the engagement",
    "displayOrder": -1,
    "externalOptions": false,
    "fieldType": "select",
    "formField": false,
    "groupName": "engagement",
    "hasUniqueValue": false,
    "hidden": false,
    "hubspotDefined": true,
    "label": "Call and meeting type",
    "modificationMetadata": {
        "archivable": true,
        "readOnlyDefinition": true,
        "readOnlyValue": false
    },
    "name": "hs_activity_type",
    "numberDisplayHint": "unformatted",
    "options": [
        {
            "description": "",
            "displayOrder": 1,
            "hidden": false,
            "label": "True",
            "value": "true"
        }
    ],
    "referencedObjectType": "OWNER",
    "type": "enumeration",
    "updatedAt": "2025-12-04T15:44:07.347Z"
}

schema_attributes:

{
    "calculated": "string",
    "calculationFormula": "string",
    "createdAt": "string",
    "dataSensitivity": "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.readOnlyValue": "string",
    "name": "string",
    "numberDisplayHint": "string",
    "options": [
        {
            "description": "string",
            "displayOrder": "string",
            "hidden": "string",
            "label": "string",
            "value": "string"
        }
    ],
    "referencedObjectType": "string",
    "type": "string",
    "updatedAt": "string"
}

schema_name_id: 1787
schema_scan_id: 6414255
updated: 2026-04-15 07:20:21

Version 906027

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_properties/2026-04-14/1776168955
id: 906027
processed: 1

raw_data:

{
    "calculated": false,
    "calculationFormula": "extract_most_recent_email_reply_text(string(hs_call_body))",
    "createdAt": "2019-12-12T14:41:18.828Z",
    "dataSensitivity": "non_sensitive",
    "description": "The activity type of the engagement",
    "displayOrder": -1,
    "externalOptions": false,
    "fieldType": "select",
    "formField": false,
    "groupName": "engagement",
    "hasUniqueValue": false,
    "hidden": false,
    "hubspotDefined": true,
    "label": "Call and meeting type",
    "modificationMetadata": {
        "archivable": true,
        "readOnlyDefinition": true,
        "readOnlyValue": false
    },
    "name": "hs_activity_type",
    "numberDisplayHint": "unformatted",
    "options": [
        {
            "description": "",
            "displayOrder": 1,
            "hidden": false,
            "label": "True",
            "value": "true"
        }
    ],
    "referencedObjectType": "OWNER",
    "type": "enumeration",
    "updatedAt": "2025-12-04T15:44:07.347Z"
}

schema_attributes:

{
    "calculated": "string",
    "calculationFormula": "string",
    "createdAt": "string",
    "dataSensitivity": "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.readOnlyValue": "string",
    "name": "string",
    "numberDisplayHint": "string",
    "options": [
        {
            "description": "string",
            "displayOrder": "string",
            "hidden": "string",
            "label": "string",
            "value": "string"
        }
    ],
    "referencedObjectType": "string",
    "type": "string",
    "updatedAt": "string"
}

schema_name_id: 1787
schema_scan_id: 6413758
updated: 2026-04-14 07:16:23

Version 905812

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_properties/2026-04-13/1776082696
id: 905812
processed: 1

raw_data:

{
    "calculated": false,
    "calculationFormula": "extract_most_recent_email_reply_text(string(hs_call_body))",
    "createdAt": "2019-12-12T14:41:18.828Z",
    "dataSensitivity": "non_sensitive",
    "description": "The activity type of the engagement",
    "displayOrder": -1,
    "externalOptions": false,
    "fieldType": "select",
    "formField": false,
    "groupName": "engagement",
    "hasUniqueValue": false,
    "hidden": false,
    "hubspotDefined": true,
    "label": "Call and meeting type",
    "modificationMetadata": {
        "archivable": true,
        "readOnlyDefinition": true,
        "readOnlyValue": false
    },
    "name": "hs_activity_type",
    "numberDisplayHint": "unformatted",
    "options": [
        {
            "description": "",
            "displayOrder": 1,
            "hidden": false,
            "label": "True",
            "value": "true"
        }
    ],
    "referencedObjectType": "OWNER",
    "type": "enumeration",
    "updatedAt": "2025-12-04T15:44:07.347Z"
}

schema_attributes:

{
    "calculated": "string",
    "calculationFormula": "string",
    "createdAt": "string",
    "dataSensitivity": "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.readOnlyValue": "string",
    "name": "string",
    "numberDisplayHint": "string",
    "options": [
        {
            "description": "string",
            "displayOrder": "string",
            "hidden": "string",
            "label": "string",
            "value": "string"
        }
    ],
    "referencedObjectType": "string",
    "type": "string",
    "updatedAt": "string"
}

schema_name_id: 1787
schema_scan_id: 6413207
updated: 2026-04-13 07:19:18

Version 905609

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_properties/2026-04-12/1775996141
id: 905609
processed: 1

raw_data:

{
    "calculated": false,
    "calculationFormula": "extract_most_recent_email_reply_text(string(hs_call_body))",
    "createdAt": "2019-12-12T14:41:18.828Z",
    "dataSensitivity": "non_sensitive",
    "description": "The activity type of the engagement",
    "displayOrder": -1,
    "externalOptions": false,
    "fieldType": "select",
    "formField": false,
    "groupName": "engagement",
    "hasUniqueValue": false,
    "hidden": false,
    "hubspotDefined": true,
    "label": "Call and meeting type",
    "modificationMetadata": {
        "archivable": true,
        "readOnlyDefinition": true,
        "readOnlyValue": false
    },
    "name": "hs_activity_type",
    "numberDisplayHint": "unformatted",
    "options": [
        {
            "description": "",
            "displayOrder": 1,
            "hidden": false,
            "label": "True",
            "value": "true"
        }
    ],
    "referencedObjectType": "OWNER",
    "type": "enumeration",
    "updatedAt": "2025-12-04T15:44:07.347Z"
}

schema_attributes:

{
    "calculated": "string",
    "calculationFormula": "string",
    "createdAt": "string",
    "dataSensitivity": "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.readOnlyValue": "string",
    "name": "string",
    "numberDisplayHint": "string",
    "options": [
        {
            "description": "string",
            "displayOrder": "string",
            "hidden": "string",
            "label": "string",
            "value": "string"
        }
    ],
    "referencedObjectType": "string",
    "type": "string",
    "updatedAt": "string"
}

schema_name_id: 1787
schema_scan_id: 6412794
updated: 2026-04-12 07:16:17

Version 905408

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_properties/2026-04-11/1775909628
id: 905408
processed: 1

raw_data:

{
    "calculated": false,
    "calculationFormula": "extract_most_recent_email_reply_text(string(hs_call_body))",
    "createdAt": "2019-12-12T14:41:18.828Z",
    "dataSensitivity": "non_sensitive",
    "description": "The activity type of the engagement",
    "displayOrder": -1,
    "externalOptions": false,
    "fieldType": "select",
    "formField": false,
    "groupName": "engagement",
    "hasUniqueValue": false,
    "hidden": false,
    "hubspotDefined": true,
    "label": "Call and meeting type",
    "modificationMetadata": {
        "archivable": true,
        "readOnlyDefinition": true,
        "readOnlyValue": false
    },
    "name": "hs_activity_type",
    "numberDisplayHint": "unformatted",
    "options": [
        {
            "description": "",
            "displayOrder": 1,
            "hidden": false,
            "label": "True",
            "value": "true"
        }
    ],
    "referencedObjectType": "OWNER",
    "type": "enumeration",
    "updatedAt": "2025-12-04T15:44:07.347Z"
}

schema_attributes:

{
    "calculated": "string",
    "calculationFormula": "string",
    "createdAt": "string",
    "dataSensitivity": "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.readOnlyValue": "string",
    "name": "string",
    "numberDisplayHint": "string",
    "options": [
        {
            "description": "string",
            "displayOrder": "string",
            "hidden": "string",
            "label": "string",
            "value": "string"
        }
    ],
    "referencedObjectType": "string",
    "type": "string",
    "updatedAt": "string"
}

schema_name_id: 1787
schema_scan_id: 6412415
updated: 2026-04-11 07:14:31

Version 905192

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_properties/2026-04-10/1775823108
id: 905192
processed: 1

raw_data:

{
    "calculated": false,
    "calculationFormula": "extract_most_recent_email_reply_text(string(hs_call_body))",
    "createdAt": "2019-12-12T14:41:18.828Z",
    "dataSensitivity": "non_sensitive",
    "description": "The activity type of the engagement",
    "displayOrder": -1,
    "externalOptions": false,
    "fieldType": "select",
    "formField": false,
    "groupName": "engagement",
    "hasUniqueValue": false,
    "hidden": false,
    "hubspotDefined": true,
    "label": "Call and meeting type",
    "modificationMetadata": {
        "archivable": true,
        "readOnlyDefinition": true,
        "readOnlyValue": false
    },
    "name": "hs_activity_type",
    "numberDisplayHint": "unformatted",
    "options": [
        {
            "description": "",
            "displayOrder": 1,
            "hidden": false,
            "label": "True",
            "value": "true"
        }
    ],
    "referencedObjectType": "OWNER",
    "type": "enumeration",
    "updatedAt": "2025-12-04T15:44:07.347Z"
}

schema_attributes:

{
    "calculated": "string",
    "calculationFormula": "string",
    "createdAt": "string",
    "dataSensitivity": "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.readOnlyValue": "string",
    "name": "string",
    "numberDisplayHint": "string",
    "options": [
        {
            "description": "string",
            "displayOrder": "string",
            "hidden": "string",
            "label": "string",
            "value": "string"
        }
    ],
    "referencedObjectType": "string",
    "type": "string",
    "updatedAt": "string"
}

schema_name_id: 1787
schema_scan_id: 6411939
updated: 2026-04-10 07:12:19

Version 904981

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_properties/2026-04-09/1775736711
id: 904981
processed: 1

raw_data:

{
    "calculated": false,
    "calculationFormula": "extract_most_recent_email_reply_text(string(hs_call_body))",
    "createdAt": "2019-12-12T14:41:18.828Z",
    "dataSensitivity": "non_sensitive",
    "description": "The activity type of the engagement",
    "displayOrder": -1,
    "externalOptions": false,
    "fieldType": "select",
    "formField": false,
    "groupName": "engagement",
    "hasUniqueValue": false,
    "hidden": false,
    "hubspotDefined": true,
    "label": "Call and meeting type",
    "modificationMetadata": {
        "archivable": true,
        "readOnlyDefinition": true,
        "readOnlyValue": false
    },
    "name": "hs_activity_type",
    "numberDisplayHint": "unformatted",
    "options": [
        {
            "description": "",
            "displayOrder": 1,
            "hidden": false,
            "label": "True",
            "value": "true"
        }
    ],
    "referencedObjectType": "OWNER",
    "type": "enumeration",
    "updatedAt": "2025-12-04T15:44:07.347Z"
}

schema_attributes:

{
    "calculated": "string",
    "calculationFormula": "string",
    "createdAt": "string",
    "dataSensitivity": "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.readOnlyValue": "string",
    "name": "string",
    "numberDisplayHint": "string",
    "options": [
        {
            "description": "string",
            "displayOrder": "string",
            "hidden": "string",
            "label": "string",
            "value": "string"
        }
    ],
    "referencedObjectType": "string",
    "type": "string",
    "updatedAt": "string"
}

schema_name_id: 1787
schema_scan_id: 6411428
updated: 2026-04-09 07:12:14

Version 904766

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_properties/2026-04-08/1775650393
id: 904766
processed: 1

raw_data:

{
    "calculated": false,
    "calculationFormula": "extract_most_recent_email_reply_text(string(hs_call_body))",
    "createdAt": "2019-12-12T14:41:18.828Z",
    "dataSensitivity": "non_sensitive",
    "description": "The activity type of the engagement",
    "displayOrder": -1,
    "externalOptions": false,
    "fieldType": "select",
    "formField": false,
    "groupName": "engagement",
    "hasUniqueValue": false,
    "hidden": false,
    "hubspotDefined": true,
    "label": "Call and meeting type",
    "modificationMetadata": {
        "archivable": true,
        "readOnlyDefinition": true,
        "readOnlyValue": false
    },
    "name": "hs_activity_type",
    "numberDisplayHint": "unformatted",
    "options": [
        {
            "description": "",
            "displayOrder": 1,
            "hidden": false,
            "label": "True",
            "value": "true"
        }
    ],
    "referencedObjectType": "OWNER",
    "type": "enumeration",
    "updatedAt": "2025-12-04T15:44:07.347Z"
}

schema_attributes:

{
    "calculated": "string",
    "calculationFormula": "string",
    "createdAt": "string",
    "dataSensitivity": "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.readOnlyValue": "string",
    "name": "string",
    "numberDisplayHint": "string",
    "options": [
        {
            "description": "string",
            "displayOrder": "string",
            "hidden": "string",
            "label": "string",
            "value": "string"
        }
    ],
    "referencedObjectType": "string",
    "type": "string",
    "updatedAt": "string"
}

schema_name_id: 1787
schema_scan_id: 6410924
updated: 2026-04-08 07:13:46

Version 904557

created: 2026-04-07 07:17:37

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_properties/2026-04-07/1775564204
id: 904557
processed: 1

raw_data:

{
    "calculated": false,
    "calculationFormula": "extract_most_recent_email_reply_text(string(hs_call_body))",
    "createdAt": "2019-12-12T14:41:18.828Z",
    "dataSensitivity": "non_sensitive",
    "description": "The activity type of the engagement",
    "displayOrder": -1,
    "externalOptions": false,
    "fieldType": "select",
    "formField": false,
    "groupName": "engagement",
    "hasUniqueValue": false,
    "hidden": false,
    "hubspotDefined": true,
    "label": "Call and meeting type",
    "modificationMetadata": {
        "archivable": true,
        "readOnlyDefinition": true,
        "readOnlyValue": false
    },
    "name": "hs_activity_type",
    "numberDisplayHint": "unformatted",
    "options": [
        {
            "description": "",
            "displayOrder": 1,
            "hidden": false,
            "label": "True",
            "value": "true"
        }
    ],
    "referencedObjectType": "OWNER",
    "type": "enumeration",
    "updatedAt": "2025-12-04T15:44:07.347Z"
}

schema_attributes:

{
    "calculated": "string",
    "calculationFormula": "string",
    "createdAt": "string",
    "dataSensitivity": "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.readOnlyValue": "string",
    "name": "string",
    "numberDisplayHint": "string",
    "options": [
        {
            "description": "string",
            "displayOrder": "string",
            "hidden": "string",
            "label": "string",
            "value": "string"
        }
    ],
    "referencedObjectType": "string",
    "type": "string",
    "updatedAt": "string"
}

schema_name_id: 1787
schema_scan_id: 6410421
updated: 2026-04-07 07:17:48

Version 904343

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_properties/2026-04-06/1775477891
id: 904343
processed: 1

raw_data:

{
    "calculated": false,
    "calculationFormula": "extract_most_recent_email_reply_text(string(hs_call_body))",
    "createdAt": "2019-12-12T14:41:18.828Z",
    "dataSensitivity": "non_sensitive",
    "description": "The activity type of the engagement",
    "displayOrder": -1,
    "externalOptions": false,
    "fieldType": "select",
    "formField": false,
    "groupName": "engagement",
    "hasUniqueValue": false,
    "hidden": false,
    "hubspotDefined": true,
    "label": "Call and meeting type",
    "modificationMetadata": {
        "archivable": true,
        "readOnlyDefinition": true,
        "readOnlyValue": false
    },
    "name": "hs_activity_type",
    "numberDisplayHint": "unformatted",
    "options": [
        {
            "description": "",
            "displayOrder": 1,
            "hidden": false,
            "label": "True",
            "value": "true"
        }
    ],
    "referencedObjectType": "OWNER",
    "type": "enumeration",
    "updatedAt": "2025-12-04T15:44:07.347Z"
}

schema_attributes:

{
    "calculated": "string",
    "calculationFormula": "string",
    "createdAt": "string",
    "dataSensitivity": "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.readOnlyValue": "string",
    "name": "string",
    "numberDisplayHint": "string",
    "options": [
        {
            "description": "string",
            "displayOrder": "string",
            "hidden": "string",
            "label": "string",
            "value": "string"
        }
    ],
    "referencedObjectType": "string",
    "type": "string",
    "updatedAt": "string"
}

schema_name_id: 1787
schema_scan_id: 6409877
updated: 2026-04-06 07:19:12

Version 904137

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_properties/2026-04-05/1775391171
id: 904137
processed: 1

raw_data:

{
    "calculated": false,
    "calculationFormula": "extract_most_recent_email_reply_text(string(hs_call_body))",
    "createdAt": "2019-12-12T14:41:18.828Z",
    "dataSensitivity": "non_sensitive",
    "description": "The activity type of the engagement",
    "displayOrder": -1,
    "externalOptions": false,
    "fieldType": "select",
    "formField": false,
    "groupName": "engagement",
    "hasUniqueValue": false,
    "hidden": false,
    "hubspotDefined": true,
    "label": "Call and meeting type",
    "modificationMetadata": {
        "archivable": true,
        "readOnlyDefinition": true,
        "readOnlyValue": false
    },
    "name": "hs_activity_type",
    "numberDisplayHint": "unformatted",
    "options": [
        {
            "description": "",
            "displayOrder": 1,
            "hidden": false,
            "label": "True",
            "value": "true"
        }
    ],
    "referencedObjectType": "OWNER",
    "type": "enumeration",
    "updatedAt": "2025-12-04T15:44:07.347Z"
}

schema_attributes:

{
    "calculated": "string",
    "calculationFormula": "string",
    "createdAt": "string",
    "dataSensitivity": "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.readOnlyValue": "string",
    "name": "string",
    "numberDisplayHint": "string",
    "options": [
        {
            "description": "string",
            "displayOrder": "string",
            "hidden": "string",
            "label": "string",
            "value": "string"
        }
    ],
    "referencedObjectType": "string",
    "type": "string",
    "updatedAt": "string"
}

schema_name_id: 1787
schema_scan_id: 6409464
updated: 2026-04-05 07:13:43

Version 903933

created: 2026-04-04 07:14:43

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_properties/2026-04-04/1775304844
id: 903933
processed: 1

raw_data:

{
    "calculated": false,
    "calculationFormula": "extract_most_recent_email_reply_text(string(hs_call_body))",
    "createdAt": "2019-12-12T14:41:18.828Z",
    "dataSensitivity": "non_sensitive",
    "description": "The activity type of the engagement",
    "displayOrder": -1,
    "externalOptions": false,
    "fieldType": "select",
    "formField": false,
    "groupName": "engagement",
    "hasUniqueValue": false,
    "hidden": false,
    "hubspotDefined": true,
    "label": "Call and meeting type",
    "modificationMetadata": {
        "archivable": true,
        "readOnlyDefinition": true,
        "readOnlyValue": false
    },
    "name": "hs_activity_type",
    "numberDisplayHint": "unformatted",
    "options": [
        {
            "description": "",
            "displayOrder": 1,
            "hidden": false,
            "label": "True",
            "value": "true"
        }
    ],
    "referencedObjectType": "OWNER",
    "type": "enumeration",
    "updatedAt": "2025-12-04T15:44:07.347Z"
}

schema_attributes:

{
    "calculated": "string",
    "calculationFormula": "string",
    "createdAt": "string",
    "dataSensitivity": "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.readOnlyValue": "string",
    "name": "string",
    "numberDisplayHint": "string",
    "options": [
        {
            "description": "string",
            "displayOrder": "string",
            "hidden": "string",
            "label": "string",
            "value": "string"
        }
    ],
    "referencedObjectType": "string",
    "type": "string",
    "updatedAt": "string"
}

schema_name_id: 1787
schema_scan_id: 6409083
updated: 2026-04-04 07:15:53

Version 903723

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls_properties/2026-04-03/1775218606
id: 903723
processed: 1

raw_data:

{
    "calculated": false,
    "calculationFormula": "extract_most_recent_email_reply_text(string(hs_call_body))",
    "createdAt": "2019-12-12T14:41:18.828Z",
    "dataSensitivity": "non_sensitive",
    "description": "The activity type of the engagement",
    "displayOrder": -1,
    "externalOptions": false,
    "fieldType": "select",
    "formField": false,
    "groupName": "engagement",
    "hasUniqueValue": false,
    "hidden": false,
    "hubspotDefined": true,
    "label": "Call and meeting type",
    "modificationMetadata": {
        "archivable": true,
        "readOnlyDefinition": true,
        "readOnlyValue": false
    },
    "name": "hs_activity_type",
    "numberDisplayHint": "unformatted",
    "options": [
        {
            "description": "",
            "displayOrder": 1,
            "hidden": false,
            "label": "True",
            "value": "true"
        }
    ],
    "referencedObjectType": "OWNER",
    "type": "enumeration",
    "updatedAt": "2025-12-04T15:44:07.347Z"
}

schema_attributes:

{
    "calculated": "string",
    "calculationFormula": "string",
    "createdAt": "string",
    "dataSensitivity": "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.readOnlyValue": "string",
    "name": "string",
    "numberDisplayHint": "string",
    "options": [
        {
            "description": "string",
            "displayOrder": "string",
            "hidden": "string",
            "label": "string",
            "value": "string"
        }
    ],
    "referencedObjectType": "string",
    "type": "string",
    "updatedAt": "string"
}

schema_name_id: 1787
schema_scan_id: 6408614
updated: 2026-04-03 07:17:32

Schema Scans: 15

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

Scan 6415292

duration: 0:00:15.004735

exit_message:

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

id: 6415292

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_calls_properties/2026-04-17/1776428291",
        "key": "raw/hubspot_molo_calls_properties/2026-04-17/1776428291/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 2898888572407223155,
        "service_name": "drive-thru",
        "span_id": 10693842175149674924,
        "trace_id": 9643619540763743918
    }
}

running: False
schema_name_id: 1787
start_time: 2026-04-17 07:18:56
success: True
trace_id: 9643619540763743918

Scan 6414737

duration: 0:00:12.332969

exit_message:

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

id: 6414737

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_calls_properties/2026-04-16/1776341602",
        "key": "raw/hubspot_molo_calls_properties/2026-04-16/1776341602/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 12398154559570634304,
        "service_name": "drive-thru",
        "span_id": 8105816803261026638,
        "trace_id": 2459752706537071030
    }
}

running: False
schema_name_id: 1787
start_time: 2026-04-16 07:13:47
success: True
trace_id: 2459752706537071030

Scan 6414255

duration: 0:00:12.329140

exit_message:

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

id: 6414255

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_calls_properties/2026-04-15/1776255579",
        "key": "raw/hubspot_molo_calls_properties/2026-04-15/1776255579/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 15557382460031134768,
        "service_name": "drive-thru",
        "span_id": 2965162891374122896,
        "trace_id": 2333793006351651932
    }
}

running: False
schema_name_id: 1787
start_time: 2026-04-15 07:20:09
success: True
trace_id: 2333793006351651932

Scan 6413758

duration: 0:00:12.400015

exit_message:

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

id: 6413758

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_calls_properties/2026-04-14/1776168955",
        "key": "raw/hubspot_molo_calls_properties/2026-04-14/1776168955/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 18133186714016014787,
        "service_name": "drive-thru",
        "span_id": 11466163437390713732,
        "trace_id": 15772331706433116784
    }
}

running: False
schema_name_id: 1787
start_time: 2026-04-14 07:16:10
success: True
trace_id: 15772331706433116784

Scan 6413207

duration: 0:00:14.720924

exit_message:

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

id: 6413207

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_calls_properties/2026-04-13/1776082696",
        "key": "raw/hubspot_molo_calls_properties/2026-04-13/1776082696/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 15989618987072203082,
        "service_name": "drive-thru",
        "span_id": 8090808089549508845,
        "trace_id": 17136495455309737836
    }
}

running: False
schema_name_id: 1787
start_time: 2026-04-13 07:19:03
success: True
trace_id: 17136495455309737836

Scan 6412794

duration: 0:00:12.245569

exit_message:

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

id: 6412794

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_calls_properties/2026-04-12/1775996141",
        "key": "raw/hubspot_molo_calls_properties/2026-04-12/1775996141/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 14881265687304771378,
        "service_name": "drive-thru",
        "span_id": 16164887764265704141,
        "trace_id": 12335359579537796796
    }
}

running: False
schema_name_id: 1787
start_time: 2026-04-12 07:16:05
success: True
trace_id: 12335359579537796796

Scan 6412415

duration: 0:00:14.784196

exit_message:

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

id: 6412415

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_calls_properties/2026-04-11/1775909628",
        "key": "raw/hubspot_molo_calls_properties/2026-04-11/1775909628/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 3506399562183512406,
        "service_name": "drive-thru",
        "span_id": 4513218112158836302,
        "trace_id": 18255202046974918324
    }
}

running: False
schema_name_id: 1787
start_time: 2026-04-11 07:14:17
success: True
trace_id: 18255202046974918324

Scan 6411939

duration: 0:00:12.397932

exit_message:

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

id: 6411939

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_calls_properties/2026-04-10/1775823108",
        "key": "raw/hubspot_molo_calls_properties/2026-04-10/1775823108/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 7327175800147099527,
        "service_name": "drive-thru",
        "span_id": 8776519837744922564,
        "trace_id": 3933311009995046415
    }
}

running: False
schema_name_id: 1787
start_time: 2026-04-10 07:12:07
success: True
trace_id: 3933311009995046415

Scan 6411428

duration: 0:00:12.461779

exit_message:

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

id: 6411428

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_calls_properties/2026-04-09/1775736711",
        "key": "raw/hubspot_molo_calls_properties/2026-04-09/1775736711/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 6870669736345726575,
        "service_name": "drive-thru",
        "span_id": 5007066836244445863,
        "trace_id": 12210744833377855782
    }
}

running: False
schema_name_id: 1787
start_time: 2026-04-09 07:12:02
success: True
trace_id: 12210744833377855782

Scan 6410924

duration: 0:00:12.287573

exit_message:

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

id: 6410924

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_calls_properties/2026-04-08/1775650393",
        "key": "raw/hubspot_molo_calls_properties/2026-04-08/1775650393/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 10024304750183832531,
        "service_name": "drive-thru",
        "span_id": 12107991169171157184,
        "trace_id": 2364598170222962232
    }
}

running: False
schema_name_id: 1787
start_time: 2026-04-08 07:13:33
success: True
trace_id: 2364598170222962232

Scan 6410421

duration: 0:00:12.241481

exit_message:

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

id: 6410421

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_calls_properties/2026-04-07/1775564204",
        "key": "raw/hubspot_molo_calls_properties/2026-04-07/1775564204/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 1833913136400773021,
        "service_name": "drive-thru",
        "span_id": 8931717160535429975,
        "trace_id": 9178173769581690196
    }
}

running: False
schema_name_id: 1787
start_time: 2026-04-07 07:17:36
success: True
trace_id: 9178173769581690196

Scan 6409877

duration: 0:00:12.301888

exit_message:

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

id: 6409877

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_calls_properties/2026-04-06/1775477891",
        "key": "raw/hubspot_molo_calls_properties/2026-04-06/1775477891/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 17327719356095951303,
        "service_name": "drive-thru",
        "span_id": 4403938953346573469,
        "trace_id": 12644207551341902508
    }
}

running: False
schema_name_id: 1787
start_time: 2026-04-06 07:19:00
success: True
trace_id: 12644207551341902508

Scan 6409464

duration: 0:00:14.672322

exit_message:

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

id: 6409464

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_calls_properties/2026-04-05/1775391171",
        "key": "raw/hubspot_molo_calls_properties/2026-04-05/1775391171/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 17010078676459900754,
        "service_name": "drive-thru",
        "span_id": 7904778020021826538,
        "trace_id": 8720388862405752391
    }
}

running: False
schema_name_id: 1787
start_time: 2026-04-05 07:13:28
success: True
trace_id: 8720388862405752391

Scan 6409083

duration: 0:01:10.831769

exit_message:

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

id: 6409083

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_calls_properties/2026-04-04/1775304844",
        "key": "raw/hubspot_molo_calls_properties/2026-04-04/1775304844/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 3127790535010946030,
        "service_name": "drive-thru",
        "span_id": 2257300896127234729,
        "trace_id": 16513577332071289299
    }
}

running: False
schema_name_id: 1787
start_time: 2026-04-04 07:14:42
success: True
trace_id: 16513577332071289299

Scan 6408614

duration: 0:00:14.827266

exit_message:

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

id: 6408614

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_calls_properties/2026-04-03/1775218606",
        "key": "raw/hubspot_molo_calls_properties/2026-04-03/1775218606/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 15429288125640560494,
        "service_name": "drive-thru",
        "span_id": 9235377251714863428,
        "trace_id": 15709787353331819701
    }
}

running: False
schema_name_id: 1787
start_time: 2026-04-03 07:17:18
success: True
trace_id: 15709787353331819701

Partitions:

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

Schema:

attributes:

{
    "calculated": "string",
    "calculationFormula": "string",
    "createdAt": "string",
    "dataSensitivity": "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.readOnlyValue": "string",
    "name": "string",
    "numberDisplayHint": "string",
    "options": [
        {
            "description": "string",
            "displayOrder": "string",
            "hidden": "string",
            "label": "string",
            "value": "string"
        }
    ],
    "referencedObjectType": "string",
    "type": "string",
    "updatedAt": "string"
}

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

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