Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Running pre-defined SQL script

HKR_4410
5 - Atom

Hello, I am trying to execute a pre-defined SQL script which looks something like this:

 


DEFINE CODE_PATH =C:\XYZ
DEFINE DATA_PATH =C:\XYZ\Final_Extracts

 

@"&&CODE_PATH\ALL_PARAM.sql"

 

DEFINE FRAMEWORK = HFV
@"&&CODE_PATH\ALL_HFV.sql" 

 

In above code - ALL_PARAM.sql just contains the date parameters

and ALL_VFH.sql is another script which enables the scripts that are needed to be run... Is there anyway I could run the scripts in Alteryx as I can  it in SQL developer. 

 

Any help would be much appreciated.

 

 

1 REPLY 1
Qiu
20 - Arcturus
20 - Arcturus

@HKR_4410 
I dont know much detail but maybe you can dig something with Run Command Tool?

Labels