At AWS re:Invent 2016, Amazon announced Amazon Athena, a query service allowing you to execute SQL queries on your data stored in Amazon S3. Athena can query against CSV files, JSON data, or row data parsed by regular expressions. Using Amazon Athena, you don’t need to extract and load your data into a database to perform queries against your data.
Amazon Athena is not a full CRUD database system. It can only query data. So you basically can only perform
SELECT queries on your data in S3. You cannot execute any
We wanted to do some experimenting with Athena to see what it can do.
Whether you are a small AWS user or a large enterprise, security and auditing should be front-of-mind when it comes to your AWS account.
AWS CloudTrail provides a way to record all AWS API calls. Logs are saved to an Amazon S3 bucket for you. You can read and process the logs yourself, or you can use one of the many third-party tools and services available to you.
Today, we’re happy to announce a new action available to you: Create CloudTrail Trails.
This week is AWS re:Invent. It’s bigger than ever, spanning 3 hotels: The Venetian, The Mirange, and The Wynn & Encore. So make sure you have some good walking shoes.
As you’re walking around AWS re:Invent this year, you’ll notice different coloured lanyards holding everyone’s badges. Ever wondered what the different colours mean? Here’s the list.
AWS Directory Service is a managed Microsoft Active Directory solution. Using this service, you can manage the identities for your organization, and by joining EC2 instances to your directory domain, authorize access to your AWS resources.
AWS Elastic Beanstalk is a deployment service for your web applications. By configuring your Elastic Beanstalk environment, AWS can manage the scaling and high-availability for your web application. Supported environments include NodeJS, Ruby, and .NET, among others.
If you have an existing .NET application, or are building one that utilizes “Windows Authentication”, you can deploy your application using Elastic Beanstalk, and use Directory Service as your Windows authentication directory.
Ideally, we would implement this combination using off-the-shelf Elastic Beanstalk AMI images. However, due to an issue with Elastic Beanstalk hostnames being re-used, we’ll need to create a custom AMI image to be used by our Elastic Beanstalk applications.
The custom AMI will only address the hostname issue. This way, once AWS fixes it on their end, the custom AMI can be done away with.
We have employed these techniques in our own internal applications and we wanted to share them with anyone else who wanted to do the same.
This article will walk you through these steps:
Today, we are excited to unveil Action Exclusions. Action Exclusions are a way to exclude certain AWS resources from being acted upon by Skeddly actions. This allows you to take a subset of your AWS resources out of Skeddly control for a short or long period of time.
For example, you can exclude an EC2 instance from being stopped by Skeddly for the next 12 hours.
Identity Federation is the ability to access Service Providers (such as Skeddly) using an existing Identity Provider (such as Active Directory Federation Services). It uses your existing users when accessing the Service’s resources, and eliminates the need to provision new user credentials for the Service Provider.
Today, we’re happy to announce that you can now use your existing SAML 2.0 compliant Identity Providers to access your Skeddly accounts.
For the second year, we’re excited to be sponsoring AWS re:Invent in Las Vegas.
Where: AWS re:Invent 2016, Booth #919
When: November 28 - December 2, 2016
This year’s event is expected to be bigger and better than last year’s. There is an entire extra day of sessions, a bigger expo, and the return of “reserved seating” (ooooooooh).
Skeddly will be at booth #919 in the expo hall not far from the main AWS booth. Stop by the booth to:
Skeddly includes an action called “Delete EBS Snapshots” which can be used to remove old EBS snapshots based on matching criteria and minimum age. It can also ensure that a minimum number of EBS snapshots are preserved.
Today, we’ve made two new enhancements to this action available:
Security groups are a fundamental building block of your AWS account. Using security groups, you can permit access to your instances for the right people. Misusing security groups, you can allow access to your databases for the wrong people.
Using Skeddly’s “Add EC2 Security Group Rule” action, you can automatically add and revoke security group rules based on your desired schedule.
For many AWS customers, Skeddly has become a cornerstone tool in reducing AWS costs. One key method they’re using to reduce their AWS costs is by stopping their EC2 instances at times when the EC2 instances are not needed. Using Skeddly’s reliable scheduling system, they can start the instances in the morning, and stop them in the evening.
Skeddly includes many actions that can be used to stop and restart your EC2 instances:
Any of these actions can be used to reduce your AWS costs. The actions you choose to use depend on your desired workflow.
Until now, if you wanted to both start and stop your EC2 instances with a single action, you would use one of the “Start” actions. However, what if your desired workflow were to stop the instance at key times. Using the “Start” actions may work, but they may not be the exact fit for your workflow.
We have enhanced our “Stop EC2 Instance” and “Stop Multiple EC2 Instances” actions to better fit some workflows.