Schema Info

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`",
    "DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_readmoreclicked`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.reactfoot_readmoreclicked`\n(\n`anonymousId`STRING,`messageId`STRING,`timestamp`STRING,`properties`struct<`site_id`:STRING,`label`:STRING,`Hit_Timestamp`:STRING,`category`:STRING,`readMore`:STRING,`env`:STRING,`isReact`:STRING>,`context`struct<`timezone`:STRING,`library`:struct<`name`:STRING,`version`:STRING>,`campaign`:struct<`content`:STRING,`source`:STRING,`medium`:STRING,`term`:STRING,`name`:STRING>,`ip`:STRING,`userAgentData`:struct<`brands`:array>,`mobile`:STRING,`platform`:STRING>,`locale`:STRING,`page`:struct<`title`:STRING,`url`:STRING,`search`:STRING,`referrer`:STRING,`path`:STRING>,`userAgent`:STRING>,`sentAt`STRING,`projectId`STRING,`event`STRING,`_origin`STRING,`channel`STRING,`originalTimestamp`STRING,`receivedAt`STRING,`type`STRING,`userId`STRING,`version`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-reactfoot-prod/separated_dt/Read More Clicked'\n",
    "MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_readmoreclicked"
]

{
    "__segment_internal": {},
    "_metadata": {
        "bundled": [
            "Google Tag Manager",
            "Segment.io"
        ],
        "bundledIds": [
            "59c13c7c1386430001b3c90e"
        ],
        "unbundled": []
    },
    "_origin": "2025-02-01T06:56:16Z|s3://sfdl-segment-reactfoot-prod/segment-logs/a0wkEvFBBK/1738368000000/1738392909119.events-archiver-480-28..264c2ade-f6bc-40d1-a97d-f5fb4064b0bf.gz|analytics-segment-separator-prod:$LATEST",
    "anonymousId": "4f2625d6-2bf7-414f-8dd2-ce5dfe9d940d",
    "channel": "client",
    "context": {
        "campaign": {
            "content": "",
            "medium": "paidsearch",
            "name": "SF Google|PMAX",
            "source": "google",
            "term": ""
        },
        "ip": "2600:8804:8758:4f00:cc8e:43fb:b1ef:65d5",
        "library": {
            "name": "analytics.js",
            "version": "next-1.77.0"
        },
        "locale": "en-US",
        "page": {
            "path": "/storage-unit-size-guide.html",
            "referrer": "https://www.google.com/",
            "search": "?tsid=google-ppc&utm_source=google&utm_medium=paidsearch&utm_campaign=SF+Google%7CPMAX&utm_content=&ploc=9026133&utm_term=&location=%7Blocation%7D&iloc=&mkwid=%7Cpcrid%7C%7Cpkw%7C%7Cpmt%7C%7Cpdv%7Cm%7Cpgrid%7C%7Ccpgnid%7C18795194638%7Cptaid%7C%7Cadext%7C&pgrid=&ptaid=&gad_source=1&gbraid=0AAAAAD0HYGma-8OEI3iamZNP58waVxpqo&gclid=EAIaIQobChMI9bb1q-yhiwMVSjYIBR00jx0eEAAYASAKEgKgifD_BwE",
            "title": "Storage Unit Size Guide | Find The Right Size Unit For Your Storage Needs",
            "url": "https://www.sparefoot.com/storage-unit-size-guide.html?tsid=google-ppc&utm_source=google&utm_medium=paidsearch&utm_campaign=SF+Google%7CPMAX&utm_content=&ploc=9026133&utm_term=&location=%7Blocation%7D&iloc=&mkwid=%7Cpcrid%7C%7Cpkw%7C%7Cpmt%7C%7Cpdv%7Cm%7Cpgrid%7C%7Ccpgnid%7C18795194638%7Cptaid%7C%7Cadext%7C&pgrid=&ptaid=&gad_source=1&gbraid=0AAAAAD0HYGma-8OEI3iamZNP58waVxpqo&gclid=EAIaIQobChMI9bb1q-yhiwMVSjYIBR00jx0eEAAYASAKEgKgifD_BwE"
        },
        "timezone": "America/Chicago",
        "userAgent": "Mozilla/5.0 (iPhone; CPU iPhone OS 18_1_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Mobile/15E148 Safari/604.1"
    },
    "event": "Read More Clicked",
    "integrations": {},
    "messageId": "ajs-next-1738391461329-fe9d940d-1756-4cd2-aefa-451f6bc26f8d",
    "originalTimestamp": "2025-02-01T06:31:01.329Z",
    "projectId": "a0wkEvFBBK",
    "properties": {
        "Hit Timestamp": 1738391461329,
        "category": "missing category-storageSizeLandingPage",
        "env": "production",
        "isReact": true,
        "label": "Storage Calculator Read More",
        "readMore": true,
        "site_id": -1
    },
    "receivedAt": "2025-02-01T06:31:01.627Z",
    "sentAt": "2025-02-01T06:31:01.338Z",
    "timestamp": "2025-02-01T06:31:01.618Z",
    "type": "track",
    "userId": "d8f0bcf99692e57ff10bc74adcc44e45",
    "version": 2
}

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.campaign.content": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.campaign.source": "string",
    "context.campaign.term": "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.timezone": "string",
    "context.userAgent": "string",
    "context.userAgentData.brands": [
        {
            "brand": "string",
            "version": "string"
        }
    ],
    "context.userAgentData.mobile": "string",
    "context.userAgentData.platform": "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.readMore": "string",
    "properties.site_id": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`",
    "DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_readmoreclicked`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.reactfoot_readmoreclicked`\n(\n`type`STRING,`event`STRING,`userId`STRING,`anonymousId`STRING,`originalTimestamp`STRING,`_origin`STRING,`version`STRING,`receivedAt`STRING,`timestamp`STRING,`projectId`STRING,`messageId`STRING,`context`struct<`ip`:STRING,`timezone`:STRING,`userAgent`:STRING,`locale`:STRING,`userAgentData`:struct<`brands`:array>,`mobile`:STRING,`platform`:STRING>,`campaign`:struct<`source`:STRING,`medium`:STRING,`name`:STRING>,`library`:struct<`version`:STRING,`name`:STRING>,`page`:struct<`title`:STRING,`path`:STRING,`url`:STRING,`referrer`:STRING,`search`:STRING>>,`properties`struct<`env`:STRING,`category`:STRING,`isReact`:STRING,`site_id`:STRING,`readMore`:STRING,`label`:STRING,`Hit_Timestamp`:STRING>,`sentAt`STRING,`channel`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-reactfoot-prod/separated_dt/Read More Clicked'\n",
    "MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_readmoreclicked"
]

{
    "__segment_internal": {},
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "bundledIds": [
            "59c55a4597f7a100011813be",
            "59c13c7c1386430001b3c90e"
        ],
        "unbundled": []
    },
    "_origin": "2024-11-17T18:45:09Z|s3://sfdl-segment-reactfoot-prod/segment-logs/a0wkEvFBBK/1731801600000/1731869088416.events-archiver-480-31..ff23c793-abbc-4634-9c14-9109ecbbd038.gz|analytics-segment-separator-prod:$LATEST",
    "anonymousId": "952fd66f-579e-4a25-8e60-8061eb33a13b",
    "channel": "client",
    "context": {
        "campaign": {
            "medium": "paidsearch",
            "name": "SF Google|General|Dynamic",
            "source": "google"
        },
        "ip": "47.212.96.106",
        "library": {
            "name": "analytics.js",
            "version": "next-1.76.0"
        },
        "locale": "en-US",
        "page": {
            "path": "/storage-unit-size-guide.html",
            "referrer": "https://www.google.com/",
            "search": "?tsid=google-ppc&utm_source=google&utm_medium=paidsearch&utm_campaign=SF+Google%7CGeneral%7CDynamic&pdv=m&pgrid=32834077631&cpgnid=611394405&ptaid=dsa-19959388920&mkwid=sBj3C9stH%7Cpcrid%7C325580280382%7Cpkw%7C%7Cpmt%7C%7Cpdv%7Cm%7Cpgrid%7C32834077631%7Ccpgnid%7C611394405%7Cptaid%7Cdsa-19959388920%7Cadext%7C&gad_source=1&gbraid=0AAAAAD0HYGlIb0fu_efj7nKYDM1eol4jn&gclid=CjwKCAiAxea5BhBeEiwAh4t5K2yNODunf3kM9WxK7tHcQAz9vVkUlBhHQXfzZ4ZlIs4VW_BbhGZPKxoC0cQQAvD_BwE",
            "title": "Storage Unit Size Guide | Find The Right Size Unit For Your Storage Needs",
            "url": "https://www.sparefoot.com/storage-unit-size-guide.html?tsid=google-ppc&utm_source=google&utm_medium=paidsearch&utm_campaign=SF+Google%7CGeneral%7CDynamic&pdv=m&pgrid=32834077631&cpgnid=611394405&ptaid=dsa-19959388920&mkwid=sBj3C9stH%7Cpcrid%7C325580280382%7Cpkw%7C%7Cpmt%7C%7Cpdv%7Cm%7Cpgrid%7C32834077631%7Ccpgnid%7C611394405%7Cptaid%7Cdsa-19959388920%7Cadext%7C&gad_source=1&gbraid=0AAAAAD0HYGlIb0fu_efj7nKYDM1eol4jn&gclid=CjwKCAiAxea5BhBeEiwAh4t5K2yNODunf3kM9WxK7tHcQAz9vVkUlBhHQXfzZ4ZlIs4VW_BbhGZPKxoC0cQQAvD_BwE"
        },
        "timezone": "America/New_York",
        "userAgent": "Mozilla/5.0 (iPhone; CPU iPhone OS 17_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) GSA/342.0.693598186 Mobile/15E148 Safari/604.1"
    },
    "event": "Read More Clicked",
    "integrations": {},
    "messageId": "ajs-next-1731865620954-9c0d129a-a361-4ceb-b02a-4d26eb3588a8",
    "originalTimestamp": "2024-11-17T17:47:00.954Z",
    "projectId": "a0wkEvFBBK",
    "properties": {
        "Hit Timestamp": 1731865620954,
        "category": "missing category-storageSizeLandingPage",
        "env": "production",
        "isReact": true,
        "label": "Storage Calculator Read More",
        "readMore": true,
        "site_id": -1
    },
    "receivedAt": "2024-11-17T17:47:01.247Z",
    "sentAt": "2024-11-17T17:47:00.963Z",
    "timestamp": "2024-11-17T17:47:01.238Z",
    "type": "track",
    "userId": "c6e76a78293babba71d317ac773a6a03",
    "version": 2
}

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "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.timezone": "string",
    "context.userAgent": "string",
    "context.userAgentData.brands": [
        {
            "brand": "string",
            "version": "string"
        }
    ],
    "context.userAgentData.mobile": "string",
    "context.userAgentData.platform": "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.readMore": "string",
    "properties.site_id": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`",
    "DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_readmoreclicked`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.reactfoot_readmoreclicked`\n(\n`version`STRING,`userId`STRING,`event`STRING,`receivedAt`STRING,`timestamp`STRING,`type`STRING,`projectId`STRING,`context`struct<`page`:struct<`path`:STRING,`referrer`:STRING,`search`:STRING,`title`:STRING,`url`:STRING>,`userAgent`:STRING,`userAgentData`:struct<`brands`:array>,`mobile`:STRING,`platform`:STRING>,`locale`:STRING,`library`:struct<`name`:STRING,`version`:STRING>,`timezone`:STRING,`ip`:STRING>,`messageId`STRING,`properties`struct<`category`:STRING,`label`:STRING,`readMore`:STRING,`env`:STRING,`Hit_Timestamp`:STRING,`site_id`:STRING,`isReact`:STRING>,`anonymousId`STRING,`sentAt`STRING,`channel`STRING,`originalTimestamp`STRING,`_origin`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-reactfoot-prod/separated_dt/Read More Clicked'\n",
    "MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_readmoreclicked"
]

{
    "__segment_internal": {},
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "bundledIds": [
            "59c55a4597f7a100011813be",
            "59c13c7c1386430001b3c90e"
        ],
        "unbundled": []
    },
    "_origin": "2024-11-13T20:34:52Z|s3://sfdl-segment-reactfoot-prod/segment-logs/a0wkEvFBBK/1731456000000/1731530081429.events-archiver-480-25..36204444-6df4-4343-a0a8-8d5d51d04d76.gz|analytics-segment-separator-prod:$LATEST",
    "anonymousId": "7362c8f2-d510-4924-977d-5873707febb1",
    "channel": "client",
    "context": {
        "ip": "2600:8800:6d01:f000:8df2:f0b4:1934:54fc",
        "library": {
            "name": "analytics.js",
            "version": "next-1.76.0"
        },
        "locale": "en-US",
        "page": {
            "path": "/storage-unit-size-guide.html",
            "referrer": "android-app://com.slack/",
            "search": "",
            "title": "Storage Unit Size Guide | Find The Right Size Unit For Your Storage Needs",
            "url": "https://www.sparefoot.com/storage-unit-size-guide.html"
        },
        "timezone": "America/Phoenix",
        "userAgent": "Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Mobile Safari/537.36",
        "userAgentData": {
            "brands": [
                {
                    "brand": "Chromium",
                    "version": "130"
                },
                {
                    "brand": "Google Chrome",
                    "version": "130"
                },
                {
                    "brand": "Not?A_Brand",
                    "version": "99"
                }
            ],
            "mobile": true,
            "platform": "Android"
        }
    },
    "event": "Read More Clicked",
    "integrations": {},
    "messageId": "ajs-next-1731528806497-2b886f45-398d-48f0-9ab0-1e8c99ee9f3a",
    "originalTimestamp": "2024-11-13T20:13:26.497Z",
    "projectId": "a0wkEvFBBK",
    "properties": {
        "Hit Timestamp": 1731528806497,
        "category": "missing category-storageSizeLandingPage",
        "env": "production",
        "isReact": true,
        "label": "Storage Calculator Read More",
        "readMore": true,
        "site_id": -1
    },
    "receivedAt": "2024-11-13T20:13:27.965Z",
    "sentAt": "2024-11-13T20:13:26.513Z",
    "timestamp": "2024-11-13T20:13:27.949Z",
    "type": "track",
    "userId": "5bc4290533e42d47970af65fff113dc3",
    "version": 2
}

{
    "_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.timezone": "string",
    "context.userAgent": "string",
    "context.userAgentData.brands": [
        {
            "brand": "string",
            "version": "string"
        }
    ],
    "context.userAgentData.mobile": "string",
    "context.userAgentData.platform": "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.readMore": "string",
    "properties.site_id": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

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

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "partition": {
        "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Read More Clicked/dt=2025-02-01/",
        "name": "dt",
        "type": "string",
        "value": "2025-02-01"
    },
    "s3": {
        "bucket": "sfdl-segment-reactfoot-prod",
        "hive_path": "s3://sfdl-segment-reactfoot-prod/separated_dt/Read More Clicked",
        "key": "separated_dt/Read More Clicked/dt=2025-02-01/1738392909119.events-archiver-480-28..264c2ade-f6bc-40d1-a97d-f5fb4064b0bf.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_segment.reactfoot_ReadMoreClicked",
        "type": "segment"
    }
}

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

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "partition": {
        "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Read More Clicked/dt=2024-11-17/",
        "name": "dt",
        "type": "string",
        "value": "2024-11-17"
    },
    "s3": {
        "bucket": "sfdl-segment-reactfoot-prod",
        "hive_path": "s3://sfdl-segment-reactfoot-prod/separated_dt/Read More Clicked",
        "key": "separated_dt/Read More Clicked/dt=2024-11-17/1731869088416.events-archiver-480-31..ff23c793-abbc-4634-9c14-9109ecbbd038.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_segment.reactfoot_ReadMoreClicked",
        "type": "segment"
    }
}

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

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "partition": {
        "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Read More Clicked/dt=2024-11-13/",
        "name": "dt",
        "type": "string",
        "value": "2024-11-13"
    },
    "s3": {
        "bucket": "sfdl-segment-reactfoot-prod",
        "hive_path": "s3://sfdl-segment-reactfoot-prod/separated_dt/Read More Clicked",
        "key": "separated_dt/Read More Clicked/dt=2024-11-13/1731530081429.events-archiver-480-25..36204444-6df4-4343-a0a8-8d5d51d04d76.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_segment.reactfoot_ReadMoreClicked",
        "type": "segment"
    }
}