{"id":3797,"date":"2019-12-04T11:11:09","date_gmt":"2019-12-04T11:11:09","guid":{"rendered":"https:\/\/prwatech.in\/blog\/?p=3797"},"modified":"2024-03-29T06:35:52","modified_gmt":"2024-03-29T06:35:52","slug":"getting-started-with-athena","status":"publish","type":"post","link":"https:\/\/prwatech.in\/blog\/aws\/amazon-athena\/getting-started-with-athena\/","title":{"rendered":"Getting Started With Athena"},"content":{"rendered":"<h1>Getting Started With Athena<\/h1>\n<p>&nbsp;<\/p>\n<p>Getting Started With Athena, in this Tutorial one, you can learn about Getting Started With Athena. Are you the one who is looking for the <a href=\"https:\/\/www.youtube.com\/channel\/UCwAaWqnH2MqikDMpb1jBspw\">best platform<\/a> which provides information about Getting Started With Athena? Or the one who is looking forward to taking the advanced Certification Course from India\u2019s Leading <a href=\"https:\/\/prwatech.in\/aws-training-institute-in-pune\/\">AWS Training institute<\/a>? Then you\u2019ve landed on the Right Path.<\/p>\n<p>The Below mentioned Tutorial will help to Understand the detailed information about Getting Started With Athena, so Just Follow All the Tutorials of India\u2019s Leading <a href=\"https:\/\/prwatech.in\/aws-training-institute-in-pune\/\">Best AWS Training institute<\/a> and Be a Pro AWS Developer.<\/p>\n<p>If you&#8217;ve already signed up for Amazon Web Services (AWS) account, you can start using Amazon Athena immediately.<\/p>\n<h3>Sign Up for AWS<\/h3>\n<p>When you sign up for AWS, your account is automatically signed up for all services in AWS, including Amazon Athena. You are charged only for the AWS services that you use. When you use Amazon Athena, you use Amazon S3 to store your data. Amazon Athena has no AWS Free Tier pricing.<\/p>\n<p>If you have an AWS account, skip to the next task. If you don&#8217;t have an AWS account, please use the following procedure to create one.<\/p>\n<h3>To create an AWS account<\/h3>\n<ol>\n<li>Open\u00a0http:\/\/aws.amazon.com\/, and then choose to\u00a0<strong>Create an AWS Account<\/strong>.<\/li>\n<li>Follow the online instructions. Part of the sign-up procedure involves receiving a phone call &amp; entering a PIN using the phone keypad.<\/li>\n<\/ol>\n<p>Note your AWS Account ID, because you need it for the next task.<\/p>\n<h3><strong>Getting Started<\/strong><\/h3>\n<p>This tutorial guides you through using Amazon Athena to query data. You&#8217;ll create a table based on sample data stored or loaded data in Amazon Simple Storage Service, query the table, and check the results of the query.<\/p>\n<p><strong>Step 1: Create a Database<\/strong><\/p>\n<p>You first need to create a database in Amazon Athena.<\/p>\n<h3><strong>To create a database<\/strong><\/h3>\n<ol>\n<li>Open the Athena console.<\/li>\n<li>If this is your first time visiting the Amazon Athena console, you&#8217;ll go to a Getting Started page. Click on\u00a0<strong>Get Started<\/strong>to open the Query Editor. If it isn&#8217;t your first time, the Amazon Athena Query Editor opens.<\/li>\n<li>In an Athena Query Editor, you see a query pane with an example query. Start typing your query anywhere in the query pane.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"912\" height=\"216\" class=\"aligncenter wp-image-3798\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/12\/a.png\" alt=\"&quot;&lt;\/p\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/12\/a.png 912w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/12\/a-300x71.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/12\/a-768x182.png 768w\" sizes=\"auto, (max-width: 912px) 100vw, 912px\" \/><\/p>\n<p>4. To create a database named\u00a0sacramento, enter the following CREATE DATABASE statement, and then choose\u00a0<strong>Run Query<\/strong>:<\/p>\n<p>CREATE DATABASE sacramento;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"938\" height=\"314\" class=\"alignnone wp-image-3799\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/12\/12.png\" alt=\"&quot;&lt;\/p\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/12\/12.png 938w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/12\/12-300x100.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/12\/12-768x257.png 768w\" sizes=\"auto, (max-width: 938px) 100vw, 938px\" \/><\/p>\n<p>Confirm that the catalog displays refreshes and\u00a0sacramento appears in the\u00a0<strong>DATABASE<\/strong>\u00a0list in the\u00a0<strong>Catalog<\/strong>\u00a0dashboard on the left side.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"338\" height=\"351\" class=\"aligncenter wp-image-3800\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/12\/b.png\" alt=\"&quot;&lt;\/p\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/12\/b.png 338w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/12\/b-289x300.png 289w\" sizes=\"auto, (max-width: 338px) 100vw, 338px\" \/><\/p>\n<p><strong>Step 2: Create a Table<\/strong><\/p>\n<p>Now that you have a database, you&#8217;re ready to create a table that&#8217;s based on the sample csv data file.<\/p>\n<p><strong>To create a table<\/strong><\/p>\n<ol>\n<li>Make sure that sacramento is select for <strong>DATABASE<\/strong>and then choose\u00a0<strong>New Query<\/strong>.<\/li>\n<li>In the query pane, enter the following CREATE TABLE statement to create table, and then choose\u00a0<strong>Run Query<\/strong>:<\/li>\n<\/ol>\n<h4><strong>Note<\/strong><\/h4>\n<p>You can query data in regions other than the region where you run Athena means it is not regions specific. Standard inter-region data transfer rates for Amazon Simple Storage Service S3 apply in addition to standard Athena charges. To reduce data transfer charges, replace\u00a0<em>myregion<\/em>\u00a0in\u00a0s3:\/\/athena-examples-<em>myregion<\/em>\/path\/to\/data\/\u00a0with the region identifier where you run Athena, e.g.\u00a0s3:\/\/athena-examples-us-east-1\/path\/to\/data\/.<\/p>\n<p>The\u00a0table <strong>crime_data<\/strong> is created and appears in the\u00a0<strong>Catalog<\/strong>\u00a0dashboard for your database.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"338\" height=\"351\" class=\"aligncenter wp-image-3800\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/12\/b.png\" alt=\"&quot;&lt;\/p\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/12\/b.png 338w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/12\/b-289x300.png 289w\" sizes=\"auto, (max-width: 338px) 100vw, 338px\" \/><\/p>\n<p><strong>Step 3: Query Data<\/strong><\/p>\n<p>Now that you have the\u00a0<strong>crime_data<\/strong> table created in Athena based on the data in Amazon S3, you can run queries on the table and see the results in Athena.<\/p>\n<h4><strong>To run a query<\/strong><\/h4>\n<ol>\n<li>Choose\u00a0<strong>New Query<\/strong>, enter the following statement anywhere in the query pane, and then choose\u00a0<strong>Run Query<\/strong>:<\/li>\n<\/ol>\n<p>The next step, creating the table, is more interesting: not only does Athena create the table, but it also learns where and how to read the data from my S3 bucket. There\u2019s plenty of work going on behind the hood on this one. I\u2019ve decided to call the table\u00a0<strong>crime_data.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3801\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/12\/15-1024x414.png\" alt=\"\" width=\"850\" height=\"344\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/12\/15-1024x414.png 1024w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/12\/15-300x121.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/12\/15-768x311.png 768w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/12\/15-1200x486.png 1200w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/12\/15.png 1317w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<h3>By running above query table <strong>crime_data <\/strong>will create under <strong>sacramento<\/strong> database.<\/h3>\n<p>The EXTERNAL keyword on line one dictates that our data is originating from a source outwith the database, specified by the LOCATION parameter on line 15. This points to the crime-data folder from my S3 bucket. Furthermore, we exclude the first line of our CSV file =&gt; consisting of header values =&gt;using TBLPROPERTIES on lines 16\u201318.<\/p>\n<p>Each attribute from lines 2\u201310 corresponds to one column in the CSV file, with the first, ts, being timestamps of form \u201cMM\/DD\/YY HH:MI\u201d. In other words, 1am on January 21st would look like 1\/21\/06 1:00, whilst 10pm on January 21st would like like 1\/21\/06 22:00. Given that all data for this file is from January, all the MMs are \u201c1\u201d!<\/p>\n<p>With both database\u00a0sacramento\u00a0and table\u00a0crime_data\u00a0created, it\u2019s time to analyse the latter to our heart\u2019s content with some SQL\u00a0SELECT\u00a0statements. For the sake of demonstrating how this works, let\u2019s write a query to fetch all crimes reported between January 1st and January 2nd in 2006.<\/p>\n<p>As ever with programming, timestamps and dates prove interesting to work with. Critical to dealing with this data is knowing which query engine Athena uses under the hood.<\/p>\n<p>The answer?\u00a0Presto, an open-source distributed query engine. Following Presto\u2019s\u00a0documentation on dates and times, we find ourselves parsing the provided timestamps with format specifiers in the form of\u00a0%c\/%e\/%y %k: %i<\/p>\n<ol start=\"2\">\n<li>\n<h3>To pull the data which are available in s3 location you have to specify path<\/h3>\n<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3802\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/12\/10-1.png\" alt=\"\" width=\"926\" height=\"534\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/12\/10-1.png 926w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/12\/10-1-300x173.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/12\/10-1-768x443.png 768w\" sizes=\"auto, (max-width: 926px) 100vw, 926px\" \/><\/p>\n<p>Choose the file type loaded in s3 and want to process in Athena<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3803\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/12\/11.png\" alt=\"\" width=\"513\" height=\"487\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/12\/11.png 513w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/12\/11-300x285.png 300w\" sizes=\"auto, (max-width: 513px) 100vw, 513px\" \/><\/p>\n<p>The next step is to run the select query once the data pulled by Athena<\/p>\n<p>Go to the query editor of Amazon Athena<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3804\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/12\/17.png\" alt=\"\" width=\"468\" height=\"110\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/12\/17.png 468w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/12\/17-300x71.png 300w\" sizes=\"auto, (max-width: 468px) 100vw, 468px\" \/><\/p>\n<p>After heating Run Query result are following:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3805\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/12\/20.png\" alt=\"\" width=\"967\" height=\"616\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/12\/20.png 967w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/12\/20-300x191.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/12\/20-768x489.png 768w\" sizes=\"auto, (max-width: 967px) 100vw, 967px\" \/><\/p>\n<p>You can save the query to run again<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3806\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/12\/19.png\" alt=\"\" width=\"532\" height=\"247\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/12\/19.png 532w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/12\/19-300x139.png 300w\" sizes=\"auto, (max-width: 532px) 100vw, 532px\" \/><\/p>\n<p>You can also view the results of previous queries or queries that may take some time to complete. Choose\u00a0<strong>History<\/strong>\u00a0then either search for your query or choose\u00a0<strong>View<\/strong>\/<strong>Download<\/strong> to view or download the results of previous completed queries. This also displays the status of queries that are currently running. Query history is retain for 45 days for view the results.<\/p>\n<h3><strong>Running this query produced the expected results within a couple of seconds:<\/strong><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-3807 aligncenter\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/12\/success-1024x500.png\" alt=\"\" width=\"840\" height=\"410\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/12\/success-1024x500.png 1024w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/12\/success-300x146.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/12\/success-768x375.png 768w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/12\/success-1200x586.png 1200w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/12\/success.png 1287w\" sizes=\"auto, (max-width: 840px) 100vw, 840px\" \/><\/p>\n<p>You can save the output result in the other folder in s3<\/p>\n<h3><strong>Accessing Amazon Athena<\/strong><\/h3>\n<p>You can access Amazon Athena using the AWS Management Console, the Amazon Athena API and the AWS CLI.<\/p>\n<p><strong>Using the Console<\/strong><\/p>\n<p>You can use the AWS Management Console for Amazon Athena to do the following:<\/p>\n<p>To create or select a database.<\/p>\n<p>Create, view, and delete tables.<\/p>\n<p>To Filter tables by starting to type their names.<\/p>\n<p>To Preview tables and generate CREATE TABLE DDL for them.<\/p>\n<p>Show table properties.<\/p>\n<p>To Run queries on tables, save and format queries, and view query history.<\/p>\n<p>Create up to ten queries using different query tabs in the query editor. To open a new query tab, click the plus sign.<\/p>\n<p>To Display query results, save, and export them.<\/p>\n<p>Access the AWS Glue Data Catalog.<\/p>\n<p>View and change settings, such as view the query result location, configure auto-complete, and encrypt query results.<\/p>\n<p>In the right pane, the Query Editor displays an introductory screen that prompts you to create your first table. You can view your tables under\u00a0<strong>Tables<\/strong>\u00a0in the left pane.<\/p>\n<p>Here&#8217;s a high-level overview of the actions available for each table:<\/p>\n<p><strong>To Preview tables<\/strong>\u2013 View the query syntax in the Query Editor on the right.<\/p>\n<p><strong>Show properties<\/strong>\u2013 Show a table&#8217;s name, its location in Amazon S3, input and output formats, the serialization (SerDe) library used, and whether the table has encrypted data.<\/p>\n<p><strong>Delete table<\/strong>\u2013 Delete a table.<\/p>\n<p><strong>Generate CREATE TABLE DDL<\/strong>\u2013 To Generate the query behind a table and view it in the query editor.<\/p>\n<p><strong>Using the API<\/strong><\/p>\n<p>Amazon Athena enables application programming for Athena. For more information, see\u00a0Amazon Athena API Reference. The latest AWS SDKs include support for the Athena API.<\/p>\n<p>For examples of using the AWS SDK for Java with Athena.<\/p>\n<p><strong>Using the CLI<\/strong><\/p>\n<p>You can access Amazon Athena using the AWS CLI.<\/p>\n<p style=\"text-align: center;\"><strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<span style=\"color: #0000ff;\">\u00a0\u00a0\u00a0\u00a0 #Last but not least, always ask for help!<\/span><\/strong><span style=\"color: #0000ff;\">\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Getting Started With Athena &nbsp; Getting Started With Athena, in this Tutorial one, you can learn about Getting Started With Athena. Are you the one who is looking for the best platform which provides information about Getting Started With Athena? Or the one who is looking forward to taking the advanced Certification Course from India\u2019s [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":3588,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1661,31],"tags":[396],"class_list":["post-3797","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-amazon-athena","category-aws","tag-getting-started-with-athena"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Getting Started With Athena | Prwatech Bangalore<\/title>\n<meta name=\"description\" content=\"Getting Started With Athena, If you&#039;ve already signed up for Amazon Web Services (AWS) account, you can start using Amazon Athena immediately.\" \/>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Getting Started With Athena | Prwatech Bangalore\" \/>\n<meta property=\"og:description\" content=\"Getting Started With Athena, If you&#039;ve already signed up for Amazon Web Services (AWS) account, you can start using Amazon Athena immediately.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prwatech.in\/blog\/aws\/amazon-athena\/getting-started-with-athena\/\" \/>\n<meta property=\"og:site_name\" content=\"Prwatech\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prwatech.in\/\" \/>\n<meta property=\"article:published_time\" content=\"2019-12-04T11:11:09+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-29T06:35:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/White-and-Grey-Laurel-Hipster-Logo.png\" \/>\n\t<meta property=\"og:image:width\" content=\"500\" \/>\n\t<meta property=\"og:image:height\" content=\"500\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Prwatech\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@Eduprwatech\" \/>\n<meta name=\"twitter:site\" content=\"@Eduprwatech\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Prwatech\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/prwatech.in\/blog\/aws\/amazon-athena\/getting-started-with-athena\/\",\"url\":\"https:\/\/prwatech.in\/blog\/aws\/amazon-athena\/getting-started-with-athena\/\",\"name\":\"How to Getting Started With Athena | Prwatech Bangalore\",\"isPartOf\":{\"@id\":\"https:\/\/prwatech.in\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/prwatech.in\/blog\/aws\/amazon-athena\/getting-started-with-athena\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/prwatech.in\/blog\/aws\/amazon-athena\/getting-started-with-athena\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/White-and-Grey-Laurel-Hipster-Logo.png\",\"datePublished\":\"2019-12-04T11:11:09+00:00\",\"dateModified\":\"2024-03-29T06:35:52+00:00\",\"author\":{\"@id\":\"https:\/\/prwatech.in\/blog\/#\/schema\/person\/db90baff7744090b2288bbc98fea87f3\"},\"description\":\"Getting Started With Athena, If you've already signed up for Amazon Web Services (AWS) account, you can start using Amazon Athena immediately.\",\"breadcrumb\":{\"@id\":\"https:\/\/prwatech.in\/blog\/aws\/amazon-athena\/getting-started-with-athena\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/prwatech.in\/blog\/aws\/amazon-athena\/getting-started-with-athena\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/prwatech.in\/blog\/aws\/amazon-athena\/getting-started-with-athena\/#primaryimage\",\"url\":\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/White-and-Grey-Laurel-Hipster-Logo.png\",\"contentUrl\":\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/White-and-Grey-Laurel-Hipster-Logo.png\",\"width\":500,\"height\":500},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/prwatech.in\/blog\/aws\/amazon-athena\/getting-started-with-athena\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/prwatech.in\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Getting Started With Athena\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/prwatech.in\/blog\/#website\",\"url\":\"https:\/\/prwatech.in\/blog\/\",\"name\":\"Prwatech\",\"description\":\"Share Ideas, Start Something Good.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/prwatech.in\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/prwatech.in\/blog\/#\/schema\/person\/db90baff7744090b2288bbc98fea87f3\",\"name\":\"Prwatech\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/prwatech.in\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c00bafc1b04045f31eda917de39891456c44fa47c092b9bb6be0f860a3a30a2f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c00bafc1b04045f31eda917de39891456c44fa47c092b9bb6be0f860a3a30a2f?s=96&d=mm&r=g\",\"caption\":\"Prwatech\"},\"url\":\"https:\/\/prwatech.in\/blog\/author\/prwatech123\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Getting Started With Athena | Prwatech Bangalore","description":"Getting Started With Athena, If you've already signed up for Amazon Web Services (AWS) account, you can start using Amazon Athena immediately.","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_US","og_type":"article","og_title":"How to Getting Started With Athena | Prwatech Bangalore","og_description":"Getting Started With Athena, If you've already signed up for Amazon Web Services (AWS) account, you can start using Amazon Athena immediately.","og_url":"https:\/\/prwatech.in\/blog\/aws\/amazon-athena\/getting-started-with-athena\/","og_site_name":"Prwatech","article_publisher":"https:\/\/www.facebook.com\/prwatech.in\/","article_published_time":"2019-12-04T11:11:09+00:00","article_modified_time":"2024-03-29T06:35:52+00:00","og_image":[{"width":500,"height":500,"url":"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/White-and-Grey-Laurel-Hipster-Logo.png","type":"image\/png"}],"author":"Prwatech","twitter_card":"summary_large_image","twitter_creator":"@Eduprwatech","twitter_site":"@Eduprwatech","twitter_misc":{"Written by":"Prwatech","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/prwatech.in\/blog\/aws\/amazon-athena\/getting-started-with-athena\/","url":"https:\/\/prwatech.in\/blog\/aws\/amazon-athena\/getting-started-with-athena\/","name":"How to Getting Started With Athena | Prwatech Bangalore","isPartOf":{"@id":"https:\/\/prwatech.in\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prwatech.in\/blog\/aws\/amazon-athena\/getting-started-with-athena\/#primaryimage"},"image":{"@id":"https:\/\/prwatech.in\/blog\/aws\/amazon-athena\/getting-started-with-athena\/#primaryimage"},"thumbnailUrl":"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/White-and-Grey-Laurel-Hipster-Logo.png","datePublished":"2019-12-04T11:11:09+00:00","dateModified":"2024-03-29T06:35:52+00:00","author":{"@id":"https:\/\/prwatech.in\/blog\/#\/schema\/person\/db90baff7744090b2288bbc98fea87f3"},"description":"Getting Started With Athena, If you've already signed up for Amazon Web Services (AWS) account, you can start using Amazon Athena immediately.","breadcrumb":{"@id":"https:\/\/prwatech.in\/blog\/aws\/amazon-athena\/getting-started-with-athena\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prwatech.in\/blog\/aws\/amazon-athena\/getting-started-with-athena\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prwatech.in\/blog\/aws\/amazon-athena\/getting-started-with-athena\/#primaryimage","url":"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/White-and-Grey-Laurel-Hipster-Logo.png","contentUrl":"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/White-and-Grey-Laurel-Hipster-Logo.png","width":500,"height":500},{"@type":"BreadcrumbList","@id":"https:\/\/prwatech.in\/blog\/aws\/amazon-athena\/getting-started-with-athena\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/prwatech.in\/blog\/"},{"@type":"ListItem","position":2,"name":"Getting Started With Athena"}]},{"@type":"WebSite","@id":"https:\/\/prwatech.in\/blog\/#website","url":"https:\/\/prwatech.in\/blog\/","name":"Prwatech","description":"Share Ideas, Start Something Good.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/prwatech.in\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/prwatech.in\/blog\/#\/schema\/person\/db90baff7744090b2288bbc98fea87f3","name":"Prwatech","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prwatech.in\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c00bafc1b04045f31eda917de39891456c44fa47c092b9bb6be0f860a3a30a2f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c00bafc1b04045f31eda917de39891456c44fa47c092b9bb6be0f860a3a30a2f?s=96&d=mm&r=g","caption":"Prwatech"},"url":"https:\/\/prwatech.in\/blog\/author\/prwatech123\/"}]}},"_links":{"self":[{"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/posts\/3797","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/comments?post=3797"}],"version-history":[{"count":5,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/posts\/3797\/revisions"}],"predecessor-version":[{"id":11171,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/posts\/3797\/revisions\/11171"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/media\/3588"}],"wp:attachment":[{"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/media?parent=3797"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/categories?post=3797"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/tags?post=3797"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}