azeem jainulabdeen“GROUP BY” vs “WINDOW FUNCTIONS”These two queries use different SQL techniques (GROUP BY vs. WINDOW FUNCTIONS) and have distinct purposes, even though they both work with…5h ago5h ago
azeem jainulabdeeninAWS TipIs the AWS Glue Data Catalog schema-on-read or schema-on-write?AWS Glue Data Catalog follows a “schema-on-read” approach rather than “schema-on-write.”8h ago8h ago
azeem jainulabdeenPySpark (on S3) vs Redshift:When using PySpark to process data stored in Amazon S3 instead of using Amazon Redshift, you will be working in different paradigms, and…1d ago1d ago
azeem jainulabdeeninAWS TipDifferent data types in Amazon S3When storing and processing different data types in Amazon S3, the data is typically stored in file formats such as CSV, Parquet, JSON…5d ago5d ago
azeem jainulabdeenTable partitioning in RedshiftAmazon Redshift does not support native table partitioning in the same way as databases like PostgreSQL or Oracle. However, Redshift…Sep 111Sep 111
azeem jainulabdeenOnce the data is stored in S3, can we query directly without using Athena?once data is stored in Amazon S3, there are several ways to query it directly, with or without Amazon Athena. Here are some of the options:Aug 28Aug 28
azeem jainulabdeeninAWS TipIAM roles and their associated permissions are crucial in controlling who can decrypt dataIAM roles and their associated permissions are crucial in controlling who can decrypt encrypted data using AWS Key Management Service (KMS)…Aug 17Aug 17
azeem jainulabdeeninTowards DevFederated Queries in Amazon Redshift and AthenaFederated queries in Amazon Redshift and Amazon Athena allow you to query data across different data sources, including relational…Aug 9Aug 9
azeem jainulabdeenTo ensure the highest security standards on AWSScenario: when A system leverages Amazon EC2 instances for computation, AWS Lambda for data transformation, and Amazon S3 for storing raw…Aug 5Aug 5
azeem jainulabdeenAmazon Athena does not supportAmazon Athena is a powerful tool for running SQL queries on data stored in Amazon S3 using a serverless architecture, but it does have some…Jul 30Jul 30