How to extract "SQL Query" that is internally run by a dataflow in OAC-Autonomous
SummaryI want to extract "SQL Query" that is internally run by a dataflow
I am using OAC-Autonomous and am running dataflows to create my visualizations. One of my data flows takes a long time to run (around 10min) and all I am doing in this dataflow is a join between two tables. Ideally the dataflow should not take less than a minute to complete. I want to extract the "SQL Query" that is internally run by this dataflow, in order to root cause, this delay in its execution.
In order to extract the "SQL Query", I enabled Session Cache in OAC and checked the logs for this dataflow run. It does'nt give the query details (though it lists the steps used in dataflow, datasets (tables) used here and also the column names in the datasets).