Tag: aws
Data segmentation with Amazon Redshift’s NTILE(n) Function
Data segmentation is a critical aspect of data analysis, and Amazon Redshift offers a powerful tool to accomplish this task…
Exploring data percentiles with Amazon redshift’s PERCENT_RANK() function
Amazon Redshift, a powerful data warehousing solution, offers a variety of analytical functions to help you gain insights into your…
AWS : Transferring files from Amazon S3 to an external SFTP server using AWS Transfer Family
AWS Transfer Family is a fully managed service that enables the transfer of files over SFTP, FTPS, and FTP directly…
Automating AWS EC2 Instance Lifecycle with Lambda and CloudFormation: A Step-by-Step Guide
One of the most powerful features of Amazon Web Services (AWS) is the ability to automate operational tasks. In this…
EMR’s Add Steps API – An Overview
Amazon EMR’s Add Steps API is a part of Amazon EMR that allows you to add steps to a running…
AWS Glue : Handling Errors and Retries in AWS Glue
AWS Glue is a fully managed ETL service that simplifies and automates data processing tasks. While AWS Glue is designed…
Redshift : Redshift Unload getting the file as filename appended with 000 – how to get as actual filename.
Unfortunately, Redshift’s UNLOAD command appends a part number (like 000) to the output file names by default, and there’s no…
Redshift : How to check table exists in Redshift using query ?
To check if a table exists in Amazon Redshift using a query, you can use the following SQL statement: SELECT…
AWS Lambda : Export all AWS Lambda function with code in a single go using AWS CLI [For backup]
To export all AWS Lambda functions in a single Go using AWS CLI, you can use the following steps: Install…
How to SSH or connect between two AWS EC2 instance ?
You can use the SSH command to connect to another AWS EC2 instance from the command line. Here are the…
