Patel Akshaykumar

Database Administration

Redshift IdP Authentication Setup using Azure Active Directory

Introduction Recently, we helped a large enterprise customer set up their data warehouse on Amazon Redshift using Azure AD for corporate credentials. This allowed users to log in with their corporate credentials, improving user experience and simplifying maintenance. We achieved this by setting up Azure AD federated access to Amazon...

23-Aug-2024

AWS, Cloud

Snapshot Migration to S3 and Extract Data from Snapshot using Athena

Introduction Sometimes We have to keep our database backup for longer retention for Security and DR Compliances in RDS. But as we know, if we have a longer backup period in RDS, it will also create more burden on the pocket, as RDS charges for storage in Normal S3 bucket format. So we can export our backup snapshots from RDS to an S3...

11-Nov-2023