Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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