Schema Info
Schema Name: sfdl_stage_segment.storagescout_click
- created: 2019-04-01 13:33:42
- disabled: False
- format: raw
- id: 802
- is_partitioned: True
- is_schema_datatyped: False
- name:
{ "database": "sfdl_stage_segment", "table": "storagescout_click" } - type: segment
Schema Versions: 3
-
Version 604478
- created: 2023-10-02 09:29:51
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_segment`", "DROP TABLE IF EXISTS `sfdl_stage_segment.storagescout_click`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_segment.storagescout_click`\n(\n`integrations`struct<`_empty_`:STRING>,`timestamp`STRING,`_origin`STRING,`originalTimestamp`STRING,`event`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array >,`anonymousId`STRING,`type`STRING,`properties`struct<`extra`:struct<`dateSelected`:STRING,`unitId`:STRING,`facilityId`:STRING,`place`:struct<`formatted_address`:STRING,`scope`:STRING,`geometry`:struct<`viewport`:struct<`ka`:struct<`g`:STRING,`h`:STRING>,`pa`:struct<`h`:STRING,`g`:STRING>,`Qa`:struct<`i`:STRING,`j`:STRING>,`Ra`:struct<`g`:STRING,`i`:STRING>,`Va`:struct<`i`:STRING,`j`:STRING>,`La`:struct<`g`:STRING,`i`:STRING>,`ga`:struct<`j`:STRING,`l`:STRING>,`oa`:struct<`h`:STRING,`g`:STRING>,`ja`:struct<`h`:STRING,`g`:STRING>,`Ua`:struct<`g`:STRING,`i`:STRING>,`na`:struct<`l`:STRING,`j`:STRING,`g`:STRING,`h`:STRING>,`ia`:struct<`j`:STRING,`l`:STRING>>>,`vicinity`:STRING,`place_id`:STRING,`types`:array ,`adr_address`:STRING,`utc_offset`:STRING,`website`:STRING,`utc_offset_minutes`:STRING,`icon`:STRING,`name`:STRING,`id`:STRING,`address_components`:array ,`reference`:STRING>>,`13`:STRING,`facilityId`:STRING,`12`:STRING,`2`:STRING,`4`:STRING,`5`:STRING,`isReact`:STRING,`11`:STRING,`16`:STRING,`15`:STRING,`14`:STRING,`7`:STRING,`9`:STRING,`category`:STRING,`site_id`:STRING,`breadcrumb`:STRING,`Hit_Timestamp`:STRING,`3`:STRING,`label`:STRING,`10`:STRING,`0`:STRING,`17`:STRING,`value`:STRING,`8`:STRING,`1`:STRING,`6`:STRING,`env`:STRING>,`userId`STRING,`version`STRING,`context`struct<`library`:struct<`name`:STRING,`version`:STRING>,`locale`:STRING,`userAgent`:STRING,`page`:struct<`path`:STRING,`title`:STRING,`search`:STRING,`url`:STRING,`referrer`:STRING>,`userAgentData`:struct<`brands`:array - hive_path: s3://sfdl-segment-storagescout-stage/separated_dt/click
- id: 604478
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "bundledIds": [ "5cfe783d418588000189e438", "5ce847aa3bcc70000140d5a5" ], "unbundled": [] }, "_origin": "2023-10-02T14:29:39Z|s3://sfdl-segment-storagescout-stage/segment-logs/TYN5JDpyiK/1696204800000/1696256926813.events-archiver-480-10..6cb39304-c3e8-4c9c-aba9-7872381d0a0d.gz|analytics-segment-separator-stage:$LATEST", "anonymousId": "82624da9-e4de-4093-a66e-3745706fb947", "channel": "client", "context": { "ip": "162.238.214.89", "library": { "name": "analytics.js", "version": "next-1.55.0" }, "locale": "en-US", "page": { "path": "/", "referrer": "https://sparefoot.atlassian.net/", "search": "", "title": "SiteLink Demo Facility Storage Units | Perryville, AK | USStorageSearch.com", "url": "https://usstoragesearch.extrameter.com/" }, "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36", "userAgentData": { "brands": [ { "brand": "Google Chrome", "version": "117" }, { "brand": "Not;A=Brand", "version": "8" }, { "brand": "Chromium", "version": "117" } ], "mobile": false, "platform": "Windows" } }, "event": "click", "integrations": {}, "messageId": "ajs-next-093413acb95dfd2bef4626c7500e41c8", "originalTimestamp": "2023-10-02T13:41:27.571Z", "projectId": "TYN5JDpyiK", "properties": { "Hit Timestamp": 1696254087569, "category": "missing category", "env": "stage", "isReact": true, "label": "logo", "site_id": 413 }, "receivedAt": "2023-10-02T13:41:27.722Z", "sentAt": "2023-10-02T13:41:27.602Z", "timestamp": "2023-10-02T13:41:27.691Z", "type": "track", "userId": "d21c440b0b5f4087ec97af00324bba3c", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.ip": "string", "context.library.name": "string", "context.library.version": "string", "context.locale": "string", "context.page.path": "string", "context.page.referrer": "string", "context.page.search": "string", "context.page.title": "string", "context.page.url": "string", "context.userAgent": "string", "context.userAgentData.brands": [ { "brand": "string", "version": "string" } ], "context.userAgentData.mobile": "string", "context.userAgentData.platform": "string", "event": "string", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.0": "string", "properties.1": "string", "properties.10": "string", "properties.11": "string", "properties.12": "string", "properties.13": "string", "properties.14": "string", "properties.15": "string", "properties.16": "string", "properties.17": "string", "properties.2": "string", "properties.3": "string", "properties.4": "string", "properties.5": "string", "properties.6": "string", "properties.7": "string", "properties.8": "string", "properties.9": "string", "properties.Hit_Timestamp": "string", "properties.breadcrumb": "string", "properties.category": "string", "properties.env": "string", "properties.extra.dateSelected": "string", "properties.extra.facilityId": "string", "properties.extra.place.address_components": [ { "long_name": "string", "short_name": "string", "types": [ "string" ] } ], "properties.extra.place.adr_address": "string", "properties.extra.place.formatted_address": "string", "properties.extra.place.geometry.viewport.La.g": "string", "properties.extra.place.geometry.viewport.La.i": "string", "properties.extra.place.geometry.viewport.Qa.i": "string", "properties.extra.place.geometry.viewport.Qa.j": "string", "properties.extra.place.geometry.viewport.Ra.g": "string", "properties.extra.place.geometry.viewport.Ra.i": "string", "properties.extra.place.geometry.viewport.Ua.g": "string", "properties.extra.place.geometry.viewport.Ua.i": "string", "properties.extra.place.geometry.viewport.Va.i": "string", "properties.extra.place.geometry.viewport.Va.j": "string", "properties.extra.place.geometry.viewport.ga.j": "string", "properties.extra.place.geometry.viewport.ga.l": "string", "properties.extra.place.geometry.viewport.ia.j": "string", "properties.extra.place.geometry.viewport.ia.l": "string", "properties.extra.place.geometry.viewport.ja.g": "string", "properties.extra.place.geometry.viewport.ja.h": "string", "properties.extra.place.geometry.viewport.ka.g": "string", "properties.extra.place.geometry.viewport.ka.h": "string", "properties.extra.place.geometry.viewport.na.g": "string", "properties.extra.place.geometry.viewport.na.h": "string", "properties.extra.place.geometry.viewport.na.j": "string", "properties.extra.place.geometry.viewport.na.l": "string", "properties.extra.place.geometry.viewport.oa.g": "string", "properties.extra.place.geometry.viewport.oa.h": "string", "properties.extra.place.geometry.viewport.pa.g": "string", "properties.extra.place.geometry.viewport.pa.h": "string", "properties.extra.place.html_attributions": [ "string" ], "properties.extra.place.icon": "string", "properties.extra.place.id": "string", "properties.extra.place.name": "string", "properties.extra.place.photos": [ { "height": "string", "html_attributions": [ "string" ], "width": "string" } ], "properties.extra.place.place_id": "string", "properties.extra.place.reference": "string", "properties.extra.place.scope": "string", "properties.extra.place.types": [ "string" ], "properties.extra.place.url": "string", "properties.extra.place.utc_offset": "string", "properties.extra.place.utc_offset_minutes": "string", "properties.extra.place.vicinity": "string", "properties.extra.place.website": "string", "properties.extra.unitId": "string", "properties.facilityId": "string", "properties.isReact": "string", "properties.label": "string", "properties.site_id": "string", "properties.value": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 802
- schema_scan_id: 5220550
- updated: 2023-10-02 09:30:08
-
Version 327638
- created: 2021-05-04 16:40:23
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_segment`", "DROP TABLE IF EXISTS `sfdl_stage_segment.storagescout_click`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_segment.storagescout_click`\n(\n`event`STRING,`integrations`struct<`_empty_`:STRING>,`channel`STRING,`properties`struct<`12`:STRING,`6`:STRING,`extra`:struct<`dateSelected`:STRING,`unitId`:STRING,`facilityId`:STRING,`place`:struct<`formatted_address`:STRING,`scope`:STRING,`geometry`:struct<`viewport`:struct<`ka`:struct<`g`:STRING,`h`:STRING>,`pa`:struct<`h`:STRING,`g`:STRING>,`Qa`:struct<`i`:STRING,`j`:STRING>,`Ra`:struct<`g`:STRING,`i`:STRING>,`Va`:struct<`i`:STRING,`j`:STRING>,`La`:struct<`g`:STRING,`i`:STRING>,`ga`:struct<`j`:STRING,`l`:STRING>,`oa`:struct<`h`:STRING,`g`:STRING>,`ja`:struct<`h`:STRING,`g`:STRING>,`Ua`:struct<`g`:STRING,`i`:STRING>,`na`:struct<`l`:STRING,`j`:STRING,`g`:STRING,`h`:STRING>,`ia`:struct<`j`:STRING,`l`:STRING>>>,`vicinity`:STRING,`place_id`:STRING,`types`:array,`adr_address`:STRING,`utc_offset`:STRING,`website`:STRING,`utc_offset_minutes`:STRING,`icon`:STRING,`name`:STRING,`id`:STRING,`address_components`:array ,`reference`:STRING>>,`isReact`:STRING,`1`:STRING,`0`:STRING,`17`:STRING,`11`:STRING,`13`:STRING,`14`:STRING,`16`:STRING,`Hit_Timestamp`:STRING,`9`:STRING,`breadcrumb`:STRING,`site_id`:STRING,`facilityId`:STRING,`3`:STRING,`7`:STRING,`10`:STRING,`label`:STRING,`5`:STRING,`8`:STRING,`15`:STRING,`category`:STRING,`env`:STRING,`4`:STRING,`value`:STRING,`2`:STRING>,`timestamp`STRING,`anonymousId`STRING,`type`STRING,`_origin`STRING,`userId`STRING,`messageId`STRING,`projectId`STRING,`sentAt`STRING,`originalTimestamp`STRING,`receivedAt`STRING,`_metadata`struct<`bundled`:array ,`unbundled`:array >,`version`STRING,`context`struct<`library`:struct<`version`:STRING,`name`:STRING>,`page`:struct<`url`:STRING,`search`:STRING,`path`:STRING,`referrer`:STRING,`title`:STRING>,`userAgent`:STRING,`ip`:STRING,`locale`:STRING>\n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-segment-storagescout-stage/separated_dt/click'\n", "MSCK REPAIR TABLE sfdl_stage_segment.storagescout_click" ] - hive_path: s3://sfdl-segment-storagescout-stage/separated_dt/click
- id: 327638
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "bundledIds": [ "5cfe783d418588000189e438", "5ce847aa3bcc70000140d5a5" ], "unbundled": [] }, "_origin": "2021-05-04T21:39:56Z|s3://sfdl-segment-storagescout-stage/segment-logs/TYN5JDpyiK/1620086400000/1620164208647.9ef039d8c650.d65711d.7f406624-d878-4b97-858d-cf1a83eafaff.gz|analytics-segment-separator-stage:$LATEST", "anonymousId": "b3dd5d40-7c1a-4143-a8fa-36c4019db417", "channel": "client", "context": { "ip": "34.239.223.223", "library": { "name": "analytics.js", "version": "4.0.8" }, "locale": "en-MX", "page": { "path": "/", "referrer": "", "search": "", "title": "Self Storage Deals & Discounts Near Me | USStorageSearch", "url": "http://localhost:9125/" }, "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.93 Safari/537.36" }, "event": "click", "integrations": {}, "messageId": "ajs-70a51e2435ed36b18981fc4a14dff42c", "originalTimestamp": "2021-05-04T21:30:29.350Z", "projectId": "TYN5JDpyiK", "properties": { "Hit Timestamp": 1620163829347, "category": "missing category-index", "env": "development", "extra": { "place": { "address_components": [ { "long_name": "Perryville", "short_name": "Perryville", "types": [ "locality", "political" ] }, { "long_name": "Lake and Peninsula", "short_name": "Lake and Peninsula", "types": [ "administrative_area_level_2", "political" ] }, { "long_name": "Alaska", "short_name": "AK", "types": [ "administrative_area_level_1", "political" ] }, { "long_name": "United States", "short_name": "US", "types": [ "country", "political" ] } ], "adr_address": "Perryville, AK, USA", "formatted_address": "Perryville, AK, USA", "geometry": { "location": {}, "viewport": { "La": { "g": -159.1797199131214, "i": -159.0754940085034 }, "Ua": { "g": 55.88803697059989, "i": 55.97949196068363 } } }, "html_attributions": [], "icon": "https://maps.gstatic.com/mapfiles/place_api/icons/v1/png_71/geocode-71.png", "name": "Perryville", "photos": [ { "height": 2988, "html_attributions": [ "Alec Phillips Jr." ], "width": 5312 } ], "place_id": "ChIJT1YyoXh_8FYRdXvcanMax48", "reference": "ChIJT1YyoXh_8FYRdXvcanMax48", "types": [ "locality", "political" ], "url": "https://maps.google.com/?q=Perryville,+AK,+USA&ftid=0x56f07f78a132564f:0x8fc71a736adc7b75", "utc_offset": -480, "utc_offset_minutes": -480, "vicinity": "Perryville" } }, "isReact": true, "label": "search autocomplete", "site_id": 413 }, "receivedAt": "2021-05-04T21:30:29.766Z", "sentAt": "2021-05-04T21:30:29.353Z", "timestamp": "2021-05-04T21:30:29.763Z", "type": "track", "userId": "7abb706feff0db8b50eaf25e639ae1df", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.ip": "string", "context.library.name": "string", "context.library.version": "string", "context.locale": "string", "context.page.path": "string", "context.page.referrer": "string", "context.page.search": "string", "context.page.title": "string", "context.page.url": "string", "context.userAgent": "string", "event": "string", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.0": "string", "properties.1": "string", "properties.10": "string", "properties.11": "string", "properties.12": "string", "properties.13": "string", "properties.14": "string", "properties.15": "string", "properties.16": "string", "properties.17": "string", "properties.2": "string", "properties.3": "string", "properties.4": "string", "properties.5": "string", "properties.6": "string", "properties.7": "string", "properties.8": "string", "properties.9": "string", "properties.Hit_Timestamp": "string", "properties.breadcrumb": "string", "properties.category": "string", "properties.env": "string", "properties.extra.dateSelected": "string", "properties.extra.facilityId": "string", "properties.extra.place.address_components": [ { "long_name": "string", "short_name": "string", "types": [ "string" ] } ], "properties.extra.place.adr_address": "string", "properties.extra.place.formatted_address": "string", "properties.extra.place.geometry.viewport.La.g": "string", "properties.extra.place.geometry.viewport.La.i": "string", "properties.extra.place.geometry.viewport.Qa.i": "string", "properties.extra.place.geometry.viewport.Qa.j": "string", "properties.extra.place.geometry.viewport.Ra.g": "string", "properties.extra.place.geometry.viewport.Ra.i": "string", "properties.extra.place.geometry.viewport.Ua.g": "string", "properties.extra.place.geometry.viewport.Ua.i": "string", "properties.extra.place.geometry.viewport.Va.i": "string", "properties.extra.place.geometry.viewport.Va.j": "string", "properties.extra.place.geometry.viewport.ga.j": "string", "properties.extra.place.geometry.viewport.ga.l": "string", "properties.extra.place.geometry.viewport.ia.j": "string", "properties.extra.place.geometry.viewport.ia.l": "string", "properties.extra.place.geometry.viewport.ja.g": "string", "properties.extra.place.geometry.viewport.ja.h": "string", "properties.extra.place.geometry.viewport.ka.g": "string", "properties.extra.place.geometry.viewport.ka.h": "string", "properties.extra.place.geometry.viewport.na.g": "string", "properties.extra.place.geometry.viewport.na.h": "string", "properties.extra.place.geometry.viewport.na.j": "string", "properties.extra.place.geometry.viewport.na.l": "string", "properties.extra.place.geometry.viewport.oa.g": "string", "properties.extra.place.geometry.viewport.oa.h": "string", "properties.extra.place.geometry.viewport.pa.g": "string", "properties.extra.place.geometry.viewport.pa.h": "string", "properties.extra.place.html_attributions": [ "string" ], "properties.extra.place.icon": "string", "properties.extra.place.id": "string", "properties.extra.place.name": "string", "properties.extra.place.photos": [ { "height": "string", "html_attributions": [ "string" ], "width": "string" } ], "properties.extra.place.place_id": "string", "properties.extra.place.reference": "string", "properties.extra.place.scope": "string", "properties.extra.place.types": [ "string" ], "properties.extra.place.url": "string", "properties.extra.place.utc_offset": "string", "properties.extra.place.utc_offset_minutes": "string", "properties.extra.place.vicinity": "string", "properties.extra.place.website": "string", "properties.extra.unitId": "string", "properties.facilityId": "string", "properties.isReact": "string", "properties.label": "string", "properties.site_id": "string", "properties.value": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 802
- schema_scan_id: 3271869
- updated: 2021-05-04 16:40:59
-
Version 317300
- created: 2021-03-04 10:18:10
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_segment`", "DROP TABLE IF EXISTS `sfdl_stage_segment.storagescout_click`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_segment.storagescout_click`\n(\n`_metadata`struct<`bundled`:array,`unbundled`:array >,`type`STRING,`anonymousId`STRING,`userId`STRING,`properties`struct<`16`:STRING,`7`:STRING,`9`:STRING,`10`:STRING,`4`:STRING,`Hit_Timestamp`:STRING,`site_id`:STRING,`breadcrumb`:STRING,`11`:STRING,`8`:STRING,`2`:STRING,`category`:STRING,`17`:STRING,`12`:STRING,`6`:STRING,`value`:STRING,`14`:STRING,`env`:STRING,`label`:STRING,`3`:STRING,`extra`:struct<`place`:struct<`html_attributions`:array ,`adr_address`:STRING,`formatted_address`:STRING,`address_components`:array >,`unitId`:STRING,`dateSelected`:STRING,`facilityId`:STRING>,`isReact`:STRING,`13`:STRING,`facilityId`:STRING,`15`:STRING,`5`:STRING,`1`:STRING,`0`:STRING>,`context`struct<`page`:struct<`url`:STRING,`path`:STRING,`referrer`:STRING,`search`:STRING,`title`:STRING>,`userAgent`:STRING,`library`:struct<`name`:STRING,`version`:STRING>,`locale`:STRING,`ip`:STRING>,`receivedAt`STRING,`event`STRING,`messageId`STRING,`timestamp`STRING,`channel`STRING,`originalTimestamp`STRING,`integrations`struct<`_empty_`:STRING>,`projectId`STRING,`sentAt`STRING,`_origin`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-storagescout-stage/separated_dt/click'\n", "MSCK REPAIR TABLE sfdl_stage_segment.storagescout_click" ] - hive_path: s3://sfdl-segment-storagescout-stage/separated_dt/click
- id: 317300
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "bundledIds": [ "5cfe783d418588000189e438", "5ce847aa3bcc70000140d5a5" ], "unbundled": [] }, "_origin": "2021-03-04T16:18:05Z|s3://sfdl-segment-storagescout-stage/segment-logs/TYN5JDpyiK/1614816000000/1614874541004.dd55961e0a84.fde281a.01daa219-f391-43c5-b7e5-2627a0ab00bb.gz|analytics-segment-separator-stage:$LATEST", "anonymousId": "f6de1652-fcc9-43e5-b8fb-4c34ae2cb069", "channel": "client", "context": { "campaign": {}, "ip": "34.239.223.223", "library": { "name": "analytics.js", "version": "4.0.4" }, "locale": "en-US", "page": { "path": "/undefined", "referrer": "https://usstoragesearch.extrameter.com/self-storage/tx/houston-storage-units/public-storage-houston-5200-gulfton-st-213732/reserve/22225822/", "search": "?city=Houston&latitude=29.7604267&location=Houston%2C%20TX%2C%20USA&locationSource=google_autocomplete&longitude=-95.3698028&state=TX", "title": "Self Storage Deals & Discounts Near Me | USStorageSearch", "url": "https://www.usstoragesearch.extrameter.com/undefined?city=Houston&latitude=29.7604267&location=Houston%2C%20TX%2C%20USA&locationSource=google_autocomplete&longitude=-95.3698028&state=TX" }, "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.96 Safari/537.36" }, "event": "click", "integrations": {}, "messageId": "ajs-09d322570b85db14f05e314f281a7e78", "originalTimestamp": "2021-03-04T15:25:06.997Z", "projectId": "TYN5JDpyiK", "properties": { "0": "l", "1": "i", "10": "i", "11": "t", "12": "y", "13": " ", "14": "n", "15": "a", "16": "m", "17": "e", "2": "n", "3": "k", "4": " ", "5": "f", "6": "a", "7": "c", "8": "i", "9": "l", "Hit Timestamp": 1614871506996, "category": "facility interactions-searchPage", "env": "stage", "extra": { "place": { "address_components": [ { "long_name": "Austin", "short_name": "Austin", "types": [ "locality", "political" ] }, { "long_name": "Travis County", "short_name": "Travis County", "types": [ "administrative_area_level_2", "political" ] }, { "long_name": "Texas", "short_name": "TX", "types": [ "administrative_area_level_1", "political" ] }, { "long_name": "United States", "short_name": "US", "types": [ "country", "political" ] } ], "adr_address": "Austin, TX, USA", "formatted_address": "Austin, TX, USA", "geometry": { "location": {}, "viewport": { "La": { "g": -97.93838291739291, "i": -97.56841987285418 }, "Ra": { "g": 30.09865891736228, "i": 30.51686291865151 } } }, "html_attributions": [], "icon": "https://maps.gstatic.com/mapfiles/place_api/icons/v1/png_71/geocode-71.png", "name": "Austin", "photos": [ { "height": 3024, "html_attributions": [ "Genius Zhou" ], "width": 4032 }, { "height": 2592, "html_attributions": [ "John Kelly" ], "width": 4608 }, { "height": 1816, "html_attributions": [ "Gajen Jan" ], "width": 4032 }, { "height": 2540, "html_attributions": [ "Leannette Vasquez" ], "width": 2032 }, { "height": 1816, "html_attributions": [ "Gajen Jan" ], "width": 4032 }, { "height": 2160, "html_attributions": [ "Reinerio Ricardo Fernandez" ], "width": 3840 }, { "height": 4032, "html_attributions": [ "GK Ramstead" ], "width": 3024 }, { "height": 1836, "html_attributions": [ "Hosea Baker" ], "width": 3264 }, { "height": 2160, "html_attributions": [ "Elijah Neeley" ], "width": 3840 }, { "height": 1960, "html_attributions": [ "James Benavides" ], "width": 4032 } ], "place_id": "ChIJLwPMoJm1RIYRetVp1EtGm10", "reference": "ChIJLwPMoJm1RIYRetVp1EtGm10", "types": [ "locality", "political" ], "url": "https://maps.google.com/?q=Austin,+TX,+USA&ftid=0x8644b599a0cc032f:0x5d9b464bd469d57a", "utc_offset": -360, "utc_offset_minutes": -360, "vicinity": "Austin", "website": "http://www.ci.austin.tx.us/" } }, "facilityId": 213732, "isReact": true, "label": "title", "site_id": 413 }, "receivedAt": "2021-03-04T15:25:07.284Z", "sentAt": "2021-03-04T15:25:07.001Z", "timestamp": "2021-03-04T15:25:07.280Z", "type": "track", "userId": "75e709536b7cc2062dd3b2fb468eb515", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.ip": "string", "context.library.name": "string", "context.library.version": "string", "context.locale": "string", "context.page.path": "string", "context.page.referrer": "string", "context.page.search": "string", "context.page.title": "string", "context.page.url": "string", "context.userAgent": "string", "event": "string", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.0": "string", "properties.1": "string", "properties.10": "string", "properties.11": "string", "properties.12": "string", "properties.13": "string", "properties.14": "string", "properties.15": "string", "properties.16": "string", "properties.17": "string", "properties.2": "string", "properties.3": "string", "properties.4": "string", "properties.5": "string", "properties.6": "string", "properties.7": "string", "properties.8": "string", "properties.9": "string", "properties.Hit_Timestamp": "string", "properties.breadcrumb": "string", "properties.category": "string", "properties.env": "string", "properties.extra.dateSelected": "string", "properties.extra.facilityId": "string", "properties.extra.place.address_components": [ { "long_name": "string", "short_name": "string", "types": [ "string" ] } ], "properties.extra.place.adr_address": "string", "properties.extra.place.formatted_address": "string", "properties.extra.place.geometry.viewport.La.g": "string", "properties.extra.place.geometry.viewport.La.i": "string", "properties.extra.place.geometry.viewport.Qa.i": "string", "properties.extra.place.geometry.viewport.Qa.j": "string", "properties.extra.place.geometry.viewport.Ra.g": "string", "properties.extra.place.geometry.viewport.Ra.i": "string", "properties.extra.place.geometry.viewport.Va.i": "string", "properties.extra.place.geometry.viewport.Va.j": "string", "properties.extra.place.geometry.viewport.ga.j": "string", "properties.extra.place.geometry.viewport.ga.l": "string", "properties.extra.place.geometry.viewport.ia.j": "string", "properties.extra.place.geometry.viewport.ia.l": "string", "properties.extra.place.geometry.viewport.ja.g": "string", "properties.extra.place.geometry.viewport.ja.h": "string", "properties.extra.place.geometry.viewport.ka.g": "string", "properties.extra.place.geometry.viewport.ka.h": "string", "properties.extra.place.geometry.viewport.na.g": "string", "properties.extra.place.geometry.viewport.na.h": "string", "properties.extra.place.geometry.viewport.na.j": "string", "properties.extra.place.geometry.viewport.na.l": "string", "properties.extra.place.geometry.viewport.oa.g": "string", "properties.extra.place.geometry.viewport.oa.h": "string", "properties.extra.place.geometry.viewport.pa.g": "string", "properties.extra.place.geometry.viewport.pa.h": "string", "properties.extra.place.html_attributions": [ "string" ], "properties.extra.place.icon": "string", "properties.extra.place.id": "string", "properties.extra.place.name": "string", "properties.extra.place.photos": [ { "height": "string", "html_attributions": [ "string" ], "width": "string" } ], "properties.extra.place.place_id": "string", "properties.extra.place.reference": "string", "properties.extra.place.scope": "string", "properties.extra.place.types": [ "string" ], "properties.extra.place.url": "string", "properties.extra.place.utc_offset": "string", "properties.extra.place.utc_offset_minutes": "string", "properties.extra.place.vicinity": "string", "properties.extra.place.website": "string", "properties.extra.unitId": "string", "properties.facilityId": "string", "properties.isReact": "string", "properties.label": "string", "properties.site_id": "string", "properties.value": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 802
- schema_scan_id: 3173278
- updated: 2021-03-04 10:18:47
Schema Scans: 3
Last at 2023-10-02 09:29:49
-
Scan 5220550
- duration: 0:00:30.406142
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 120, "partitions_applied": false, "success": true } - id: 5220550
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2023-10-02/", "name": "dt", "type": "string", "value": "2023-10-02" }, "s3": { "bucket": "sfdl-segment-storagescout-stage", "hive_path": "s3://sfdl-segment-storagescout-stage/separated_dt/click", "key": "separated_dt/click/dt=2023-10-02/1696256926813.events-archiver-480-10..6cb39304-c3e8-4c9c-aba9-7872381d0a0d.json.gz" }, "schema": { "name": "sfdl_stage_segment.storagescout_click", "type": "segment" } } - running: False
- schema_name_id: 802
- start_time: 2023-10-02 09:29:49
- success: True
- trace_id: 4609514299760007530
-
Scan 3271869
- duration: 0:00:39.880812
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 102, "partitions_applied": false, "success": true } - id: 3271869
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-05-04/", "name": "dt", "type": "string", "value": "2021-05-04" }, "s3": { "bucket": "sfdl-segment-storagescout-stage", "hive_path": "s3://sfdl-segment-storagescout-stage/separated_dt/click", "key": "separated_dt/click/dt=2021-05-04/1620164208647.9ef039d8c650.d65711d.7f406624-d878-4b97-858d-cf1a83eafaff.json.gz" }, "schema": { "name": "sfdl_stage_segment.storagescout_click", "type": "segment" } } - running: False
- schema_name_id: 802
- start_time: 2021-05-04 16:40:22
- success: True
- trace_id: 6781623019787893894
-
Scan 3173278
- duration: 0:00:39.945819
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 99, "partitions_applied": false, "success": true } - id: 3173278
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-03-04/", "name": "dt", "type": "string", "value": "2021-03-04" }, "s3": { "bucket": "sfdl-segment-storagescout-stage", "hive_path": "s3://sfdl-segment-storagescout-stage/separated_dt/click", "key": "separated_dt/click/dt=2021-03-04/1614874541004.dd55961e0a84.fde281a.01daa219-f391-43c5-b7e5-2627a0ab00bb.json.gz" }, "schema": { "name": "sfdl_stage_segment.storagescout_click", "type": "segment" } } - running: False
- schema_name_id: 802
- start_time: 2021-03-04 10:18:10
- success: True
- trace_id: 3023116812184875661
- count: 119
- ddl:
[ "ALTER TABLE\n `sfdl_stage_segment.storagescout_click`\nADD\n\n\n PARTITION (dt='2019-04-01') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-04-01/'\n PARTITION (dt='2019-04-17') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-04-17/'\n PARTITION (dt='2019-04-18') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-04-18/'\n PARTITION (dt='2019-04-19') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-04-19/'\n PARTITION (dt='2019-04-22') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-04-22/'\n PARTITION (dt='2019-04-24') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-04-24/'\n PARTITION (dt='2019-04-25') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-04-25/'\n PARTITION (dt='2019-04-26') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-04-26/'\n PARTITION (dt='2019-04-27') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-04-27/'\n PARTITION (dt='2019-04-29') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-04-29/'\n PARTITION (dt='2019-04-30') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-04-30/'\n PARTITION (dt='2019-05-01') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-01/'\n PARTITION (dt='2019-05-04') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-04/'\n PARTITION (dt='2019-05-06') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-06/'\n PARTITION (dt='2019-05-07') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-07/'\n PARTITION (dt='2019-05-08') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-08/'\n PARTITION (dt='2019-05-09') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-09/'\n PARTITION (dt='2019-05-10') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-10/'\n PARTITION (dt='2019-05-11') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-11/'\n PARTITION (dt='2019-05-13') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-13/'\n PARTITION (dt='2019-05-14') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-14/'\n PARTITION (dt='2019-05-15') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-15/'\n PARTITION (dt='2019-05-16') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-16/'\n PARTITION (dt='2019-05-17') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-17/'\n PARTITION (dt='2019-05-18') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-18/'\n PARTITION (dt='2019-05-20') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-20/'\n PARTITION (dt='2019-05-21') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-21/'\n PARTITION (dt='2019-05-22') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-22/'\n PARTITION (dt='2019-05-23') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-23/'\n PARTITION (dt='2019-05-28') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-28/'\n PARTITION (dt='2019-05-30') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-30/'\n PARTITION (dt='2019-06-02') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-02/'\n PARTITION (dt='2019-06-03') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-03/'\n PARTITION (dt='2019-06-04') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-04/'\n PARTITION (dt='2019-06-05') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-05/'\n PARTITION (dt='2019-06-06') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-06/'\n PARTITION (dt='2019-06-07') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-07/'\n PARTITION (dt='2019-06-10') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-10/'\n PARTITION (dt='2019-06-11') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-11/'\n PARTITION (dt='2019-06-12') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-12/'\n PARTITION (dt='2019-06-13') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-13/'\n PARTITION (dt='2019-06-14') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-14/'\n PARTITION (dt='2019-06-17') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-17/'\n PARTITION (dt='2019-06-18') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-18/'\n PARTITION (dt='2019-06-19') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-19/'\n PARTITION (dt='2019-06-20') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-20/'\n PARTITION (dt='2019-06-21') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-21/'\n PARTITION (dt='2019-06-24') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-24/'\n PARTITION (dt='2019-06-25') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-25/'\n PARTITION (dt='2019-06-26') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-26/'\n PARTITION (dt='2019-06-28') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-28/'\n PARTITION (dt='2019-07-01') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-01/'\n PARTITION (dt='2019-07-02') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-02/'\n PARTITION (dt='2019-07-05') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-05/'\n PARTITION (dt='2019-07-08') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-08/'\n PARTITION (dt='2019-07-09') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-09/'\n PARTITION (dt='2019-07-10') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-10/'\n PARTITION (dt='2019-07-11') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-11/'\n PARTITION (dt='2019-07-12') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-12/'\n PARTITION (dt='2019-07-15') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-15/'\n PARTITION (dt='2019-07-16') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-16/'\n PARTITION (dt='2019-07-17') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-17/'\n PARTITION (dt='2019-07-18') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-18/'\n PARTITION (dt='2019-07-19') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-19/'\n PARTITION (dt='2019-07-23') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-23/'\n PARTITION (dt='2019-07-25') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-25/'\n PARTITION (dt='2019-08-09') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-08-09/'\n PARTITION (dt='2019-08-12') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-08-12/'\n PARTITION (dt='2019-08-13') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-08-13/'\n PARTITION (dt='2019-08-14') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-08-14/'\n PARTITION (dt='2019-08-20') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-08-20/'\n PARTITION (dt='2019-08-29') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-08-29/'\n PARTITION (dt='2019-09-04') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-09-04/'\n PARTITION (dt='2019-09-18') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-09-18/'\n PARTITION (dt='2019-10-04') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-10-04/'\n PARTITION (dt='2019-10-15') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-10-15/'\n PARTITION (dt='2019-10-21') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-10-21/'\n PARTITION (dt='2019-10-22') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-10-22/'\n PARTITION (dt='2019-10-23') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-10-23/'\n PARTITION (dt='2019-10-24') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-10-24/'\n PARTITION (dt='2019-11-06') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-11-06/'\n PARTITION (dt='2019-11-13') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-11-13/'\n PARTITION (dt='2019-11-15') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-11-15/'\n PARTITION (dt='2019-11-19') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-11-19/'\n PARTITION (dt='2019-11-21') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-11-21/'\n PARTITION (dt='2019-12-03') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-12-03/'\n PARTITION (dt='2020-01-06') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2020-01-06/'\n PARTITION (dt='2020-01-07') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2020-01-07/'\n PARTITION (dt='2020-01-25') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2020-01-25/'\n PARTITION (dt='2020-02-17') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2020-02-17/'\n PARTITION (dt='2020-05-18') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2020-05-18/'\n PARTITION (dt='2020-05-27') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2020-05-27/'\n PARTITION (dt='2020-05-28') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2020-05-28/'\n PARTITION (dt='2021-02-02') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-02-02/'\n PARTITION (dt='2021-02-08') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-02-08/'\n PARTITION (dt='2021-02-09') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-02-09/'\n PARTITION (dt='2021-02-10') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-02-10/'\n PARTITION (dt='2021-02-11') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-02-11/'\n PARTITION (dt='2021-03-04') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-03-04/'\n PARTITION (dt='2021-03-05') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-03-05/'\n PARTITION (dt='2021-03-08') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-03-08/'\n PARTITION (dt='2021-05-04') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-05-04/'\n PARTITION (dt='2021-05-05') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-05-05/'\n PARTITION (dt='2021-05-06') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-05-06/'\n PARTITION (dt='2021-05-13') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-05-13/'\n PARTITION (dt='2021-06-22') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-06-22/'\n PARTITION (dt='2021-06-23') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-06-23/'\n PARTITION (dt='2021-06-24') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-06-24/'\n PARTITION (dt='2021-06-25') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-06-25/'\n PARTITION (dt='2021-07-12') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-07-12/'\n PARTITION (dt='2021-07-20') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-07-20/'\n PARTITION (dt='2021-08-20') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-08-20/'\n PARTITION (dt='2021-09-23') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-09-23/'\n PARTITION (dt='2021-09-30') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-09-30/'\n PARTITION (dt='2022-01-24') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2022-01-24/'\n PARTITION (dt='2022-02-28') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2022-02-28/'\n PARTITION (dt='2022-06-06') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2022-06-06/'\n PARTITION (dt='2023-02-09') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2023-02-09/'\n PARTITION (dt='2023-10-02') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2023-10-02/'\n;" ] - name: dt
- state:
[ { "info": { "id": 467065, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-04-01/", "name": "dt", "value": "2019-04-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:16", "last_data": "2023-10-02 09:30:16" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467000, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-04-17/", "name": "dt", "value": "2019-04-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:11", "last_data": "2023-10-02 09:30:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467010, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-04-18/", "name": "dt", "value": "2019-04-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:12", "last_data": "2023-10-02 09:30:12" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467094, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-04-19/", "name": "dt", "value": "2019-04-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:18", "last_data": "2023-10-02 09:30:18" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467095, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-04-22/", "name": "dt", "value": "2019-04-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:18", "last_data": "2023-10-02 09:30:18" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467091, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-04-24/", "name": "dt", "value": "2019-04-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:18", "last_data": "2023-10-02 09:30:18" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467080, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-04-25/", "name": "dt", "value": "2019-04-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:17", "last_data": "2023-10-02 09:30:17" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467038, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-04-26/", "name": "dt", "value": "2019-04-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:14", "last_data": "2023-10-02 09:30:14" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467007, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-04-27/", "name": "dt", "value": "2019-04-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:11", "last_data": "2023-10-02 09:30:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467017, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-04-29/", "name": "dt", "value": "2019-04-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:12", "last_data": "2023-10-02 09:30:12" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467005, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-04-30/", "name": "dt", "value": "2019-04-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:11", "last_data": "2023-10-02 09:30:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467111, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-01/", "name": "dt", "value": "2019-05-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:19", "last_data": "2023-10-02 09:30:19" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467060, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-04/", "name": "dt", "value": "2019-05-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:15", "last_data": "2023-10-02 09:30:15" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467050, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-06/", "name": "dt", "value": "2019-05-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:15", "last_data": "2023-10-02 09:30:15" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467061, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-07/", "name": "dt", "value": "2019-05-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:16", "last_data": "2023-10-02 09:30:16" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467036, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-08/", "name": "dt", "value": "2019-05-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:14", "last_data": "2023-10-02 09:30:14" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467029, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-09/", "name": "dt", "value": "2019-05-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:13", "last_data": "2023-10-02 09:30:13" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467092, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-10/", "name": "dt", "value": "2019-05-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:18", "last_data": "2023-10-02 09:30:18" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467100, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-11/", "name": "dt", "value": "2019-05-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:19", "last_data": "2023-10-02 09:30:19" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467089, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-13/", "name": "dt", "value": "2019-05-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:18", "last_data": "2023-10-02 09:30:18" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467043, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-14/", "name": "dt", "value": "2019-05-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:14", "last_data": "2023-10-02 09:30:14" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467086, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-15/", "name": "dt", "value": "2019-05-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:18", "last_data": "2023-10-02 09:30:18" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467004, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-16/", "name": "dt", "value": "2019-05-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:11", "last_data": "2023-10-02 09:30:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467113, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-17/", "name": "dt", "value": "2019-05-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:20", "last_data": "2023-10-02 09:30:20" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467021, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-18/", "name": "dt", "value": "2019-05-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:12", "last_data": "2023-10-02 09:30:12" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467108, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-20/", "name": "dt", "value": "2019-05-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:19", "last_data": "2023-10-02 09:30:19" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467074, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-21/", "name": "dt", "value": "2019-05-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:17", "last_data": "2023-10-02 09:30:17" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467055, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-22/", "name": "dt", "value": "2019-05-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:15", "last_data": "2023-10-02 09:30:15" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467097, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-23/", "name": "dt", "value": "2019-05-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:18", "last_data": "2023-10-02 09:30:18" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467022, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-28/", "name": "dt", "value": "2019-05-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:12", "last_data": "2023-10-02 09:30:12" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467030, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-30/", "name": "dt", "value": "2019-05-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:13", "last_data": "2023-10-02 09:30:13" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467070, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-02/", "name": "dt", "value": "2019-06-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:16", "last_data": "2023-10-02 09:30:16" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467026, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-03/", "name": "dt", "value": "2019-06-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:13", "last_data": "2023-10-02 09:30:13" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467103, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-04/", "name": "dt", "value": "2019-06-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:19", "last_data": "2023-10-02 09:30:19" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467044, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-05/", "name": "dt", "value": "2019-06-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:14", "last_data": "2023-10-02 09:30:14" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467025, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-06/", "name": "dt", "value": "2019-06-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:13", "last_data": "2023-10-02 09:30:13" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467112, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-07/", "name": "dt", "value": "2019-06-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:20", "last_data": "2023-10-02 09:30:20" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467114, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-10/", "name": "dt", "value": "2019-06-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:20", "last_data": "2023-10-02 09:30:20" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467003, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-11/", "name": "dt", "value": "2019-06-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:11", "last_data": "2023-10-02 09:30:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467032, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-12/", "name": "dt", "value": "2019-06-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:13", "last_data": "2023-10-02 09:30:13" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467052, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-13/", "name": "dt", "value": "2019-06-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:15", "last_data": "2023-10-02 09:30:15" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467099, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-14/", "name": "dt", "value": "2019-06-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:19", "last_data": "2023-10-02 09:30:19" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467063, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-17/", "name": "dt", "value": "2019-06-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:16", "last_data": "2023-10-02 09:30:16" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467023, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-18/", "name": "dt", "value": "2019-06-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:13", "last_data": "2023-10-02 09:30:13" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467081, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-19/", "name": "dt", "value": "2019-06-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:17", "last_data": "2023-10-02 09:30:17" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467042, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-20/", "name": "dt", "value": "2019-06-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:14", "last_data": "2023-10-02 09:30:14" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467037, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-21/", "name": "dt", "value": "2019-06-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:14", "last_data": "2023-10-02 09:30:14" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467034, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-24/", "name": "dt", "value": "2019-06-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:13", "last_data": "2023-10-02 09:30:13" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467048, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-25/", "name": "dt", "value": "2019-06-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:14", "last_data": "2023-10-02 09:30:14" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467107, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-26/", "name": "dt", "value": "2019-06-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:19", "last_data": "2023-10-02 09:30:19" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467087, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-28/", "name": "dt", "value": "2019-06-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:18", "last_data": "2023-10-02 09:30:18" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467039, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-01/", "name": "dt", "value": "2019-07-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:14", "last_data": "2023-10-02 09:30:14" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467056, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-02/", "name": "dt", "value": "2019-07-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:15", "last_data": "2023-10-02 09:30:15" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467083, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-05/", "name": "dt", "value": "2019-07-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:17", "last_data": "2023-10-02 09:30:17" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467054, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-08/", "name": "dt", "value": "2019-07-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:15", "last_data": "2023-10-02 09:30:15" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467115, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-09/", "name": "dt", "value": "2019-07-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:20", "last_data": "2023-10-02 09:30:20" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467053, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-10/", "name": "dt", "value": "2019-07-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:15", "last_data": "2023-10-02 09:30:15" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467024, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-11/", "name": "dt", "value": "2019-07-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:13", "last_data": "2023-10-02 09:30:13" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467031, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-12/", "name": "dt", "value": "2019-07-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:13", "last_data": "2023-10-02 09:30:13" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467058, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-15/", "name": "dt", "value": "2019-07-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:15", "last_data": "2023-10-02 09:30:15" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467016, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-16/", "name": "dt", "value": "2019-07-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:12", "last_data": "2023-10-02 09:30:12" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467072, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-17/", "name": "dt", "value": "2019-07-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:16", "last_data": "2023-10-02 09:30:16" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467101, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-18/", "name": "dt", "value": "2019-07-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:19", "last_data": "2023-10-02 09:30:19" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467104, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-19/", "name": "dt", "value": "2019-07-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:19", "last_data": "2023-10-02 09:30:19" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467075, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-23/", "name": "dt", "value": "2019-07-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:17", "last_data": "2023-10-02 09:30:17" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467047, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-25/", "name": "dt", "value": "2019-07-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:14", "last_data": "2023-10-02 09:30:14" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467068, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-08-09/", "name": "dt", "value": "2019-08-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:16", "last_data": "2023-10-02 09:30:16" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467079, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-08-12/", "name": "dt", "value": "2019-08-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:17", "last_data": "2023-10-02 09:30:17" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467098, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-08-13/", "name": "dt", "value": "2019-08-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:18", "last_data": "2023-10-02 09:30:18" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467027, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-08-14/", "name": "dt", "value": "2019-08-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:13", "last_data": "2023-10-02 09:30:13" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467040, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-08-20/", "name": "dt", "value": "2019-08-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:14", "last_data": "2023-10-02 09:30:14" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467006, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-08-29/", "name": "dt", "value": "2019-08-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:11", "last_data": "2023-10-02 09:30:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467076, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-09-04/", "name": "dt", "value": "2019-09-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:17", "last_data": "2023-10-02 09:30:17" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467082, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-09-18/", "name": "dt", "value": "2019-09-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:17", "last_data": "2023-10-02 09:30:17" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467057, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-10-04/", "name": "dt", "value": "2019-10-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:15", "last_data": "2023-10-02 09:30:15" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467033, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-10-15/", "name": "dt", "value": "2019-10-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:13", "last_data": "2023-10-02 09:30:13" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467062, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-10-21/", "name": "dt", "value": "2019-10-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:16", "last_data": "2023-10-02 09:30:16" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467028, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-10-22/", "name": "dt", "value": "2019-10-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:13", "last_data": "2023-10-02 09:30:13" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467051, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-10-23/", "name": "dt", "value": "2019-10-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:15", "last_data": "2023-10-02 09:30:15" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467073, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-10-24/", "name": "dt", "value": "2019-10-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:17", "last_data": "2023-10-02 09:30:17" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467018, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-11-06/", "name": "dt", "value": "2019-11-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:12", "last_data": "2023-10-02 09:30:12" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467019, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-11-13/", "name": "dt", "value": "2019-11-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:12", "last_data": "2023-10-02 09:30:12" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467035, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-11-15/", "name": "dt", "value": "2019-11-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:13", "last_data": "2023-10-02 09:30:13" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467085, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-11-19/", "name": "dt", "value": "2019-11-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:17", "last_data": "2023-10-02 09:30:17" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467071, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-11-21/", "name": "dt", "value": "2019-11-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:16", "last_data": "2023-10-02 09:30:16" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467084, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-12-03/", "name": "dt", "value": "2019-12-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:17", "last_data": "2023-10-02 09:30:17" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467088, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2020-01-06/", "name": "dt", "value": "2020-01-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:18", "last_data": "2023-10-02 09:30:18" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467009, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2020-01-07/", "name": "dt", "value": "2020-01-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:11", "last_data": "2023-10-02 09:30:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467020, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2020-01-25/", "name": "dt", "value": "2020-01-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:12", "last_data": "2023-10-02 09:30:12" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467011, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2020-02-17/", "name": "dt", "value": "2020-02-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:12", "last_data": "2023-10-02 09:30:12" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467093, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2020-05-18/", "name": "dt", "value": "2020-05-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:18", "last_data": "2023-10-02 09:30:18" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467064, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2020-05-27/", "name": "dt", "value": "2020-05-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:16", "last_data": "2023-10-02 09:30:16" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467105, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2020-05-28/", "name": "dt", "value": "2020-05-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:19", "last_data": "2023-10-02 09:30:19" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467067, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-02-02/", "name": "dt", "value": "2021-02-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:16", "last_data": "2023-10-02 09:30:16" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467069, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-02-08/", "name": "dt", "value": "2021-02-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:16", "last_data": "2023-10-02 09:30:16" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467059, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-02-09/", "name": "dt", "value": "2021-02-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:15", "last_data": "2023-10-02 09:30:15" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467096, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-02-10/", "name": "dt", "value": "2021-02-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:18", "last_data": "2023-10-02 09:30:18" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467013, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-02-11/", "name": "dt", "value": "2021-02-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:12", "last_data": "2023-10-02 09:30:12" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467077, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-03-04/", "name": "dt", "value": "2021-03-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:17", "last_data": "2023-10-02 09:30:17" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467002, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-03-05/", "name": "dt", "value": "2021-03-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:11", "last_data": "2023-10-02 09:30:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467014, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-03-08/", "name": "dt", "value": "2021-03-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:12", "last_data": "2023-10-02 09:30:12" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467049, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-05-04/", "name": "dt", "value": "2021-05-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:15", "last_data": "2023-10-02 09:30:15" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467102, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-05-05/", "name": "dt", "value": "2021-05-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:19", "last_data": "2023-10-02 09:30:19" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467045, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-05-06/", "name": "dt", "value": "2021-05-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:14", "last_data": "2023-10-02 09:30:14" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467066, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-05-13/", "name": "dt", "value": "2021-05-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:16", "last_data": "2023-10-02 09:30:16" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467041, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-06-22/", "name": "dt", "value": "2021-06-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:14", "last_data": "2023-10-02 09:30:14" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467046, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-06-23/", "name": "dt", "value": "2021-06-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:14", "last_data": "2023-10-02 09:30:14" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467078, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-06-24/", "name": "dt", "value": "2021-06-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:17", "last_data": "2023-10-02 09:30:17" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467001, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-06-25/", "name": "dt", "value": "2021-06-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:11", "last_data": "2023-10-02 09:30:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467106, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-07-12/", "name": "dt", "value": "2021-07-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:19", "last_data": "2023-10-02 09:30:19" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467008, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-07-20/", "name": "dt", "value": "2021-07-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:11", "last_data": "2023-10-02 09:30:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467090, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-08-20/", "name": "dt", "value": "2021-08-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:18", "last_data": "2023-10-02 09:30:18" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467109, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-09-23/", "name": "dt", "value": "2021-09-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:19", "last_data": "2023-10-02 09:30:19" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467012, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-09-30/", "name": "dt", "value": "2021-09-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:12", "last_data": "2023-10-02 09:30:12" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467110, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2022-01-24/", "name": "dt", "value": "2022-01-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:19", "last_data": "2023-10-02 09:30:19" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 467015, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2022-02-28/", "name": "dt", "value": "2022-02-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:30:12", "last_data": "2023-10-02 09:30:12" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 289019, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2022-06-06/", "name": "dt", "value": "2022-06-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2022-06-06 13:46:29", "last_data": "2022-06-06 13:54:06" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 395308, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2023-02-09/", "name": "dt", "value": "2023-02-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-02-08 23:38:16", "last_data": "2023-02-09 00:15:09" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 466999, "location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2023-10-02/", "name": "dt", "value": "2023-10-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2023-10-02 09:29:52", "last_data": "2023-10-02 09:29:52" }, "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.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", "context.userAgentData.brands": [ { "brand": "string", "version": "string" } ], "context.userAgentData.mobile": "string", "context.userAgentData.platform": "string", "event": "string", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.0": "string", "properties.1": "string", "properties.10": "string", "properties.11": "string", "properties.12": "string", "properties.13": "string", "properties.14": "string", "properties.15": "string", "properties.16": "string", "properties.17": "string", "properties.2": "string", "properties.3": "string", "properties.4": "string", "properties.5": "string", "properties.6": "string", "properties.7": "string", "properties.8": "string", "properties.9": "string", "properties.Hit_Timestamp": "string", "properties.breadcrumb": "string", "properties.category": "string", "properties.env": "string", "properties.extra.dateSelected": "string", "properties.extra.facilityId": "string", "properties.extra.place.address_components": [ { "long_name": "string", "short_name": "string", "types": [ "string" ] } ], "properties.extra.place.adr_address": "string", "properties.extra.place.formatted_address": "string", "properties.extra.place.geometry.viewport.La.g": "string", "properties.extra.place.geometry.viewport.La.i": "string", "properties.extra.place.geometry.viewport.Qa.i": "string", "properties.extra.place.geometry.viewport.Qa.j": "string", "properties.extra.place.geometry.viewport.Ra.g": "string", "properties.extra.place.geometry.viewport.Ra.i": "string", "properties.extra.place.geometry.viewport.Ua.g": "string", "properties.extra.place.geometry.viewport.Ua.i": "string", "properties.extra.place.geometry.viewport.Va.i": "string", "properties.extra.place.geometry.viewport.Va.j": "string", "properties.extra.place.geometry.viewport.ga.j": "string", "properties.extra.place.geometry.viewport.ga.l": "string", "properties.extra.place.geometry.viewport.ia.j": "string", "properties.extra.place.geometry.viewport.ia.l": "string", "properties.extra.place.geometry.viewport.ja.g": "string", "properties.extra.place.geometry.viewport.ja.h": "string", "properties.extra.place.geometry.viewport.ka.g": "string", "properties.extra.place.geometry.viewport.ka.h": "string", "properties.extra.place.geometry.viewport.na.g": "string", "properties.extra.place.geometry.viewport.na.h": "string", "properties.extra.place.geometry.viewport.na.j": "string", "properties.extra.place.geometry.viewport.na.l": "string", "properties.extra.place.geometry.viewport.oa.g": "string", "properties.extra.place.geometry.viewport.oa.h": "string", "properties.extra.place.geometry.viewport.pa.g": "string", "properties.extra.place.geometry.viewport.pa.h": "string", "properties.extra.place.html_attributions": [ "string" ], "properties.extra.place.icon": "string", "properties.extra.place.id": "string", "properties.extra.place.name": "string", "properties.extra.place.photos": [ { "height": "string", "html_attributions": [ "string" ], "width": "string" } ], "properties.extra.place.place_id": "string", "properties.extra.place.reference": "string", "properties.extra.place.scope": "string", "properties.extra.place.types": [ "string" ], "properties.extra.place.url": "string", "properties.extra.place.utc_offset": "string", "properties.extra.place.utc_offset_minutes": "string", "properties.extra.place.vicinity": "string", "properties.extra.place.website": "string", "properties.extra.unitId": "string", "properties.facilityId": "string", "properties.isReact": "string", "properties.label": "string", "properties.site_id": "string", "properties.value": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - created: 2023-10-02 09:29:51
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_segment`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_segment.storagescout_click`\n(\n`integrations`struct<`_empty_`:STRING>,`timestamp`STRING,`_origin`STRING,`originalTimestamp`STRING,`event`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array >,`anonymousId`STRING,`type`STRING,`properties`struct<`extra`:struct<`dateSelected`:STRING,`unitId`:STRING,`facilityId`:STRING,`place`:struct<`formatted_address`:STRING,`scope`:STRING,`geometry`:struct<`viewport`:struct<`ka`:struct<`g`:STRING,`h`:STRING>,`pa`:struct<`h`:STRING,`g`:STRING>,`Qa`:struct<`i`:STRING,`j`:STRING>,`Ra`:struct<`g`:STRING,`i`:STRING>,`Va`:struct<`i`:STRING,`j`:STRING>,`La`:struct<`g`:STRING,`i`:STRING>,`ga`:struct<`j`:STRING,`l`:STRING>,`oa`:struct<`h`:STRING,`g`:STRING>,`ja`:struct<`h`:STRING,`g`:STRING>,`Ua`:struct<`g`:STRING,`i`:STRING>,`na`:struct<`l`:STRING,`j`:STRING,`g`:STRING,`h`:STRING>,`ia`:struct<`j`:STRING,`l`:STRING>>>,`vicinity`:STRING,`place_id`:STRING,`types`:array ,`adr_address`:STRING,`utc_offset`:STRING,`website`:STRING,`utc_offset_minutes`:STRING,`icon`:STRING,`name`:STRING,`id`:STRING,`address_components`:array ,`reference`:STRING>>,`13`:STRING,`facilityId`:STRING,`12`:STRING,`2`:STRING,`4`:STRING,`5`:STRING,`isReact`:STRING,`11`:STRING,`16`:STRING,`15`:STRING,`14`:STRING,`7`:STRING,`9`:STRING,`category`:STRING,`site_id`:STRING,`breadcrumb`:STRING,`Hit_Timestamp`:STRING,`3`:STRING,`label`:STRING,`10`:STRING,`0`:STRING,`17`:STRING,`value`:STRING,`8`:STRING,`1`:STRING,`6`:STRING,`env`:STRING>,`userId`STRING,`version`STRING,`context`struct<`library`:struct<`name`:STRING,`version`:STRING>,`locale`:STRING,`userAgent`:STRING,`page`:struct<`path`:STRING,`title`:STRING,`search`:STRING,`url`:STRING,`referrer`:STRING>,`userAgentData`:struct<`brands`:array
- hostname: schemamanager-5c55c886bf-h2ts4
- name: schema_manager
- process_start: 2025-10-21 13:03:27
- sf_env: stage
- version: 2112174301
{
"name": {
"created": "2019-04-01 13:33:42",
"disabled": false,
"format": "raw",
"id": 802,
"is_partitioned": true,
"is_schema_datatyped": false,
"name": {
"database": "sfdl_stage_segment",
"table": "storagescout_click"
},
"type": "segment"
},
"partition": {
"count": 119,
"ddl": [
"ALTER TABLE\n `sfdl_stage_segment.storagescout_click`\nADD\n\n\n PARTITION (dt='2019-04-01') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-04-01/'\n PARTITION (dt='2019-04-17') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-04-17/'\n PARTITION (dt='2019-04-18') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-04-18/'\n PARTITION (dt='2019-04-19') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-04-19/'\n PARTITION (dt='2019-04-22') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-04-22/'\n PARTITION (dt='2019-04-24') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-04-24/'\n PARTITION (dt='2019-04-25') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-04-25/'\n PARTITION (dt='2019-04-26') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-04-26/'\n PARTITION (dt='2019-04-27') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-04-27/'\n PARTITION (dt='2019-04-29') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-04-29/'\n PARTITION (dt='2019-04-30') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-04-30/'\n PARTITION (dt='2019-05-01') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-01/'\n PARTITION (dt='2019-05-04') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-04/'\n PARTITION (dt='2019-05-06') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-06/'\n PARTITION (dt='2019-05-07') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-07/'\n PARTITION (dt='2019-05-08') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-08/'\n PARTITION (dt='2019-05-09') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-09/'\n PARTITION (dt='2019-05-10') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-10/'\n PARTITION (dt='2019-05-11') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-11/'\n PARTITION (dt='2019-05-13') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-13/'\n PARTITION (dt='2019-05-14') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-14/'\n PARTITION (dt='2019-05-15') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-15/'\n PARTITION (dt='2019-05-16') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-16/'\n PARTITION (dt='2019-05-17') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-17/'\n PARTITION (dt='2019-05-18') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-18/'\n PARTITION (dt='2019-05-20') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-20/'\n PARTITION (dt='2019-05-21') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-21/'\n PARTITION (dt='2019-05-22') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-22/'\n PARTITION (dt='2019-05-23') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-23/'\n PARTITION (dt='2019-05-28') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-28/'\n PARTITION (dt='2019-05-30') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-30/'\n PARTITION (dt='2019-06-02') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-02/'\n PARTITION (dt='2019-06-03') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-03/'\n PARTITION (dt='2019-06-04') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-04/'\n PARTITION (dt='2019-06-05') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-05/'\n PARTITION (dt='2019-06-06') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-06/'\n PARTITION (dt='2019-06-07') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-07/'\n PARTITION (dt='2019-06-10') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-10/'\n PARTITION (dt='2019-06-11') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-11/'\n PARTITION (dt='2019-06-12') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-12/'\n PARTITION (dt='2019-06-13') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-13/'\n PARTITION (dt='2019-06-14') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-14/'\n PARTITION (dt='2019-06-17') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-17/'\n PARTITION (dt='2019-06-18') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-18/'\n PARTITION (dt='2019-06-19') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-19/'\n PARTITION (dt='2019-06-20') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-20/'\n PARTITION (dt='2019-06-21') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-21/'\n PARTITION (dt='2019-06-24') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-24/'\n PARTITION (dt='2019-06-25') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-25/'\n PARTITION (dt='2019-06-26') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-26/'\n PARTITION (dt='2019-06-28') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-28/'\n PARTITION (dt='2019-07-01') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-01/'\n PARTITION (dt='2019-07-02') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-02/'\n PARTITION (dt='2019-07-05') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-05/'\n PARTITION (dt='2019-07-08') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-08/'\n PARTITION (dt='2019-07-09') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-09/'\n PARTITION (dt='2019-07-10') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-10/'\n PARTITION (dt='2019-07-11') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-11/'\n PARTITION (dt='2019-07-12') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-12/'\n PARTITION (dt='2019-07-15') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-15/'\n PARTITION (dt='2019-07-16') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-16/'\n PARTITION (dt='2019-07-17') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-17/'\n PARTITION (dt='2019-07-18') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-18/'\n PARTITION (dt='2019-07-19') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-19/'\n PARTITION (dt='2019-07-23') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-23/'\n PARTITION (dt='2019-07-25') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-25/'\n PARTITION (dt='2019-08-09') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-08-09/'\n PARTITION (dt='2019-08-12') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-08-12/'\n PARTITION (dt='2019-08-13') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-08-13/'\n PARTITION (dt='2019-08-14') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-08-14/'\n PARTITION (dt='2019-08-20') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-08-20/'\n PARTITION (dt='2019-08-29') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-08-29/'\n PARTITION (dt='2019-09-04') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-09-04/'\n PARTITION (dt='2019-09-18') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-09-18/'\n PARTITION (dt='2019-10-04') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-10-04/'\n PARTITION (dt='2019-10-15') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-10-15/'\n PARTITION (dt='2019-10-21') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-10-21/'\n PARTITION (dt='2019-10-22') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-10-22/'\n PARTITION (dt='2019-10-23') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-10-23/'\n PARTITION (dt='2019-10-24') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-10-24/'\n PARTITION (dt='2019-11-06') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-11-06/'\n PARTITION (dt='2019-11-13') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-11-13/'\n PARTITION (dt='2019-11-15') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-11-15/'\n PARTITION (dt='2019-11-19') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-11-19/'\n PARTITION (dt='2019-11-21') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-11-21/'\n PARTITION (dt='2019-12-03') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-12-03/'\n PARTITION (dt='2020-01-06') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2020-01-06/'\n PARTITION (dt='2020-01-07') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2020-01-07/'\n PARTITION (dt='2020-01-25') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2020-01-25/'\n PARTITION (dt='2020-02-17') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2020-02-17/'\n PARTITION (dt='2020-05-18') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2020-05-18/'\n PARTITION (dt='2020-05-27') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2020-05-27/'\n PARTITION (dt='2020-05-28') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2020-05-28/'\n PARTITION (dt='2021-02-02') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-02-02/'\n PARTITION (dt='2021-02-08') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-02-08/'\n PARTITION (dt='2021-02-09') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-02-09/'\n PARTITION (dt='2021-02-10') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-02-10/'\n PARTITION (dt='2021-02-11') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-02-11/'\n PARTITION (dt='2021-03-04') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-03-04/'\n PARTITION (dt='2021-03-05') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-03-05/'\n PARTITION (dt='2021-03-08') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-03-08/'\n PARTITION (dt='2021-05-04') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-05-04/'\n PARTITION (dt='2021-05-05') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-05-05/'\n PARTITION (dt='2021-05-06') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-05-06/'\n PARTITION (dt='2021-05-13') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-05-13/'\n PARTITION (dt='2021-06-22') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-06-22/'\n PARTITION (dt='2021-06-23') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-06-23/'\n PARTITION (dt='2021-06-24') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-06-24/'\n PARTITION (dt='2021-06-25') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-06-25/'\n PARTITION (dt='2021-07-12') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-07-12/'\n PARTITION (dt='2021-07-20') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-07-20/'\n PARTITION (dt='2021-08-20') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-08-20/'\n PARTITION (dt='2021-09-23') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-09-23/'\n PARTITION (dt='2021-09-30') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-09-30/'\n PARTITION (dt='2022-01-24') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2022-01-24/'\n PARTITION (dt='2022-02-28') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2022-02-28/'\n PARTITION (dt='2022-06-06') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2022-06-06/'\n PARTITION (dt='2023-02-09') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2023-02-09/'\n PARTITION (dt='2023-10-02') location 's3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2023-10-02/'\n;"
],
"name": "dt",
"state": [
{
"info": {
"id": 467065,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-04-01/",
"name": "dt",
"value": "2019-04-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:16",
"last_data": "2023-10-02 09:30:16"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467000,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-04-17/",
"name": "dt",
"value": "2019-04-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:11",
"last_data": "2023-10-02 09:30:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467010,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-04-18/",
"name": "dt",
"value": "2019-04-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:12",
"last_data": "2023-10-02 09:30:12"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467094,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-04-19/",
"name": "dt",
"value": "2019-04-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:18",
"last_data": "2023-10-02 09:30:18"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467095,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-04-22/",
"name": "dt",
"value": "2019-04-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:18",
"last_data": "2023-10-02 09:30:18"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467091,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-04-24/",
"name": "dt",
"value": "2019-04-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:18",
"last_data": "2023-10-02 09:30:18"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467080,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-04-25/",
"name": "dt",
"value": "2019-04-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:17",
"last_data": "2023-10-02 09:30:17"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467038,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-04-26/",
"name": "dt",
"value": "2019-04-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:14",
"last_data": "2023-10-02 09:30:14"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467007,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-04-27/",
"name": "dt",
"value": "2019-04-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:11",
"last_data": "2023-10-02 09:30:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467017,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-04-29/",
"name": "dt",
"value": "2019-04-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:12",
"last_data": "2023-10-02 09:30:12"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467005,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-04-30/",
"name": "dt",
"value": "2019-04-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:11",
"last_data": "2023-10-02 09:30:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467111,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-01/",
"name": "dt",
"value": "2019-05-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:19",
"last_data": "2023-10-02 09:30:19"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467060,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-04/",
"name": "dt",
"value": "2019-05-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:15",
"last_data": "2023-10-02 09:30:15"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467050,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-06/",
"name": "dt",
"value": "2019-05-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:15",
"last_data": "2023-10-02 09:30:15"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467061,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-07/",
"name": "dt",
"value": "2019-05-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:16",
"last_data": "2023-10-02 09:30:16"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467036,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-08/",
"name": "dt",
"value": "2019-05-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:14",
"last_data": "2023-10-02 09:30:14"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467029,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-09/",
"name": "dt",
"value": "2019-05-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:13",
"last_data": "2023-10-02 09:30:13"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467092,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-10/",
"name": "dt",
"value": "2019-05-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:18",
"last_data": "2023-10-02 09:30:18"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467100,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-11/",
"name": "dt",
"value": "2019-05-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:19",
"last_data": "2023-10-02 09:30:19"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467089,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-13/",
"name": "dt",
"value": "2019-05-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:18",
"last_data": "2023-10-02 09:30:18"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467043,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-14/",
"name": "dt",
"value": "2019-05-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:14",
"last_data": "2023-10-02 09:30:14"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467086,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-15/",
"name": "dt",
"value": "2019-05-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:18",
"last_data": "2023-10-02 09:30:18"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467004,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-16/",
"name": "dt",
"value": "2019-05-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:11",
"last_data": "2023-10-02 09:30:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467113,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-17/",
"name": "dt",
"value": "2019-05-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:20",
"last_data": "2023-10-02 09:30:20"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467021,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-18/",
"name": "dt",
"value": "2019-05-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:12",
"last_data": "2023-10-02 09:30:12"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467108,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-20/",
"name": "dt",
"value": "2019-05-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:19",
"last_data": "2023-10-02 09:30:19"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467074,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-21/",
"name": "dt",
"value": "2019-05-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:17",
"last_data": "2023-10-02 09:30:17"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467055,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-22/",
"name": "dt",
"value": "2019-05-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:15",
"last_data": "2023-10-02 09:30:15"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467097,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-23/",
"name": "dt",
"value": "2019-05-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:18",
"last_data": "2023-10-02 09:30:18"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467022,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-28/",
"name": "dt",
"value": "2019-05-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:12",
"last_data": "2023-10-02 09:30:12"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467030,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-05-30/",
"name": "dt",
"value": "2019-05-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:13",
"last_data": "2023-10-02 09:30:13"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467070,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-02/",
"name": "dt",
"value": "2019-06-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:16",
"last_data": "2023-10-02 09:30:16"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467026,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-03/",
"name": "dt",
"value": "2019-06-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:13",
"last_data": "2023-10-02 09:30:13"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467103,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-04/",
"name": "dt",
"value": "2019-06-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:19",
"last_data": "2023-10-02 09:30:19"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467044,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-05/",
"name": "dt",
"value": "2019-06-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:14",
"last_data": "2023-10-02 09:30:14"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467025,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-06/",
"name": "dt",
"value": "2019-06-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:13",
"last_data": "2023-10-02 09:30:13"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467112,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-07/",
"name": "dt",
"value": "2019-06-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:20",
"last_data": "2023-10-02 09:30:20"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467114,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-10/",
"name": "dt",
"value": "2019-06-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:20",
"last_data": "2023-10-02 09:30:20"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467003,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-11/",
"name": "dt",
"value": "2019-06-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:11",
"last_data": "2023-10-02 09:30:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467032,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-12/",
"name": "dt",
"value": "2019-06-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:13",
"last_data": "2023-10-02 09:30:13"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467052,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-13/",
"name": "dt",
"value": "2019-06-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:15",
"last_data": "2023-10-02 09:30:15"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467099,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-14/",
"name": "dt",
"value": "2019-06-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:19",
"last_data": "2023-10-02 09:30:19"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467063,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-17/",
"name": "dt",
"value": "2019-06-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:16",
"last_data": "2023-10-02 09:30:16"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467023,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-18/",
"name": "dt",
"value": "2019-06-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:13",
"last_data": "2023-10-02 09:30:13"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467081,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-19/",
"name": "dt",
"value": "2019-06-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:17",
"last_data": "2023-10-02 09:30:17"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467042,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-20/",
"name": "dt",
"value": "2019-06-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:14",
"last_data": "2023-10-02 09:30:14"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467037,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-21/",
"name": "dt",
"value": "2019-06-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:14",
"last_data": "2023-10-02 09:30:14"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467034,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-24/",
"name": "dt",
"value": "2019-06-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:13",
"last_data": "2023-10-02 09:30:13"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467048,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-25/",
"name": "dt",
"value": "2019-06-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:14",
"last_data": "2023-10-02 09:30:14"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467107,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-26/",
"name": "dt",
"value": "2019-06-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:19",
"last_data": "2023-10-02 09:30:19"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467087,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-06-28/",
"name": "dt",
"value": "2019-06-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:18",
"last_data": "2023-10-02 09:30:18"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467039,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-01/",
"name": "dt",
"value": "2019-07-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:14",
"last_data": "2023-10-02 09:30:14"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467056,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-02/",
"name": "dt",
"value": "2019-07-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:15",
"last_data": "2023-10-02 09:30:15"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467083,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-05/",
"name": "dt",
"value": "2019-07-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:17",
"last_data": "2023-10-02 09:30:17"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467054,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-08/",
"name": "dt",
"value": "2019-07-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:15",
"last_data": "2023-10-02 09:30:15"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467115,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-09/",
"name": "dt",
"value": "2019-07-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:20",
"last_data": "2023-10-02 09:30:20"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467053,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-10/",
"name": "dt",
"value": "2019-07-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:15",
"last_data": "2023-10-02 09:30:15"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467024,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-11/",
"name": "dt",
"value": "2019-07-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:13",
"last_data": "2023-10-02 09:30:13"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467031,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-12/",
"name": "dt",
"value": "2019-07-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:13",
"last_data": "2023-10-02 09:30:13"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467058,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-15/",
"name": "dt",
"value": "2019-07-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:15",
"last_data": "2023-10-02 09:30:15"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467016,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-16/",
"name": "dt",
"value": "2019-07-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:12",
"last_data": "2023-10-02 09:30:12"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467072,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-17/",
"name": "dt",
"value": "2019-07-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:16",
"last_data": "2023-10-02 09:30:16"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467101,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-18/",
"name": "dt",
"value": "2019-07-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:19",
"last_data": "2023-10-02 09:30:19"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467104,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-19/",
"name": "dt",
"value": "2019-07-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:19",
"last_data": "2023-10-02 09:30:19"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467075,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-23/",
"name": "dt",
"value": "2019-07-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:17",
"last_data": "2023-10-02 09:30:17"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467047,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-07-25/",
"name": "dt",
"value": "2019-07-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:14",
"last_data": "2023-10-02 09:30:14"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467068,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-08-09/",
"name": "dt",
"value": "2019-08-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:16",
"last_data": "2023-10-02 09:30:16"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467079,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-08-12/",
"name": "dt",
"value": "2019-08-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:17",
"last_data": "2023-10-02 09:30:17"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467098,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-08-13/",
"name": "dt",
"value": "2019-08-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:18",
"last_data": "2023-10-02 09:30:18"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467027,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-08-14/",
"name": "dt",
"value": "2019-08-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:13",
"last_data": "2023-10-02 09:30:13"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467040,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-08-20/",
"name": "dt",
"value": "2019-08-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:14",
"last_data": "2023-10-02 09:30:14"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467006,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-08-29/",
"name": "dt",
"value": "2019-08-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:11",
"last_data": "2023-10-02 09:30:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467076,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-09-04/",
"name": "dt",
"value": "2019-09-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:17",
"last_data": "2023-10-02 09:30:17"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467082,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-09-18/",
"name": "dt",
"value": "2019-09-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:17",
"last_data": "2023-10-02 09:30:17"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467057,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-10-04/",
"name": "dt",
"value": "2019-10-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:15",
"last_data": "2023-10-02 09:30:15"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467033,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-10-15/",
"name": "dt",
"value": "2019-10-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:13",
"last_data": "2023-10-02 09:30:13"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467062,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-10-21/",
"name": "dt",
"value": "2019-10-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:16",
"last_data": "2023-10-02 09:30:16"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467028,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-10-22/",
"name": "dt",
"value": "2019-10-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:13",
"last_data": "2023-10-02 09:30:13"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467051,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-10-23/",
"name": "dt",
"value": "2019-10-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:15",
"last_data": "2023-10-02 09:30:15"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467073,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-10-24/",
"name": "dt",
"value": "2019-10-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:17",
"last_data": "2023-10-02 09:30:17"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467018,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-11-06/",
"name": "dt",
"value": "2019-11-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:12",
"last_data": "2023-10-02 09:30:12"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467019,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-11-13/",
"name": "dt",
"value": "2019-11-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:12",
"last_data": "2023-10-02 09:30:12"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467035,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-11-15/",
"name": "dt",
"value": "2019-11-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:13",
"last_data": "2023-10-02 09:30:13"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467085,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-11-19/",
"name": "dt",
"value": "2019-11-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:17",
"last_data": "2023-10-02 09:30:17"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467071,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-11-21/",
"name": "dt",
"value": "2019-11-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:16",
"last_data": "2023-10-02 09:30:16"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467084,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2019-12-03/",
"name": "dt",
"value": "2019-12-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:17",
"last_data": "2023-10-02 09:30:17"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467088,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2020-01-06/",
"name": "dt",
"value": "2020-01-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:18",
"last_data": "2023-10-02 09:30:18"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467009,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2020-01-07/",
"name": "dt",
"value": "2020-01-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:11",
"last_data": "2023-10-02 09:30:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467020,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2020-01-25/",
"name": "dt",
"value": "2020-01-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:12",
"last_data": "2023-10-02 09:30:12"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467011,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2020-02-17/",
"name": "dt",
"value": "2020-02-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:12",
"last_data": "2023-10-02 09:30:12"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467093,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2020-05-18/",
"name": "dt",
"value": "2020-05-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:18",
"last_data": "2023-10-02 09:30:18"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467064,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2020-05-27/",
"name": "dt",
"value": "2020-05-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:16",
"last_data": "2023-10-02 09:30:16"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467105,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2020-05-28/",
"name": "dt",
"value": "2020-05-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:19",
"last_data": "2023-10-02 09:30:19"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467067,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-02-02/",
"name": "dt",
"value": "2021-02-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:16",
"last_data": "2023-10-02 09:30:16"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467069,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-02-08/",
"name": "dt",
"value": "2021-02-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:16",
"last_data": "2023-10-02 09:30:16"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467059,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-02-09/",
"name": "dt",
"value": "2021-02-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:15",
"last_data": "2023-10-02 09:30:15"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467096,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-02-10/",
"name": "dt",
"value": "2021-02-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:18",
"last_data": "2023-10-02 09:30:18"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467013,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-02-11/",
"name": "dt",
"value": "2021-02-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:12",
"last_data": "2023-10-02 09:30:12"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467077,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-03-04/",
"name": "dt",
"value": "2021-03-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:17",
"last_data": "2023-10-02 09:30:17"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467002,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-03-05/",
"name": "dt",
"value": "2021-03-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:11",
"last_data": "2023-10-02 09:30:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467014,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-03-08/",
"name": "dt",
"value": "2021-03-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:12",
"last_data": "2023-10-02 09:30:12"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467049,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-05-04/",
"name": "dt",
"value": "2021-05-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:15",
"last_data": "2023-10-02 09:30:15"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467102,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-05-05/",
"name": "dt",
"value": "2021-05-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:19",
"last_data": "2023-10-02 09:30:19"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467045,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-05-06/",
"name": "dt",
"value": "2021-05-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:14",
"last_data": "2023-10-02 09:30:14"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467066,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-05-13/",
"name": "dt",
"value": "2021-05-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:16",
"last_data": "2023-10-02 09:30:16"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467041,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-06-22/",
"name": "dt",
"value": "2021-06-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:14",
"last_data": "2023-10-02 09:30:14"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467046,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-06-23/",
"name": "dt",
"value": "2021-06-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:14",
"last_data": "2023-10-02 09:30:14"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467078,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-06-24/",
"name": "dt",
"value": "2021-06-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:17",
"last_data": "2023-10-02 09:30:17"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467001,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-06-25/",
"name": "dt",
"value": "2021-06-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:11",
"last_data": "2023-10-02 09:30:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467106,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-07-12/",
"name": "dt",
"value": "2021-07-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:19",
"last_data": "2023-10-02 09:30:19"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467008,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-07-20/",
"name": "dt",
"value": "2021-07-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:11",
"last_data": "2023-10-02 09:30:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467090,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-08-20/",
"name": "dt",
"value": "2021-08-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:18",
"last_data": "2023-10-02 09:30:18"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467109,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-09-23/",
"name": "dt",
"value": "2021-09-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:19",
"last_data": "2023-10-02 09:30:19"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467012,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2021-09-30/",
"name": "dt",
"value": "2021-09-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:12",
"last_data": "2023-10-02 09:30:12"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467110,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2022-01-24/",
"name": "dt",
"value": "2022-01-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:19",
"last_data": "2023-10-02 09:30:19"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 467015,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2022-02-28/",
"name": "dt",
"value": "2022-02-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:30:12",
"last_data": "2023-10-02 09:30:12"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 289019,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2022-06-06/",
"name": "dt",
"value": "2022-06-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2022-06-06 13:46:29",
"last_data": "2022-06-06 13:54:06"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 395308,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2023-02-09/",
"name": "dt",
"value": "2023-02-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-02-08 23:38:16",
"last_data": "2023-02-09 00:15:09"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 466999,
"location": "s3://sfdl-segment-storagescout-stage/separated_dt/click/dt=2023-10-02/",
"name": "dt",
"value": "2023-10-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2023-10-02 09:29:52",
"last_data": "2023-10-02 09:29:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
}
],
"type": "string"
},
"schema": {
"attributes": {
"_origin": "string",
"anonymousId": "string",
"channel": "string",
"context.ip": "string",
"context.library.name": "string",
"context.library.version": "string",
"context.locale": "string",
"context.page.path": "string",
"context.page.referrer": "string",
"context.page.search": "string",
"context.page.title": "string",
"context.page.url": "string",
"context.userAgent": "string",
"context.userAgentData.brands": [
{
"brand": "string",
"version": "string"
}
],
"context.userAgentData.mobile": "string",
"context.userAgentData.platform": "string",
"event": "string",
"messageId": "string",
"originalTimestamp": "string",
"projectId": "string",
"properties.0": "string",
"properties.1": "string",
"properties.10": "string",
"properties.11": "string",
"properties.12": "string",
"properties.13": "string",
"properties.14": "string",
"properties.15": "string",
"properties.16": "string",
"properties.17": "string",
"properties.2": "string",
"properties.3": "string",
"properties.4": "string",
"properties.5": "string",
"properties.6": "string",
"properties.7": "string",
"properties.8": "string",
"properties.9": "string",
"properties.Hit_Timestamp": "string",
"properties.breadcrumb": "string",
"properties.category": "string",
"properties.env": "string",
"properties.extra.dateSelected": "string",
"properties.extra.facilityId": "string",
"properties.extra.place.address_components": [
{
"long_name": "string",
"short_name": "string",
"types": [
"string"
]
}
],
"properties.extra.place.adr_address": "string",
"properties.extra.place.formatted_address": "string",
"properties.extra.place.geometry.viewport.La.g": "string",
"properties.extra.place.geometry.viewport.La.i": "string",
"properties.extra.place.geometry.viewport.Qa.i": "string",
"properties.extra.place.geometry.viewport.Qa.j": "string",
"properties.extra.place.geometry.viewport.Ra.g": "string",
"properties.extra.place.geometry.viewport.Ra.i": "string",
"properties.extra.place.geometry.viewport.Ua.g": "string",
"properties.extra.place.geometry.viewport.Ua.i": "string",
"properties.extra.place.geometry.viewport.Va.i": "string",
"properties.extra.place.geometry.viewport.Va.j": "string",
"properties.extra.place.geometry.viewport.ga.j": "string",
"properties.extra.place.geometry.viewport.ga.l": "string",
"properties.extra.place.geometry.viewport.ia.j": "string",
"properties.extra.place.geometry.viewport.ia.l": "string",
"properties.extra.place.geometry.viewport.ja.g": "string",
"properties.extra.place.geometry.viewport.ja.h": "string",
"properties.extra.place.geometry.viewport.ka.g": "string",
"properties.extra.place.geometry.viewport.ka.h": "string",
"properties.extra.place.geometry.viewport.na.g": "string",
"properties.extra.place.geometry.viewport.na.h": "string",
"properties.extra.place.geometry.viewport.na.j": "string",
"properties.extra.place.geometry.viewport.na.l": "string",
"properties.extra.place.geometry.viewport.oa.g": "string",
"properties.extra.place.geometry.viewport.oa.h": "string",
"properties.extra.place.geometry.viewport.pa.g": "string",
"properties.extra.place.geometry.viewport.pa.h": "string",
"properties.extra.place.html_attributions": [
"string"
],
"properties.extra.place.icon": "string",
"properties.extra.place.id": "string",
"properties.extra.place.name": "string",
"properties.extra.place.photos": [
{
"height": "string",
"html_attributions": [
"string"
],
"width": "string"
}
],
"properties.extra.place.place_id": "string",
"properties.extra.place.reference": "string",
"properties.extra.place.scope": "string",
"properties.extra.place.types": [
"string"
],
"properties.extra.place.url": "string",
"properties.extra.place.utc_offset": "string",
"properties.extra.place.utc_offset_minutes": "string",
"properties.extra.place.vicinity": "string",
"properties.extra.place.website": "string",
"properties.extra.unitId": "string",
"properties.facilityId": "string",
"properties.isReact": "string",
"properties.label": "string",
"properties.site_id": "string",
"properties.value": "string",
"receivedAt": "string",
"sentAt": "string",
"timestamp": "string",
"type": "string",
"userId": "string",
"version": "string"
},
"created": "2023-10-02 09:29:51",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_segment`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_segment.storagescout_click`\n(\n`integrations`struct<`_empty_`:STRING>,`timestamp`STRING,`_origin`STRING,`originalTimestamp`STRING,`event`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`anonymousId`STRING,`type`STRING,`properties`struct<`extra`:struct<`dateSelected`:STRING,`unitId`:STRING,`facilityId`:STRING,`place`:struct<`formatted_address`:STRING,`scope`:STRING,`geometry`:struct<`viewport`:struct<`ka`:struct<`g`:STRING,`h`:STRING>,`pa`:struct<`h`:STRING,`g`:STRING>,`Qa`:struct<`i`:STRING,`j`:STRING>,`Ra`:struct<`g`:STRING,`i`:STRING>,`Va`:struct<`i`:STRING,`j`:STRING>,`La`:struct<`g`:STRING,`i`:STRING>,`ga`:struct<`j`:STRING,`l`:STRING>,`oa`:struct<`h`:STRING,`g`:STRING>,`ja`:struct<`h`:STRING,`g`:STRING>,`Ua`:struct<`g`:STRING,`i`:STRING>,`na`:struct<`l`:STRING,`j`:STRING,`g`:STRING,`h`:STRING>,`ia`:struct<`j`:STRING,`l`:STRING>>>,`vicinity`:STRING,`place_id`:STRING,`types`:array,`adr_address`:STRING,`utc_offset`:STRING,`website`:STRING,`utc_offset_minutes`:STRING,`icon`:STRING,`name`:STRING,`id`:STRING,`address_components`:array>>,`photos`:array,`width`:STRING>>,`url`:STRING,`html_attributions`:array,`reference`:STRING>>,`13`:STRING,`facilityId`:STRING,`12`:STRING,`2`:STRING,`4`:STRING,`5`:STRING,`isReact`:STRING,`11`:STRING,`16`:STRING,`15`:STRING,`14`:STRING,`7`:STRING,`9`:STRING,`category`:STRING,`site_id`:STRING,`breadcrumb`:STRING,`Hit_Timestamp`:STRING,`3`:STRING,`label`:STRING,`10`:STRING,`0`:STRING,`17`:STRING,`value`:STRING,`8`:STRING,`1`:STRING,`6`:STRING,`env`:STRING>,`userId`STRING,`version`STRING,`context`struct<`library`:struct<`name`:STRING,`version`:STRING>,`locale`:STRING,`userAgent`:STRING,`page`:struct<`path`:STRING,`title`:STRING,`search`:STRING,`url`:STRING,`referrer`:STRING>,`userAgentData`:struct<`brands`:array>,`mobile`:STRING,`platform`:STRING>,`ip`:STRING>,`channel`STRING,`receivedAt`STRING,`messageId`STRING,`sentAt`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-storagescout-stage/separated_dt/click'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_stage_segment.storagescout_click`",
"repair_table": "MSCK REPAIR TABLE sfdl_stage_segment.storagescout_click"
}
},
"server": {
"hostname": "schemamanager-5c55c886bf-h2ts4",
"name": "schema_manager",
"process_start": "2025-10-21 13:03:27",
"sf_env": "stage",
"version": "2112174301"
}
}