Schema Info

Schema Name: sfdl_prod_segment.ssdc_product_clicked

created: 2017-11-02 13:48:41
disabled: False
format: raw
id: 116
is_partitioned: True
is_schema_datatyped: False

name:

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

type: segment

Schema Versions: 3

Version 131219

created: 2020-03-13 16:07:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`",
    "DROP TABLE IF EXISTS `sfdl_prod_segment.ssdc_product_clicked`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.ssdc_product_clicked`\n(\n`event`STRING,`context`struct<`library`:struct<`version`:STRING,`name`:STRING>,`ip`:STRING,`userAgent`:STRING,`locale`:STRING,`page`:struct<`referrer`:STRING,`search`:STRING,`title`:STRING,`path`:STRING,`url`:STRING>,`campaign`:struct<`campaign__`:STRING,`campaign_5B_5D`:STRING,`source_5B_5D`:STRING,`medium__`:STRING,`content`:STRING,`content__`:STRING,`term`:STRING,`source`:STRING,`medium`:STRING,`source__`:STRING,`content_5B_5D`:STRING,`medium_5B_5D`:STRING,`name`:STRING>>,`_metadata`struct<`bundled`:array,`unbundled`:array>,`receivedAt`STRING,`channel`STRING,`integrations`struct<`page`:struct<`url`:STRING,`path`:STRING,`search`:STRING,`title`:STRING,`referrer`:STRING>,`library`:struct<`version`:STRING,`name`:STRING>>,`sentAt`STRING,`_origin`STRING,`anonymousId`STRING,`version`STRING,`timestamp`STRING,`originalTimestamp`STRING,`userId`STRING,`projectId`STRING,`properties`struct<`id`:STRING,`label`:STRING,`variant`:STRING,`quantity`:STRING,`list`:STRING,`isReact`:STRING,`price`:STRING,`name`:STRING,`search_id`:STRING,`brand`:STRING,`site_id`:STRING,`product_id`:STRING,`category`:STRING,`env`:STRING,`Hit_Timestamp`:STRING,`position`:STRING,`rank`:STRING,`inNetwork`:STRING>,`messageId`STRING,`type`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/Product Clicked'\n",
    "MSCK REPAIR TABLE sfdl_prod_segment.ssdc_product_clicked"
]

hive_path: s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked
id: 131219
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "unbundled": []
    },
    "_origin": "2020-03-13T21:07:19Z|s3://sfdl-segment-ssdc-prod/segment-logs/5yGJd9z7eL/1584057600000/1584133597290.c1031d165a34.e4797d0.be1953a0-18c0-473a-9906-58eb91e448ca.gz|segment_separator:37",
    "anonymousId": "8102c309-025e-488f-8cda-9a0d0f78b753",
    "channel": "client",
    "context": {
        "campaign": {
            "campaign%5B%5D": "pro_national_nogeo_noproduct_dynamic",
            "content": "",
            "content%5B%5D": "",
            "medium": "paidsearch",
            "medium%5B%5D": "paidsearch",
            "name": "pro_national_nogeo_noproduct_dynamic",
            "source": "bing",
            "source%5B%5D": "bing"
        },
        "ip": "76.98.2.204",
        "library": {
            "name": "analytics.js",
            "version": "3.11.2"
        },
        "locale": "en-US",
        "page": {
            "path": "/self-storage/virginia/virginia-beach/",
            "referrer": "",
            "search": "?bidgroup=&cid%5B%5D=pro_national_nogeo_noproduct_dynamic&cid%5B%5D=pro_national_nogeo_noproduct_dynamic&facilityNotFound=true&iloc%5B%5D=66801&iloc%5B%5D=66801&iv_=__iv_c_76828392868262_w_dat-76828401852529%3Aloc-71262_g_1229254033759492_n_o_e__h_95485_ii_66801_q_self%20storage%20near%20birdneck%20village%20%2C%20virginia%20beach_p_2_d_c_vi__&location=virginia-beach%2C%20virginia&mkwid%5B%5D=fC5ZCtkB%7Cpcrid%7C76828392868262%7Cpkw%7Cself-storage%2Fvirginia%2F%7Cpmt%7Cbb%7Cpdv%7Cc%7Cpgrid%7C1229254033759492%7Cptaid%7Cdat-76828401852529%3Aloc-71262&mkwid%5B%5D=fC5ZCtkB%7Cpcrid%7C76828392868262%7Cpkw%7Cself-storage%2Fvirginia%2F%7Cpmt%7Cbb%7Cpdv%7Cc%7Cpgrid%7C1229254033759492%7Cptaid%7Cdat-76828401852529%3Aloc-71262&msclkid=1e2e6db9969b1993a73233d3ae8a34f1&pgrid%5B%5D=1229254033759492&pgrid%5B%5D=1229254033759492&ploc%5B%5D=95485&ploc%5B%5D=95485&ptaid%5B%5D=dat-76828401852529%3Aloc-71262https%3A%2F%2Fwww.selfstorage.com%2Fself-storage%2Fvirginia%2Fvirginia-beach%2Fbirdneck-self-storage-155744%2F%3Ftsid%3Dbing-ppc&ptaid%5B%5D=dat-76828401852529%3Aloc-71262&tsid=bing-ppc&utm_campaign%5B%5D=pro_national_nogeo_noproduct_dynamic&utm_campaign%5B%5D=pro_national_nogeo_noproduct_dynamic&utm_content%5B%5D=&utm_content%5B%5D=&utm_medium%5B%5D=paidsearch&utm_medium%5B%5D=paidsearch&utm_source%5B%5D=bing&utm_source%5B%5D=bing",
            "title": "SelfStorage.com: Find Cheap Storage Units Near You",
            "url": "https://www.selfstorage.com/self-storage/virginia/virginia-beach/?bidgroup=&cid%5B%5D=pro_national_nogeo_noproduct_dynamic&cid%5B%5D=pro_national_nogeo_noproduct_dynamic&facilityNotFound=true&iloc%5B%5D=66801&iloc%5B%5D=66801&iv_=__iv_c_76828392868262_w_dat-76828401852529%3Aloc-71262_g_1229254033759492_n_o_e__h_95485_ii_66801_q_self%20storage%20near%20birdneck%20village%20%2C%20virginia%20beach_p_2_d_c_vi__&location=virginia-beach%2C%20virginia&mkwid%5B%5D=fC5ZCtkB%7Cpcrid%7C76828392868262%7Cpkw%7Cself-storage%2Fvirginia%2F%7Cpmt%7Cbb%7Cpdv%7Cc%7Cpgrid%7C1229254033759492%7Cptaid%7Cdat-76828401852529%3Aloc-71262&mkwid%5B%5D=fC5ZCtkB%7Cpcrid%7C76828392868262%7Cpkw%7Cself-storage%2Fvirginia%2F%7Cpmt%7Cbb%7Cpdv%7Cc%7Cpgrid%7C1229254033759492%7Cptaid%7Cdat-76828401852529%3Aloc-71262&msclkid=1e2e6db9969b1993a73233d3ae8a34f1&pgrid%5B%5D=1229254033759492&pgrid%5B%5D=1229254033759492&ploc%5B%5D=95485&ploc%5B%5D=95485&ptaid%5B%5D=dat-76828401852529%3Aloc-71262https%3A%2F%2Fwww.selfstorage.com%2Fself-storage%2Fvirginia%2Fvirginia-beach%2Fbirdneck-self-storage-155744%2F%3Ftsid%3Dbing-ppc&ptaid%5B%5D=dat-76828401852529%3Aloc-71262&tsid=bing-ppc&utm_campaign%5B%5D=pro_national_nogeo_noproduct_dynamic&utm_campaign%5B%5D=pro_national_nogeo_noproduct_dynamic&utm_content%5B%5D=&utm_content%5B%5D=&utm_medium%5B%5D=paidsearch&utm_medium%5B%5D=paidsearch&utm_source%5B%5D=bing&utm_source%5B%5D=bing"
        },
        "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_3) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.5 Safari/605.1.15"
    },
    "event": "Product Clicked",
    "integrations": {},
    "messageId": "ajs-daefc24206fab86eb3281f84a046fe58",
    "originalTimestamp": "2020-03-13T20:10:05.141Z",
    "projectId": "5yGJd9z7eL",
    "properties": {
        "Hit Timestamp": 1584130205140,
        "brand": "self-storage",
        "category": "Virginia Beach, VA",
        "env": "production",
        "isReact": true,
        "list": "undefined: virginia-beach, virginia",
        "name": "Fort Storage - Virginia Beach - 199144",
        "position": 14,
        "price": 36,
        "product_id": 199144,
        "quantity": 1,
        "search_id": "0ae65e6be87c2a75d3.68107962",
        "site_id": 27,
        "variant": null
    },
    "receivedAt": "2020-03-13T20:10:05.285Z",
    "sentAt": "2020-03-13T20:10:05.150Z",
    "timestamp": "2020-03-13T20:10:05.276Z",
    "type": "track",
    "userId": "3b02179445049a3d24e2ca2f07289e60",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.campaign.campaign_5B_5D": "string",
    "context.campaign.campaign__": "string",
    "context.campaign.content": "string",
    "context.campaign.content_5B_5D": "string",
    "context.campaign.content__": "string",
    "context.campaign.medium": "string",
    "context.campaign.medium_5B_5D": "string",
    "context.campaign.medium__": "string",
    "context.campaign.name": "string",
    "context.campaign.source": "string",
    "context.campaign.source_5B_5D": "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.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.brand": "string",
    "properties.category": "string",
    "properties.env": "string",
    "properties.id": "string",
    "properties.inNetwork": "string",
    "properties.isReact": "string",
    "properties.label": "string",
    "properties.list": "string",
    "properties.name": "string",
    "properties.position": "string",
    "properties.price": "string",
    "properties.product_id": "string",
    "properties.quantity": "string",
    "properties.rank": "string",
    "properties.search_id": "string",
    "properties.site_id": "string",
    "properties.variant": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 116
schema_scan_id: 33915884
updated: 2020-03-13 16:12:24

Version 120649

created: 2020-01-16 12:46:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`",
    "DROP TABLE IF EXISTS `sfdl_prod_segment.ssdc_product_clicked`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.ssdc_product_clicked`\n(\n`sentAt`STRING,`version`STRING,`type`STRING,`event`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<`rank`:STRING,`isReact`:STRING,`quantity`:STRING,`brand`:STRING,`inNetwork`:STRING,`Hit_Timestamp`:STRING,`label`:STRING,`site_id`:STRING,`category`:STRING,`name`:STRING,`price`:STRING,`id`:STRING,`product_id`:STRING,`search_id`:STRING,`position`:STRING,`list`:STRING,`variant`:STRING,`env`:STRING>,`receivedAt`STRING,`messageId`STRING,`context`struct<`locale`:STRING,`library`:struct<`name`:STRING,`version`:STRING>,`campaign`:struct<`term`:STRING,`content__`:STRING,`medium`:STRING,`name`:STRING,`campaign__`:STRING,`content`:STRING,`source__`:STRING,`medium__`:STRING,`source`:STRING>,`ip`:STRING,`userAgent`:STRING,`page`:struct<`referrer`:STRING,`search`: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/Product Clicked'\n",
    "MSCK REPAIR TABLE sfdl_prod_segment.ssdc_product_clicked"
]

hive_path: s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked
id: 120649
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "unbundled": []
    },
    "_origin": "2020-01-16T17:44:36Z|s3://sfdl-segment-ssdc-prod/segment-logs/5yGJd9z7eL/1579132800000/1579196618503.c55215427e02.e4797d0.cbee33fd-6d5c-48e6-b79f-1b0e78b64fd1.gz|segment_separator:37",
    "anonymousId": "041cdbea-7c46-4b29-8954-261d0fc5681a",
    "channel": "client",
    "context": {
        "campaign": {},
        "ip": "24.56.75.10",
        "library": {
            "name": "analytics.js",
            "version": "3.10.1"
        },
        "locale": "en-US",
        "page": {
            "path": "/self-storage/wisconsin/waukesha/",
            "referrer": "https://www.selfstorage.com/self-storage/wisconsin/waukesha/",
            "search": "?informedSearch=true&location=53189",
            "title": "SelfStorage.com: Find Cheap Storage Units Near You",
            "url": "https://www.selfstorage.com/self-storage/wisconsin/waukesha/?informedSearch=true&location=53189"
        },
        "userAgent": "Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.88 Safari/537.36"
    },
    "event": "Product Clicked",
    "integrations": {},
    "messageId": "ajs-3fb74231a93b479df6e67a8114fa9ad8",
    "originalTimestamp": "2020-01-16T16:45:19.122Z",
    "projectId": "5yGJd9z7eL",
    "properties": {
        "Hit Timestamp": 1579193119119,
        "brand": "self-storage",
        "category": "Waukesha, WI",
        "env": "production",
        "isReact": true,
        "list": "undefined: 53189",
        "name": "Public Storage - Waukesha - 1643 Arcadian Ave - 214265",
        "position": 3,
        "price": null,
        "product_id": 214265,
        "quantity": 1,
        "search_id": "90f25e2092d0298336.40273687",
        "site_id": 27,
        "variant": null
    },
    "receivedAt": "2020-01-16T16:45:19.332Z",
    "sentAt": "2020-01-16T16:45:19.129Z",
    "timestamp": "2020-01-16T16:45:19.325Z",
    "type": "track",
    "userId": "d5d42a94f8dc6b5f890dad4dc599f3d6",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.campaign.campaign__": "string",
    "context.campaign.content": "string",
    "context.campaign.content__": "string",
    "context.campaign.medium": "string",
    "context.campaign.medium__": "string",
    "context.campaign.name": "string",
    "context.campaign.source": "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.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.brand": "string",
    "properties.category": "string",
    "properties.env": "string",
    "properties.id": "string",
    "properties.inNetwork": "string",
    "properties.isReact": "string",
    "properties.label": "string",
    "properties.list": "string",
    "properties.name": "string",
    "properties.position": "string",
    "properties.price": "string",
    "properties.product_id": "string",
    "properties.quantity": "string",
    "properties.rank": "string",
    "properties.search_id": "string",
    "properties.site_id": "string",
    "properties.variant": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 116
schema_scan_id: 31692879
updated: 2020-01-16 13:04:23

Version 119509

created: 2020-01-10 17:13:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`",
    "DROP TABLE IF EXISTS `sfdl_prod_segment.ssdc_product_clicked`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.ssdc_product_clicked`\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<`rank`:STRING,`isReact`:STRING,`quantity`:STRING,`brand`:STRING,`inNetwork`:STRING,`Hit_Timestamp`:STRING,`label`:STRING,`site_id`:STRING,`name`:STRING,`category`:STRING,`price`:STRING,`id`:STRING,`product_id`:STRING,`search_id`:STRING,`position`:STRING,`list`:STRING,`variant`:STRING,`env`:STRING>,`receivedAt`STRING,`messageId`STRING,`context`struct<`library`:struct<`name`:STRING,`version`:STRING>,`campaign`:struct<`term`:STRING,`content__`:STRING,`medium`:STRING,`name`:STRING,`campaign__`:STRING,`content`:STRING,`source__`:STRING,`medium__`:STRING,`source`:STRING>,`ip`:STRING,`userAgent`:STRING,`page`:struct<`referrer`:STRING,`search`: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/Product Clicked'\n",
    "MSCK REPAIR TABLE sfdl_prod_segment.ssdc_product_clicked"
]

hive_path: s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked
id: 119509
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "unbundled": []
    },
    "_origin": "2020-01-10T23:13:21Z|s3://sfdl-segment-ssdc-prod/segment-logs/5yGJd9z7eL/1578614400000/1578697634905.81f34d95408c.e4797d0.e3f98b0d-6a02-4956-bcff-a9dbb3960c03.gz|segment_separator:37",
    "anonymousId": "380d2f5b-ecbf-49d5-ab36-9458362aa7b7",
    "channel": "client",
    "context": {
        "campaign": {
            "campaign[]": "pro_national_nogeo_noproduct_dynamic",
            "content[]": "",
            "medium[]": "paidsearch",
            "source[]": "bing"
        },
        "ip": "67.172.178.69",
        "library": {
            "name": "analytics.js",
            "version": "3.10.1"
        },
        "page": {
            "path": "/self-storage/california/salida/",
            "referrer": "https://www.bing.com/search?q=storage%20star%20salida%20ca&pc=cosp&ptag=G6C999N1234D080118A98C4AF66BD&form=CONMHP&conlogo=CT3210127",
            "search": "?cid[]=pro_national_nogeo_noproduct_dynamic&cid[]=pro_national_nogeo_noproduct_dynamic&facilityNotFound=true&iloc[]=44009&iloc[]=44009&iv_=__iv_c_77171990268899_w_dat-77171999477138%3Aloc-4084_g_1234751591900569_n_o_e__h_91595_ii_44009_q_storage%20star%20salida%20ca_p_2_d_c_vi__&location=salida%2C%20california&mkwid[]=dRDZerxb%7Cpcrid%7C77171990268899%7Cpkw%7Cself-storage%2Fcalifornia%2F%7Cpmt%7Cbb%7Cpdv%7Cc%7Cpgrid%7C1234751591900569%7Cptaid%7Cdat-77171999477138%3Aloc-4084&mkwid[]=dRDZerxb%7Cpcrid%7C77171990268899%7Cpkw%7Cself-storage%2Fcalifornia%2F%7Cpmt%7Cbb%7Cpdv%7Cc%7Cpgrid%7C1234751591900569%7Cptaid%7Cdat-77171999477138%3Aloc-4084&msclkid=5c40ee7174381e1bcf09b0698152d84c&pgrid[]=1234751591900569&pgrid[]=1234751591900569&ploc[]=91595&ploc[]=91595&ptaid[]=dat-77171999477138%3Aloc-4084https%3A%2F%2Fwww.selfstorage.com%2Fself-storage%2Fcalifornia%2Fsalida%2Fstorage-star-secured-self-storage-salida-211819%2F%3Ftsid%3Dbing-ppc&ptaid[]=dat-77171999477138%3Aloc-4084&tsid=bing-ppc&utm_campaign[]=pro_national_nogeo_noproduct_dynamic&utm_campaign[]=pro_national_nogeo_noproduct_dynamic&utm_content[]=&utm_content[]=&utm_medium[]=paidsearch&utm_medium[]=paidsearch&utm_source[]=bing&utm_source[]=bing",
            "title": "SelfStorage.com: Find Cheap Storage Units Near You",
            "url": "https://www.selfstorage.com/self-storage/california/salida/?cid[]=pro_national_nogeo_noproduct_dynamic&cid[]=pro_national_nogeo_noproduct_dynamic&facilityNotFound=true&iloc[]=44009&iloc[]=44009&iv_=__iv_c_77171990268899_w_dat-77171999477138%3Aloc-4084_g_1234751591900569_n_o_e__h_91595_ii_44009_q_storage%20star%20salida%20ca_p_2_d_c_vi__&location=salida%2C%20california&mkwid[]=dRDZerxb%7Cpcrid%7C77171990268899%7Cpkw%7Cself-storage%2Fcalifornia%2F%7Cpmt%7Cbb%7Cpdv%7Cc%7Cpgrid%7C1234751591900569%7Cptaid%7Cdat-77171999477138%3Aloc-4084&mkwid[]=dRDZerxb%7Cpcrid%7C77171990268899%7Cpkw%7Cself-storage%2Fcalifornia%2F%7Cpmt%7Cbb%7Cpdv%7Cc%7Cpgrid%7C1234751591900569%7Cptaid%7Cdat-77171999477138%3Aloc-4084&msclkid=5c40ee7174381e1bcf09b0698152d84c&pgrid[]=1234751591900569&pgrid[]=1234751591900569&ploc[]=91595&ploc[]=91595&ptaid[]=dat-77171999477138%3Aloc-4084https%3A%2F%2Fwww.selfstorage.com%2Fself-storage%2Fcalifornia%2Fsalida%2Fstorage-star-secured-self-storage-salida-211819%2F%3Ftsid%3Dbing-ppc&ptaid[]=dat-77171999477138%3Aloc-4084&tsid=bing-ppc&utm_campaign[]=pro_national_nogeo_noproduct_dynamic&utm_campaign[]=pro_national_nogeo_noproduct_dynamic&utm_content[]=&utm_content[]=&utm_medium[]=paidsearch&utm_medium[]=paidsearch&utm_source[]=bing&utm_source[]=bing"
        },
        "userAgent": "Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; .NET4.0C; .NET4.0E; rv:11.0) like Gecko"
    },
    "event": "Product Clicked",
    "integrations": {},
    "messageId": "ajs-3f6df948e9496370a0043ef335aba5bf",
    "originalTimestamp": "2020-01-10T22:02:31.667Z",
    "projectId": "5yGJd9z7eL",
    "properties": {
        "Hit Timestamp": 1578693751667,
        "brand": "self-storage",
        "category": "Modesto, CA",
        "env": "production",
        "isReact": true,
        "list": "undefined: salida, california",
        "name": "Storage Star - Modesto - 210699",
        "position": 6,
        "price": null,
        "product_id": 210699,
        "quantity": 1,
        "search_id": "80f45e18f5890f3b54.19468323",
        "site_id": 27,
        "variant": null
    },
    "receivedAt": "2020-01-10T22:08:15.139Z",
    "sentAt": "2020-01-10T22:02:31.673Z",
    "timestamp": "2020-01-10T22:08:15.133Z",
    "type": "track",
    "userId": "e0006fc37f300139f54613194325eca9",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.campaign.campaign__": "string",
    "context.campaign.content": "string",
    "context.campaign.content__": "string",
    "context.campaign.medium": "string",
    "context.campaign.medium__": "string",
    "context.campaign.name": "string",
    "context.campaign.source": "string",
    "context.campaign.source__": "string",
    "context.campaign.term": "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.brand": "string",
    "properties.category": "string",
    "properties.env": "string",
    "properties.id": "string",
    "properties.inNetwork": "string",
    "properties.isReact": "string",
    "properties.label": "string",
    "properties.list": "string",
    "properties.name": "string",
    "properties.position": "string",
    "properties.price": "string",
    "properties.product_id": "string",
    "properties.quantity": "string",
    "properties.rank": "string",
    "properties.search_id": "string",
    "properties.site_id": "string",
    "properties.variant": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 116
schema_scan_id: 31509905
updated: 2020-01-10 17:18:21

Schema Scans: 3

Last at 2020-03-13 16:07:41

Scan 33915884

duration: 0:04:54.163503

exit_message:

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

id: 33915884

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "partition": {
        "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2020-03-13/",
        "name": "dt",
        "type": "string",
        "value": "2020-03-13"
    },
    "s3": {
        "bucket": "sfdl-segment-ssdc-prod",
        "hive_path": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked",
        "key": "separated_dt/Product Clicked/dt=2020-03-13/1584133597290.c1031d165a34.e4797d0.be1953a0-18c0-473a-9906-58eb91e448ca.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_segment.ssdc_Product_Clicked",
        "type": "segment"
    }
}

running: False
schema_name_id: 116
start_time: 2020-03-13 16:07:41
success: True
trace_id: 5521476346257618644

Scan 31692879

duration: 0:10:12.153397

exit_message:

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

id: 31692879

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "partition": {
        "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/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/Product Clicked",
        "key": "separated_dt/Product Clicked/dt=2020-01-16/1579196618503.c55215427e02.e4797d0.cbee33fd-6d5c-48e6-b79f-1b0e78b64fd1.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_segment.ssdc_Product_Clicked",
        "type": "segment"
    }
}

running: False
schema_name_id: 116
start_time: 2020-01-16 12:46:22
success: True
trace_id: 17540516983455750880

Scan 31509905

duration: 0:04:45.895922

exit_message:

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

id: 31509905

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "partition": {
        "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2020-01-10/",
        "name": "dt",
        "type": "string",
        "value": "2020-01-10"
    },
    "s3": {
        "bucket": "sfdl-segment-ssdc-prod",
        "hive_path": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked",
        "key": "separated_dt/Product Clicked/dt=2020-01-10/1578697634905.81f34d95408c.e4797d0.e3f98b0d-6a02-4956-bcff-a9dbb3960c03.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_segment.ssdc_Product_Clicked",
        "type": "segment"
    }
}

running: False
schema_name_id: 116
start_time: 2020-01-10 17:13:46
success: True
trace_id: 17428752571697767405

Partitions:

count: 3

ddl:

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

name: dt

state:

[
    {
        "info": {
            "id": 541046,
            "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2021-02-09/",
            "name": "dt",
            "value": "2021-02-09"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2021-02-08 18:04:05",
                "last_data": "2021-02-09 18:45:39"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 541252,
            "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2021-02-10/",
            "name": "dt",
            "value": "2021-02-10"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2021-02-09 18:06:45",
                "last_data": "2021-02-10 19:06:11"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 541415,
            "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2021-02-11/",
            "name": "dt",
            "value": "2021-02-11"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2021-02-10 18:06:08",
                "last_data": "2021-02-11 15:30:59"
            },
            "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.campaign_5B_5D": "string",
    "context.campaign.campaign__": "string",
    "context.campaign.content": "string",
    "context.campaign.content_5B_5D": "string",
    "context.campaign.content__": "string",
    "context.campaign.medium": "string",
    "context.campaign.medium_5B_5D": "string",
    "context.campaign.medium__": "string",
    "context.campaign.name": "string",
    "context.campaign.source": "string",
    "context.campaign.source_5B_5D": "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.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.brand": "string",
    "properties.category": "string",
    "properties.env": "string",
    "properties.id": "string",
    "properties.inNetwork": "string",
    "properties.isReact": "string",
    "properties.label": "string",
    "properties.list": "string",
    "properties.name": "string",
    "properties.position": "string",
    "properties.price": "string",
    "properties.product_id": "string",
    "properties.quantity": "string",
    "properties.rank": "string",
    "properties.search_id": "string",
    "properties.site_id": "string",
    "properties.variant": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

created: 2020-03-13 16:07:42

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.ssdc_product_clicked`\n(\n`event`STRING,`context`struct<`library`:struct<`version`:STRING,`name`:STRING>,`ip`:STRING,`userAgent`:STRING,`locale`:STRING,`page`:struct<`referrer`:STRING,`search`:STRING,`title`:STRING,`path`:STRING,`url`:STRING>,`campaign`:struct<`campaign__`:STRING,`campaign_5B_5D`:STRING,`source_5B_5D`:STRING,`medium__`:STRING,`content`:STRING,`content__`:STRING,`term`:STRING,`source`:STRING,`medium`:STRING,`source__`:STRING,`content_5B_5D`:STRING,`medium_5B_5D`:STRING,`name`:STRING>>,`_metadata`struct<`bundled`:array,`unbundled`:array>,`receivedAt`STRING,`channel`STRING,`integrations`struct<`page`:struct<`url`:STRING,`path`:STRING,`search`:STRING,`title`:STRING,`referrer`:STRING>,`library`:struct<`version`:STRING,`name`:STRING>>,`sentAt`STRING,`_origin`STRING,`anonymousId`STRING,`version`STRING,`timestamp`STRING,`originalTimestamp`STRING,`userId`STRING,`projectId`STRING,`properties`struct<`id`:STRING,`label`:STRING,`variant`:STRING,`quantity`:STRING,`list`:STRING,`isReact`:STRING,`price`:STRING,`name`:STRING,`search_id`:STRING,`brand`:STRING,`site_id`:STRING,`product_id`:STRING,`category`:STRING,`env`:STRING,`Hit_Timestamp`:STRING,`position`:STRING,`rank`:STRING,`inNetwork`:STRING>,`messageId`STRING,`type`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/Product Clicked'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_segment.ssdc_product_clicked`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_segment.ssdc_product_clicked"
}

Server:

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

Raw:

{
    "name": {
        "created": "2017-11-02 13:48:41",
        "disabled": false,
        "format": "raw",
        "id": 116,
        "is_partitioned": true,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_prod_segment",
            "table": "ssdc_product_clicked"
        },
        "type": "segment"
    },
    "partition": {
        "count": 3,
        "ddl": [
            "ALTER TABLE\n    `sfdl_prod_segment.ssdc_product_clicked`\nADD\n\n\n PARTITION (dt='2021-02-09') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2021-02-09/'\n PARTITION (dt='2021-02-10') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2021-02-10/'\n PARTITION (dt='2021-02-11') location 's3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2021-02-11/'\n;"
        ],
        "name": "dt",
        "state": [
            {
                "info": {
                    "id": 541046,
                    "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2021-02-09/",
                    "name": "dt",
                    "value": "2021-02-09"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2021-02-08 18:04:05",
                        "last_data": "2021-02-09 18:45:39"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 541252,
                    "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2021-02-10/",
                    "name": "dt",
                    "value": "2021-02-10"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2021-02-09 18:06:45",
                        "last_data": "2021-02-10 19:06:11"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 541415,
                    "location": "s3://sfdl-segment-ssdc-prod/separated_dt/Product Clicked/dt=2021-02-11/",
                    "name": "dt",
                    "value": "2021-02-11"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2021-02-10 18:06:08",
                        "last_data": "2021-02-11 15:30:59"
                    },
                    "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.campaign_5B_5D": "string",
            "context.campaign.campaign__": "string",
            "context.campaign.content": "string",
            "context.campaign.content_5B_5D": "string",
            "context.campaign.content__": "string",
            "context.campaign.medium": "string",
            "context.campaign.medium_5B_5D": "string",
            "context.campaign.medium__": "string",
            "context.campaign.name": "string",
            "context.campaign.source": "string",
            "context.campaign.source_5B_5D": "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.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.brand": "string",
            "properties.category": "string",
            "properties.env": "string",
            "properties.id": "string",
            "properties.inNetwork": "string",
            "properties.isReact": "string",
            "properties.label": "string",
            "properties.list": "string",
            "properties.name": "string",
            "properties.position": "string",
            "properties.price": "string",
            "properties.product_id": "string",
            "properties.quantity": "string",
            "properties.rank": "string",
            "properties.search_id": "string",
            "properties.site_id": "string",
            "properties.variant": "string",
            "receivedAt": "string",
            "sentAt": "string",
            "timestamp": "string",
            "type": "string",
            "userId": "string",
            "version": "string"
        },
        "created": "2020-03-13 16:07:42",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.ssdc_product_clicked`\n(\n`event`STRING,`context`struct<`library`:struct<`version`:STRING,`name`:STRING>,`ip`:STRING,`userAgent`:STRING,`locale`:STRING,`page`:struct<`referrer`:STRING,`search`:STRING,`title`:STRING,`path`:STRING,`url`:STRING>,`campaign`:struct<`campaign__`:STRING,`campaign_5B_5D`:STRING,`source_5B_5D`:STRING,`medium__`:STRING,`content`:STRING,`content__`:STRING,`term`:STRING,`source`:STRING,`medium`:STRING,`source__`:STRING,`content_5B_5D`:STRING,`medium_5B_5D`:STRING,`name`:STRING>>,`_metadata`struct<`bundled`:array,`unbundled`:array>,`receivedAt`STRING,`channel`STRING,`integrations`struct<`page`:struct<`url`:STRING,`path`:STRING,`search`:STRING,`title`:STRING,`referrer`:STRING>,`library`:struct<`version`:STRING,`name`:STRING>>,`sentAt`STRING,`_origin`STRING,`anonymousId`STRING,`version`STRING,`timestamp`STRING,`originalTimestamp`STRING,`userId`STRING,`projectId`STRING,`properties`struct<`id`:STRING,`label`:STRING,`variant`:STRING,`quantity`:STRING,`list`:STRING,`isReact`:STRING,`price`:STRING,`name`:STRING,`search_id`:STRING,`brand`:STRING,`site_id`:STRING,`product_id`:STRING,`category`:STRING,`env`:STRING,`Hit_Timestamp`:STRING,`position`:STRING,`rank`:STRING,`inNetwork`:STRING>,`messageId`STRING,`type`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/Product Clicked'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_segment.ssdc_product_clicked`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_segment.ssdc_product_clicked"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}