Schema Info
Schema Name: sfdl_prod_segment.reactfoot_productclicked
- created: 2021-02-11 16:14:36
- disabled: False
- format: raw
- id: 826
- is_partitioned: True
- is_schema_datatyped: False
- name:
{ "database": "sfdl_prod_segment", "table": "reactfoot_productclicked" } - type: segment
Schema Versions: 3
-
Version 1147123
- created: 2025-01-04 01:57:50
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`", "DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_productclicked`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.reactfoot_productclicked`\n(\n`anonymousId`STRING,`messageId`STRING,`properties`struct<`search_id`:STRING,`site_id`:STRING,`variant`:STRING,`brand`:STRING,`list`:STRING,`Hit_Timestamp`:STRING,`category`:STRING,`price`:STRING,`product_id`:STRING,`env`:STRING,`quantity`:STRING,`position`:STRING,`name`:STRING,`isReact`:STRING>,`sentAt`STRING,`context`struct<`timezone`:STRING,`library`:struct<`name`:STRING,`version`:STRING>,`campaign`:struct<`content`:STRING,`id`:STRING,`term`:STRING,`name`:STRING,`source`:STRING,`medium`:STRING>,`amp`:struct<`id`:STRING>,`ip`:STRING,`locale`:STRING,`userAgentData`:struct<`platform`:STRING,`mobile`:STRING,`brands`:array - hive_path: s3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked
- id: 1147123
- processed: 1
- raw_data:
{ "__segment_internal": {}, "_metadata": { "bundled": [ "Google Tag Manager", "Segment.io" ], "bundledIds": [ "59c13c7c1386430001b3c90e" ], "unbundled": [] }, "_origin": "2025-01-04T07:56:57Z|s3://sfdl-segment-reactfoot-prod/segment-logs/a0wkEvFBBK/1735948800000/1735977346686.events-archiver-480-45..80154339-7d08-4356-b536-19d5528ba4fc.gz|analytics-segment-separator-prod:$LATEST", "anonymousId": "bcdcb0bc-4c84-496e-9bf2-2520f720e8c8", "channel": "client", "context": { "campaign": { "content": "Self Storage", "id": "120211029505070476", "medium": "paid", "name": "SF Facebook|General", "source": "facebook", "term": "120211029505180476" }, "ip": "2601:647:ca00:b8c0:d172:f222:f485:f37c", "library": { "name": "analytics.js", "version": "next-1.76.0" }, "locale": "en-US", "page": { "path": "/Santa-Cruz-CA-self-storage.html", "referrer": "", "search": "?location=95060&informedSearch=true&utm_source=facebook&utm_medium=paid&utm_campaign=SF%20Facebook%7CGeneral&utm_term=120211029505180476&utm_content=Self%20Storage&utm_id=120211029505070476", "title": "15 Cheap Self-Storage Units in Santa Cruz, CA (From $19)", "url": "https://www.sparefoot.com/Santa-Cruz-CA-self-storage.html?location=95060&informedSearch=true&utm_source=facebook&utm_medium=paid&utm_campaign=SF%20Facebook%7CGeneral&utm_term=120211029505180476&utm_content=Self%20Storage&utm_id=120211029505070476" }, "timezone": "America/Los_Angeles", "userAgent": "Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Mobile Safari/537.36", "userAgentData": { "brands": [ { "brand": "Not_A Brand", "version": "24" } ], "mobile": true, "platform": "Android" } }, "event": "Product Clicked", "integrations": {}, "messageId": "ajs-next-1735974443765-c48299d8-ae3a-49fa-961a-545b0b6706d4", "originalTimestamp": "2025-01-04T07:07:23.765Z", "projectId": "a0wkEvFBBK", "properties": { "Hit Timestamp": 1735974443765, "brand": "self-storage", "category": "Soquel, CA-cityLandingPage", "env": "production", "isReact": true, "list": "facility list: Santa Cruz, CA", "name": "StorageMart - Soquel Dr - 238134", "position": 6, "price": 54, "product_id": 238134, "quantity": 1, "search_id": "742a6778de0fe59599.65106347", "site_id": -1, "variant": "5' x 10'" }, "receivedAt": "2025-01-04T07:07:24.619Z", "sentAt": "2025-01-04T07:07:23.802Z", "timestamp": "2025-01-04T07:07:24.582Z", "type": "track", "userId": "0ecab8d1bec01573ff195393554c8b78", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.amp.id": "string", "context.campaign.content": "string", "context.campaign.id": "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.brand": "string", "properties.category": "string", "properties.env": "string", "properties.isReact": "string", "properties.list": "string", "properties.name": "string", "properties.position": "string", "properties.price": "string", "properties.product_id": "string", "properties.quantity": "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: 826
- schema_scan_id: 134745750
- updated: 2025-01-04 02:07:04
-
Version 962537
- created: 2024-07-30 16:38:01
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`", "DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_productclicked`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.reactfoot_productclicked`\n(\n`channel`STRING,`_origin`STRING,`type`STRING,`sentAt`STRING,`projectId`STRING,`context`struct<`locale`:STRING,`campaign`:struct<`name`:STRING,`term`:STRING,`medium`:STRING,`source`:STRING,`content`:STRING>,`timezone`:STRING,`library`:struct<`version`:STRING,`name`:STRING>,`userAgent`:STRING,`amp`:struct<`id`:STRING>,`page`:struct<`title`:STRING,`path`:STRING,`search`:STRING,`url`:STRING,`referrer`:STRING>,`ip`:STRING,`userAgentData`:struct<`mobile`:STRING,`brands`:array - hive_path: s3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked
- id: 962537
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "bundledIds": [ "59c55a4597f7a100011813be", "59c13c7c1386430001b3c90e" ], "failedInitializations": [ "Google Tag Manager", "Google Analytics" ], "unbundled": [] }, "_origin": "2024-07-30T21:37:37Z|s3://sfdl-segment-reactfoot-prod/segment-logs/a0wkEvFBBK/1722297600000/1722375449429.events-archiver-480-30..35652808-9461-41e9-a1ff-2a35990f7fa7.gz|analytics-segment-separator-prod:$LATEST", "anonymousId": "7bea60a1-959c-4716-9207-ca5e723d2b02", "channel": "client", "context": { "campaign": { "content": "", "medium": "paidsearch", "name": "pro_national_nogeo_noproduct_dynamic", "source": "bing", "term": "GA-self-storage" }, "ip": "2600:100d:b08b:9c5:0:2b:eacd:9f01", "library": { "name": "analytics.js", "version": "next-1.72.1" }, "locale": "en-US", "page": { "path": "/LaGrange-GA-self-storage/rv-storage.html", "referrer": "https://images.search.yahoo.com/", "search": "?tsid=bing-ppc&cid=pro_national_nogeo_noproduct_dynamic&utm_source=bing&utm_medium=paidsearch&utm_campaign=pro_national_nogeo_noproduct_dynamic&utm_content=&ploc=65791&iloc=&mkwid=z6ikjeDF|pcrid|76759736644203|pkw|GA-self-storage|pmt|bb|pdv|m|pgrid|1228154634946547|ptaid|dat-2328559469250780:loc-190&pgrid=1228154634946547&ptaid=dat-2328559469250780:loc-190&msclkid=92fe675aaa0318ee3f3d01f3fa420ac8&utm_term=GA-self-storage", "title": "10 Cheap RV Storage Facilities Near Lagrange, GA on Sparefoot", "url": "https://www.sparefoot.com/LaGrange-GA-self-storage/rv-storage.html?tsid=bing-ppc&cid=pro_national_nogeo_noproduct_dynamic&utm_source=bing&utm_medium=paidsearch&utm_campaign=pro_national_nogeo_noproduct_dynamic&utm_content=&ploc=65791&iloc=&mkwid=z6ikjeDF|pcrid|76759736644203|pkw|GA-self-storage|pmt|bb|pdv|m|pgrid|1228154634946547|ptaid|dat-2328559469250780:loc-190&pgrid=1228154634946547&ptaid=dat-2328559469250780:loc-190&msclkid=92fe675aaa0318ee3f3d01f3fa420ac8&utm_term=GA-self-storage" }, "timezone": "America/Chicago", "userAgent": "Mozilla/5.0 (Linux; Android 14; SM-A546V Build/UP1A.231005.007; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/127.0.6533.64 Mobile Safari/537.36", "userAgentData": { "brands": [ { "brand": "Chromium", "version": "127" } ], "mobile": true, "platform": "Android" } }, "event": "Product Clicked", "integrations": {}, "messageId": "ajs-next-1722372289179-07b35b77-1a42-457c-b0a8-b928b54b2169", "originalTimestamp": "2024-07-30T20:44:49.179Z", "projectId": "a0wkEvFBBK", "properties": { "Hit Timestamp": 1722372289179, "brand": "self-storage", "category": "LaGrange, GA-vehicleLandingPage", "env": "production", "isReact": true, "list": "facility list: LaGrange, GA", "name": "FreeUp Storage Lagrange - 228176", "position": 1, "price": null, "product_id": 228176, "quantity": 1, "search_id": "74a266a950a1e074d5.62050492", "site_id": -1, "variant": null }, "receivedAt": "2024-07-30T20:44:50.056Z", "sentAt": "2024-07-30T20:44:49.222Z", "timestamp": "2024-07-30T20:44:50.013Z", "type": "track", "userId": "e4ea1330a6d421c43bdf7eff2034f1ca", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.amp.id": "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.brand": "string", "properties.category": "string", "properties.env": "string", "properties.isReact": "string", "properties.list": "string", "properties.name": "string", "properties.position": "string", "properties.price": "string", "properties.product_id": "string", "properties.quantity": "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: 826
- schema_scan_id: 124128073
- updated: 2024-07-30 16:39:11
-
Version 677164
- created: 2023-11-16 17:12:07
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`", "DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_productclicked`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.reactfoot_productclicked`\n(\n`type`STRING,`originalTimestamp`STRING,`receivedAt`STRING,`anonymousId`STRING,`properties`struct<`category`:STRING,`search_id`:STRING,`site_id`:STRING,`Hit_Timestamp`:STRING,`env`:STRING,`variant`:STRING,`name`:STRING,`product_id`:STRING,`isReact`:STRING,`brand`:STRING,`price`:STRING,`quantity`:STRING,`list`:STRING,`position`:STRING>,`event`STRING,`version`STRING,`messageId`STRING,`context`struct<`campaign`:struct<`content`:STRING,`medium`:STRING,`name`:STRING,`source`:STRING>,`page`:struct<`title`:STRING,`path`:STRING,`referrer`:STRING,`url`:STRING,`search`:STRING>,`ip`:STRING,`userAgentData`:struct<`brands`:array - hive_path: s3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked
- id: 677164
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "bundledIds": [ "59c55a4597f7a100011813be", "59c13c7c1386430001b3c90e" ], "unbundled": [] }, "_origin": "2023-11-16T22:59:53Z|s3://sfdl-segment-reactfoot-prod/segment-logs/a0wkEvFBBK/1700092800000/1700175475342.events-archiver-480-5..6517dbf9-760f-4466-add5-9e011ee5c7c3.gz|analytics-segment-separator-prod:$LATEST", "anonymousId": "41e3df79-c412-4a0f-9921-2faff057f390", "channel": "client", "context": { "campaign": {}, "ip": "2607:fb91:3f85:aa98:18fa:322:7a6b:d4ae", "library": { "name": "analytics.js", "version": "next-1.55.0" }, "locale": "en-US", "page": { "path": "/search.html", "referrer": "https://www.google.com/", "search": "?city=Manassas&state=VA&location=Manassas%2C%20VA&searchType=storage&page=1&listingsPerPage=15&twentyFourHourAccess=true&subPageType=cityLandingPage&climateControlled=true", "title": "15 Cheap Storage Units in Manassas, VA (From $19) - SpareFoot", "url": "https://www.sparefoot.com/search.html?city=Manassas&state=VA&location=Manassas%2C%20VA&searchType=storage&page=1&listingsPerPage=15&twentyFourHourAccess=true&subPageType=cityLandingPage&climateControlled=true" }, "timezone": "America/Denver", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36", "userAgentData": { "brands": [ { "brand": "Not?A_Brand", "version": "24" } ], "mobile": false, "platform": "Windows" } }, "event": "Product Clicked", "integrations": {}, "messageId": "ajs-next-30bc7d8a7d81a214c22f407e535fd774", "originalTimestamp": "2023-11-16T22:01:16.145Z", "projectId": "a0wkEvFBBK", "properties": { "Hit Timestamp": 1700172076145, "brand": "self-storage", "category": "Fairfax Station, VA-cityLandingPage", "env": "production", "isReact": true, "list": "facility list: Manassas, VA", "name": "CubeSmart Self Storage - Fairfax Station - 63980", "position": 1, "price": null, "product_id": 63980, "quantity": 1, "search_id": "1a1d6556912937cd29.17108029", "site_id": -1, "variant": null }, "receivedAt": "2023-11-16T22:01:16.468Z", "sentAt": "2023-11-16T22:01:16.163Z", "timestamp": "2023-11-16T22:01:16.450Z", "type": "track", "userId": "7579c0abc1639fa887e952b4044ba44d", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.amp.id": "string", "context.campaign.content": "string", "context.campaign.medium": "string", "context.campaign.name": "string", "context.campaign.source": "string", "context.ip": "string", "context.library.name": "string", "context.library.version": "string", "context.locale": "string", "context.page.path": "string", "context.page.referrer": "string", "context.page.search": "string", "context.page.title": "string", "context.page.url": "string", "context.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.brand": "string", "properties.category": "string", "properties.env": "string", "properties.isReact": "string", "properties.list": "string", "properties.name": "string", "properties.position": "string", "properties.price": "string", "properties.product_id": "string", "properties.quantity": "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: 826
- schema_scan_id: 106050199
- updated: 2023-11-16 17:19:02
Schema Scans: 3
Last at 2025-01-04 01:57:49
-
Scan 134745750
- duration: 0:01:55.208653
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 2659, "partitions_applied": false, "success": true } - id: 134745750
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2025-01-04/", "name": "dt", "type": "string", "value": "2025-01-04" }, "s3": { "bucket": "sfdl-segment-reactfoot-prod", "hive_path": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked", "key": "separated_dt/Product Clicked/dt=2025-01-04/1735977346686.events-archiver-480-45..80154339-7d08-4356-b536-19d5528ba4fc.json.gz" }, "schema": { "name": "sfdl_prod_segment.reactfoot_ProductClicked", "type": "segment" } } - running: False
- schema_name_id: 826
- start_time: 2025-01-04 01:57:49
- success: True
- trace_id: 9670707433293201617
-
Scan 124128073
- duration: 0:00:15.696292
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 0, "partitions_applied": false, "success": true } - id: 124128073
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2024-07-30/", "name": "dt", "type": "string", "value": "2024-07-30" }, "s3": { "bucket": "sfdl-segment-reactfoot-prod", "hive_path": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked", "key": "separated_dt/Product Clicked/dt=2024-07-30/1722375449429.events-archiver-480-30..35652808-9461-41e9-a1ff-2a35990f7fa7.json.gz" }, "schema": { "name": "sfdl_prod_segment.reactfoot_ProductClicked", "type": "segment" } } - running: False
- schema_name_id: 826
- start_time: 2024-07-30 16:37:59
- success: True
- trace_id: 18308480306852094014
-
Scan 106050199
- duration: 0:07:50.662000
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 2244, "partitions_applied": false, "success": true } - id: 106050199
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2023-11-16/", "name": "dt", "type": "string", "value": "2023-11-16" }, "s3": { "bucket": "sfdl-segment-reactfoot-prod", "hive_path": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked", "key": "separated_dt/Product Clicked/dt=2023-11-16/1700175475342.events-archiver-480-5..6517dbf9-760f-4466-add5-9e011ee5c7c3.json.gz" }, "schema": { "name": "sfdl_prod_segment.reactfoot_ProductClicked", "type": "segment" } } - running: False
- schema_name_id: 826
- start_time: 2023-11-16 17:12:05
- success: True
- trace_id: 8904511220021313744
- count: 14
- ddl:
[ "ALTER TABLE\n `sfdl_prod_segment.reactfoot_productclicked`\nADD\n\n\n PARTITION (dt='2025-10-20') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2025-10-20/'\n PARTITION (dt='2025-12-07') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2025-12-07/'\n PARTITION (dt='2025-12-18') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2025-12-18/'\n PARTITION (dt='2025-12-19') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2025-12-19/'\n PARTITION (dt='2025-12-20') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2025-12-20/'\n PARTITION (dt='2025-12-29') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2025-12-29/'\n PARTITION (dt='2026-01-02') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2026-01-02/'\n PARTITION (dt='2026-01-03') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2026-01-03/'\n PARTITION (dt='2026-02-16') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2026-02-16/'\n PARTITION (dt='2026-02-20') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2026-02-20/'\n PARTITION (dt='2026-02-25') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2026-02-25/'\n PARTITION (dt='2026-03-10') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2026-03-10/'\n PARTITION (dt='2026-03-15') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2026-03-15/'\n PARTITION (dt='2026-04-05') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2026-04-05/'\n;" ] - name: dt
- state:
[ { "info": { "id": 1596726, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2025-10-20/", "name": "dt", "value": "2025-10-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-20 04:28:09", "last_data": "2025-10-20 04:28:09" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1611451, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2025-12-07/", "name": "dt", "value": "2025-12-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-07 10:13:51", "last_data": "2025-12-07 10:13:51" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1616765, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2025-12-18/", "name": "dt", "value": "2025-12-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-17 20:55:08", "last_data": "2025-12-17 21:02:23" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1616993, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2025-12-19/", "name": "dt", "value": "2025-12-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-19 01:12:47", "last_data": "2025-12-19 01:12:47" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1617228, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2025-12-20/", "name": "dt", "value": "2025-12-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-20 04:00:46", "last_data": "2025-12-20 17:59:32" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1619200, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2025-12-29/", "name": "dt", "value": "2025-12-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-28 21:54:13", "last_data": "2025-12-28 21:57:20" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1620227, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2026-01-02/", "name": "dt", "value": "2026-01-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-02 12:44:47", "last_data": "2026-01-02 12:48:03" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1620351, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2026-01-03/", "name": "dt", "value": "2026-01-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-03 05:52:49", "last_data": "2026-01-03 05:52:49" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1634967, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2026-02-16/", "name": "dt", "value": "2026-02-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-16 10:34:41", "last_data": "2026-02-16 10:38:18" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1635699, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2026-02-20/", "name": "dt", "value": "2026-02-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-19 19:59:22", "last_data": "2026-02-19 20:03:05" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1637100, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2026-02-25/", "name": "dt", "value": "2026-02-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-25 11:41:34", "last_data": "2026-02-25 11:45:09" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1643935, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2026-03-10/", "name": "dt", "value": "2026-03-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-09 23:55:04", "last_data": "2026-03-09 23:55:04" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1646067, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2026-03-15/", "name": "dt", "value": "2026-03-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-15 15:49:57", "last_data": "2026-03-15 15:49:57" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1656457, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2026-04-05/", "name": "dt", "value": "2026-04-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-05 12:57:34", "last_data": "2026-04-05 12:57:34" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } } ] - type: string
- attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.amp.id": "string", "context.campaign.content": "string", "context.campaign.id": "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.brand": "string", "properties.category": "string", "properties.env": "string", "properties.isReact": "string", "properties.list": "string", "properties.name": "string", "properties.position": "string", "properties.price": "string", "properties.product_id": "string", "properties.quantity": "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: 2025-01-04 01:57:50
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.reactfoot_productclicked`\n(\n`anonymousId`STRING,`messageId`STRING,`properties`struct<`search_id`:STRING,`site_id`:STRING,`variant`:STRING,`brand`:STRING,`list`:STRING,`Hit_Timestamp`:STRING,`category`:STRING,`price`:STRING,`product_id`:STRING,`env`:STRING,`quantity`:STRING,`position`:STRING,`name`:STRING,`isReact`:STRING>,`sentAt`STRING,`context`struct<`timezone`:STRING,`library`:struct<`name`:STRING,`version`:STRING>,`campaign`:struct<`content`:STRING,`id`:STRING,`term`:STRING,`name`:STRING,`source`:STRING,`medium`:STRING>,`amp`:struct<`id`:STRING>,`ip`:STRING,`locale`:STRING,`userAgentData`:struct<`platform`:STRING,`mobile`:STRING,`brands`:array
- hostname: schemamanager-5475496c57-7dpqb
- name: schema_manager
- process_start: 2026-01-09 11:27:47
- sf_env: prod
- version: 2112174301
{
"name": {
"created": "2021-02-11 16:14:36",
"disabled": false,
"format": "raw",
"id": 826,
"is_partitioned": true,
"is_schema_datatyped": false,
"name": {
"database": "sfdl_prod_segment",
"table": "reactfoot_productclicked"
},
"type": "segment"
},
"partition": {
"count": 14,
"ddl": [
"ALTER TABLE\n `sfdl_prod_segment.reactfoot_productclicked`\nADD\n\n\n PARTITION (dt='2025-10-20') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2025-10-20/'\n PARTITION (dt='2025-12-07') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2025-12-07/'\n PARTITION (dt='2025-12-18') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2025-12-18/'\n PARTITION (dt='2025-12-19') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2025-12-19/'\n PARTITION (dt='2025-12-20') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2025-12-20/'\n PARTITION (dt='2025-12-29') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2025-12-29/'\n PARTITION (dt='2026-01-02') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2026-01-02/'\n PARTITION (dt='2026-01-03') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2026-01-03/'\n PARTITION (dt='2026-02-16') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2026-02-16/'\n PARTITION (dt='2026-02-20') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2026-02-20/'\n PARTITION (dt='2026-02-25') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2026-02-25/'\n PARTITION (dt='2026-03-10') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2026-03-10/'\n PARTITION (dt='2026-03-15') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2026-03-15/'\n PARTITION (dt='2026-04-05') location 's3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2026-04-05/'\n;"
],
"name": "dt",
"state": [
{
"info": {
"id": 1596726,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2025-10-20/",
"name": "dt",
"value": "2025-10-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-20 04:28:09",
"last_data": "2025-10-20 04:28:09"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1611451,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2025-12-07/",
"name": "dt",
"value": "2025-12-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-07 10:13:51",
"last_data": "2025-12-07 10:13:51"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1616765,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2025-12-18/",
"name": "dt",
"value": "2025-12-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-17 20:55:08",
"last_data": "2025-12-17 21:02:23"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1616993,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2025-12-19/",
"name": "dt",
"value": "2025-12-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-19 01:12:47",
"last_data": "2025-12-19 01:12:47"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1617228,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2025-12-20/",
"name": "dt",
"value": "2025-12-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-20 04:00:46",
"last_data": "2025-12-20 17:59:32"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1619200,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2025-12-29/",
"name": "dt",
"value": "2025-12-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-28 21:54:13",
"last_data": "2025-12-28 21:57:20"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1620227,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2026-01-02/",
"name": "dt",
"value": "2026-01-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-02 12:44:47",
"last_data": "2026-01-02 12:48:03"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1620351,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2026-01-03/",
"name": "dt",
"value": "2026-01-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-03 05:52:49",
"last_data": "2026-01-03 05:52:49"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1634967,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2026-02-16/",
"name": "dt",
"value": "2026-02-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-16 10:34:41",
"last_data": "2026-02-16 10:38:18"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1635699,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2026-02-20/",
"name": "dt",
"value": "2026-02-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-19 19:59:22",
"last_data": "2026-02-19 20:03:05"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1637100,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2026-02-25/",
"name": "dt",
"value": "2026-02-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-25 11:41:34",
"last_data": "2026-02-25 11:45:09"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1643935,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2026-03-10/",
"name": "dt",
"value": "2026-03-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-09 23:55:04",
"last_data": "2026-03-09 23:55:04"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1646067,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2026-03-15/",
"name": "dt",
"value": "2026-03-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-15 15:49:57",
"last_data": "2026-03-15 15:49:57"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1656457,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/Product Clicked/dt=2026-04-05/",
"name": "dt",
"value": "2026-04-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-05 12:57:34",
"last_data": "2026-04-05 12:57:34"
},
"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.amp.id": "string",
"context.campaign.content": "string",
"context.campaign.id": "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.brand": "string",
"properties.category": "string",
"properties.env": "string",
"properties.isReact": "string",
"properties.list": "string",
"properties.name": "string",
"properties.position": "string",
"properties.price": "string",
"properties.product_id": "string",
"properties.quantity": "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": "2025-01-04 01:57:50",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.reactfoot_productclicked`\n(\n`anonymousId`STRING,`messageId`STRING,`properties`struct<`search_id`:STRING,`site_id`:STRING,`variant`:STRING,`brand`:STRING,`list`:STRING,`Hit_Timestamp`:STRING,`category`:STRING,`price`:STRING,`product_id`:STRING,`env`:STRING,`quantity`:STRING,`position`:STRING,`name`:STRING,`isReact`:STRING>,`sentAt`STRING,`context`struct<`timezone`:STRING,`library`:struct<`name`:STRING,`version`:STRING>,`campaign`:struct<`content`:STRING,`id`:STRING,`term`:STRING,`name`:STRING,`source`:STRING,`medium`:STRING>,`amp`:struct<`id`:STRING>,`ip`:STRING,`locale`:STRING,`userAgentData`:struct<`platform`:STRING,`mobile`:STRING,`brands`:array>>,`page`:struct<`title`:STRING,`search`:STRING,`url`:STRING,`referrer`:STRING,`path`:STRING>,`userAgent`:STRING>,`projectId`STRING,`event`STRING,`_origin`STRING,`channel`STRING,`originalTimestamp`STRING,`userId`STRING,`timestamp`STRING,`type`STRING,`receivedAt`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/Product Clicked'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_productclicked`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_productclicked"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}