Schema Info

Schema Name: sfdl_dev_segment.storagescout_click

created: 2019-03-28 11:32:20
disabled: False
format: raw
id: 1228
is_partitioned: True
is_schema_datatyped: False

name:

{
    "database": "sfdl_dev_segment",
    "table": "storagescout_click"
}

type: segment

Schema Versions: 3

Version 4684479

created: 2021-03-04 14:21:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`",
    "DROP TABLE IF EXISTS `sfdl_dev_segment.storagescout_click`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.storagescout_click`\n(\n`integrations`struct<`_empty_`:STRING>,`event`STRING,`version`STRING,`timestamp`STRING,`originalTimestamp`STRING,`receivedAt`STRING,`projectId`STRING,`userId`STRING,`_origin`STRING,`anonymousId`STRING,`properties`struct<`9`:STRING,`label`:STRING,`13`:STRING,`site_id`:STRING,`facilityId`:STRING,`1`:STRING,`4`:STRING,`breadcrumb`:STRING,`category`:STRING,`11`:STRING,`16`:STRING,`env`:STRING,`5`:STRING,`value`:STRING,`14`:STRING,`2`:STRING,`0`:STRING,`15`:STRING,`6`:STRING,`12`:STRING,`7`:STRING,`isReact`:STRING,`8`:STRING,`17`:STRING,`3`:STRING,`moveInDateSelected`:STRING,`10`:STRING,`extra`:struct<`unitId`:STRING,`facilityId`:STRING,`dateSelected`:STRING,`place`:struct<`photos`:array,`width`:STRING>>,`formatted_address`:STRING,`types`:array,`scope`:STRING,`url`:STRING,`geometry`:struct<`viewport`:struct<`Qa`:struct<`i`:STRING,`j`:STRING>,`ga`:struct<`j`:STRING,`l`:STRING>,`pa`:struct<`h`:STRING,`g`:STRING>,`Ya`:struct<`i`:STRING,`j`:STRING>,`Va`:struct<`i`:STRING,`j`:STRING>,`na`:struct<`j`:STRING,`l`:STRING>,`oa`:struct<`h`:STRING,`g`:STRING>,`ka`:struct<`h`:STRING,`g`:STRING>,`ia`:struct<`j`:STRING,`l`:STRING>,`Ua`:struct<`i`:STRING,`j`:STRING>,`Ra`:struct<`g`:STRING,`i`:STRING>,`La`:struct<`g`:STRING,`i`:STRING>>>,`utc_offset`:STRING,`icon`:STRING,`vicinity`:STRING,`website`:STRING,`place_id`:STRING,`address_components`:array>>,`html_attributions`:array,`utc_offset_minutes`:STRING,`name`:STRING,`adr_address`:STRING,`reference`:STRING,`id`:STRING>>,`Hit_Timestamp`:STRING>,`channel`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`messageId`STRING,`context`struct<`locale`:STRING,`userAgent`:STRING,`page`:struct<`title`:STRING,`search`:STRING,`url`:STRING,`path`:STRING,`referrer`:STRING>,`ip`:STRING,`library`:struct<`name`:STRING,`version`:STRING>,`campaign`:struct<`_empty_`:STRING>>,`type`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-storagescout-dev/separated_dt/click'\n",
    "MSCK REPAIR TABLE sfdl_dev_segment.storagescout_click"
]

hive_path: s3://sfdl-segment-storagescout-dev/separated_dt/click
id: 4684479
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "bundledIds": [
            "5cfe787456e4780001147814",
            "5ce8476368627300017bf3e5"
        ],
        "unbundled": []
    },
    "_origin": "2021-03-04T20:21:08Z|s3://sfdl-segment-storagescout-dev/segment-logs/adK1RCRyGa/1614816000000/1614888924636.3fc67538772f.fde281a.7a617201-9489-4451-bbc0-8cfab0f55efc.gz|analytics-segment-separator-dev:$LATEST",
    "anonymousId": "a90a7467-519a-4ace-8ec0-8180400b8013",
    "channel": "client",
    "context": {
        "ip": "34.239.223.223",
        "library": {
            "name": "analytics.js",
            "version": "4.0.4"
        },
        "locale": "en-US",
        "page": {
            "path": "/",
            "referrer": "",
            "search": "",
            "title": "Self Storage Deals & Discounts Near Me | USStorageSearch",
            "url": "https://usstoragesearch.moreyard.com/"
        },
        "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.96 Safari/537.36"
    },
    "event": "click",
    "integrations": {},
    "messageId": "ajs-fda199f37b52ca6bc470a62631ec46ee",
    "originalTimestamp": "2021-03-04T20:04:09.301Z",
    "projectId": "adK1RCRyGa",
    "properties": {
        "Hit Timestamp": 1614888249298,
        "category": "missing category-index",
        "env": "dev",
        "extra": {
            "place": {
                "address_components": [
                    {
                        "long_name": "Louisville",
                        "short_name": "Louisville",
                        "types": [
                            "locality",
                            "political"
                        ]
                    },
                    {
                        "long_name": "Jefferson County",
                        "short_name": "Jefferson County",
                        "types": [
                            "administrative_area_level_2",
                            "political"
                        ]
                    },
                    {
                        "long_name": "Kentucky",
                        "short_name": "KY",
                        "types": [
                            "administrative_area_level_1",
                            "political"
                        ]
                    },
                    {
                        "long_name": "United States",
                        "short_name": "US",
                        "types": [
                            "country",
                            "political"
                        ]
                    }
                ],
                "adr_address": "Louisville, KY, USA",
                "formatted_address": "Louisville, KY, USA",
                "geometry": {
                    "location": {},
                    "viewport": {
                        "La": {
                            "g": -85.94844104021959,
                            "i": -85.40509997801766
                        },
                        "Ra": {
                            "g": 37.99710001138357,
                            "i": 38.38051003915312
                        }
                    }
                },
                "html_attributions": [],
                "icon": "https://maps.gstatic.com/mapfiles/place_api/icons/v1/png_71/geocode-71.png",
                "name": "Louisville",
                "photos": [
                    {
                        "height": 297,
                        "html_attributions": [
                            "Craig Altemeyer"
                        ],
                        "width": 450
                    },
                    {
                        "height": 2160,
                        "html_attributions": [
                            "Roger Peter"
                        ],
                        "width": 3840
                    },
                    {
                        "height": 802,
                        "html_attributions": [
                            "StockTotal"
                        ],
                        "width": 1203
                    },
                    {
                        "height": 4032,
                        "html_attributions": [
                            "Mike Bartsch"
                        ],
                        "width": 3024
                    },
                    {
                        "height": 3006,
                        "html_attributions": [
                            "steve & kimberly morton"
                        ],
                        "width": 5344
                    },
                    {
                        "height": 4032,
                        "html_attributions": [
                            "Williams Pacheco"
                        ],
                        "width": 3024
                    },
                    {
                        "height": 3006,
                        "html_attributions": [
                            "Michael Welsh"
                        ],
                        "width": 5344
                    },
                    {
                        "height": 1908,
                        "html_attributions": [
                            "Bo McDougal"
                        ],
                        "width": 4032
                    },
                    {
                        "height": 3024,
                        "html_attributions": [
                            "Kim B"
                        ],
                        "width": 4032
                    },
                    {
                        "height": 3000,
                        "html_attributions": [
                            "Michael Skelton"
                        ],
                        "width": 4000
                    }
                ],
                "place_id": "ChIJEdVbsxoLaYgRMv1xICi009Q",
                "reference": "ChIJEdVbsxoLaYgRMv1xICi009Q",
                "types": [
                    "locality",
                    "political"
                ],
                "url": "https://maps.google.com/?q=Louisville,+KY,+USA&ftid=0x88690b1ab35bd511:0xd4d3b4282071fd32",
                "utc_offset": -300,
                "utc_offset_minutes": -300,
                "vicinity": "Louisville",
                "website": "http://www.louisvilleky.gov/"
            }
        },
        "isReact": true,
        "label": "search autocomplete",
        "site_id": 413
    },
    "receivedAt": "2021-03-04T20:04:09.630Z",
    "sentAt": "2021-03-04T20:04:09.306Z",
    "timestamp": "2021-03-04T20:04:09.625Z",
    "type": "track",
    "userId": "49eb9b116b86fe3b6f282009da877ec7",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "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",
    "messageId": "string",
    "originalTimestamp": "string",
    "projectId": "string",
    "properties.0": "string",
    "properties.1": "string",
    "properties.10": "string",
    "properties.11": "string",
    "properties.12": "string",
    "properties.13": "string",
    "properties.14": "string",
    "properties.15": "string",
    "properties.16": "string",
    "properties.17": "string",
    "properties.2": "string",
    "properties.3": "string",
    "properties.4": "string",
    "properties.5": "string",
    "properties.6": "string",
    "properties.7": "string",
    "properties.8": "string",
    "properties.9": "string",
    "properties.Hit_Timestamp": "string",
    "properties.breadcrumb": "string",
    "properties.category": "string",
    "properties.env": "string",
    "properties.extra.dateSelected": "string",
    "properties.extra.facilityId": "string",
    "properties.extra.place.address_components": [
        {
            "long_name": "string",
            "short_name": "string",
            "types": [
                "string"
            ]
        }
    ],
    "properties.extra.place.adr_address": "string",
    "properties.extra.place.formatted_address": "string",
    "properties.extra.place.geometry.viewport.La.g": "string",
    "properties.extra.place.geometry.viewport.La.i": "string",
    "properties.extra.place.geometry.viewport.Qa.i": "string",
    "properties.extra.place.geometry.viewport.Qa.j": "string",
    "properties.extra.place.geometry.viewport.Ra.g": "string",
    "properties.extra.place.geometry.viewport.Ra.i": "string",
    "properties.extra.place.geometry.viewport.Ua.i": "string",
    "properties.extra.place.geometry.viewport.Ua.j": "string",
    "properties.extra.place.geometry.viewport.Va.i": "string",
    "properties.extra.place.geometry.viewport.Va.j": "string",
    "properties.extra.place.geometry.viewport.Ya.i": "string",
    "properties.extra.place.geometry.viewport.Ya.j": "string",
    "properties.extra.place.geometry.viewport.ga.j": "string",
    "properties.extra.place.geometry.viewport.ga.l": "string",
    "properties.extra.place.geometry.viewport.ia.j": "string",
    "properties.extra.place.geometry.viewport.ia.l": "string",
    "properties.extra.place.geometry.viewport.ka.g": "string",
    "properties.extra.place.geometry.viewport.ka.h": "string",
    "properties.extra.place.geometry.viewport.na.j": "string",
    "properties.extra.place.geometry.viewport.na.l": "string",
    "properties.extra.place.geometry.viewport.oa.g": "string",
    "properties.extra.place.geometry.viewport.oa.h": "string",
    "properties.extra.place.geometry.viewport.pa.g": "string",
    "properties.extra.place.geometry.viewport.pa.h": "string",
    "properties.extra.place.html_attributions": [
        "string"
    ],
    "properties.extra.place.icon": "string",
    "properties.extra.place.id": "string",
    "properties.extra.place.name": "string",
    "properties.extra.place.photos": [
        {
            "height": "string",
            "html_attributions": [
                "string"
            ],
            "width": "string"
        }
    ],
    "properties.extra.place.place_id": "string",
    "properties.extra.place.reference": "string",
    "properties.extra.place.scope": "string",
    "properties.extra.place.types": [
        "string"
    ],
    "properties.extra.place.url": "string",
    "properties.extra.place.utc_offset": "string",
    "properties.extra.place.utc_offset_minutes": "string",
    "properties.extra.place.vicinity": "string",
    "properties.extra.place.website": "string",
    "properties.extra.unitId": "string",
    "properties.facilityId": "string",
    "properties.isReact": "string",
    "properties.label": "string",
    "properties.moveInDateSelected": "string",
    "properties.site_id": "string",
    "properties.value": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 1228
schema_scan_id: 5761808
updated: 2021-03-04 14:22:00

Version 4684378

created: 2021-02-09 11:28:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`",
    "DROP TABLE IF EXISTS `sfdl_dev_segment.storagescout_click`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.storagescout_click`\n(\n`integrations`struct<`_empty_`:STRING>,`event`STRING,`version`STRING,`timestamp`STRING,`originalTimestamp`STRING,`receivedAt`STRING,`projectId`STRING,`userId`STRING,`_origin`STRING,`anonymousId`STRING,`properties`struct<`9`:STRING,`label`:STRING,`site_id`:STRING,`facilityId`:STRING,`1`:STRING,`4`:STRING,`breadcrumb`:STRING,`category`:STRING,`11`:STRING,`16`:STRING,`env`:STRING,`5`:STRING,`value`:STRING,`14`:STRING,`2`:STRING,`0`:STRING,`10`:STRING,`15`:STRING,`6`:STRING,`12`:STRING,`7`:STRING,`isReact`:STRING,`8`:STRING,`17`:STRING,`3`:STRING,`moveInDateSelected`:STRING,`13`:STRING,`extra`:struct<`unitId`:STRING,`dateSelected`:STRING,`facilityId`:STRING,`place`:struct<`photos`:array,`height`:STRING>>,`formatted_address`:STRING,`types`:array,`scope`:STRING,`url`:STRING,`geometry`:struct<`viewport`:struct<`Qa`:struct<`i`:STRING,`j`:STRING>,`ga`:struct<`j`:STRING,`l`:STRING>,`pa`:struct<`h`:STRING,`g`:STRING>,`Ya`:struct<`i`:STRING,`j`:STRING>,`Va`:struct<`i`:STRING,`j`:STRING>,`na`:struct<`j`:STRING,`l`:STRING>,`oa`:struct<`h`:STRING,`g`:STRING>,`ka`:struct<`h`:STRING,`g`:STRING>,`ia`:struct<`j`:STRING,`l`:STRING>,`Ua`:struct<`i`:STRING,`j`:STRING>>>,`utc_offset`:STRING,`icon`:STRING,`vicinity`:STRING,`website`:STRING,`place_id`:STRING,`address_components`:array,`short_name`:STRING>>,`html_attributions`:array,`utc_offset_minutes`:STRING,`name`:STRING,`adr_address`:STRING,`reference`:STRING,`id`:STRING>>,`Hit_Timestamp`:STRING>,`channel`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`messageId`STRING,`context`struct<`locale`:STRING,`userAgent`:STRING,`library`:struct<`name`:STRING,`version`:STRING>,`page`:struct<`title`:STRING,`search`:STRING,`url`:STRING,`path`:STRING,`referrer`:STRING>,`ip`:STRING,`campaign`:struct<`_empty_`:STRING>>,`type`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-storagescout-dev/separated_dt/click'\n",
    "MSCK REPAIR TABLE sfdl_dev_segment.storagescout_click"
]

hive_path: s3://sfdl-segment-storagescout-dev/separated_dt/click
id: 4684378
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "unbundled": []
    },
    "_origin": "2021-02-09T17:27:53Z|s3://sfdl-segment-storagescout-dev/segment-logs/adK1RCRyGa/1612828800000/1612890729995.528c661c61a8.fde281a.e4257bda-108c-4012-9067-fae3ddd5224c.gz|segment_separator:34",
    "anonymousId": "ecb6eb96-1ed3-4be8-bf01-129b3b8ba773",
    "channel": "client",
    "context": {
        "campaign": {},
        "ip": "187.176.246.99",
        "library": {
            "name": "analytics.js",
            "version": "4.0.4"
        },
        "locale": "en-US",
        "page": {
            "path": "/",
            "referrer": "",
            "search": "",
            "title": "Self Storage Deals & Discounts Near Me | USStorageSearch",
            "url": "https://www.storagescout.moreyard.com/"
        },
        "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.150 Safari/537.36"
    },
    "event": "click",
    "integrations": {},
    "messageId": "ajs-694ba7762f7ad1e202255e919bab8771",
    "originalTimestamp": "2021-02-09T17:10:43.712Z",
    "projectId": "adK1RCRyGa",
    "properties": {
        "Hit Timestamp": 1612890643709,
        "category": "missing category-index",
        "env": "dev",
        "extra": {
            "place": {
                "address_components": [
                    {
                        "long_name": "Austin",
                        "short_name": "Austin",
                        "types": [
                            "locality",
                            "political"
                        ]
                    },
                    {
                        "long_name": "Travis County",
                        "short_name": "Travis County",
                        "types": [
                            "administrative_area_level_2",
                            "political"
                        ]
                    },
                    {
                        "long_name": "Texas",
                        "short_name": "TX",
                        "types": [
                            "administrative_area_level_1",
                            "political"
                        ]
                    },
                    {
                        "long_name": "United States",
                        "short_name": "US",
                        "types": [
                            "country",
                            "political"
                        ]
                    }
                ],
                "adr_address": "Austin, TX, USA",
                "formatted_address": "Austin, TX, USA",
                "geometry": {
                    "location": {},
                    "viewport": {
                        "Qa": {
                            "i": -97.93838291739291,
                            "j": -97.56841987285418
                        },
                        "Va": {
                            "i": 30.09865891736228,
                            "j": 30.51686291865151
                        }
                    }
                },
                "html_attributions": [],
                "icon": "https://maps.gstatic.com/mapfiles/place_api/icons/v1/png_71/geocode-71.png",
                "name": "Austin",
                "photos": [
                    {
                        "height": 5312,
                        "html_attributions": [
                            "Adriana Rebold"
                        ],
                        "width": 2988
                    },
                    {
                        "height": 1500,
                        "html_attributions": [
                            "Paul Biwer"
                        ],
                        "width": 1000
                    },
                    {
                        "height": 3024,
                        "html_attributions": [
                            "Marsha Landry"
                        ],
                        "width": 4032
                    },
                    {
                        "height": 1254,
                        "html_attributions": [
                            "Alex Tucker"
                        ],
                        "width": 2048
                    },
                    {
                        "height": 1960,
                        "html_attributions": [
                            "dennis l lanning"
                        ],
                        "width": 4032
                    },
                    {
                        "height": 2932,
                        "html_attributions": [
                            "Alcibiades Fleires"
                        ],
                        "width": 3908
                    },
                    {
                        "height": 2587,
                        "html_attributions": [
                            "Edie Schutza Schoener"
                        ],
                        "width": 3867
                    },
                    {
                        "height": 2268,
                        "html_attributions": [
                            "Christian ANNEREL"
                        ],
                        "width": 4032
                    },
                    {
                        "height": 1960,
                        "html_attributions": [
                            "James Benavides"
                        ],
                        "width": 4032
                    },
                    {
                        "height": 3016,
                        "html_attributions": [
                            "Dk Su"
                        ],
                        "width": 4032
                    }
                ],
                "place_id": "ChIJLwPMoJm1RIYRetVp1EtGm10",
                "reference": "ChIJLwPMoJm1RIYRetVp1EtGm10",
                "types": [
                    "locality",
                    "political"
                ],
                "url": "https://maps.google.com/?q=Austin,+TX,+USA&ftid=0x8644b599a0cc032f:0x5d9b464bd469d57a",
                "utc_offset": -360,
                "utc_offset_minutes": -360,
                "vicinity": "Austin",
                "website": "http://www.ci.austin.tx.us/"
            }
        },
        "isReact": true,
        "label": "search autocomplete",
        "site_id": 413
    },
    "receivedAt": "2021-02-09T17:10:44.028Z",
    "sentAt": "2021-02-09T17:10:43.715Z",
    "timestamp": "2021-02-09T17:10:44.025Z",
    "type": "track",
    "userId": "19c60d1b7da48b89c97e94eb582bc948",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "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",
    "messageId": "string",
    "originalTimestamp": "string",
    "projectId": "string",
    "properties.0": "string",
    "properties.1": "string",
    "properties.10": "string",
    "properties.11": "string",
    "properties.12": "string",
    "properties.13": "string",
    "properties.14": "string",
    "properties.15": "string",
    "properties.16": "string",
    "properties.17": "string",
    "properties.2": "string",
    "properties.3": "string",
    "properties.4": "string",
    "properties.5": "string",
    "properties.6": "string",
    "properties.7": "string",
    "properties.8": "string",
    "properties.9": "string",
    "properties.Hit_Timestamp": "string",
    "properties.breadcrumb": "string",
    "properties.category": "string",
    "properties.env": "string",
    "properties.extra.dateSelected": "string",
    "properties.extra.facilityId": "string",
    "properties.extra.place.address_components": [
        {
            "long_name": "string",
            "short_name": "string",
            "types": [
                "string"
            ]
        }
    ],
    "properties.extra.place.adr_address": "string",
    "properties.extra.place.formatted_address": "string",
    "properties.extra.place.geometry.viewport.Qa.i": "string",
    "properties.extra.place.geometry.viewport.Qa.j": "string",
    "properties.extra.place.geometry.viewport.Ua.i": "string",
    "properties.extra.place.geometry.viewport.Ua.j": "string",
    "properties.extra.place.geometry.viewport.Va.i": "string",
    "properties.extra.place.geometry.viewport.Va.j": "string",
    "properties.extra.place.geometry.viewport.Ya.i": "string",
    "properties.extra.place.geometry.viewport.Ya.j": "string",
    "properties.extra.place.geometry.viewport.ga.j": "string",
    "properties.extra.place.geometry.viewport.ga.l": "string",
    "properties.extra.place.geometry.viewport.ia.j": "string",
    "properties.extra.place.geometry.viewport.ia.l": "string",
    "properties.extra.place.geometry.viewport.ka.g": "string",
    "properties.extra.place.geometry.viewport.ka.h": "string",
    "properties.extra.place.geometry.viewport.na.j": "string",
    "properties.extra.place.geometry.viewport.na.l": "string",
    "properties.extra.place.geometry.viewport.oa.g": "string",
    "properties.extra.place.geometry.viewport.oa.h": "string",
    "properties.extra.place.geometry.viewport.pa.g": "string",
    "properties.extra.place.geometry.viewport.pa.h": "string",
    "properties.extra.place.html_attributions": [
        "string"
    ],
    "properties.extra.place.icon": "string",
    "properties.extra.place.id": "string",
    "properties.extra.place.name": "string",
    "properties.extra.place.photos": [
        {
            "height": "string",
            "html_attributions": [
                "string"
            ],
            "width": "string"
        }
    ],
    "properties.extra.place.place_id": "string",
    "properties.extra.place.reference": "string",
    "properties.extra.place.scope": "string",
    "properties.extra.place.types": [
        "string"
    ],
    "properties.extra.place.url": "string",
    "properties.extra.place.utc_offset": "string",
    "properties.extra.place.utc_offset_minutes": "string",
    "properties.extra.place.vicinity": "string",
    "properties.extra.place.website": "string",
    "properties.extra.unitId": "string",
    "properties.facilityId": "string",
    "properties.isReact": "string",
    "properties.label": "string",
    "properties.moveInDateSelected": "string",
    "properties.site_id": "string",
    "properties.value": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 1228
schema_scan_id: 5753577
updated: 2021-02-09 11:28:54

Version 4678799

created: 2020-05-18 17:41:37

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`",
    "DROP TABLE IF EXISTS `sfdl_dev_segment.storagescout_click`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.storagescout_click`\n(\n`messageId`STRING,`context`struct<`library`:struct<`version`:STRING,`name`:STRING>,`page`:struct<`path`:STRING,`title`:STRING,`referrer`:STRING,`url`:STRING,`search`:STRING>,`campaign`:struct<`_empty_`:STRING>,`locale`:STRING,`userAgent`:STRING,`ip`:STRING>,`_origin`STRING,`sentAt`STRING,`integrations`struct<`_empty_`:STRING>,`anonymousId`STRING,`event`STRING,`properties`struct<`14`:STRING,`Hit_Timestamp`:STRING,`9`:STRING,`7`:STRING,`breadcrumb`:STRING,`4`:STRING,`5`:STRING,`extra`:struct<`unitId`:STRING,`facilityId`:STRING,`place`:struct<`photos`:array,`height`:STRING>>,`reference`:STRING,`url`:STRING,`place_id`:STRING,`formatted_address`:STRING,`types`:array,`vicinity`:STRING,`geometry`:struct<`viewport`:struct<`ga`:struct<`j`:STRING,`l`:STRING>,`na`:struct<`j`:STRING,`l`:STRING>,`oa`:struct<`h`:STRING,`g`:STRING>,`ka`:struct<`h`:STRING,`g`:STRING>,`Ya`:struct<`i`:STRING,`j`:STRING>,`pa`:struct<`h`:STRING,`g`:STRING>,`ia`:struct<`j`:STRING,`l`:STRING>,`Ua`:struct<`i`:STRING,`j`:STRING>>>,`name`:STRING,`scope`:STRING,`utc_offset`:STRING,`address_components`:array,`short_name`:STRING>>,`adr_address`:STRING,`html_attributions`:array,`icon`:STRING,`utc_offset_minutes`:STRING,`website`:STRING,`id`:STRING>,`dateSelected`:STRING>,`17`:STRING,`category`:STRING,`env`:STRING,`site_id`:STRING,`11`:STRING,`15`:STRING,`isReact`:STRING,`value`:STRING,`3`:STRING,`facilityId`:STRING,`moveInDateSelected`:STRING,`16`:STRING,`2`:STRING,`label`:STRING,`13`:STRING,`8`:STRING,`1`:STRING,`6`:STRING,`0`:STRING,`10`:STRING,`12`:STRING>,`userId`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`version`STRING,`channel`STRING,`type`STRING,`originalTimestamp`STRING,`timestamp`STRING,`projectId`STRING,`receivedAt`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-storagescout-dev/separated_dt/click'\n",
    "MSCK REPAIR TABLE sfdl_dev_segment.storagescout_click"
]

hive_path: s3://sfdl-segment-storagescout-dev/separated_dt/click
id: 4678799
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "unbundled": []
    },
    "_origin": "2020-05-18T21:08:20Z|s3://sfdl-segment-storagescout-dev/segment-logs/adK1RCRyGa/1589760000000/1589836081773.764f4f590070.e4797d0.b4632d41-f87b-4df1-af70-b873e64d925e.gz|segment_separator:34",
    "anonymousId": "9218147e-e6b1-4de4-abec-dba2e3e867ea",
    "channel": "client",
    "context": {
        "campaign": {},
        "ip": "54.88.102.255",
        "library": {
            "name": "analytics.js",
            "version": "3.13.1"
        },
        "locale": "en-US",
        "page": {
            "path": "/self-storage/tx/austin-storage-units/",
            "referrer": "",
            "search": "?SELENIUM=true",
            "title": "Best Self-Storage Units in Austin, TX - StorageScout",
            "url": "https://www.storagescout.moreyard.com/self-storage/tx/austin-storage-units/?SELENIUM=true"
        },
        "userAgent": "Mozilla/5.0 (Windows NT 6.2; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.129 Safari/537.36"
    },
    "event": "click",
    "integrations": {},
    "messageId": "ajs-3ff6ea1ddb1fdd64343ba7397e925378",
    "originalTimestamp": "2020-05-18T20:25:29.142Z",
    "projectId": "adK1RCRyGa",
    "properties": {
        "0": "l",
        "1": "i",
        "10": "i",
        "11": "t",
        "12": "y",
        "13": " ",
        "14": "n",
        "15": "a",
        "16": "m",
        "17": "e",
        "2": "n",
        "3": "k",
        "4": " ",
        "5": "f",
        "6": "a",
        "7": "c",
        "8": "i",
        "9": "l",
        "Hit Timestamp": 1589833529138,
        "category": "facility interactions-cityLandingPage",
        "env": "dev",
        "extra": {
            "place": {
                "address_components": [
                    {
                        "long_name": "Houston",
                        "short_name": "Houston",
                        "types": [
                            "locality",
                            "political"
                        ]
                    },
                    {
                        "long_name": "Harris County",
                        "short_name": "Harris County",
                        "types": [
                            "administrative_area_level_2",
                            "political"
                        ]
                    },
                    {
                        "long_name": "Texas",
                        "short_name": "TX",
                        "types": [
                            "administrative_area_level_1",
                            "political"
                        ]
                    },
                    {
                        "long_name": "United States",
                        "short_name": "US",
                        "types": [
                            "country",
                            "political"
                        ]
                    }
                ],
                "adr_address": "Houston, TX, USA",
                "formatted_address": "Houston, TX, USA",
                "geometry": {
                    "location": {},
                    "viewport": {
                        "Ua": {
                            "i": -95.78808690000001,
                            "j": -95.014496
                        },
                        "Ya": {
                            "i": 29.523624,
                            "j": 30.1107319
                        }
                    }
                },
                "html_attributions": [],
                "icon": "https://maps.gstatic.com/mapfiles/place_api/icons/geocode-71.png",
                "id": "25faf0a7ef1056b980f3a19237cfa8e295668123",
                "name": "Houston",
                "photos": [
                    {
                        "height": 1365,
                        "html_attributions": [
                            "Victor Martin"
                        ],
                        "width": 2048
                    },
                    {
                        "height": 1000,
                        "html_attributions": [
                            "Rofale"
                        ],
                        "width": 750
                    },
                    {
                        "height": 3024,
                        "html_attributions": [
                            "Ayub Maredia"
                        ],
                        "width": 4032
                    },
                    {
                        "height": 4032,
                        "html_attributions": [
                            "Tuan Anh Vu"
                        ],
                        "width": 3024
                    },
                    {
                        "height": 3840,
                        "html_attributions": [
                            "Marie Nilsson"
                        ],
                        "width": 2160
                    },
                    {
                        "height": 3264,
                        "html_attributions": [
                            "Jacky"
                        ],
                        "width": 1836
                    },
                    {
                        "height": 1152,
                        "html_attributions": [
                            "Reinhard Link"
                        ],
                        "width": 2048
                    },
                    {
                        "height": 3024,
                        "html_attributions": [
                            "Harsh Gupta"
                        ],
                        "width": 4032
                    },
                    {
                        "height": 2281,
                        "html_attributions": [
                            "Bob RC"
                        ],
                        "width": 7012
                    },
                    {
                        "height": 4032,
                        "html_attributions": [
                            "Lisa Swaim"
                        ],
                        "width": 3024
                    }
                ],
                "place_id": "ChIJAYWNSLS4QIYROwVl894CDco",
                "reference": "ChIJAYWNSLS4QIYROwVl894CDco",
                "scope": "GOOGLE",
                "types": [
                    "locality",
                    "political"
                ],
                "url": "https://maps.google.com/?q=Houston,+TX,+USA&ftid=0x8640b8b4488d8501:0xca0d02def365053b",
                "utc_offset": -300,
                "utc_offset_minutes": -300,
                "vicinity": "Houston",
                "website": "http://www.houstontx.gov/"
            }
        },
        "facilityId": 214569,
        "isReact": true,
        "label": "title",
        "site_id": 413
    },
    "receivedAt": "2020-05-18T20:25:29.303Z",
    "sentAt": "2020-05-18T20:25:29.148Z",
    "timestamp": "2020-05-18T20:25:29.297Z",
    "type": "track",
    "userId": "c37faef6fb14abdb0e2fe384740d1e74",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "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",
    "messageId": "string",
    "originalTimestamp": "string",
    "projectId": "string",
    "properties.0": "string",
    "properties.1": "string",
    "properties.10": "string",
    "properties.11": "string",
    "properties.12": "string",
    "properties.13": "string",
    "properties.14": "string",
    "properties.15": "string",
    "properties.16": "string",
    "properties.17": "string",
    "properties.2": "string",
    "properties.3": "string",
    "properties.4": "string",
    "properties.5": "string",
    "properties.6": "string",
    "properties.7": "string",
    "properties.8": "string",
    "properties.9": "string",
    "properties.Hit_Timestamp": "string",
    "properties.breadcrumb": "string",
    "properties.category": "string",
    "properties.env": "string",
    "properties.extra.dateSelected": "string",
    "properties.extra.facilityId": "string",
    "properties.extra.place.address_components": [
        {
            "long_name": "string",
            "short_name": "string",
            "types": [
                "string"
            ]
        }
    ],
    "properties.extra.place.adr_address": "string",
    "properties.extra.place.formatted_address": "string",
    "properties.extra.place.geometry.viewport.Ua.i": "string",
    "properties.extra.place.geometry.viewport.Ua.j": "string",
    "properties.extra.place.geometry.viewport.Ya.i": "string",
    "properties.extra.place.geometry.viewport.Ya.j": "string",
    "properties.extra.place.geometry.viewport.ga.j": "string",
    "properties.extra.place.geometry.viewport.ga.l": "string",
    "properties.extra.place.geometry.viewport.ia.j": "string",
    "properties.extra.place.geometry.viewport.ia.l": "string",
    "properties.extra.place.geometry.viewport.ka.g": "string",
    "properties.extra.place.geometry.viewport.ka.h": "string",
    "properties.extra.place.geometry.viewport.na.j": "string",
    "properties.extra.place.geometry.viewport.na.l": "string",
    "properties.extra.place.geometry.viewport.oa.g": "string",
    "properties.extra.place.geometry.viewport.oa.h": "string",
    "properties.extra.place.geometry.viewport.pa.g": "string",
    "properties.extra.place.geometry.viewport.pa.h": "string",
    "properties.extra.place.html_attributions": [
        "string"
    ],
    "properties.extra.place.icon": "string",
    "properties.extra.place.id": "string",
    "properties.extra.place.name": "string",
    "properties.extra.place.photos": [
        {
            "height": "string",
            "html_attributions": [
                "string"
            ],
            "width": "string"
        }
    ],
    "properties.extra.place.place_id": "string",
    "properties.extra.place.reference": "string",
    "properties.extra.place.scope": "string",
    "properties.extra.place.types": [
        "string"
    ],
    "properties.extra.place.url": "string",
    "properties.extra.place.utc_offset": "string",
    "properties.extra.place.utc_offset_minutes": "string",
    "properties.extra.place.vicinity": "string",
    "properties.extra.place.website": "string",
    "properties.extra.unitId": "string",
    "properties.facilityId": "string",
    "properties.isReact": "string",
    "properties.label": "string",
    "properties.moveInDateSelected": "string",
    "properties.site_id": "string",
    "properties.value": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 1228
schema_scan_id: 5609262
updated: 2020-05-18 17:42:08

Schema Scans: 3

Last at 2021-03-04 14:21:23

Scan 5761808

duration: 0:00:40.348502

exit_message:

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

id: 5761808

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "partition": {
        "location": "s3://sfdl-segment-storagescout-dev/separated_dt/click/dt=2021-03-04/",
        "name": "dt",
        "type": "string",
        "value": "2021-03-04"
    },
    "s3": {
        "bucket": "sfdl-segment-storagescout-dev",
        "hive_path": "s3://sfdl-segment-storagescout-dev/separated_dt/click",
        "key": "separated_dt/click/dt=2021-03-04/1614888924636.3fc67538772f.fde281a.7a617201-9489-4451-bbc0-8cfab0f55efc.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_segment.storagescout_click",
        "type": "segment"
    }
}

running: False
schema_name_id: 1228
start_time: 2021-03-04 14:21:23
success: True
trace_id: 12166620125412676655

Scan 5753577

duration: 0:00:39.989862

exit_message:

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

id: 5753577

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "partition": {
        "location": "s3://sfdl-segment-storagescout-dev/separated_dt/click/dt=2021-02-09/",
        "name": "dt",
        "type": "string",
        "value": "2021-02-09"
    },
    "s3": {
        "bucket": "sfdl-segment-storagescout-dev",
        "hive_path": "s3://sfdl-segment-storagescout-dev/separated_dt/click",
        "key": "separated_dt/click/dt=2021-02-09/1612890729995.528c661c61a8.fde281a.e4257bda-108c-4012-9067-fae3ddd5224c.gz.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_segment.storagescout_click",
        "type": "segment"
    }
}

running: False
schema_name_id: 1228
start_time: 2021-02-09 11:28:17
success: True
trace_id: 5453323117439312036

Scan 5609262

duration: 0:00:34.826409

exit_message:

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

id: 5609262

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "partition": {
        "location": "s3://sfdl-segment-storagescout-dev/separated_dt/click/dt=2020-05-18/",
        "name": "dt",
        "type": "string",
        "value": "2020-05-18"
    },
    "s3": {
        "bucket": "sfdl-segment-storagescout-dev",
        "hive_path": "s3://sfdl-segment-storagescout-dev/separated_dt/click",
        "key": "separated_dt/click/dt=2020-05-18/1589836081773.764f4f590070.e4797d0.b4632d41-f87b-4df1-af70-b873e64d925e.gz.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_segment.storagescout_click",
        "type": "segment"
    }
}

running: False
schema_name_id: 1228
start_time: 2020-05-18 17:41:36
success: True
trace_id: 13083106888899221513

Partitions:

count: 3

ddl:

[
    "ALTER TABLE\n    `sfdl_dev_segment.storagescout_click`\nADD\n\n\n PARTITION (dt='2021-07-20') location 's3://sfdl-segment-storagescout-dev/separated_dt/click/dt=2021-07-20/'\n PARTITION (dt='2021-11-10') location 's3://sfdl-segment-storagescout-dev/separated_dt/click/dt=2021-11-10/'\n PARTITION (dt='2022-02-28') location 's3://sfdl-segment-storagescout-dev/separated_dt/click/dt=2022-02-28/'\n;"
]

name: dt

state:

[
    {
        "info": {
            "id": 177595,
            "location": "s3://sfdl-segment-storagescout-dev/separated_dt/click/dt=2021-07-20/",
            "name": "dt",
            "value": "2021-07-20"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2021-07-20 14:42:17",
                "last_data": "2021-07-20 14:50:14"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 180302,
            "location": "s3://sfdl-segment-storagescout-dev/separated_dt/click/dt=2021-11-10/",
            "name": "dt",
            "value": "2021-11-10"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2021-11-10 16:47:02",
                "last_data": "2021-11-10 16:56:10"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 183448,
            "location": "s3://sfdl-segment-storagescout-dev/separated_dt/click/dt=2022-02-28/",
            "name": "dt",
            "value": "2022-02-28"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2022-02-28 14:13:20",
                "last_data": "2022-02-28 14:25:35"
            },
            "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.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",
    "messageId": "string",
    "originalTimestamp": "string",
    "projectId": "string",
    "properties.0": "string",
    "properties.1": "string",
    "properties.10": "string",
    "properties.11": "string",
    "properties.12": "string",
    "properties.13": "string",
    "properties.14": "string",
    "properties.15": "string",
    "properties.16": "string",
    "properties.17": "string",
    "properties.2": "string",
    "properties.3": "string",
    "properties.4": "string",
    "properties.5": "string",
    "properties.6": "string",
    "properties.7": "string",
    "properties.8": "string",
    "properties.9": "string",
    "properties.Hit_Timestamp": "string",
    "properties.breadcrumb": "string",
    "properties.category": "string",
    "properties.env": "string",
    "properties.extra.dateSelected": "string",
    "properties.extra.facilityId": "string",
    "properties.extra.place.address_components": [
        {
            "long_name": "string",
            "short_name": "string",
            "types": [
                "string"
            ]
        }
    ],
    "properties.extra.place.adr_address": "string",
    "properties.extra.place.formatted_address": "string",
    "properties.extra.place.geometry.viewport.La.g": "string",
    "properties.extra.place.geometry.viewport.La.i": "string",
    "properties.extra.place.geometry.viewport.Qa.i": "string",
    "properties.extra.place.geometry.viewport.Qa.j": "string",
    "properties.extra.place.geometry.viewport.Ra.g": "string",
    "properties.extra.place.geometry.viewport.Ra.i": "string",
    "properties.extra.place.geometry.viewport.Ua.i": "string",
    "properties.extra.place.geometry.viewport.Ua.j": "string",
    "properties.extra.place.geometry.viewport.Va.i": "string",
    "properties.extra.place.geometry.viewport.Va.j": "string",
    "properties.extra.place.geometry.viewport.Ya.i": "string",
    "properties.extra.place.geometry.viewport.Ya.j": "string",
    "properties.extra.place.geometry.viewport.ga.j": "string",
    "properties.extra.place.geometry.viewport.ga.l": "string",
    "properties.extra.place.geometry.viewport.ia.j": "string",
    "properties.extra.place.geometry.viewport.ia.l": "string",
    "properties.extra.place.geometry.viewport.ka.g": "string",
    "properties.extra.place.geometry.viewport.ka.h": "string",
    "properties.extra.place.geometry.viewport.na.j": "string",
    "properties.extra.place.geometry.viewport.na.l": "string",
    "properties.extra.place.geometry.viewport.oa.g": "string",
    "properties.extra.place.geometry.viewport.oa.h": "string",
    "properties.extra.place.geometry.viewport.pa.g": "string",
    "properties.extra.place.geometry.viewport.pa.h": "string",
    "properties.extra.place.html_attributions": [
        "string"
    ],
    "properties.extra.place.icon": "string",
    "properties.extra.place.id": "string",
    "properties.extra.place.name": "string",
    "properties.extra.place.photos": [
        {
            "height": "string",
            "html_attributions": [
                "string"
            ],
            "width": "string"
        }
    ],
    "properties.extra.place.place_id": "string",
    "properties.extra.place.reference": "string",
    "properties.extra.place.scope": "string",
    "properties.extra.place.types": [
        "string"
    ],
    "properties.extra.place.url": "string",
    "properties.extra.place.utc_offset": "string",
    "properties.extra.place.utc_offset_minutes": "string",
    "properties.extra.place.vicinity": "string",
    "properties.extra.place.website": "string",
    "properties.extra.unitId": "string",
    "properties.facilityId": "string",
    "properties.isReact": "string",
    "properties.label": "string",
    "properties.moveInDateSelected": "string",
    "properties.site_id": "string",
    "properties.value": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

created: 2021-03-04 14:21:23

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.storagescout_click`\n(\n`integrations`struct<`_empty_`:STRING>,`event`STRING,`version`STRING,`timestamp`STRING,`originalTimestamp`STRING,`receivedAt`STRING,`projectId`STRING,`userId`STRING,`_origin`STRING,`anonymousId`STRING,`properties`struct<`9`:STRING,`label`:STRING,`13`:STRING,`site_id`:STRING,`facilityId`:STRING,`1`:STRING,`4`:STRING,`breadcrumb`:STRING,`category`:STRING,`11`:STRING,`16`:STRING,`env`:STRING,`5`:STRING,`value`:STRING,`14`:STRING,`2`:STRING,`0`:STRING,`15`:STRING,`6`:STRING,`12`:STRING,`7`:STRING,`isReact`:STRING,`8`:STRING,`17`:STRING,`3`:STRING,`moveInDateSelected`:STRING,`10`:STRING,`extra`:struct<`unitId`:STRING,`facilityId`:STRING,`dateSelected`:STRING,`place`:struct<`photos`:array,`width`:STRING>>,`formatted_address`:STRING,`types`:array,`scope`:STRING,`url`:STRING,`geometry`:struct<`viewport`:struct<`Qa`:struct<`i`:STRING,`j`:STRING>,`ga`:struct<`j`:STRING,`l`:STRING>,`pa`:struct<`h`:STRING,`g`:STRING>,`Ya`:struct<`i`:STRING,`j`:STRING>,`Va`:struct<`i`:STRING,`j`:STRING>,`na`:struct<`j`:STRING,`l`:STRING>,`oa`:struct<`h`:STRING,`g`:STRING>,`ka`:struct<`h`:STRING,`g`:STRING>,`ia`:struct<`j`:STRING,`l`:STRING>,`Ua`:struct<`i`:STRING,`j`:STRING>,`Ra`:struct<`g`:STRING,`i`:STRING>,`La`:struct<`g`:STRING,`i`:STRING>>>,`utc_offset`:STRING,`icon`:STRING,`vicinity`:STRING,`website`:STRING,`place_id`:STRING,`address_components`:array>>,`html_attributions`:array,`utc_offset_minutes`:STRING,`name`:STRING,`adr_address`:STRING,`reference`:STRING,`id`:STRING>>,`Hit_Timestamp`:STRING>,`channel`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`messageId`STRING,`context`struct<`locale`:STRING,`userAgent`:STRING,`page`:struct<`title`:STRING,`search`:STRING,`url`:STRING,`path`:STRING,`referrer`:STRING>,`ip`:STRING,`library`:struct<`name`:STRING,`version`:STRING>,`campaign`:struct<`_empty_`:STRING>>,`type`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-storagescout-dev/separated_dt/click'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_segment.storagescout_click`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_segment.storagescout_click"
}

Server:

hostname: schemamanager-5447774fc6-4w58v
name: schema_manager
process_start: 2026-04-02 21:43:44
sf_env: dev
version: 2427328685

Raw:

{
    "name": {
        "created": "2019-03-28 11:32:20",
        "disabled": false,
        "format": "raw",
        "id": 1228,
        "is_partitioned": true,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_dev_segment",
            "table": "storagescout_click"
        },
        "type": "segment"
    },
    "partition": {
        "count": 3,
        "ddl": [
            "ALTER TABLE\n    `sfdl_dev_segment.storagescout_click`\nADD\n\n\n PARTITION (dt='2021-07-20') location 's3://sfdl-segment-storagescout-dev/separated_dt/click/dt=2021-07-20/'\n PARTITION (dt='2021-11-10') location 's3://sfdl-segment-storagescout-dev/separated_dt/click/dt=2021-11-10/'\n PARTITION (dt='2022-02-28') location 's3://sfdl-segment-storagescout-dev/separated_dt/click/dt=2022-02-28/'\n;"
        ],
        "name": "dt",
        "state": [
            {
                "info": {
                    "id": 177595,
                    "location": "s3://sfdl-segment-storagescout-dev/separated_dt/click/dt=2021-07-20/",
                    "name": "dt",
                    "value": "2021-07-20"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2021-07-20 14:42:17",
                        "last_data": "2021-07-20 14:50:14"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 180302,
                    "location": "s3://sfdl-segment-storagescout-dev/separated_dt/click/dt=2021-11-10/",
                    "name": "dt",
                    "value": "2021-11-10"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2021-11-10 16:47:02",
                        "last_data": "2021-11-10 16:56:10"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 183448,
                    "location": "s3://sfdl-segment-storagescout-dev/separated_dt/click/dt=2022-02-28/",
                    "name": "dt",
                    "value": "2022-02-28"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2022-02-28 14:13:20",
                        "last_data": "2022-02-28 14:25:35"
                    },
                    "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.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",
            "messageId": "string",
            "originalTimestamp": "string",
            "projectId": "string",
            "properties.0": "string",
            "properties.1": "string",
            "properties.10": "string",
            "properties.11": "string",
            "properties.12": "string",
            "properties.13": "string",
            "properties.14": "string",
            "properties.15": "string",
            "properties.16": "string",
            "properties.17": "string",
            "properties.2": "string",
            "properties.3": "string",
            "properties.4": "string",
            "properties.5": "string",
            "properties.6": "string",
            "properties.7": "string",
            "properties.8": "string",
            "properties.9": "string",
            "properties.Hit_Timestamp": "string",
            "properties.breadcrumb": "string",
            "properties.category": "string",
            "properties.env": "string",
            "properties.extra.dateSelected": "string",
            "properties.extra.facilityId": "string",
            "properties.extra.place.address_components": [
                {
                    "long_name": "string",
                    "short_name": "string",
                    "types": [
                        "string"
                    ]
                }
            ],
            "properties.extra.place.adr_address": "string",
            "properties.extra.place.formatted_address": "string",
            "properties.extra.place.geometry.viewport.La.g": "string",
            "properties.extra.place.geometry.viewport.La.i": "string",
            "properties.extra.place.geometry.viewport.Qa.i": "string",
            "properties.extra.place.geometry.viewport.Qa.j": "string",
            "properties.extra.place.geometry.viewport.Ra.g": "string",
            "properties.extra.place.geometry.viewport.Ra.i": "string",
            "properties.extra.place.geometry.viewport.Ua.i": "string",
            "properties.extra.place.geometry.viewport.Ua.j": "string",
            "properties.extra.place.geometry.viewport.Va.i": "string",
            "properties.extra.place.geometry.viewport.Va.j": "string",
            "properties.extra.place.geometry.viewport.Ya.i": "string",
            "properties.extra.place.geometry.viewport.Ya.j": "string",
            "properties.extra.place.geometry.viewport.ga.j": "string",
            "properties.extra.place.geometry.viewport.ga.l": "string",
            "properties.extra.place.geometry.viewport.ia.j": "string",
            "properties.extra.place.geometry.viewport.ia.l": "string",
            "properties.extra.place.geometry.viewport.ka.g": "string",
            "properties.extra.place.geometry.viewport.ka.h": "string",
            "properties.extra.place.geometry.viewport.na.j": "string",
            "properties.extra.place.geometry.viewport.na.l": "string",
            "properties.extra.place.geometry.viewport.oa.g": "string",
            "properties.extra.place.geometry.viewport.oa.h": "string",
            "properties.extra.place.geometry.viewport.pa.g": "string",
            "properties.extra.place.geometry.viewport.pa.h": "string",
            "properties.extra.place.html_attributions": [
                "string"
            ],
            "properties.extra.place.icon": "string",
            "properties.extra.place.id": "string",
            "properties.extra.place.name": "string",
            "properties.extra.place.photos": [
                {
                    "height": "string",
                    "html_attributions": [
                        "string"
                    ],
                    "width": "string"
                }
            ],
            "properties.extra.place.place_id": "string",
            "properties.extra.place.reference": "string",
            "properties.extra.place.scope": "string",
            "properties.extra.place.types": [
                "string"
            ],
            "properties.extra.place.url": "string",
            "properties.extra.place.utc_offset": "string",
            "properties.extra.place.utc_offset_minutes": "string",
            "properties.extra.place.vicinity": "string",
            "properties.extra.place.website": "string",
            "properties.extra.unitId": "string",
            "properties.facilityId": "string",
            "properties.isReact": "string",
            "properties.label": "string",
            "properties.moveInDateSelected": "string",
            "properties.site_id": "string",
            "properties.value": "string",
            "receivedAt": "string",
            "sentAt": "string",
            "timestamp": "string",
            "type": "string",
            "userId": "string",
            "version": "string"
        },
        "created": "2021-03-04 14:21:23",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.storagescout_click`\n(\n`integrations`struct<`_empty_`:STRING>,`event`STRING,`version`STRING,`timestamp`STRING,`originalTimestamp`STRING,`receivedAt`STRING,`projectId`STRING,`userId`STRING,`_origin`STRING,`anonymousId`STRING,`properties`struct<`9`:STRING,`label`:STRING,`13`:STRING,`site_id`:STRING,`facilityId`:STRING,`1`:STRING,`4`:STRING,`breadcrumb`:STRING,`category`:STRING,`11`:STRING,`16`:STRING,`env`:STRING,`5`:STRING,`value`:STRING,`14`:STRING,`2`:STRING,`0`:STRING,`15`:STRING,`6`:STRING,`12`:STRING,`7`:STRING,`isReact`:STRING,`8`:STRING,`17`:STRING,`3`:STRING,`moveInDateSelected`:STRING,`10`:STRING,`extra`:struct<`unitId`:STRING,`facilityId`:STRING,`dateSelected`:STRING,`place`:struct<`photos`:array,`width`:STRING>>,`formatted_address`:STRING,`types`:array,`scope`:STRING,`url`:STRING,`geometry`:struct<`viewport`:struct<`Qa`:struct<`i`:STRING,`j`:STRING>,`ga`:struct<`j`:STRING,`l`:STRING>,`pa`:struct<`h`:STRING,`g`:STRING>,`Ya`:struct<`i`:STRING,`j`:STRING>,`Va`:struct<`i`:STRING,`j`:STRING>,`na`:struct<`j`:STRING,`l`:STRING>,`oa`:struct<`h`:STRING,`g`:STRING>,`ka`:struct<`h`:STRING,`g`:STRING>,`ia`:struct<`j`:STRING,`l`:STRING>,`Ua`:struct<`i`:STRING,`j`:STRING>,`Ra`:struct<`g`:STRING,`i`:STRING>,`La`:struct<`g`:STRING,`i`:STRING>>>,`utc_offset`:STRING,`icon`:STRING,`vicinity`:STRING,`website`:STRING,`place_id`:STRING,`address_components`:array>>,`html_attributions`:array,`utc_offset_minutes`:STRING,`name`:STRING,`adr_address`:STRING,`reference`:STRING,`id`:STRING>>,`Hit_Timestamp`:STRING>,`channel`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`messageId`STRING,`context`struct<`locale`:STRING,`userAgent`:STRING,`page`:struct<`title`:STRING,`search`:STRING,`url`:STRING,`path`:STRING,`referrer`:STRING>,`ip`:STRING,`library`:struct<`name`:STRING,`version`:STRING>,`campaign`:struct<`_empty_`:STRING>>,`type`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-storagescout-dev/separated_dt/click'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_segment.storagescout_click`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_segment.storagescout_click"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}