How to get the number of columns in one or more athena tables
Enjoy SELECT table_name, COUNT(*) FROM information_schema.columns AS columns_number GROUP BY table_name ORDER BY 2 desc Other articles for databases geeks Using Athena …
Section
Aws
Connections
5 ways to forecast your cloud spend
5 ways to forecast your cloud spend Why do you need to forecast? In every company there is a need to plan for future flows of money, and IT is no exception. Before the …
Linux on Windows 10
Windows feature + Install Ubuntu + AWS CLI https://docs.microsoft.com/en-us/windows/wsl/about Install https://www.shellhacks.com/aws-cli-install-aws-cli-ubuntu-linux/
AWS DevOps Pro certification links
Hello techies, the following are my notes preparing for the AWS DevOps professional certification. It contains the name of the AWS services to know and some of the links …
Poor devs
The AWS approach: using the right tool for the right job, sounds great in principle, but each tool uses different standard, languages and approaches. All the connections …
Why are AWS tags useful? the rough version
Caveat Yes, I know, everyone feels they are using the tags well, but this is my article, and I’m unilaterally deciding that (for now) I’m right until you prove me wrong …
Getting today and yesterday in AWS Athena
Interesting links Using Athena from the AWS CLI on Linux Getting today in Athena Getting today in PostgreSQL How to get the metadata of AWS Athena tables Get the number …
Diary: SA Pro 2020
Happy to have re-certified, yesterday, the AWS Solution Architect Pro certification. Tough one.
The missing bit
While doing some review of the blog, I noticed that I am hiding 50% of what I do best. That is IT, AWS Cloud in particular. It is a pity because I love the topic and have …
What does a TTL of 0 means in CloudFront and an intro to CloudFront
A technical article but with simple words (I hope). In AWS words: Amazon CloudFront is a fast content delivery network (CDN) service that securely delivers data, videos, …