Stack Overflow
Stack Overflow

Questions tagged [amazon-quicksight]

Amazon QuickSight is a product offering from Amazon that provides a "business analytics" service in order to visualize your data, perform ad hoc data analysis, and also derive useful business insights from the supplied data. Use this tag for programming questions related to Amazon QuickSight. Questions related to the usage of the product itself are not on topic for Stack Overflow.

Documentation: https://aws.amazon.com/documentation/quicksight/

783 questions
3
votes
0 answers

Amazon-Quicksight - Syntax for SQL Server CTE

I am inserting a custom SQL into QS to query my DB; the query contains a CTE and some selection from the same like below: with cte as ( ..... ) select * from cte; Whenever I run the query in QS, I get a syntax error. sourceErrorMessage:…
AltafParkar
  • 31
  • 2
3
votes
2 answers

AWS Quicksight cant see Athena DB in another region

My Athena DB is in ap-south-1 region and AWS QuickSight doesn't exist in that region. How can I connect QuickSight with Athena in that case?
Srihari Karanth
  • 2,067
  • 2
  • 24
  • 34
3
votes
1 answer

Quicksight refreshing Anomaly dashboards for real time data

Currently AWS QuickSight has an option to refresh the Dataset from S3 using scheduled refresh. Once the data is refreshed, normal dashboards (visuals chart) gets updated with new data. For Anomaly dashboards (insights chart), currently if the data…
Arvind Purohith
  • 31
  • 4
3
votes
2 answers

(Quicksight) How to Sum Values only from Unique Fields

My data set has a {Invoice No} field that I want to sum the cost of. All invoice numbers are unique and have one cost value. However, because there are multiple {Part No} fields in each {Invoice No}, Quicksight multiplies this one cost by however…
Big Chungus
  • 185
  • 1
  • 3
  • 13
3
votes
1 answer

Use one quicksight dashboard (created from one analysis) for different data sets

I have a multi-user website and each user has own data which I can store on s3. I want to integrate(embed) QuickSight to my website, in that way so each user able to see own data. I want to have one analysis to be able to modify if for all users.…
Ivan Borshchov
  • 3,036
  • 5
  • 40
  • 62
3
votes
1 answer

Error message from embedded QuickSight dashboard - what is the meaining of DatasetRulesUserDenied?

I'm embedding a QuickSight dashboard on a web page and when it loads, I get a message saying: There is an issue with your data set rules. Contact your data set owner for asssistance. Error code: DatasetRulesUserDenied I can't find any…
daktaklakpak
  • 349
  • 3
  • 10
3
votes
2 answers

Does Amazon S3 Manifest File Support Parquet Format?

According to this AWS documentation it appears that Amazon S3 does not support parquet format in the manifest file but I find this hard to believe because that's a very common file format that's used and for Athena/Redshift you are supposed to use…
Kyle Bridenstine
  • 6,055
  • 11
  • 62
  • 100
3
votes
2 answers

External View query works in athena console but fails to work when using it in aws quicksight

I am using cloudformation to create a "Virtual_View" of my table. When I use the same view to query data in AWS Athena Console it works fine and returns the data but When I try to use the same view as a dataset in AWS QuickSight(using SPICE) it…
Sohail Ali
  • 81
  • 8
3
votes
1 answer

Joining Multiple Datasets in AWS Quicksight

I'm just wondering if there is any way to join data within Amazon Quicksight. I have several data sets each created from a separate database. I was wondering if there is any way to join these data sets together. Thanks
Henry Dang
  • 179
  • 3
  • 8
3
votes
1 answer

AWS QuickSight Embedding CLI error - aws: error: argument command: Invalid choice, valid choices are:

I am trying to embed a QuickSight Dashboard and am following the current steps. https://aws.amazon.com/blogs/big-data/embed-interactive-dashboards-in-your-application-with-amazon-quicksight/ I'm at step 3 and able to assume the role and, export…
MillerC
  • 663
  • 1
  • 11
  • 26
3
votes
1 answer

Manifest for multiple JSON files in S3

I am trying to create a quicksight data source using a manifest for S3. The data at S3 is multiple JSON documents. Millions of them. I can create a dataset using a single document like this: { "fileLocations": [ { "URIs":…
Kevin
  • 3,690
  • 5
  • 35
  • 38
3
votes
1 answer

Using API to work with AWS Quicksight

I'm trying to figure out if there are any ways to integrate part of the AWS Quicksight service into our web application or site. Are there any support for embedding parts of the service in an web application or site? Or are there any support for…
Ole
  • 41
  • 10
3
votes
1 answer

Unable to Parse JSON file from S3 in AWS Quick Sight

I developed a pipeline in AWS where I collect CPU Temperature from my notebook via Python 3, send to AWS IoT Core using security protocols, a rule sends data to Cloud Watch and DynamoDB saves it. A Data Pipeline was created to save this DynamoDB…
razimbres
  • 4,715
  • 5
  • 23
  • 50
3
votes
1 answer

QuickSight - Count of active events over time

I have a event dataset in QuickSight, where each record has two date fields: startDate and endDate. An event is considered active at time T if T is between startDate and endDate. I want to build a visualization of active events over time as a line…
Tofig Hasanov
  • 3,303
  • 10
  • 51
  • 81
3
votes
3 answers

How to schedule automatic data refresh on quicksight

Is there a way to schedule automatic (periodic) data refresh on AWS Quicksight?
N.N.
  • 3,094
  • 21
  • 41
1 2 3
…
51 52