All Content tagged with Analytics

Hey AWS team, I have one E-commerce site which has more than 3 lakh products. I can see when I list the products it takes some time around 2-3 secs. On the first page I shows 50 products, when I filt...

I am working with AWS Athena and QuickSight. I have a dataset with boolean fields, and I need to ensure that these fields remain intact as true and false instead of being converted into integers (0 an...

We have been using Redshift ra3.large type instance. We were ingesting data into the redshift via COPY JOB in redshift from S3. Suddenly, from the last few hours the CPU utilisation keeps hovering a...

So I created an Athena connector to my RDS and when I used it all tables were showing, but then I clicked on "Get started with AWS lake formation" so it created a glue catalog and the 3 schemas I have...

I'm encountering intermittent throttling exceptions when AWS Glue accesses its security configuration. Our setup involves running tens of Glue jobs concurrently across multiple workers. Initially, we ...

I have a SUPER column in redshift. Here is an example of what data in that column might look like: ``` {"message":[{"entityType":"PHONE_NUMBER","actionUsed":"DETECT","start":121,"end":133},{"enti...

Hi all, I'm trying to create a Iceberg table through Athena. The detailed S3 bucket path looks like this 's3://my_bucket/company_id={company_id}/date={YYYY-MM-DD}/data.parquet However, the 'date' ...

In order to upgrade my RDS MySQL to 8.0.40 version I got some warnings, among them is the 'mysql_native_password', stating that it'll be deprecated in future versions, so I updated the plugin to 'cach...

Hi, I use AWS QuickSight to analyze trade data. I currently use DIRECT QUERY using Athena , but as the data is growing I want to speed up my dashboards by ideally having trades younger then two months...

I am currently engaged in a data migration reconciliation process using Athena. The data consists of millions of records stored in S3 as JSON files, with multiple records potentially contained within ...

I am trying to test S3 Tables using this tutorial: Tutorial: Getting started with S3 Tables https://docs.aws.amazon.com/AmazonS3/latest/userguide/s3-tables-getting-started.html#s1-tables-tutorial-cre...

**Hi AWS Community,** I’m facing **a persistent issue while trying to delete users from Redshift database**. Despite following standard procedures and using various queries to remove dependencies, I ...