{"id":3095,"date":"2019-07-19T19:14:28","date_gmt":"2019-07-19T17:14:28","guid":{"rendered":"http:\/\/miro.borodziuk.eu\/?p=3095"},"modified":"2019-09-06T19:38:56","modified_gmt":"2019-09-06T17:38:56","slug":"amazon-athena","status":"publish","type":"post","link":"http:\/\/miro.borodziuk.eu\/index.php\/2019\/07\/19\/amazon-athena\/","title":{"rendered":"Amazon Athena"},"content":{"rendered":"<p>Amazon Athena is an interactive query service that utilizes <strong>schema-on-read<\/strong>, allowing you to run ad-hoc SQL-like queries on data from a range of sources.<\/p>\n<p><!--more-->Results are returned in seconds, and you are billed only for the compute time used and any existing storage costs.<br \/>\nAthena can query many forms of structured, semi-structured, and unstructured data in <strong>S3<\/strong>.<\/p>\n<p>Tables are defined in a data catalog and are applied on read. Athena allows SQL queries against data stored on S3, through the schema-on-read tables.<\/p>\n<p>Athena can be used to query various AWS logs, including flow logs and ELB logs.<br \/>\nNo data is modified by Athena, and output can be sent to visualization tools.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3096 aligncenter\" src=\"http:\/\/miro.borodziuk.eu\/wp-content\/uploads\/AmazonAthena.jpg\" alt=\"\" width=\"620\" height=\"611\" srcset=\"http:\/\/miro.borodziuk.eu\/wp-content\/uploads\/AmazonAthena.jpg 620w, http:\/\/miro.borodziuk.eu\/wp-content\/uploads\/AmazonAthena-300x296.jpg 300w, http:\/\/miro.borodziuk.eu\/wp-content\/uploads\/AmazonAthena-100x100.jpg 100w\" sizes=\"(max-width: 620px) 100vw, 620px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Amazon Athena is an interactive query service that utilizes schema-on-read, allowing you to run ad-hoc SQL-like queries on data from a range of sources.<\/p>\n","protected":false},"author":1,"featured_media":3098,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[83],"tags":[],"_links":{"self":[{"href":"http:\/\/miro.borodziuk.eu\/index.php\/wp-json\/wp\/v2\/posts\/3095"}],"collection":[{"href":"http:\/\/miro.borodziuk.eu\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/miro.borodziuk.eu\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/miro.borodziuk.eu\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/miro.borodziuk.eu\/index.php\/wp-json\/wp\/v2\/comments?post=3095"}],"version-history":[{"count":4,"href":"http:\/\/miro.borodziuk.eu\/index.php\/wp-json\/wp\/v2\/posts\/3095\/revisions"}],"predecessor-version":[{"id":3101,"href":"http:\/\/miro.borodziuk.eu\/index.php\/wp-json\/wp\/v2\/posts\/3095\/revisions\/3101"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/miro.borodziuk.eu\/index.php\/wp-json\/wp\/v2\/media\/3098"}],"wp:attachment":[{"href":"http:\/\/miro.borodziuk.eu\/index.php\/wp-json\/wp\/v2\/media?parent=3095"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/miro.borodziuk.eu\/index.php\/wp-json\/wp\/v2\/categories?post=3095"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/miro.borodziuk.eu\/index.php\/wp-json\/wp\/v2\/tags?post=3095"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}