Associate IDs passed with custom SQL with Dataset IDs

[asmptote]

I want to associate the queries run on our Redshift cluster with the Quicksight dataset. How can I use the ID passed in the SQL code (not sure what this is called, IngestionID maybe or RequestID?) to find the dataset ID?

[ErikG]

Hi @asmptote
maybe that post similar.

How to go from a redshift SQL query back to the QS dataset that generated that query

working on a different query (not the one from above), but the arn (or guid or hash or whatever you want to call it) that is the first that you see, may not be traceable; but in the SQL (at least in this complex SQL with multiple with clauses aka CTE), there is an ARN in the SQL that maps back to something in the dataset. The SQL in redshift in the QS built portion of the SQL (that wraps our custom SQL), there is an arn that maps back to a PhyscialTableMap component as per the CLI. I used the …

BR