Questions tagged with Analytics

Hi, I used Quicksight for visualizations for my IoT data, I'm not able to see the raw data variation with the time , other than that all statistical things like Sum, Min, Avg I am able to see. I need help on how to just plot the raw data?lg...

Hi folks , got the below error while running query in athena editor after triggering crawler SYNTAX_ERROR: line 1:8: SELECT * not allowed from relation that has no columns This query ran against the "demodb" database, unless qualified by the query **Note** : the table got populated in the workgroup but when I try to preview table it should run the query but got the syntax error , Any help would be great , Thankslg...

I assume that the date range specified in the Analytics/usage page applies to funnels output. What I found is that irrespective of the date range, funnels output is always the same. What am I missing?lg...

I have a set of files in my S3 bucket which have a delimiter ASCII 31 (unit separator). I am using a crawler to read these files and create the tables in AWS Glue catalog. I tried using the custom delimiter in the classifiers but with no luck since this is a non-printable character. What is the best way to incorporate this delimiter within a crawler?lg...

Is it a best practice to create multiple SPICE databases for a single analysis and dashboard creation? Will this add significant monthly cost compared to creating only 1 big SPICE database?lg...

**Use Case: Cleanup old telemetry data from very Big DynamoDb table based on timestamp which is older then 90 days** **Date Size: 750 GB ( Ireland + Ohio + Beijing ) Item Count : 5000 million records** *Sample Data:* ``` { "deviceid": "a00a940c-b804-4806-a14f-7c713964fc65", "timestamp": 1661521317, "notifications": false, "payload": [ { "n": "temprature", "v": "20" }, { "n": "humidity", "v": "91" } ] } ``` > **Goal: Needs to clean-up stale data from DynamoDB table which is older than 90 days by keeping cost as low as possible**lg...

Hi everyone, We have a Mobile SAAS APP where each AWS tenant can share their Mobile Sensors data on to AWS and inside the App, they can view their respective sensor data onto series of individual tile reports. We are leveraging AWS IOT and site wise and need to choose a dashboard tool for creating Reports for Sensor data, My Analysis on this is we should consider embed analytics which I think is only available with Quick Sight as we will be showing reports on to the APP with each Users respective data, My Questions are: 1) Can we use any other tool within AWS like Grafana or site wise also provide Portal to create reports and embed them in our APP with data row level security. 2) If we use Quick Sight embed, how can we make sure each User will see its respective data. Thank you and will appreciate for your reply.lg...

Hi, I cannot get data from IoT Analytics Channel to the Analytics datastore. I'm able to get the messages in Channel from IoT Core; kindly help me with this. I suspect pipeline is not excecuting.lg...

Dear friends, Greetings. I need help with a project in Quicksight that was delegated to me. I have the budget for 2023, where I have to add month by month the amounts spent. But I have not been able to find a way to add up the months to today. I have the following table in Quicksight, the idea is that at the end of the current month it shows the sum of the previous months. I have been thinking about a kpi, I don't know if it is the right one. lg...

hi, has the on road safety dashboard been depreciated if so, what alternate link can be used to view the data, thank youlg...

I receive the error: "Failed to start notebook server" when creating a Jupyter notebook in AWS Gluelg...

Hello, I have Change Capture Data landing into a S3 bucket. The CDC data is from an AWS RDS. This is my starting point. Now, let's say, I have tables taba, tabb, tabc. I have the 3 folders for each table and all the CDC data is segregated per table in these folders. Now I must create another bucket, that will only hold the latest data. so in taba folder, if I had rows with 10 inserts , 10 updates and 3 deletes. How do I bring it to a state of finalization in the new bucket, meaning I should only have the latest data?lg...