All Content tagged with Analytics

Hello everyone, I’m trying to create a histogram in AWS QuickSight to display my IoT data. However, every time I attempt to create a visualization, I only get options with aggregate functions (like...

Hi community, I need to store hourly and daily data for about 6,000 assets in my PostgreSQL Aurora DB. Given the scale, I plan to keep three years of daily data and three months of hourly data....

Under AWS Glue > Data Catalog > Connections > Create connection, a JDBC connection is created. Would like to test the connection, however, no IAM role is available for selection to proceed with the...

Hi there, Im reaching out with a query about Security Hub Thing is, Im a beginner with Security Hub and our company recently started the project for deploying & tracking the Security findings...

Getting this error when try to start an Athena query using Python: "Error details TABLE_NOT_FOUND: line 5:11: Table 'awsdatacatalog.athenacurcfn_c_u_r_athena.cur_athena' does not exist This query ran...

Trying to have a Glue Crawler/Athena automatically pick up a timestamp format of `yyyy-MM-dd'T'HH:mm:ss.SSS'Z'`. I have confirmed all the values in my dataset are formatted as this format, example:...

Came across the following useful documentation: https://docs.aws.amazon.com/prescriptive-guidance/latest/apache-iceberg-on-aws/best-practices-read.html#read-sort-order I have a large table where I...

We have loved the flexibility of the Athena engine, but are starting to get concerned about its instability. Recently we've identified needs to rerun major queries that return zero records the first...

Hello, we are facing a very odd issue with AWS Glue. When we run AWS Glue Crawler against the RDS Postgres v14 we get very vague error logs from CloudWatch (see below). Now, admittedly the schema is...

Hi, My Athena Query to transform the data is failing randomly with the error: Exception: Final state of Athena job is FAILED, query_execution_id is 97b49928-68f8-44e0-af7e-1fc7ec7cefcb. Error:...

The following query returns an error ``` SELECT * from UNNEST(SEQUENCE( (SELECT min(col1) from table1), current_date, INTERVAL '1' DAY )) ``` but this query works just...

We use AWS OpenSearch domain with GitLab to enable Advanced search feature. Just want to know incase of AWS OpenSearch domain down, will it impact at only indexing or other places also?