Read and Execute .sql file

[Devaraj_Manimaran]

Hello All,

Please help with this.

I have a .sql file where i have sql query. i connected to  oracle db, but for now i can only copy paste the query directly into the table or query tab. how do i direct a path of my sql file, where it should read the sql query inside it and execute as output.

[Felipe_Ribeir0]

Hi @Devaraj_Manimaran 

You can use the input tool to read the query and the dynamic input tool to execute it.

Solved: Connect to a .SQL file - Alteryx Community

[Devaraj_Manimaran]

I did as you said. but please find the below screenshots, i have error saying no tables chosen. should i change something?

[apathetichell · Accepted solution]

Swap from "Read list of data sources" to modify "SQL query" (the lower radio button). Use your field as your query.

[Felipe_Ribeir0 · Accepted solution]

Hi @Devaraj_Manimaran 

Check the attached workflow

1)I am reading the query with the input tool

2)I used the summarize tool to turn it all in 1 cell

3)I used the bellow config to replace the embedded query of the dynamic tool for the one that came from the summarize tool

[Devaraj_Manimaran]

Thanks, now it makes sense. 😊