Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
How to extract "SQL Query" that is internally run by a dataflow in OAC-Autonomous — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to extract "SQL Query" that is internally run by a dataflow in OAC-Autonomous

Received Response
39
Views
4
Comments
edited Dec 24, 2019 4:41PM in Oracle Analytics 4 comments

Summary

I want to extract "SQL Query" that is internally run by a dataflow

Content

Hello,

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).

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!