Long time since I didn’t review the news in AWS, I won’t got back to the last time, just the announcements of last, only since July.
Amazon Athena Updates
A few news for Athena, for whose who are not familiar with Athena: it’s a serverless query service. It allows you to query data stored into S3 easily and it’s natively integrated with aws glue.
Parameterized Queries:
Athena now support parameterized queries, this means you can write queries like this:
PREPARE my_query FROM
SELECT * FROM my_table WHERE year = ?
Then execute the query with:
EXECUTE my_query USING 2021
New formats:
Athena now supports:
- Apache Hudi dataset
- Write to:
- Parquet
- Avro
- ORC
- JSON
PowerBI Connector
Microsoft Power BI can now query Athena.
Amazon Redshift
Redshift is a data warehouse service, that allows to query with SQL. And the Data API now supports multi-statement queries.
This can seem mundane, but as the API allows you to start a query in one process and gather data in another process, this means you use more complex queries with the data API.
AWS AppConfig Updates
Another service I was not aware of, but I’ll really need to check on it. It’s an tool where you can configure and deploy your application.
Maybe I should create a todo list of services, and stuff I need to explore. Let’s add this to the list
Anyway, it now support to compare 2 versions of an application configuration. When you know how complicated things can get, that really looks like a good feature.
AWS Chime Updates
Chime is AWS equivalent for skype/teams/etc… It’s a super nice messaging tool.
The SDK now supports media capture for the meetings. This means you can use the SDK to record meetings, that’s really useful for technical presentations. This one might become useful for me at work.
Amazon Lightsail
This is the service used to host this website. And if now supports objects storage for static content, I won’t go too long on this one as I’ll definitely integrate this on the website next week, so expect a tutorial for this really soon.
Cloudwatch
Cloudwatch is AWS log service, it stores longs, creates metrics and alerts from it.
It’s now capable to create alerts from another account.
AWS Trainings:
AWS offers free digital courses, here are the new ones:
0 Replies to “2021-08-08 – AWS Review”