All Content tagged with Analytics

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: [Erro...

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 fin...

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?

Hey everyone, I have a problem. I have an ESP32 with a BME280 sensor. I use platformIO to flash it with RTOS and publish temperature, humidity and pressure to a aws topic. I get the data on IoT Core ...

I have a use case where I need to run Batch EMR job on schedule (daily). I can make folders on date basis for my data coming from IoT. Or I can make folders for each device sending IoT data and put da...

Hi, I am looking for some advice on changing cluster from dc2.large 4 nodes to ra3.xlplus 1 node. The priority reason is more storage however this had been untouched since setup for my company a few...

We want to know display count of in app message for user endpoint. Our mobile team send custom event for increasing display count. How can we see displayed in app message count according to user endpo...

Hey everyone I am trying to query a set of JSON files in S3 with Athena and I am getting the Hive cursor error for invalid JSON even though the files in question are valid single-line JSON. Is there a...

Hi Experts, I have a requirement to get data from SAP Datasphere to amazon redshift. can any of you guide me in how to do this? I read in a blog that we need to use amazon S3 for that, but I am afrai...

Using the Facebook graph API, we can use the following query to get daily level ads data for a specific time range: https://graph.facebook.com/{ad_id}/insights?fields={field_names}&time_range={'since'...

https://www.youtube.com/watch?v=B-zZLWQcMek&t=1206s In this video, the presenter mentions that DataZone integrates with a variety of Analytics tools. I've searched the web (and asked ChatGPT) and, s...

Hi Team, I am Aware that we can disable hover on tool tip for the complete sheet while publishing in Advance option - https://docs.aws.amazon.com/quicksight/latest/user/creating-a-dashboard.html#:%7E...