Quicksight direct query data import incorrect?

Question & Answer
, ,
1

Hi all.

I have a very weird problem. I have created a VIEW table in PostgreSQL.

I load this data table into Quicksight as a new analysis. The analysis only consist of this one table.

When I inspect the data in the preview, I saw that the values are not correct. What is even weirder is that there are additional data appearing out of no where.

For example, after loading in Quicksight, I have this row (siteA, 234, 41, 2022-09-01). This row does not exist in my VIEW table at all (I have checked many times). Furthermore, all the values does not tally against the VIEW table.

Are there some weird import error when using direct query on VIEW table?

2

Hi @dixerio,

Direct Query – To run the SELECT statement directly against the database. This means that any delay or inconsistency in the database or the view may reflect during analysis.

If the schema of your view has been modified after creating the dataset in QuickSight, it could be causing discrepancies.

Try to create a new dataset using the same view and see how it performs. Sometimes recreating the dataset can resolve potential data discrepancies caused by schema changes or incorrect caching.

Run the SQL query for your view directly in a SQL client and confirm that the data is correct.

Check your PostgreSQL logs for any query QuickSight sends. It could help identify whether an unexpected SQL statement or transformation is being applied.

Hope this helps!

3

Hello @dixerio,

I have worked with PostgresSQL and views in the past and I have not seen this behaviour.

I can only think that you might be connected to a different server, maybe a test one and that is why you are seeing the weird data?

If that is not the case, I would recommend filing a case with AWS Support where we can dive into the details so that we can help you further. Here are the steps to open a support case. If your company has someone who manages your AWS account, you might not have direct access to AWS Support and will need to raise an internal ticket to your IT team or whomever manages your AWS account. They should be able to open an AWS Support case on your behalf.

Hope this helps!

4

Hi both,

I have tested further. Rather than using VIEW, I created a materialized view instead. The materialized view import the data correctly.

I am using RDS PostgreSQL connected to Quicksight.

1 Like
5

In VIEW, does Quickright runs this query in Quicksight engine or it runs in my PostgreSQL and take the return result from the database engine?

6

Hi @dixerio

SQL Query runs directly on the PostgreSQL engine, and QuickSight retrieves the result set from the database. The query execution and processing happen entirely in your database, and QuickSight is responsible only for visualizing the returned data.