Schema Info

Schema Name: sfdl_prod_segment.ssdc_modal_close

created: 2018-10-11 15:40:30
disabled: False
format: raw
id: 556
is_partitioned: True
is_schema_datatyped: False

name:

{
    "database": "sfdl_prod_segment",
    "table": "ssdc_modal_close"
}

type: segment

Schema Versions: 3

Version 120663

created: 2020-01-16 13:25:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`",
    "DROP TABLE IF EXISTS `sfdl_prod_segment.ssdc_modal_close`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.ssdc_modal_close`\n(\n`sentAt`STRING,`version`STRING,`event`STRING,`type`STRING,`integrations`struct<`page`:struct<`url`:STRING,`path`:STRING,`search`:STRING,`title`:STRING,`referrer`:STRING>,`library`:struct<`version`:STRING,`name`:STRING>>,`anonymousId`STRING,`timestamp`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`properties`struct<`label`:STRING,`Hit_Timestamp`:STRING,`site_id`:STRING,`category`:STRING,`isReact`:STRING,`env`:STRING>,`receivedAt`STRING,`messageId`STRING,`context`struct<`locale`:STRING,`library`:struct<`name`:STRING,`version`:STRING>,`campaign`:struct<`content`:STRING,`source`:STRING,`medium`:STRING,`name`:STRING>,`ip`:STRING,`userAgent`:STRING,`page`:struct<`search`:STRING,`referrer`:STRING,`url`:STRING,`title`:STRING,`path`:STRING>>,`userId`STRING,`_origin`STRING,`originalTimestamp`STRING,`channel`STRING,`projectId`STRING\n)\nPARTITIONED BY (dt string)\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-segment-ssdc-prod/separated_dt/modal close'\n",
    "MSCK REPAIR TABLE sfdl_prod_segment.ssdc_modal_close"
]

hive_path: s3://sfdl-segment-ssdc-prod/separated_dt/modal close
id: 120663
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "unbundled": []
    },
    "_origin": "2020-01-16T19:03:56Z|s3://sfdl-segment-ssdc-prod/segment-logs/5yGJd9z7eL/1579132800000/1579200966121.7d184d6e1834.e4797d0.8e64123f-1098-4044-8446-7008956c2850.gz|segment_separator:37",
    "anonymousId": "174a7823-91c2-4b41-8607-a689cddcd0bc",
    "channel": "client",
    "context": {
        "ip": "69.206.194.168",
        "library": {
            "name": "analytics.js",
            "version": "3.10.1"
        },
        "locale": "en-US",
        "page": {
            "path": "/self-storage/new-york/middletown/columbia-self-storage-middletown-211876/",
            "referrer": "https://duckduckgo.com/",
            "search": "",
            "title": "Columbia Self Storage - Middletown: Lowest Rates - SelfStorage.com",
            "url": "https://www.selfstorage.com/self-storage/new-york/middletown/columbia-self-storage-middletown-211876/"
        },
        "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:72.0) Gecko/20100101 Firefox/72.0"
    },
    "event": "modal close",
    "integrations": {},
    "messageId": "ajs-0f2b571007d2c69355016304727c2b5d",
    "originalTimestamp": "2020-01-16T18:15:08.814Z",
    "projectId": "5yGJd9z7eL",
    "properties": {
        "Hit Timestamp": 1579198508813,
        "category": "facility interactions-facilityPage",
        "env": "production",
        "isReact": true,
        "label": "amazon modal",
        "site_id": 27
    },
    "receivedAt": "2020-01-16T18:15:09.647Z",
    "sentAt": "2020-01-16T18:15:08.815Z",
    "timestamp": "2020-01-16T18:15:09.646Z",
    "type": "track",
    "userId": "4949c9a4c87f9388f3467d7eff3b78bb",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.campaign.content": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.campaign.source": "string",
    "context.ip": "string",
    "context.library.name": "string",
    "context.library.version": "string",
    "context.locale": "string",
    "context.page.path": "string",
    "context.page.referrer": "string",
    "context.page.search": "string",
    "context.page.title": "string",
    "context.page.url": "string",
    "context.userAgent": "string",
    "event": "string",
    "integrations.library.name": "string",
    "integrations.library.version": "string",
    "integrations.page.path": "string",
    "integrations.page.referrer": "string",
    "integrations.page.search": "string",
    "integrations.page.title": "string",
    "integrations.page.url": "string",
    "messageId": "string",
    "originalTimestamp": "string",
    "projectId": "string",
    "properties.Hit_Timestamp": "string",
    "properties.category": "string",
    "properties.env": "string",
    "properties.isReact": "string",
    "properties.label": "string",
    "properties.site_id": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 556
schema_scan_id: 31694258
updated: 2020-01-16 13:28:54

Version 73705

created: 2019-04-30 15:04:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`",
    "DROP TABLE IF EXISTS `sfdl_prod_segment.ssdc_modal_close`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.ssdc_modal_close`\n(\n`timestamp`STRING,`userId`STRING,`integrations`struct<`page`:struct<`url`:STRING,`path`:STRING,`search`:STRING,`title`:STRING,`referrer`:STRING>,`library`:struct<`version`:STRING,`name`:STRING>>,`receivedAt`STRING,`anonymousId`STRING,`_origin`STRING,`properties`struct<`category`:STRING,`Hit_Timestamp`:STRING,`isReact`:STRING,`site_id`:STRING,`label`:STRING,`env`:STRING>,`projectId`STRING,`event`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`version`STRING,`originalTimestamp`STRING,`context`struct<`userAgent`:STRING,`campaign`:struct<`content`:STRING,`source`:STRING,`medium`:STRING,`name`:STRING>,`page`:struct<`url`:STRING,`path`:STRING,`search`:STRING,`referrer`:STRING,`title`:STRING>,`library`:struct<`version`:STRING,`name`:STRING>,`ip`:STRING>,`messageId`STRING,`type`STRING,`channel`STRING,`sentAt`STRING\n)\nPARTITIONED BY (dt string)\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-segment-ssdc-prod/separated_dt/modal close'\n",
    "MSCK REPAIR TABLE sfdl_prod_segment.ssdc_modal_close"
]

hive_path: s3://sfdl-segment-ssdc-prod/separated_dt/modal close
id: 73705
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "unbundled": []
    },
    "_origin": "2019-04-30T19:57:37Z|s3://sfdl-segment-ssdc-prod/segment-logs/5yGJd9z7eL/1556582400000/1556654194444.ea245cc7f2f1.9f83b95.8c48cd14-dc77-483d-9848-ffeb4f6ff30e.gz|segment_separator:37",
    "anonymousId": "fae60661-ac1e-4348-8c74-95b415145711",
    "channel": "client",
    "context": {
        "ip": "156.99.127.65",
        "library": {
            "name": "unknown",
            "version": "unknown"
        },
        "userAgent": "Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36"
    },
    "event": "modal close",
    "integrations": {
        "library": {
            "name": "analytics.js",
            "version": "3.8.2"
        },
        "page": {
            "path": "/self-storage/minnesota/minneapolis/coon-rapids-storage-158510/",
            "referrer": "https://www.google.com/",
            "search": "",
            "title": "Coon Rapids Storage: Lowest Rates - SelfStorage.com",
            "url": "https://www.selfstorage.com/self-storage/minnesota/minneapolis/coon-rapids-storage-158510/"
        }
    },
    "messageId": "ajs-d3bd233f29c05597d24d3463769c0ea6",
    "originalTimestamp": "2019-04-30T19:39:31.918Z",
    "projectId": "5yGJd9z7eL",
    "properties": {
        "Hit Timestamp": 1556653171916,
        "category": "facility interactions-facilityPage",
        "env": "production",
        "isReact": true,
        "label": "unit-size modal",
        "site_id": 27
    },
    "receivedAt": "2019-04-30T19:39:32.154Z",
    "sentAt": "2019-04-30T19:39:31.921Z",
    "timestamp": "2019-04-30T19:39:32.151Z",
    "type": "track",
    "userId": "4188eb3d36178eeb203374e9ed5c2e75",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.campaign.content": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.campaign.source": "string",
    "context.ip": "string",
    "context.library.name": "string",
    "context.library.version": "string",
    "context.page.path": "string",
    "context.page.referrer": "string",
    "context.page.search": "string",
    "context.page.title": "string",
    "context.page.url": "string",
    "context.userAgent": "string",
    "event": "string",
    "integrations.library.name": "string",
    "integrations.library.version": "string",
    "integrations.page.path": "string",
    "integrations.page.referrer": "string",
    "integrations.page.search": "string",
    "integrations.page.title": "string",
    "integrations.page.url": "string",
    "messageId": "string",
    "originalTimestamp": "string",
    "projectId": "string",
    "properties.Hit_Timestamp": "string",
    "properties.category": "string",
    "properties.env": "string",
    "properties.isReact": "string",
    "properties.label": "string",
    "properties.site_id": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 556
schema_scan_id: 24400539
updated: 2019-04-30 15:05:22

Version 52059

created: 2018-11-12 14:02:07

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`",
    "DROP TABLE IF EXISTS `sfdl_prod_segment.ssdc_modal_close`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.ssdc_modal_close`\n(\n `version`  string , `timestamp`  string , `messageId`  string , `userId`  string , `event`  string , `receivedAt`  string ,`_metadata`   struct< `bundled`:array , `unbundled`:array >, `anonymousId`  string , `originalTimestamp`  string ,`context`   struct< `userAgent` : string ,`library` :  struct< `version` : string , `name` : string >,`page` :  struct< `url` : string , `path` : string , `search` : string , `referrer` : string , `title` : string >,`campaign` :  struct< `content` : string , `source` : string , `medium` : string , `name` : string >, `ip` : string >, `projectId`  string , `_origin`  string , `type`  string ,`properties`   struct< `category` : string , `Hit_Timestamp` : string , `isReact` : string , `site_id` : string , `label` : string , `env` : string >, `channel`  string , `sentAt`  string \n)\nPARTITIONED BY (dt string)\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-segment-ssdc-prod/separated_dt/modal close'\n",
    "MSCK REPAIR TABLE sfdl_prod_segment.ssdc_modal_close"
]

hive_path: s3://sfdl-segment-ssdc-prod/separated_dt/modal close
id: 52059
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "unbundled": []
    },
    "_origin": "2018-11-12T20:01:47Z|s3://sfdl-segment-ssdc-prod/segment-logs/5yGJd9z7eL/1541980800000/1542052762697.0517ac90e6d9.1.11.1.75ef3481-f4f2-4dcd-9a6f-919d54a10cdf.gz|segment_separator:37",
    "anonymousId": "59c01240-c5ba-4629-ba83-250583d57fd2",
    "channel": "client",
    "context": {
        "campaign": {
            "content": "",
            "medium": "paidsearch",
            "name": "pro_national_nogeo_noproduct_dynamic",
            "source": "google"
        },
        "ip": "74.113.190.218",
        "library": {
            "name": "analytics.js",
            "version": "3.7.2"
        },
        "page": {
            "path": "/self-storage/arizona/phoenix/rightspace-storage-17201-n-black-canyon-206007/",
            "referrer": "",
            "search": "?tsid=google-ppc&utm_source=google&utm_medium=paidsearch&utm_campaign=pro_national_nogeo_noproduct_dynamic&utm_content=&ploc=1015054&iloc=1013462&mkwid=sunlk3q5v%7Cpcrid%7C271834763890%7Cpkw%7C%7Cpmt%7Cb%7Cpdv%7Cc%7Cpgrid%7C9903841411%7Cptaid%7Cdsa-45429481739&pgrid=9903841411&ptaid=dsa-45429481739&gclid=Cj0KCQiAw5_fBRCSARIsAGodhk-mh1IxnC09sbwS92wVD2-sEIGy-IKadH2jaoDhl_HT0K4u0s-_rZUaAp-OEALw_wcB",
            "title": "RightSpace Storage - 17201 N Black Canyon: Lowest Rates - SelfStorage.com",
            "url": "https://www.selfstorage.com/self-storage/arizona/phoenix/rightspace-storage-17201-n-black-canyon-206007/?tsid=google-ppc&utm_source=google&utm_medium=paidsearch&utm_campaign=pro_national_nogeo_noproduct_dynamic&utm_content=&ploc=1015054&iloc=1013462&mkwid=sunlk3q5v%7Cpcrid%7C271834763890%7Cpkw%7C%7Cpmt%7Cb%7Cpdv%7Cc%7Cpgrid%7C9903841411%7Cptaid%7Cdsa-45429481739&pgrid=9903841411&ptaid=dsa-45429481739&gclid=Cj0KCQiAw5_fBRCSARIsAGodhk-mh1IxnC09sbwS92wVD2-sEIGy-IKadH2jaoDhl_HT0K4u0s-_rZUaAp-OEALw_wcB"
        },
        "userAgent": "Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3440.75 Safari/537.36"
    },
    "event": "modal close",
    "integrations": {},
    "messageId": "ajs-cf782348cecf0fe2feb7b1c775cf158e",
    "originalTimestamp": "2018-11-12T19:02:18.669Z",
    "projectId": "5yGJd9z7eL",
    "properties": {
        "Hit Timestamp": 1542049338669,
        "category": "facility interactions-ssdc_facility",
        "env": "production",
        "isReact": true,
        "label": "unit-size modal",
        "site_id": 27
    },
    "receivedAt": "2018-11-12T19:02:18.785Z",
    "sentAt": "2018-11-12T19:02:18.671Z",
    "timestamp": "2018-11-12T19:02:18.783Z",
    "type": "track",
    "userId": "2b8cafa074a47a99feeb4f62fd0baad5",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.campaign.content": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.campaign.source": "string",
    "context.ip": "string",
    "context.library.name": "string",
    "context.library.version": "string",
    "context.page.path": "string",
    "context.page.referrer": "string",
    "context.page.search": "string",
    "context.page.title": "string",
    "context.page.url": "string",
    "context.userAgent": "string",
    "event": "string",
    "messageId": "string",
    "originalTimestamp": "string",
    "projectId": "string",
    "properties.Hit_Timestamp": "string",
    "properties.category": "string",
    "properties.env": "string",
    "properties.isReact": "string",
    "properties.label": "string",
    "properties.site_id": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 556
schema_scan_id: 20410875
updated: 2018-11-12 14:02:21

Schema Scans: 3

Last at 2020-01-16 13:25:47

Scan 31694258

duration: 0:01:38.630677

exit_message:

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

id: 31694258

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "partition": {
        "location": "s3://sfdl-segment-ssdc-prod/separated_dt/modal close/dt=2020-01-16/",
        "name": "dt",
        "type": "string",
        "value": "2020-01-16"
    },
    "s3": {
        "bucket": "sfdl-segment-ssdc-prod",
        "hive_path": "s3://sfdl-segment-ssdc-prod/separated_dt/modal close",
        "key": "separated_dt/modal close/dt=2020-01-16/1579200966121.7d184d6e1834.e4797d0.8e64123f-1098-4044-8446-7008956c2850.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_segment.ssdc_modal_close",
        "type": "segment"
    }
}

running: False
schema_name_id: 556
start_time: 2020-01-16 13:25:47
success: True
trace_id: 12352780141333730241

Scan 24400539

duration: 0:00:43.281609

exit_message:

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

id: 24400539

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "partition": {
        "location": "s3://sfdl-segment-ssdc-prod/separated_dt/modal close/dt=2019-04-30/",
        "name": "dt",
        "type": "string",
        "value": "2019-04-30"
    },
    "s3": {
        "bucket": "sfdl-segment-ssdc-prod",
        "hive_path": "s3://sfdl-segment-ssdc-prod/separated_dt/modal close",
        "key": "separated_dt/modal close/dt=2019-04-30/1556654194444.ea245cc7f2f1.9f83b95.8c48cd14-dc77-483d-9848-ffeb4f6ff30e.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_segment.ssdc_modal_close",
        "type": "segment"
    }
}

running: False
schema_name_id: 556
start_time: 2019-04-30 15:04:43
success: True
trace_id: 6390723239246408086

Scan 20410875

duration: 0:00:17.019183

exit_message:

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

id: 20410875

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "partition": {
        "location": "s3://sfdl-segment-ssdc-prod/separated_dt/modal close/dt=2018-11-12/",
        "name": "dt",
        "type": "string",
        "value": "2018-11-12"
    },
    "s3": {
        "bucket": "sfdl-segment-ssdc-prod",
        "hive_path": "s3://sfdl-segment-ssdc-prod/separated_dt/modal close",
        "key": "separated_dt/modal close/dt=2018-11-12/1542052762697.0517ac90e6d9.1.11.1.75ef3481-f4f2-4dcd-9a6f-919d54a10cdf.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_segment.ssdc_modal_close",
        "type": "segment"
    }
}

running: False
schema_name_id: 556
start_time: 2018-11-12 14:02:07
success: True
trace_id: 18084471218811516768

Partitions:

count: 3

ddl:

[
    "ALTER TABLE\n    `sfdl_prod_segment.ssdc_modal_close`\nADD\n\n\n PARTITION (dt='2021-02-09') location 's3://sfdl-segment-ssdc-prod/separated_dt/modal close/dt=2021-02-09/'\n PARTITION (dt='2021-02-10') location 's3://sfdl-segment-ssdc-prod/separated_dt/modal close/dt=2021-02-10/'\n PARTITION (dt='2021-02-11') location 's3://sfdl-segment-ssdc-prod/separated_dt/modal close/dt=2021-02-11/'\n;"
]

name: dt

state:

[
    {
        "info": {
            "id": 541122,
            "location": "s3://sfdl-segment-ssdc-prod/separated_dt/modal close/dt=2021-02-09/",
            "name": "dt",
            "value": "2021-02-09"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2021-02-08 19:16:28",
                "last_data": "2021-02-09 17:25:44"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 541300,
            "location": "s3://sfdl-segment-ssdc-prod/separated_dt/modal close/dt=2021-02-10/",
            "name": "dt",
            "value": "2021-02-10"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2021-02-09 19:17:28",
                "last_data": "2021-02-10 16:22:19"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 541456,
            "location": "s3://sfdl-segment-ssdc-prod/separated_dt/modal close/dt=2021-02-11/",
            "name": "dt",
            "value": "2021-02-11"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2021-02-10 18:17:39",
                "last_data": "2021-02-11 15:18:09"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    }
]

type: string

Schema:

attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.campaign.content": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.campaign.source": "string",
    "context.ip": "string",
    "context.library.name": "string",
    "context.library.version": "string",
    "context.locale": "string",
    "context.page.path": "string",
    "context.page.referrer": "string",
    "context.page.search": "string",
    "context.page.title": "string",
    "context.page.url": "string",
    "context.userAgent": "string",
    "event": "string",
    "integrations.library.name": "string",
    "integrations.library.version": "string",
    "integrations.page.path": "string",
    "integrations.page.referrer": "string",
    "integrations.page.search": "string",
    "integrations.page.title": "string",
    "integrations.page.url": "string",
    "messageId": "string",
    "originalTimestamp": "string",
    "projectId": "string",
    "properties.Hit_Timestamp": "string",
    "properties.category": "string",
    "properties.env": "string",
    "properties.isReact": "string",
    "properties.label": "string",
    "properties.site_id": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

created: 2020-01-16 13:25:49

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.ssdc_modal_close`\n(\n`sentAt`STRING,`version`STRING,`event`STRING,`type`STRING,`integrations`struct<`page`:struct<`url`:STRING,`path`:STRING,`search`:STRING,`title`:STRING,`referrer`:STRING>,`library`:struct<`version`:STRING,`name`:STRING>>,`anonymousId`STRING,`timestamp`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`properties`struct<`label`:STRING,`Hit_Timestamp`:STRING,`site_id`:STRING,`category`:STRING,`isReact`:STRING,`env`:STRING>,`receivedAt`STRING,`messageId`STRING,`context`struct<`locale`:STRING,`library`:struct<`name`:STRING,`version`:STRING>,`campaign`:struct<`content`:STRING,`source`:STRING,`medium`:STRING,`name`:STRING>,`ip`:STRING,`userAgent`:STRING,`page`:struct<`search`:STRING,`referrer`:STRING,`url`:STRING,`title`:STRING,`path`:STRING>>,`userId`STRING,`_origin`STRING,`originalTimestamp`STRING,`channel`STRING,`projectId`STRING\n)\nPARTITIONED BY (dt string)\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-segment-ssdc-prod/separated_dt/modal close'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_segment.ssdc_modal_close`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_segment.ssdc_modal_close"
}

Server:

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

Raw:

{
    "name": {
        "created": "2018-10-11 15:40:30",
        "disabled": false,
        "format": "raw",
        "id": 556,
        "is_partitioned": true,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_prod_segment",
            "table": "ssdc_modal_close"
        },
        "type": "segment"
    },
    "partition": {
        "count": 3,
        "ddl": [
            "ALTER TABLE\n    `sfdl_prod_segment.ssdc_modal_close`\nADD\n\n\n PARTITION (dt='2021-02-09') location 's3://sfdl-segment-ssdc-prod/separated_dt/modal close/dt=2021-02-09/'\n PARTITION (dt='2021-02-10') location 's3://sfdl-segment-ssdc-prod/separated_dt/modal close/dt=2021-02-10/'\n PARTITION (dt='2021-02-11') location 's3://sfdl-segment-ssdc-prod/separated_dt/modal close/dt=2021-02-11/'\n;"
        ],
        "name": "dt",
        "state": [
            {
                "info": {
                    "id": 541122,
                    "location": "s3://sfdl-segment-ssdc-prod/separated_dt/modal close/dt=2021-02-09/",
                    "name": "dt",
                    "value": "2021-02-09"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2021-02-08 19:16:28",
                        "last_data": "2021-02-09 17:25:44"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 541300,
                    "location": "s3://sfdl-segment-ssdc-prod/separated_dt/modal close/dt=2021-02-10/",
                    "name": "dt",
                    "value": "2021-02-10"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2021-02-09 19:17:28",
                        "last_data": "2021-02-10 16:22:19"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 541456,
                    "location": "s3://sfdl-segment-ssdc-prod/separated_dt/modal close/dt=2021-02-11/",
                    "name": "dt",
                    "value": "2021-02-11"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2021-02-10 18:17:39",
                        "last_data": "2021-02-11 15:18:09"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            }
        ],
        "type": "string"
    },
    "schema": {
        "attributes": {
            "_origin": "string",
            "anonymousId": "string",
            "channel": "string",
            "context.campaign.content": "string",
            "context.campaign.medium": "string",
            "context.campaign.name": "string",
            "context.campaign.source": "string",
            "context.ip": "string",
            "context.library.name": "string",
            "context.library.version": "string",
            "context.locale": "string",
            "context.page.path": "string",
            "context.page.referrer": "string",
            "context.page.search": "string",
            "context.page.title": "string",
            "context.page.url": "string",
            "context.userAgent": "string",
            "event": "string",
            "integrations.library.name": "string",
            "integrations.library.version": "string",
            "integrations.page.path": "string",
            "integrations.page.referrer": "string",
            "integrations.page.search": "string",
            "integrations.page.title": "string",
            "integrations.page.url": "string",
            "messageId": "string",
            "originalTimestamp": "string",
            "projectId": "string",
            "properties.Hit_Timestamp": "string",
            "properties.category": "string",
            "properties.env": "string",
            "properties.isReact": "string",
            "properties.label": "string",
            "properties.site_id": "string",
            "receivedAt": "string",
            "sentAt": "string",
            "timestamp": "string",
            "type": "string",
            "userId": "string",
            "version": "string"
        },
        "created": "2020-01-16 13:25:49",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.ssdc_modal_close`\n(\n`sentAt`STRING,`version`STRING,`event`STRING,`type`STRING,`integrations`struct<`page`:struct<`url`:STRING,`path`:STRING,`search`:STRING,`title`:STRING,`referrer`:STRING>,`library`:struct<`version`:STRING,`name`:STRING>>,`anonymousId`STRING,`timestamp`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`properties`struct<`label`:STRING,`Hit_Timestamp`:STRING,`site_id`:STRING,`category`:STRING,`isReact`:STRING,`env`:STRING>,`receivedAt`STRING,`messageId`STRING,`context`struct<`locale`:STRING,`library`:struct<`name`:STRING,`version`:STRING>,`campaign`:struct<`content`:STRING,`source`:STRING,`medium`:STRING,`name`:STRING>,`ip`:STRING,`userAgent`:STRING,`page`:struct<`search`:STRING,`referrer`:STRING,`url`:STRING,`title`:STRING,`path`:STRING>>,`userId`STRING,`_origin`STRING,`originalTimestamp`STRING,`channel`STRING,`projectId`STRING\n)\nPARTITIONED BY (dt string)\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-segment-ssdc-prod/separated_dt/modal close'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_segment.ssdc_modal_close`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_segment.ssdc_modal_close"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}