<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
  <channel>
    <title>DEV Community: Vivekanand Gujjeti</title>
    <description>The latest articles on DEV Community by Vivekanand Gujjeti (@viv92945316).</description>
    <link>https://dev.to/viv92945316</link>
    <image>
      <url>https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F858934%2F0f8553e0-b3f7-4da5-aba0-f21a65fc25e9.jpg</url>
      <title>DEV Community: Vivekanand Gujjeti</title>
      <link>https://dev.to/viv92945316</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/viv92945316"/>
    <language>en</language>
    <item>
      <title>AWS Beanstalk</title>
      <dc:creator>Vivekanand Gujjeti</dc:creator>
      <pubDate>Mon, 23 May 2022 16:17:43 +0000</pubDate>
      <link>https://dev.to/viv92945316/aws-beanstalk-1gf0</link>
      <guid>https://dev.to/viv92945316/aws-beanstalk-1gf0</guid>
      <description>&lt;p&gt;&lt;strong&gt;&lt;em&gt;What is Amazon Elastic Beanstalk?&lt;/em&gt;&lt;/strong&gt;&lt;br&gt;
● Beanstalk is a compute service for deploying and scaling applications developed in many popular languages.&lt;br&gt;
● Developers can focus on writing code and don’t need to worry about the underlying infrastructure required to run the application.&lt;br&gt;
● AWS Elastic Beanstalk is the best way to deploy your application in the fastest and simplest way.&lt;br&gt;
● It provides the user interface/dashboard to monitor your application.&lt;br&gt;
● It gives you the flexibility to choose AWS resources such as Amazon EC2 Instance along with the pricing options which suit your application needs.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;&lt;em&gt;AWS Elastic Beanstalk supports two types of Environment:&lt;/em&gt;&lt;/strong&gt;&lt;br&gt;
  ● &lt;strong&gt;Web Tier Environment&lt;/strong&gt;&lt;br&gt;
o This application hosted on the Web Server Environment handles the HTTP and HTTPS requests from the users.&lt;br&gt;
o Beanstalk Environment: When an environment is launched, Beanstalk automatically assigns various resources to run the application successfully.&lt;br&gt;
o Elastic Load Balancer: Request is received from the user via Route53 which forwards the request to ELB. Then ELB distributes the request among various EC2 Instances of the Autoscaling group.&lt;br&gt;
o Auto Scaling Group: Auto Scaling will automatically add or remove EC2 Instance based on the load in the application.&lt;br&gt;
o Host Manager: Software components inside every EC2 Instance&lt;br&gt;
which is responsible for the following:&lt;br&gt;
▪ Log files generation&lt;br&gt;
▪ Monitoring&lt;br&gt;
▪ Events in Instance&lt;/p&gt;

&lt;p&gt;&lt;a href="https://res.cloudinary.com/practicaldev/image/fetch/s--HI4EZ8Hj--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/0b6zqyow8vgrtfj081wm.PNG" class="article-body-image-wrapper"&gt;&lt;img src="https://res.cloudinary.com/practicaldev/image/fetch/s--HI4EZ8Hj--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/0b6zqyow8vgrtfj081wm.PNG" alt="Image description" width="397" height="276"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;● &lt;strong&gt;&lt;em&gt;Worker Environment&lt;/em&gt;&lt;/strong&gt;&lt;br&gt;
○ A worker is a background process that helps applications for handling heavy resource and time-intensive operations.&lt;br&gt;
○ It is responsible for database clean up, report generation that helps to remain up and running.&lt;br&gt;
○ In the Worker Environment, Beanstalk installs a Daemon on each EC2 Instance in the Auto Scaling Group.&lt;br&gt;
○ Daemon pulls requests from the SQS queue and executes the task&lt;br&gt;
based on the message received.&lt;br&gt;
○ After execution, SQS will delete the message, and in case of failure, it will retry to send the message.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://res.cloudinary.com/practicaldev/image/fetch/s--rKz3aO3L--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/4b7fzgjrbxat2lc2j4ds.PNG" class="article-body-image-wrapper"&gt;&lt;img src="https://res.cloudinary.com/practicaldev/image/fetch/s--rKz3aO3L--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/4b7fzgjrbxat2lc2j4ds.PNG" alt="Image description" width="473" height="290"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;&lt;em&gt;Platform Supported&lt;/em&gt;&lt;/strong&gt;&lt;br&gt;
● .Net (on Linux or Windows)&lt;br&gt;
● Docker&lt;br&gt;
● GlassFish&lt;br&gt;
● Go&lt;br&gt;
● Java&lt;br&gt;
● Node.js&lt;br&gt;
● Python&lt;br&gt;
● Ruby&lt;br&gt;
● Tomcat&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;&lt;em&gt;Deployment Models:&lt;/em&gt;&lt;/strong&gt;&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;&lt;p&gt;&lt;strong&gt;All at Once&lt;/strong&gt;: Deployment will start taking place in all the instances at the same time. It means all your EC2 Instances will be out of service for a short time. Your application will be completely down for the same duration.&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;&lt;strong&gt;Rolling&lt;/strong&gt; : Deploy the new version in batches; unlike all at once, one group of instances will run the old version of the application. That means there will not be complete downtime just like all at once.&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;&lt;strong&gt;Rolling with additional batch&lt;/strong&gt; : Deploy the new version in batches. But before that, provision an additional group of instances to compensate for the updating one.&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;*&lt;em&gt;Immutable *&lt;/em&gt; : Deploy the new version to a separate group of instances, and the update will be immutable.&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;&lt;strong&gt;Traffic splitting&lt;/strong&gt; : Deploy the new version to a separate group of instances and split the incoming traffic between the older and the new ones.&lt;/p&gt;&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;&lt;strong&gt;&lt;em&gt;Pricing:&lt;/em&gt;&lt;/strong&gt;&lt;br&gt;
● Amazon will not charge you for AWS Elastic Beanstalk.&lt;br&gt;
● Instead, you will be paying for the resources such as EC2 Instance, ELB and Auto Scaling group where your application is hosted.&lt;/p&gt;

</description>
      <category>beanstalk</category>
      <category>serverless</category>
      <category>aws</category>
      <category>cloud</category>
    </item>
    <item>
      <title>Lambda@Edge</title>
      <dc:creator>Vivekanand Gujjeti</dc:creator>
      <pubDate>Thu, 19 May 2022 16:35:07 +0000</pubDate>
      <link>https://dev.to/viv92945316/lambdaedge-29k0</link>
      <guid>https://dev.to/viv92945316/lambdaedge-29k0</guid>
      <description>&lt;p&gt;● It is the feature of Amazon CloudFront which allows you to run your code&lt;br&gt;
closer to the location of Users of your application.&lt;br&gt;
● It improves performance and reduces latency.&lt;br&gt;
● Just like lambda, you don’t have to manage and provision the infrastructure around the world.&lt;br&gt;
● Lambda@Edge runs your code in response to the event created by the CDN.&lt;/p&gt;

</description>
      <category>serverless</category>
      <category>cloud</category>
      <category>aws</category>
      <category>computing</category>
    </item>
    <item>
      <title>Lambda Event</title>
      <dc:creator>Vivekanand Gujjeti</dc:creator>
      <pubDate>Wed, 18 May 2022 19:23:04 +0000</pubDate>
      <link>https://dev.to/viv92945316/lambda-event-4ng7</link>
      <guid>https://dev.to/viv92945316/lambda-event-4ng7</guid>
      <description>&lt;p&gt;Lambda Event&lt;br&gt;
● Lambda Event is an entity that invokes the lambda function.&lt;br&gt;
● Lambda supports synchronous invocation of Lambda Functions.&lt;br&gt;
● Lambda supports the following sources as an event:&lt;br&gt;
o AWS DynamoDB&lt;br&gt;
o AWS SQS&lt;br&gt;
o AWS SNS&lt;br&gt;
o CloudWatch Event&lt;br&gt;
o API Gateway&lt;br&gt;
o AWS IoT&lt;br&gt;
o Kinesis&lt;br&gt;
o CloudWatch Logs&lt;/p&gt;

</description>
      <category>serverless</category>
      <category>cloud</category>
      <category>aws</category>
      <category>lambda</category>
    </item>
    <item>
      <title>Lambda Layers</title>
      <dc:creator>Vivekanand Gujjeti</dc:creator>
      <pubDate>Sun, 15 May 2022 17:30:51 +0000</pubDate>
      <link>https://dev.to/viv92945316/lambda-layers-437n</link>
      <guid>https://dev.to/viv92945316/lambda-layers-437n</guid>
      <description>&lt;p&gt;●A Lambda layer is a container/archive which contains additional code such as libraries, dependencies, or custom runtimes.&lt;br&gt;
● AWS Lambda allows five layers in a function.&lt;br&gt;
● Layers are immutable.&lt;br&gt;
● A new version will be added if you publish a new layer.&lt;br&gt;
● Layers are by default private but can be shared and made public explicitly.&lt;/p&gt;

</description>
      <category>serverless</category>
      <category>lambda</category>
      <category>aws</category>
      <category>cloudcomputing</category>
    </item>
    <item>
      <title>Lambda Functions</title>
      <dc:creator>Vivekanand Gujjeti</dc:creator>
      <pubDate>Wed, 11 May 2022 21:30:23 +0000</pubDate>
      <link>https://dev.to/viv92945316/lambda-functions-oan</link>
      <guid>https://dev.to/viv92945316/lambda-functions-oan</guid>
      <description>&lt;p&gt;● A function is a block of code in Lambda.&lt;br&gt;
● You upload your application/code in the form of single or multiple functions.&lt;br&gt;
● You can upload a zip file, or you can upload a file from the S3 bucket as well.&lt;br&gt;
● After deploying the Lambda function, Lambda automatically monitors&lt;br&gt;
functions on your behalf, reporting metrics through Amazon CloudWatch.&lt;/p&gt;

</description>
      <category>serverless</category>
      <category>aws</category>
      <category>lambd</category>
      <category>cloud</category>
    </item>
    <item>
      <title>When do you use Lambda?</title>
      <dc:creator>Vivekanand Gujjeti</dc:creator>
      <pubDate>Wed, 11 May 2022 15:58:52 +0000</pubDate>
      <link>https://dev.to/viv92945316/when-do-you-use-lambda-1npn</link>
      <guid>https://dev.to/viv92945316/when-do-you-use-lambda-1npn</guid>
      <description>&lt;p&gt;● When using AWS Lambda, you are only responsible for your code.&lt;br&gt;
● AWS Lambda manages the memory, CPU, Network, and other resources.&lt;br&gt;
● It means you cannot log in to the compute instances or customize the&lt;br&gt;
operating system.&lt;br&gt;
● If you want to manage your own compute resources, you can use other&lt;br&gt;
compute services such as EC2, Elastic Beanstalk.&lt;br&gt;
● There will be a level of abstraction which means you cannot log in to the&lt;br&gt;
server or customize the runtime.&lt;/p&gt;

</description>
      <category>serverless</category>
      <category>cloud</category>
      <category>lambda</category>
      <category>aws</category>
    </item>
    <item>
      <title>AWS Lambda</title>
      <dc:creator>Vivekanand Gujjeti</dc:creator>
      <pubDate>Tue, 10 May 2022 16:02:11 +0000</pubDate>
      <link>https://dev.to/viv92945316/aws-lambda-322g</link>
      <guid>https://dev.to/viv92945316/aws-lambda-322g</guid>
      <description>&lt;p&gt;&lt;strong&gt;&lt;u&gt;&lt;em&gt;What is AWS Lambda?&lt;/em&gt;&lt;/u&gt;&lt;/strong&gt;&lt;br&gt;
● AWS Lambda is a &lt;strong&gt;serverless&lt;/strong&gt; compute service through which you can run your code without provisioning any Servers.&lt;br&gt;
● It only runs your code when needed and also scales automatically when the request count increases.&lt;br&gt;
● AWS Lambda follows the Pay per use principle – it means there is no charge when your code is not running.&lt;br&gt;
● Lambda allows you to run your code for any application or backend service with zero administration.&lt;br&gt;
● Lambda can run code in response to the events. Example – update in DynamoDB Table or change in S3 bucket.&lt;br&gt;
● You can even run your code in response to HTTP requests using Amazon API Gateway.&lt;/p&gt;

</description>
      <category>lambda</category>
      <category>aws</category>
      <category>serverless</category>
      <category>awscommunitybuilderprogram</category>
    </item>
    <item>
      <title>AWS Lambda</title>
      <dc:creator>Vivekanand Gujjeti</dc:creator>
      <pubDate>Mon, 09 May 2022 12:51:32 +0000</pubDate>
      <link>https://dev.to/viv92945316/aws-lambda-2hc1</link>
      <guid>https://dev.to/viv92945316/aws-lambda-2hc1</guid>
      <description>&lt;p&gt;&lt;strong&gt;&lt;u&gt;&lt;em&gt;AWS Lambda&lt;/em&gt;&lt;/u&gt;&lt;/strong&gt; is a serverless computing service that allows users to run code as functions without provisioning or managing servers.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://res.cloudinary.com/practicaldev/image/fetch/s--No3q_OFX--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/yzaxnljxa0zv7i0o6x92.JPG" class="article-body-image-wrapper"&gt;&lt;img src="https://res.cloudinary.com/practicaldev/image/fetch/s--No3q_OFX--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/yzaxnljxa0zv7i0o6x92.JPG" alt="Image description" width="733" height="366"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;&lt;u&gt;Lambda Functions supports the following languages:&lt;/u&gt;&lt;/strong&gt;&lt;/p&gt;

&lt;p&gt;&lt;a href="https://res.cloudinary.com/practicaldev/image/fetch/s--wleEpOOv--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/n6x97jlzvl9hcu7oy74s.JPG" class="article-body-image-wrapper"&gt;&lt;img src="https://res.cloudinary.com/practicaldev/image/fetch/s--wleEpOOv--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/n6x97jlzvl9hcu7oy74s.JPG" alt="Image description" width="533" height="115"&gt;&lt;/a&gt;&lt;br&gt;
&lt;strong&gt;&lt;u&gt;&lt;em&gt;Pricing details:&lt;/em&gt;&lt;/u&gt;&lt;/strong&gt;&lt;br&gt;
Charges are applied based on the number of requests for the functions and the time taken to execute the code.&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;   The memory allocated to AWS Lambda for computing is **128MB **(minimum) to **3008MB **(maximum). 
   **Additional memory** can be requested in an increment of **64MB between 128MB** **- 3008MB.**

   The **default execution time** for AWS Lambda is **3seconds**, and the maximum is **15 minutes** (**900 seconds**).
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;

</description>
      <category>serverless</category>
      <category>aws</category>
      <category>lambda</category>
      <category>cloudskills</category>
    </item>
    <item>
      <title>Querying Data in S3 with Amazon Athena</title>
      <dc:creator>Vivekanand Gujjeti</dc:creator>
      <pubDate>Sun, 08 May 2022 20:13:18 +0000</pubDate>
      <link>https://dev.to/viv92945316/querying-data-in-s3-with-amazon-athena-ged</link>
      <guid>https://dev.to/viv92945316/querying-data-in-s3-with-amazon-athena-ged</guid>
      <description>&lt;p&gt;&lt;strong&gt;&lt;u&gt;&lt;em&gt;Architecture Diagram&lt;/em&gt;&lt;/u&gt;&lt;/strong&gt;&lt;/p&gt;

&lt;p&gt;&lt;a href="https://res.cloudinary.com/practicaldev/image/fetch/s--yfmsbaMm--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/d112lhjy1div4x9q0d9g.png" class="article-body-image-wrapper"&gt;&lt;img src="https://res.cloudinary.com/practicaldev/image/fetch/s--yfmsbaMm--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/d112lhjy1div4x9q0d9g.png" alt="Image description" width="880" height="512"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;&lt;u&gt;&lt;em&gt;Task Details&lt;/em&gt;&lt;/u&gt;&lt;/strong&gt;&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;
&lt;p&gt;Log into AWS Management Console.&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;Setup workgroup&lt;/li&gt;
&lt;li&gt;Create a database in Glue.&lt;/li&gt;
&lt;li&gt;Query table in Athena&lt;/li&gt;
&lt;/ol&gt;


&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;&lt;strong&gt;&lt;u&gt;Task 1:-&lt;/u&gt;&lt;/strong&gt;&lt;br&gt;
i. Login to &lt;strong&gt;&lt;u&gt;AWS Console&lt;/u&gt;&lt;/strong&gt;&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;&lt;u&gt;Task 2:- &lt;/u&gt;&lt;/strong&gt;&lt;br&gt;
   i. Make sure you are in the &lt;strong&gt;&lt;u&gt;N.Virginia&lt;/u&gt;&lt;/strong&gt; Region.&lt;br&gt;
   ii. Navigate to menu in the top, then click on &lt;strong&gt;&lt;u&gt;Athena&lt;/u&gt;&lt;/strong&gt;. &lt;br&gt;
   iii. Click on the &lt;strong&gt;&lt;u&gt;Get started&lt;/u&gt;&lt;/strong&gt; button.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://res.cloudinary.com/practicaldev/image/fetch/s--DBenYXVe--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/43s46udasy0h39du63ad.png" class="article-body-image-wrapper"&gt;&lt;img src="https://res.cloudinary.com/practicaldev/image/fetch/s--DBenYXVe--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/43s46udasy0h39du63ad.png" alt="Image description" width="880" height="222"&gt;&lt;/a&gt;&lt;br&gt;
  iv. In the menu bar, click on &lt;strong&gt;&lt;u&gt;Workgroup:primary&lt;/u&gt;&lt;/strong&gt;.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://res.cloudinary.com/practicaldev/image/fetch/s--W9ybVA_7--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/ejxh1fmi8oeufawkzzcb.png" class="article-body-image-wrapper"&gt;&lt;img src="https://res.cloudinary.com/practicaldev/image/fetch/s--W9ybVA_7--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/ejxh1fmi8oeufawkzzcb.png" alt="Image description" width="624" height="137"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;v. To create a workgroup, Click on the &lt;strong&gt;&lt;u&gt;Create workgroup&lt;/u&gt;&lt;/strong&gt; button.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://res.cloudinary.com/practicaldev/image/fetch/s--nuOh0lAb--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/cewaym2e0qne7ick8y66.png" class="article-body-image-wrapper"&gt;&lt;img src="https://res.cloudinary.com/practicaldev/image/fetch/s--nuOh0lAb--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/cewaym2e0qne7ick8y66.png" alt="Image description" width="624" height="228"&gt;&lt;/a&gt;&lt;br&gt;
   vi. Provide details to create a workgroup:&lt;br&gt;
        - Workgroup Name: Enter &lt;strong&gt;&lt;u&gt;WhizWorkgroup&lt;/u&gt;&lt;/strong&gt;&lt;br&gt;
        - Description: Enter &lt;strong&gt;&lt;u&gt;Workgroup for Athena lab&lt;/u&gt;&lt;/strong&gt;&lt;br&gt;
        - Query result location: &lt;strong&gt;&lt;u&gt;Select the S3 bucket&lt;/u&gt;&lt;/strong&gt;, whose name is starting with &lt;strong&gt;&lt;u&gt;whizlabs&lt;/u&gt;&lt;/strong&gt;...&lt;/p&gt;

&lt;p&gt;&lt;a href="https://res.cloudinary.com/practicaldev/image/fetch/s--iEhw_HeV--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/29iijiykeoojxvayf34g.png" class="article-body-image-wrapper"&gt;&lt;img src="https://res.cloudinary.com/practicaldev/image/fetch/s--iEhw_HeV--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/29iijiykeoojxvayf34g.png" alt="Image description" width="880" height="556"&gt;&lt;/a&gt;&lt;br&gt;
       - Leave other settings as default.&lt;br&gt;
       - Click on the &lt;strong&gt;&lt;u&gt;Create Workgroup&lt;/u&gt;&lt;/strong&gt; button.&lt;/p&gt;

&lt;p&gt;vii. Now it will list all the Workgroups&lt;/p&gt;

&lt;p&gt;&lt;a href="https://res.cloudinary.com/practicaldev/image/fetch/s--fMNQsx2J--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/1w1j998e6ryx8ljobchx.png" class="article-body-image-wrapper"&gt;&lt;img src="https://res.cloudinary.com/practicaldev/image/fetch/s--fMNQsx2J--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/1w1j998e6ryx8ljobchx.png" alt="Image description" width="880" height="240"&gt;&lt;/a&gt;&lt;br&gt;
viii. Select &lt;strong&gt;&lt;u&gt;WhizWorkgroup&lt;/u&gt;&lt;/strong&gt; by checking on the option and click on the &lt;strong&gt;&lt;u&gt;Switch workgroup&lt;/u&gt;&lt;/strong&gt; button.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://res.cloudinary.com/practicaldev/image/fetch/s--bo68Cg5N--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/3pjm7oymz2kl1aamzri4.png" class="article-body-image-wrapper"&gt;&lt;img src="https://res.cloudinary.com/practicaldev/image/fetch/s--bo68Cg5N--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/3pjm7oymz2kl1aamzri4.png" alt="Image description" width="880" height="248"&gt;&lt;/a&gt;&lt;br&gt;
 ix. Now it will show the opening page, click on Get started&lt;/p&gt;

&lt;p&gt;&lt;a href="https://res.cloudinary.com/practicaldev/image/fetch/s--7SkS2RJ8--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/b2dt7lyegkdaqm6daa0w.png" class="article-body-image-wrapper"&gt;&lt;img src="https://res.cloudinary.com/practicaldev/image/fetch/s--7SkS2RJ8--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/b2dt7lyegkdaqm6daa0w.png" alt="Image description" width="880" height="222"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;x. Now you can verify your workspace.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://res.cloudinary.com/practicaldev/image/fetch/s--JQw9M6Ao--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/g5c96ypznsjk0kie46w4.png" class="article-body-image-wrapper"&gt;&lt;img src="https://res.cloudinary.com/practicaldev/image/fetch/s--JQw9M6Ao--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/g5c96ypznsjk0kie46w4.png" alt="Image description" width="880" height="111"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;&lt;u&gt;Task 3: Create a database in Glue&lt;/u&gt;&lt;/strong&gt;&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt; 1. Make sure you are in the **&amp;lt;u&amp;gt;N.Virginia&amp;lt;/u&amp;gt;** Region.
 2. Navigate to   menu at the top, then click on **&amp;lt;u&amp;gt;AWS Glue&amp;lt;/u&amp;gt;** in 
    the   section.
 3. By default, you will be able to see the **&amp;lt;u&amp;gt;tables &amp;lt;/u&amp;gt;**present. In the left sidebar, Under Data catalog, Click on **&amp;lt;u&amp;gt;Databases&amp;lt;/u&amp;gt;**.
 4. Click on the **&amp;lt;u&amp;gt;ADD DATABASE&amp;lt;/u&amp;gt;**
 5. In the pop-up menu, enter the database name as 
   **&amp;lt;u&amp;gt;whizgluedatabase &amp;lt;/u&amp;gt;**and click on the **&amp;lt;u&amp;gt;Create &amp;lt;/u&amp;gt;**button.
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;

&lt;p&gt;&lt;a href="https://res.cloudinary.com/practicaldev/image/fetch/s--LLCJe17B--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/80pbpxjntqc6m8pz9fcv.png" class="article-body-image-wrapper"&gt;&lt;img src="https://res.cloudinary.com/practicaldev/image/fetch/s--LLCJe17B--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/80pbpxjntqc6m8pz9fcv.png" alt="Image description" width="880" height="608"&gt;&lt;/a&gt;&lt;br&gt;
    6.  The database is now created.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://res.cloudinary.com/practicaldev/image/fetch/s--ReZ396VS--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/6hc443bbg6zji0xbgk59.png" class="article-body-image-wrapper"&gt;&lt;img src="https://res.cloudinary.com/practicaldev/image/fetch/s--ReZ396VS--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/6hc443bbg6zji0xbgk59.png" alt="Image description" width="880" height="206"&gt;&lt;/a&gt;&lt;br&gt;
&lt;strong&gt;&lt;u&gt;Task 4: Create a table in Glue&lt;/u&gt;&lt;/strong&gt;&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt; In the left sidebar, Under &lt;strong&gt;&lt;u&gt;Data catalog&lt;/u&gt;&lt;/strong&gt;, Click on &lt;strong&gt;&lt;u&gt;Tables&lt;/u&gt;&lt;/strong&gt;.&lt;/li&gt;
&lt;li&gt; To create a table, click on the &lt;strong&gt;&lt;u&gt;Add tables&lt;/u&gt;&lt;/strong&gt; button and select &lt;strong&gt;&lt;u&gt;Add table manually&lt;/u&gt;&lt;/strong&gt;.&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;&lt;a href="https://res.cloudinary.com/practicaldev/image/fetch/s--EUHPK11o--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/e9o9uxmi5uboz8wgq69g.png" class="article-body-image-wrapper"&gt;&lt;img src="https://res.cloudinary.com/practicaldev/image/fetch/s--EUHPK11o--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/e9o9uxmi5uboz8wgq69g.png" alt="Image description" width="880" height="226"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt; In the &lt;strong&gt;&lt;u&gt;Set up your table's properties&lt;/u&gt;&lt;/strong&gt; section, do the following:
• Enter the Table name as &lt;strong&gt;&lt;u&gt;whiz-sample-table &lt;/u&gt;&lt;/strong&gt;
• select the Database, select &lt;strong&gt;&lt;u&gt;whizgluedatabase&lt;/u&gt;&lt;/strong&gt;
• Click on the Next &lt;strong&gt;&lt;u&gt;button&lt;/u&gt;&lt;/strong&gt;.&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;&lt;a href="https://res.cloudinary.com/practicaldev/image/fetch/s--yCNNvbGX--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/6aah61gtanknyi7z4agi.png" class="article-body-image-wrapper"&gt;&lt;img src="https://res.cloudinary.com/practicaldev/image/fetch/s--yCNNvbGX--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/6aah61gtanknyi7z4agi.png" alt="Image description" width="880" height="436"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt; In the Add a data store section, do the following:
• &lt;strong&gt;&lt;u&gt;Select the type of source&lt;/u&gt;&lt;/strong&gt;: S3 (default)
• &lt;strong&gt;&lt;u&gt;Data is located in&lt;/u&gt;&lt;/strong&gt;: Specified path in my account (default)
• &lt;strong&gt;&lt;u&gt;Include path&lt;/u&gt;&lt;/strong&gt;: Select the S3 bucket name starting with &lt;strong&gt;&lt;u&gt;whizlabs&lt;/u&gt;&lt;/strong&gt;...
• Click on the &lt;strong&gt;&lt;u&gt;Next &lt;/u&gt;&lt;/strong&gt;button below to proceed further...&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;&lt;a href="https://res.cloudinary.com/practicaldev/image/fetch/s--4vg_oaRK--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/xvab1rvmgys049favb4b.jpg" class="article-body-image-wrapper"&gt;&lt;img src="https://res.cloudinary.com/practicaldev/image/fetch/s--4vg_oaRK--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/xvab1rvmgys049favb4b.jpg" alt="Image description" width="780" height="534"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt; In the &lt;strong&gt;&lt;u&gt;Choose a data format&lt;/u&gt;&lt;/strong&gt; section, do the following:
• Select Classification as &lt;strong&gt;&lt;u&gt;CSV&lt;/u&gt;&lt;/strong&gt;
• Choose delimiter as &lt;strong&gt;&lt;u&gt;Comma: ,&lt;/u&gt;&lt;/strong&gt;
• Click on the &lt;strong&gt;&lt;u&gt;Next &lt;/u&gt;&lt;/strong&gt;button.&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;&lt;a href="https://res.cloudinary.com/practicaldev/image/fetch/s--QVgNgq5m--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/tro8rwb5m7fvx6psvsvt.png" class="article-body-image-wrapper"&gt;&lt;img src="https://res.cloudinary.com/practicaldev/image/fetch/s--QVgNgq5m--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/tro8rwb5m7fvx6psvsvt.png" alt="Image description" width="880" height="541"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt; In the Define a schema section, we will add 2 columns.
• Click on the &lt;strong&gt;&lt;u&gt;ADD Column&lt;/u&gt;&lt;/strong&gt; button.
• Column name: Enter &lt;strong&gt;&lt;u&gt;Expense_Type&lt;/u&gt;&lt;/strong&gt; and Column Type: Select &lt;strong&gt;&lt;u&gt;string&lt;/u&gt;&lt;/strong&gt;
• Click on the &lt;strong&gt;&lt;u&gt;Add&lt;/u&gt;&lt;/strong&gt; button below.&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;• Click on the &lt;strong&gt;&lt;u&gt;ADD Column&lt;/u&gt;&lt;/strong&gt; button again.&lt;br&gt;
• Column name: Enter &lt;strong&gt;&lt;u&gt;Expense_Category&lt;/u&gt;&lt;/strong&gt; and Column Type: Select &lt;strong&gt;&lt;u&gt;string&lt;/u&gt;&lt;/strong&gt;&lt;br&gt;
• Click on the &lt;strong&gt;&lt;u&gt;Add&lt;/u&gt;&lt;/strong&gt; button below.&lt;br&gt;
• After adding both the columns, click on the &lt;strong&gt;&lt;u&gt;Next &lt;/u&gt;&lt;/strong&gt;button.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://res.cloudinary.com/practicaldev/image/fetch/s--lx2N_ULS--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/ypz7bprp9ukx8l70cfgt.png" class="article-body-image-wrapper"&gt;&lt;img src="https://res.cloudinary.com/practicaldev/image/fetch/s--lx2N_ULS--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/ypz7bprp9ukx8l70cfgt.png" alt="Image description" width="880" height="376"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt; Add partition indices: Leave everything as default and click on &lt;strong&gt;&lt;u&gt;Next &lt;/u&gt;&lt;/strong&gt;button.&lt;/li&gt;
&lt;li&gt; Review the configuration of the table and click on the &lt;strong&gt;&lt;u&gt;Finish &lt;/u&gt;&lt;/strong&gt;button.&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;&lt;strong&gt;&lt;u&gt;The table is now created.&lt;/u&gt;&lt;/strong&gt;&lt;/p&gt;

&lt;p&gt;&lt;a href="https://res.cloudinary.com/practicaldev/image/fetch/s--5ey2T8oe--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/7zs9kw3jdcagbwtgjx0r.png" class="article-body-image-wrapper"&gt;&lt;img src="https://res.cloudinary.com/practicaldev/image/fetch/s--5ey2T8oe--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/7zs9kw3jdcagbwtgjx0r.png" alt="Image description" width="880" height="173"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;&lt;u&gt;Task 5: Query table in Athena&lt;/u&gt;&lt;/strong&gt;&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt; Make sure you are in the &lt;strong&gt;&lt;u&gt;N.Virginia&lt;/u&gt;&lt;/strong&gt; Region.&lt;/li&gt;
&lt;li&gt; Navigate to   menu in the top, then click on &lt;strong&gt;&lt;u&gt;Athena &lt;/u&gt;&lt;/strong&gt;in the   section.&lt;/li&gt;
&lt;li&gt; Click on the &lt;strong&gt;&lt;u&gt;Get started&lt;/u&gt;&lt;/strong&gt; button, if asked.&lt;/li&gt;
&lt;li&gt; In the left sidebar, under data source, Select the database as &lt;strong&gt;&lt;u&gt;whizgluedatabase&lt;/u&gt;&lt;/strong&gt;.&lt;/li&gt;
&lt;li&gt;&lt;p&gt;Then you will see our table, &lt;strong&gt;&lt;u&gt;whiz-sample-table&lt;/u&gt;&lt;/strong&gt;.&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;To preview the data of &lt;strong&gt;&lt;u&gt;whiz-sample-table table&lt;/u&gt;&lt;/strong&gt;, select the &lt;strong&gt;&lt;u&gt;Preview table&lt;/u&gt;&lt;/strong&gt;.&lt;/p&gt;&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;&lt;a href="https://res.cloudinary.com/practicaldev/image/fetch/s--WesT0KSh--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/fmy3dw3r93sbhddr1bau.png" class="article-body-image-wrapper"&gt;&lt;img src="https://res.cloudinary.com/practicaldev/image/fetch/s--WesT0KSh--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/fmy3dw3r93sbhddr1bau.png" alt="Image description" width="880" height="591"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt; Query editor will automatically generate the SQL statement for querying the first 10 columns.&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;&lt;a href="https://res.cloudinary.com/practicaldev/image/fetch/s--katc6vVQ--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/4ac606p2lt0bommkvz06.png" class="article-body-image-wrapper"&gt;&lt;img src="https://res.cloudinary.com/practicaldev/image/fetch/s--katc6vVQ--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/4ac606p2lt0bommkvz06.png" alt="Image description" width="880" height="244"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt; The result of the query is shown below.&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;&lt;a href="https://res.cloudinary.com/practicaldev/image/fetch/s--w3rciwW8--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/diw4b713m5aen26q7gjf.png" class="article-body-image-wrapper"&gt;&lt;img src="https://res.cloudinary.com/practicaldev/image/fetch/s--w3rciwW8--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/diw4b713m5aen26q7gjf.png" alt="Image description" width="880" height="530"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt; To get the results of all expenses types under &lt;strong&gt;&lt;u&gt;expense_category&lt;/u&gt;&lt;/strong&gt; of food, paste the following SQL statement into the query editor.
• &lt;strong&gt;&lt;u&gt;SELECT * FROM "whizgluedatabase"."whiz-sample-table" where expense_category = 'Food';&lt;/u&gt;&lt;/strong&gt;
&lt;strong&gt;&lt;u&gt;Note&lt;/u&gt;&lt;/strong&gt;: To execute the queries through the keyboard directly use the shortcut &lt;strong&gt;&lt;u&gt;Ctrl + Enter (For windows) or Tab + Enter (For Mac)&lt;/u&gt;&lt;/strong&gt;
&lt;/li&gt;
&lt;li&gt; You can play around with some of the queries like:&lt;/li&gt;
&lt;li&gt; Getting a total number of rows present by running the following SQL statement in the query editor.
• &lt;strong&gt;&lt;u&gt;SELECT count(*) FROM "whizgluedatabase"."whiz-sample-table";&lt;/u&gt;&lt;/strong&gt;
&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;Once you execute this command you will get the result.&lt;/p&gt;

&lt;p&gt;Thank you.&lt;/p&gt;

</description>
      <category>serverless</category>
      <category>aws</category>
      <category>awscommunitybuilderprogram</category>
      <category>athena</category>
    </item>
    <item>
      <title>What is Amazon Athena?</title>
      <dc:creator>Vivekanand Gujjeti</dc:creator>
      <pubDate>Sat, 07 May 2022 07:47:37 +0000</pubDate>
      <link>https://dev.to/viv92945316/what-is-amazon-athena-4b46</link>
      <guid>https://dev.to/viv92945316/what-is-amazon-athena-4b46</guid>
      <description>&lt;p&gt;&lt;strong&gt;&lt;u&gt;&lt;em&gt;Amazon Athena&lt;/em&gt;&lt;/u&gt;&lt;/strong&gt; is an interactive &lt;strong&gt;&lt;u&gt;&lt;em&gt;serverless&lt;/em&gt;&lt;/u&gt;&lt;/strong&gt; service used to analyze data directly in Amazon Simple Storage Service using standard SQL ad-hoc queries.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;&lt;u&gt;&lt;em&gt;Pricing Details&lt;/em&gt;&lt;/u&gt;&lt;/strong&gt;:- &lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;Charges are applied based on the amount of data scanned by
each query at standard S3 rates for storage, requests, and data
transfer.&lt;/li&gt;
&lt;li&gt;Canceled queries are charged based on the amount of data
scanned.

&lt;ol&gt;
&lt;li&gt;No charges are applied for Data Definition Language (DDL)
statements.
4.Charges are applied for canceled queries also based on the
amount of data scanned.&lt;/li&gt;
&lt;/ol&gt;


&lt;/li&gt;
&lt;li&gt;Additional costs can be reduced if data gets compressed,
partitioned, or converted into a columnar format.&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;&lt;a href="https://res.cloudinary.com/practicaldev/image/fetch/s--mzCWkton--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/a0irer64embhgnh6cp7o.png" class="article-body-image-wrapper"&gt;&lt;img src="https://res.cloudinary.com/practicaldev/image/fetch/s--mzCWkton--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/a0irer64embhgnh6cp7o.png" alt="Image description" width="880" height="406"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;&lt;u&gt;&lt;em&gt;Functions of Athena&lt;/em&gt;:&lt;/u&gt;&lt;/strong&gt;&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;&lt;p&gt;It helps to analyze different kinds of data &lt;strong&gt;&lt;u&gt;&lt;em&gt;(unstructured, semi-structured, and structured)&lt;/em&gt;&lt;/u&gt;&lt;/strong&gt; stored in Amazon S3.&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;Using Athena, ad-hoc queries can be executed using ANSI SQL without actually loading the data into Athena.&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;It can be integrated with Amazon Quick Sight for data visualization and helps to generate reports with business intelligence tools.&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;It can be integrated with the AWS Glue Data Catalog to store metadata in Amazon S3 and offers data discovery features of AWS Glue.&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;It helps to connect SQL clients with a &lt;strong&gt;&lt;u&gt;JDBC &lt;/u&gt;&lt;/strong&gt;or an &lt;strong&gt;&lt;u&gt;ODBC &lt;/u&gt;&lt;/strong&gt;driver.&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;It executes multiple queries in parallel, so no need to worry about compute resources.&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;It supports various standard data formats, such as &lt;strong&gt;&lt;u&gt;&lt;em&gt;CSV, JSON, ORC,Avro, and Parquet&lt;/em&gt;&lt;/u&gt;&lt;/strong&gt;.&lt;/p&gt;&lt;/li&gt;
&lt;/ol&gt;

</description>
      <category>athena</category>
      <category>serverless</category>
      <category>aws</category>
      <category>awscommunitybuildersprogram</category>
    </item>
    <item>
      <title>How to apply the AWS Community Builder Program</title>
      <dc:creator>Vivekanand Gujjeti</dc:creator>
      <pubDate>Sat, 07 May 2022 07:07:02 +0000</pubDate>
      <link>https://dev.to/viv92945316/how-to-apply-the-aws-community-builder-program-emh</link>
      <guid>https://dev.to/viv92945316/how-to-apply-the-aws-community-builder-program-emh</guid>
      <description>&lt;p&gt;The AWS Community Builders program offers technical resources, mentorship, and networking opportunities to AWS technical enthusiasts and emerging thought leaders who are passionate about sharing knowledge and connecting with the technical community.&lt;br&gt;
Are you interested to join AWS builders Program? You should apply the program to build relationships with AWS product teams, AWS Heroes, and the AWS community.&lt;br&gt;
Throughout the program, AWS subject matter experts will provide informative webinars, share insights — including information about the latest services — as well as best practices for creating technical content, increasing reach, and sharing AWS knowledge across online and in-person communities. The program will accept a limited number of members per year. All AWS builders are welcome and encouraged to apply.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://res.cloudinary.com/practicaldev/image/fetch/s--vbA8JHsg--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/aht2twjweyx5p1gtqjhc.png" class="article-body-image-wrapper"&gt;&lt;img src="https://res.cloudinary.com/practicaldev/image/fetch/s--vbA8JHsg--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/aht2twjweyx5p1gtqjhc.png" alt="Image description" width="880" height="495"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;a href="https://res.cloudinary.com/practicaldev/image/fetch/s--mhZBMqMr--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/hercq0ex31i3ikie2k4g.jpg" class="article-body-image-wrapper"&gt;&lt;img src="https://res.cloudinary.com/practicaldev/image/fetch/s--mhZBMqMr--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/hercq0ex31i3ikie2k4g.jpg" alt="Image description" width="846" height="899"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;We have many category for applying the AWS community builder program. There are list of categories:-&lt;br&gt;
• Machine Learning&lt;br&gt;
• Mobile and Web Apps&lt;br&gt;
• Storage&lt;br&gt;
• Containers&lt;br&gt;
• Developer Tools&lt;br&gt;
• Management, Governance and Migration&lt;br&gt;
• Serverless&lt;br&gt;
• Gravitron / Arm Development&lt;br&gt;
• Data (Databases, Analytics, Blockchain)&lt;br&gt;
• Security, Identity &amp;amp; Compliance&lt;br&gt;
• Game Tech&lt;br&gt;
• Networking and Content Delivery&lt;br&gt;
If you want to become an AWS Community Builders application form, please join now in the cycle of Jan 2022. The application form is open until midnight PST on January 24th, so don’t wait too long to apply.&lt;br&gt;
What are the benefits of joining the AWS Community Builders program?&lt;br&gt;
• Access to AWS product &amp;amp; Services and information about new services and features&lt;br&gt;
• Mentorship from AWS subject matter experts on a variety of topics&lt;br&gt;
• AWS Promotional Credits and other helpful resources to support content creation&lt;br&gt;
• Opportunities to connect with and learn from like-minded developers&lt;/p&gt;

&lt;p&gt;you can check out more details here &lt;a href="https://lnkd.in/gMt96NuQ"&gt;https://lnkd.in/gMt96NuQ&lt;/a&gt;&lt;/p&gt;

</description>
      <category>aws</category>
      <category>cloud</category>
      <category>awscommunitybuilderprogram</category>
      <category>awsheroes</category>
    </item>
  </channel>
</rss>
