Help us improve the AWS re:Post Knowledge Center by sharing your feedback in a brief survey. Your input can influence how we create and update our content to better support your AWS journey.
Analytics
AWS provides the broadest selection of analytics services that fit all your data analytics needs and enables organizations of all sizes and industries reinvent their business with data. From data movement, data storage, data lakes, big data analytics, machine learning, and anything in between, AWS offers purpose-built services that provide the best price-performance, scalability, and lowest cost.
Recent questions
see all1 / 18
- Hello, I have a billing support case regarding unexpected RDS Extended Support charges (~$134). The case has remained in “Unassigned” status for over 2 weeks, and a follow-up case has the same status....
- I am unable to release an Elastic IP (EIP) in the us-east-2 (Ohio) region. When attempting to release it via the console, I receive the following error: "*Elastic IP addresses could not be released. <...
- On the case, but not limited to this origin: Origin: Aurora-postgres Destination: Redshift When a varchar/nvarchar length changes in the source table, it does not get applied to Redshift; it appears o...
- I have created the OpenSearch UI (Dashboards). While creating I haven't selected the **Single sign-on authentication** and Granted administrator's permission only for me. While Launching the Applicati...
- is it possible to configure redshift serverless query editor v2 by cdk
- PROBLEM AWS Glue Data Quality standalone evaluation runs (Data Catalog-based, not embedded in ETL) fail with AccessDeniedException from Lake Formation when accessing an Iceberg table after removing I...
- A table with approximately 1,000 rows and a primary key has been stuck in **ResyncInitiated** state for over 2 hours after triggering a refresh via `ALTER DATABASE INTEGRATION REFRESH TABLE`. T...
- Hello, I am looking for guidance regarding a billing support case that has remained unassigned for 7 days. I was charged approximately $220 (€200) for Amazon QuickSight after a free trial period exp...
- **Service and environment** * Product: Amazon EMR * Release label: emr-7.13.0 * Applications: Spark, Livy (and others as applicable) * Region: [e.g. us-east-1] * Workload: PySpark / Livy submitting Py...
- Hi everyone, We are experiencing an intermittent issue with our Amazon Aurora MySQL cluster (version: 8.0.mysql_aurora.3.08.0). During parallel execution (via AWS Lambda), some queries occasionally ...
- Hi, I am using the **Athena Neptune connector** to query an **Amazon Neptune DB** graph from **Athena**. Regular federated SQL queries against the Neptune-backed tables work correctly. For example, ...
- a cross-account AWS Lambda function needs access to Amazon Redshift that's in a different AWS account using psycopg2 VPC-based setup by cdk host used in lambda psycopg2 is redshift serverless vpc priv...
- we need to connect lambda deployed in A account to redshift serverless in B account
- We are observing inconsistent behavior with radial search (`min_score` / `max_distance`) in Amazon OpenSearch Service. ### Issue * When using only `min_score` or `max_distance`: ``` Cannot invoke "j...
- My manager wants the account name in AWS QuickSight/QuickSuite be changed from a contractor name to himself. Is this possible and how? We don't want to lose the work that has already been done creat...
- I created a Glue job in AWS Glue Studio and connected it to GitLab using a Personal Access Token (PAT). ## Behavior - Push to repository works successfully (Glue generates and commits the JSON file) -...
- I'm trying to create an Iceberg table on S3 using Athena SQL console, and it is working fine if the table is not partitioned. But I want to create a partitioned table. 1. On using the create table sy...
- Hello, We are planning to upgrade our Aurora PostgreSQL cluster from version 14.x to 17.x using Blue/Green Deployments. The minimum required version for this approach is 14.9 or later. Since our curre...
Recent Knowledge Center content
see all1 / 18
Recent articles
see all1 / 18
Jeongho KimSUPPORT ENGINEERpublished 3 days ago0 votes15 viewsWhen modifying SORTKEY or DISTKEY in production Amazon Redshift environments, teams often face a critical decision: use ALTER TABLE or CREATE TABLE AS SELECT (CTAS). This article compares both approac...
N_AgarwalEXPERTpublished 3 days ago0 votes26 viewsThis article provides practical guidance on how to safely decide whether to reduce the instance size (vertical scaling) or scale down the number of data nodes (horizontal scaling) in a 12-node Amazon ...- N_AgarwalEXPERTpublished 4 days ago0 votes60 viewsThis article provides clear guidance on how to choose the sharding strategy for an Amazon OpenSearch Service cluster with 3 data nodes. The purpose of this article is to explain, in simple and practic...
- AWS OFFICIALUpdated 4 days ago0 votes37 viewsThis article shows how organizations can use AWS Support to accelerate their compliance coverage against the Australian Cyber Security Centre (ACSC)’s Information Security Manual (ISM) framework. Note...
- Jeongho KimSUPPORT ENGINEERpublished 10 days ago0 votes44 viewsWhen monitoring Amazon MSK clusters using JMX exporter with Prometheus, you may encounter "context deadline exceeded" timeout errors on port 11001. This article explains how to identify and resolve th...
- Jatinder SinghEXPERTpublished 12 days ago2 votes43 viewsA detailed performance analysis between Amazon OpenSearch's specialized OM2 and general-purpose M7g instances to help you optimize performance and cost.
- Jatinder SinghEXPERTpublished 12 days ago0 votes28 viewsA detailed performance analysis between Amazon OpenSearch's specialized OM2 and general-purpose M7g instances to help you optimize performance and cost
- N_AgarwalEXPERTpublished 13 days ago0 votes56 viewsCustomers are securing OpenSearch domains by moving them to restricted subnets and enabling IAM authentication with Okta as the IdP via SAML. The requirement is to allow users access to OpenSearch Da...
- AmritaAWSEXPERTpublished 13 days ago0 votes22 viewsAmazon Redshift's new reusable templates for COPY operations, launched in March 2026, address a critical challenge in modern data engineering: managing repetitive data ingestion while maintaining cons...
- Jeongho KimSUPPORT ENGINEERpublished 17 days ago0 votes27 viewsWhen managing Amazon Redshift clusters, operations like disaster recovery, node type changes, or resizing are common. A key concern is whether these operations change the cluster endpoint, requiring c...
- RiteshKSinhaEXPERTpublished 18 days ago1 votes41 viewsA self-service pattern for Amazon Redshift materialized view refresh using SECURITY DEFINER stored procedures — eliminating admin bottlenecks without compromising security.
- AWS OFFICIALUpdated 18 days ago1 votes127 viewsThis article shows you how to use AWS Backup and Amazon Q for Business to transform backup compliance audits. When you use AWS Backup with Amazon Q for Business, you can analyze backup patterns across...
- Ricardo SerafimEXPERTpublished 19 days ago0 votes49 viewsAmazon Redshift defaults to UTC for all sessions. Common workarounds like SET timezone or CONVERT_TIMEZONE are session-scoped or query-scoped, making them easy to forget and leading to inconsistent re...
- Nita_SEXPERTpublished 19 days ago0 votes71 viewsApache Iceberg is an open-source table format designed to help manage and organize large-scale data stored in data lakes. it integrates seamlessly with Amazon Redshift. With this integration, Redshift...
- Ramu VaranasiEXPERTpublished 19 days ago0 votes41 viewsOrganizations managing sensitive data across heterogeneous database environments face the challenge of implementing consistent data protection strategies. Column-level data masking provides a critical...
- Anil KukkunuruEXPERTpublished 19 days ago2 votes98 viewsAmazon Aurora automatically backs up cluster volumes and retains restore data for up to 35 days at no additional cost. Snapshots taken within this window whether automated or through AWS Backup are fr...
- shubhranshuEXPERTpublished 24 days ago2 votes62 viewsI'm using the Apache Airflow REST API in my Amazon Managed Workflows for Apache Airflow (Amazon MWAA) version 3.0 environment, and some API endpoints work while others return a `{"detail": "Forbidden"...
- Jeongho KimSUPPORT ENGINEERpublished 24 days ago1 votes77 viewsThis article explains how to identify and resolve performance degradation in Amazon OpenSearch Service clusters using t2 or t3 burstable instances due to CPU credit exhaustion.
Recent selections
see all1 / 18
- Ashley LoganEXPERTpublished 6 months ago1 votes381 viewsThis spotlight on RDS Aurora MySQL equips you with the skills and troubleshooting tips to get the most out of a high-performing service.
- AWS OfficialEXPERTpublished 6 months ago0 votes299 viewsThis spotlight on Amazon OpenSearch Service equips you with the skills and troubleshooting tips to get the most out of a powerful service.
- AWS OfficialEXPERTpublished 8 months ago0 votes290 viewsThis spotlight on Amazon Redshift equips you with the skills and troubleshooting tips to get the most out of a powerful service.
- AWS OfficialEXPERTpublished a year ago0 votes425 viewsThis spotlight on AWS Glue equips you with the skills and troubleshooting tips to get the most out of a data integration service.
- published a year ago1 votes999 viewsThis spotlight on Amazon RDS for Oracle equips you with the skills and troubleshooting tips to get the most out of a powerful service.
- Henry Fuentes JrEXPERTpublished a year ago0 votes707 viewsThis spotlight on Amazon EMR equips you with the skills and troubleshooting tips to get the most out of a cloud big data platform service.
- Henry Fuentes JrEXPERTpublished 2 years ago0 votes935 viewsThis spotlight on Amazon Relational Database Service (Amazon RDS) for MySQL equips you with the skills and troubleshooting tips to get the most out of an easy-to-manage relational database service.
- Giovanni LauriaEXPERTpublished 2 years ago1 votes22.7K viewsHarnessing Real-Time Streaming for Scalable Data Processing and Analysis
- AWS OFFICIALUpdated 2 years ago0 votes184 viewsThe Cloud Intelligence Dashboards are a series of QuickSight templated dashboards built on AWS native services supported by a dedicated framework for managing access to the data. These dashboards incl...
- AWS OFFICIALUpdated 2 years ago0 votes46 viewsCloud Financial Management (CFM) is a discipline that combines tools, processes, and practices to plan, manage, and optimize cloud costs while letting enterprises innovate and scale to take advantage ...
- AWS OFFICIALUpdated 2 years ago0 votes434 viewsDo you want to optimize your Amazon RDS and Aurora PostgreSQL workloads? Explore these handpicked resources for the best practices to optimize your Amazon RDS and Aurora PostgreSQL workloads.
- AWS OFFICIALUpdated 2 years ago0 votes132 viewsDo you want to better understand your Amazon RDS and Aurora PostgreSQL workloads? Explore these curated resources for the best practices to analyze your Amazon RDS and Aurora PostgreSQL workloads.
- AWS OFFICIALUpdated 2 years ago0 votes82 viewsDo you have Amazon Aurora workloads? Are you looking to reduce your cost? Review this Selection to understand Amazon Aurora pricing, cost optimization methods, and cost and usage reporting options.
- AWS OFFICIALUpdated 2 years ago0 votes50 viewsDo you want to migrate your Amazon Aurora workloads to the AWS Cloud? Review these handpicked resources to understand your options when you migrate your Aurora workloads to AWS.
- AWS OFFICIALUpdated 8 months ago0 votes91 viewsThis selection includes a deep dive on Aurora advanced features, blue-green deployments, Aurora Serverless v2, and Aurora Global Databases.
- AWS OFFICIALUpdated 2 years ago0 votes225 viewsDo you want to optimize the performance of your Amazon Aurora MySQL-Compatible Edition databases? Review these curated resources for Amazon Aurora MySQL-Compatible Edition database best practices, per...
- AWS OFFICIALUpdated 2 years ago0 votes66 viewsAre you preparing for an Amazon Aurora MySQL-Compatible Edition database version upgrade? Review these carefully selected resources for techniques on performing the upgrade, best practices for upgrade...
- AWS OFFICIALUpdated 2 years ago0 votes45 viewsGame developers are embracing industry-wide transformation, with studios pushing the latest technology boundaries and delivering continuously updated gaming experiences that scale to tens of millions ...
1 / 18
secondabhi_aws
EXPERTUri Segev
EXPERTGiovanni Lauria
EXPERTOsvaldo Marte
EXPERTAdeleke Adebowale .J.
EXPERTGonzalo Herreros
EXPERTLeeroy Hannigan
EXPERTTushar Jagdale
EXPERTAWS-User-alantam
EXPERTIndranil Banerjee AWS
EXPERTTakahito Iwasa
EXPERTMassimilianoAWS
EXPERTFabrizio
EXPERTGunasekaran, Makendran
EXPERTThanniru Anil Kumar
EXPERTkranthi putti
EXPERT
Learn AWS faster by following popular topics
1 / 7
