Schema Info

Schema Name: sfdl_prod_drivethru.hubspot_molo_calls_properties

created: 2023-02-09 16:02:49
disabled: False
format: raw
id: 1512
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrujson

Schema Versions: 15

Version 1718125

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_calls_properties`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/hubspot_molo_calls_properties/2026-04-17/1776428513'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_calls_properties"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_properties/2026-04-17/1776428513
id: 1718125
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: 1512
schema_scan_id: 162173166
updated: 2026-04-17 07:22:39

Version 1716892

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_calls_properties`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/hubspot_molo_calls_properties/2026-04-16/1776341843'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_calls_properties"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_properties/2026-04-16/1776341843
id: 1716892
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: 1512
schema_scan_id: 162117418
updated: 2026-04-16 07:17:43

Version 1715700

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_calls_properties`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/hubspot_molo_calls_properties/2026-04-15/1776255772'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_calls_properties"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_properties/2026-04-15/1776255772
id: 1715700
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: 1512
schema_scan_id: 162061888
updated: 2026-04-15 07:23:43

Version 1714499

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_calls_properties`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/hubspot_molo_calls_properties/2026-04-14/1776168945'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_calls_properties"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_properties/2026-04-14/1776168945
id: 1714499
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: 1512
schema_scan_id: 162006446
updated: 2026-04-14 07:16:32

Version 1713279

created: 2026-04-13 07:18:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_calls_properties`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/hubspot_molo_calls_properties/2026-04-13/1776082644'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_calls_properties"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_properties/2026-04-13/1776082644
id: 1713279
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: 1512
schema_scan_id: 161948405
updated: 2026-04-13 07:18:54

Version 1712093

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_calls_properties`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/hubspot_molo_calls_properties/2026-04-12/1775996143'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_calls_properties"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_properties/2026-04-12/1775996143
id: 1712093
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: 1512
schema_scan_id: 161899585
updated: 2026-04-12 07:16:15

Version 1710878

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_calls_properties`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/hubspot_molo_calls_properties/2026-04-11/1775909683'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_calls_properties"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_properties/2026-04-11/1775909683
id: 1710878
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: 1512
schema_scan_id: 161846904
updated: 2026-04-11 07:15:33

Version 1709709

created: 2026-04-10 07:19:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_calls_properties`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/hubspot_molo_calls_properties/2026-04-10/1775823559'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_calls_properties"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_properties/2026-04-10/1775823559
id: 1709709
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: 1512
schema_scan_id: 161792164
updated: 2026-04-10 07:19:54

Version 1708561

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_calls_properties`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/hubspot_molo_calls_properties/2026-04-09/1775737224'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_calls_properties"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_properties/2026-04-09/1775737224
id: 1708561
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: 1512
schema_scan_id: 161736337
updated: 2026-04-09 07:20:48

Version 1707371

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_calls_properties`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/hubspot_molo_calls_properties/2026-04-08/1775650616'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_calls_properties"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_properties/2026-04-08/1775650616
id: 1707371
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: 1512
schema_scan_id: 161681499
updated: 2026-04-08 07:17:14

Version 1706174

created: 2026-04-07 07:17:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_calls_properties`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/hubspot_molo_calls_properties/2026-04-07/1775564242'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_calls_properties"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_properties/2026-04-07/1775564242
id: 1706174
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: 1512
schema_scan_id: 161625266
updated: 2026-04-07 07:17:39

Version 1704967

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_calls_properties`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/hubspot_molo_calls_properties/2026-04-06/1775477963'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_calls_properties"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_properties/2026-04-06/1775477963
id: 1704967
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: 1512
schema_scan_id: 161567415
updated: 2026-04-06 07:19:42

Version 1703730

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_calls_properties`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/hubspot_molo_calls_properties/2026-04-05/1775391588'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_calls_properties"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_properties/2026-04-05/1775391588
id: 1703730
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: 1512
schema_scan_id: 161520031
updated: 2026-04-05 07:20:22

Version 1702593

created: 2026-04-04 07:17:10

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_calls_properties`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/hubspot_molo_calls_properties/2026-04-04/1775304938'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_calls_properties"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_properties/2026-04-04/1775304938
id: 1702593
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: 1512
schema_scan_id: 161466481
updated: 2026-04-04 07:17:21

Version 1701391

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_calls_properties`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/hubspot_molo_calls_properties/2026-04-03/1775218795'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_calls_properties"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_properties/2026-04-03/1775218795
id: 1701391
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: 1512
schema_scan_id: 161408649
updated: 2026-04-03 07:20:18

Schema Scans: 15

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

Scan 162173166

duration: 0:00:12.279406

exit_message:

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

id: 162173166

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_properties/2026-04-17/1776428513",
        "key": "raw/hubspot_molo_calls_properties/2026-04-17/1776428513/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 16099018663365604305,
        "service_name": "drive-thru",
        "span_id": 1001350348412678936,
        "trace_id": 5687418112163424100
    }
}

running: False
schema_name_id: 1512
start_time: 2026-04-17 07:22:27
success: True
trace_id: 5687418112163424100

Scan 162117418

duration: 0:00:14.645252

exit_message:

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

id: 162117418

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_properties/2026-04-16/1776341843",
        "key": "raw/hubspot_molo_calls_properties/2026-04-16/1776341843/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 16299394129317136443,
        "service_name": "drive-thru",
        "span_id": 14734864709910818363,
        "trace_id": 7293952096918363489
    }
}

running: False
schema_name_id: 1512
start_time: 2026-04-16 07:17:28
success: True
trace_id: 7293952096918363489

Scan 162061888

duration: 0:00:14.782162

exit_message:

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

id: 162061888

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_properties/2026-04-15/1776255772",
        "key": "raw/hubspot_molo_calls_properties/2026-04-15/1776255772/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 10022590988280170798,
        "service_name": "drive-thru",
        "span_id": 13234867589610736666,
        "trace_id": 7239056063185829335
    }
}

running: False
schema_name_id: 1512
start_time: 2026-04-15 07:23:28
success: True
trace_id: 7239056063185829335

Scan 162006446

duration: 0:00:12.131519

exit_message:

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

id: 162006446

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_properties/2026-04-14/1776168945",
        "key": "raw/hubspot_molo_calls_properties/2026-04-14/1776168945/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 13784625589587721684,
        "service_name": "drive-thru",
        "span_id": 3848986585900114505,
        "trace_id": 10922724012919709634
    }
}

running: False
schema_name_id: 1512
start_time: 2026-04-14 07:16:19
success: True
trace_id: 10922724012919709634

Scan 161948405

duration: 0:00:14.846553

exit_message:

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

id: 161948405

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_properties/2026-04-13/1776082644",
        "key": "raw/hubspot_molo_calls_properties/2026-04-13/1776082644/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 7326798512767753082,
        "service_name": "drive-thru",
        "span_id": 1304986471832499852,
        "trace_id": 10175213852011375355
    }
}

running: False
schema_name_id: 1512
start_time: 2026-04-13 07:18:39
success: True
trace_id: 10175213852011375355

Scan 161899585

duration: 0:00:14.859008

exit_message:

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

id: 161899585

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_properties/2026-04-12/1775996143",
        "key": "raw/hubspot_molo_calls_properties/2026-04-12/1775996143/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 4993321287313171788,
        "service_name": "drive-thru",
        "span_id": 9346070558593109592,
        "trace_id": 9538045327592010437
    }
}

running: False
schema_name_id: 1512
start_time: 2026-04-12 07:16:01
success: True
trace_id: 9538045327592010437

Scan 161846904

duration: 0:00:14.527921

exit_message:

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

id: 161846904

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_properties/2026-04-11/1775909683",
        "key": "raw/hubspot_molo_calls_properties/2026-04-11/1775909683/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 14803333536022971711,
        "service_name": "drive-thru",
        "span_id": 18175241968583878202,
        "trace_id": 2374276151675845953
    }
}

running: False
schema_name_id: 1512
start_time: 2026-04-11 07:15:19
success: True
trace_id: 2374276151675845953

Scan 161792164

duration: 0:00:14.712685

exit_message:

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

id: 161792164

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_properties/2026-04-10/1775823559",
        "key": "raw/hubspot_molo_calls_properties/2026-04-10/1775823559/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 12539391264568557579,
        "service_name": "drive-thru",
        "span_id": 18201062991095880722,
        "trace_id": 1849815732534303087
    }
}

running: False
schema_name_id: 1512
start_time: 2026-04-10 07:19:39
success: True
trace_id: 1849815732534303087

Scan 161736337

duration: 0:00:14.803689

exit_message:

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

id: 161736337

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_properties/2026-04-09/1775737224",
        "key": "raw/hubspot_molo_calls_properties/2026-04-09/1775737224/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 824831754849598750,
        "service_name": "drive-thru",
        "span_id": 8512742373324652270,
        "trace_id": 10032387906914998189
    }
}

running: False
schema_name_id: 1512
start_time: 2026-04-09 07:20:33
success: True
trace_id: 10032387906914998189

Scan 161681499

duration: 0:00:12.255277

exit_message:

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

id: 161681499

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_properties/2026-04-08/1775650616",
        "key": "raw/hubspot_molo_calls_properties/2026-04-08/1775650616/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 14122592886775879230,
        "service_name": "drive-thru",
        "span_id": 14119386892516812527,
        "trace_id": 13849100053600851381
    }
}

running: False
schema_name_id: 1512
start_time: 2026-04-08 07:17:01
success: True
trace_id: 13849100053600851381

Scan 161625266

duration: 0:00:14.787025

exit_message:

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

id: 161625266

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_properties/2026-04-07/1775564242",
        "key": "raw/hubspot_molo_calls_properties/2026-04-07/1775564242/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 3135341145797928910,
        "service_name": "drive-thru",
        "span_id": 1591991587299367593,
        "trace_id": 4215780437940013409
    }
}

running: False
schema_name_id: 1512
start_time: 2026-04-07 07:17:24
success: True
trace_id: 4215780437940013409

Scan 161567415

duration: 0:00:12.393703

exit_message:

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

id: 161567415

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_properties/2026-04-06/1775477963",
        "key": "raw/hubspot_molo_calls_properties/2026-04-06/1775477963/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 9994718547719891065,
        "service_name": "drive-thru",
        "span_id": 1885803302614754706,
        "trace_id": 7023253209929420759
    }
}

running: False
schema_name_id: 1512
start_time: 2026-04-06 07:19:30
success: True
trace_id: 7023253209929420759

Scan 161520031

duration: 0:00:12.075667

exit_message:

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

id: 161520031

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_properties/2026-04-05/1775391588",
        "key": "raw/hubspot_molo_calls_properties/2026-04-05/1775391588/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 11476518172256369184,
        "service_name": "drive-thru",
        "span_id": 1628814115473225265,
        "trace_id": 14440214124034764163
    }
}

running: False
schema_name_id: 1512
start_time: 2026-04-05 07:20:10
success: True
trace_id: 14440214124034764163

Scan 161466481

duration: 0:00:12.087233

exit_message:

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

id: 161466481

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_properties/2026-04-04/1775304938",
        "key": "raw/hubspot_molo_calls_properties/2026-04-04/1775304938/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 15565328304301143270,
        "service_name": "drive-thru",
        "span_id": 14242966527703310175,
        "trace_id": 15126358095320655874
    }
}

running: False
schema_name_id: 1512
start_time: 2026-04-04 07:17:09
success: True
trace_id: 15126358095320655874

Scan 161408649

duration: 0:00:12.355128

exit_message:

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

id: 161408649

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls_properties/2026-04-03/1775218795",
        "key": "raw/hubspot_molo_calls_properties/2026-04-03/1775218795/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls_properties",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 3556228478649204558,
        "service_name": "drive-thru",
        "span_id": 11766273296567290666,
        "trace_id": 15233080981997071834
    }
}

running: False
schema_name_id: 1512
start_time: 2026-04-03 07:20:06
success: True
trace_id: 15233080981997071834

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:22:28

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_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-prod/raw/hubspot_molo_calls_properties/2026-04-17/1776428513'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_calls_properties`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_calls_properties"
}

Server:

hostname: schemamanager-5475496c57-7dpqb
name: schema_manager
process_start: 2026-01-09 11:27:47
sf_env: prod
version: 2112174301

Raw:

{
    "name": {
        "created": "2023-02-09 16:02:49",
        "disabled": false,
        "format": "raw",
        "id": 1512,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_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:22:28",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_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-prod/raw/hubspot_molo_calls_properties/2026-04-17/1776428513'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_calls_properties`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_calls_properties"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}