I have 2 datasets which i want to left join one of them to the other. The main one is custom SQL, the one i am joining is athena (not sure if that makes any difference). Whenever i try to create this left join, i get the following error:
And when i drag my cursor over the red error, it says ‘Something went wrong’.
Is there any reason this is happening?
Hi @HarveyB-B
Please note that custom SQL can only be applied to source tables from the same data source. Think of it as running SQL in your data warehouse, you can only join tables within the same cluster.
If you need to join tables from different sources, you should first ingest them into SPICE and then configure the join conditions within the QuickSight console. Custom SQL is not an option since the join would involve SPICE tables, and QuickSight doesn’t provide a SQL interface for SPICE.
hope this helps, mixing SPICE and custom SQL is not possible. For more complex queries, consider using tools like Redshift or Athena.
Please refer the below QuickSight documentation and community post this might be helpful for you.
