How to connect .sql file with text input tool in Alteryx Designer

[PiyushJain]

Hi Team,

i m trying to understand one workflow,that contains multiple .sql files connected through Text input Tool.  

Please help me to understand:

1. How can i connect .sql file with Text Input Tool.

I tried to selecting/brows .Sql file via. Text input tool,but error is coming like " sql file not found".

I already refer several links, (like below) ,but no luck.

Link: 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Connect-to-a-SQL-file/td-p/154596

In addition with above..

Please let me know ,can we connect multilple .sql file using text input tool?

My workflow is like below:

Multiple. Sql files connected through text input tool then output of text input tool connected to different macros as per no.of different .sql files.

Ex.:  5 Macros for 5 .sql files.

Please help me to understand the logic.

Regards 

Piyush J

[BrandonB]

What are you trying to do with the SQL file after you bring it in? Are you just looking to read in the query text or are you looking to actually execute the query? 

You can read a SQL file into a workflow as seen below:

 

[PiyushJain]

Hi Brandon,

As per my workflow, 

I am looking to actually execute the query through text input tool. ( as seems the workflow doing the same).

Because these sql queries ( as output of text input tool) are connected to different macros and then connected with different other tools like summarize. 

Unfortunately i m not able to run complete workflow because macros are encrypted. 

So trying to understand workflow step by step.

And the first step is:  How .sql queries are connected to text input tool and proceed.

Please let me know if you need more details. 

Regards 

Piyush J

[PiyushJain]

Hi Team,

Please reply..

Regards 

Piyush J

[BrandonB]

Hi @PiyushJain 

If you need to dynamically read in queries you will need to use the dynamic input tool: https://help.alteryx.com/current/designer/dynamic-input-tool 

This tool can read in a query or values and execute those changes on runtime. 

Alternatively you may need to use a macro if you have changing schemas in the same input.