Is there a way to run the SQL query from local machine (file location) rather than mentioning SQL- query in Data Files location?

Archive
1

I have more than 50 sql queries to execute and validate source and target table validation.
Have already done the automation for some of the queries using Data Files concept.

Seems to be there is always change in mapping doc for Source and Target tables. I need to update the SQL - query as well for the changes.

if the sql file in common location in local system so no need to update in Data Files.

So i would like to know how can i do the process of SQL file call function in Katalon?

2

hello,
put SQL selects in excel or where you want, you cant access thid file to read thru all rows to get your selects
here you can find way how to connect to DB and execute queries
https://docs.katalon.com/katalon-studio/tutorials/connect_db_gui_testing.html

3