Input tool - how to avoid SQL query being automatically modified

mikael_svalgaard

Hi all, in designer when I use the input tool with a SQL query and the SQL editor I often experience that Alteryx automatically adds database, schema, table names in front of the all the fields of my query. This is not needed and really expands the query text unnecessarily. An example is given below. How to avoid Alteryx doing this? thanks, Mikael

I enter this valid query:

select SERIAL_NUMBER, SLOWLOG, Max(EMISSION_ON_ID) as "MAX_EMISSION_ON_ID"
from ULTRAFAST_DEV.MSV_DEV1_EXTRACTION.LOGDATA_ANNOTATED_ANALYSIS
where (SERIAL_NUMBER = '4402' and SLOWLOG = 0 and LOG_INDEX < 111)
or (SERIAL_NUMBER = '4105' and SLOWLOG = 1 and LOG_INDEX < 222)
group by SERIAL_NUMBER, SLOWLOG

which Alteryx changes to this:

select "ULTRAFAST_DEV"."MSV_DEV1_EXTRACTION"."LOGDATA_ANNOTATED_ANALYSIS"."SERIAL_NUMBER",
"ULTRAFAST_DEV"."MSV_DEV1_EXTRACTION"."LOGDATA_ANNOTATED_ANALYSIS"."SLOWLOG",
Max("ULTRAFAST_DEV"."MSV_DEV1_EXTRACTION"."LOGDATA_ANNOTATED_ANALYSIS"."EMISSION_ON_ID") as "MAX_EMISSION_ON_ID"
from "ULTRAFAST_DEV"."MSV_DEV1_EXTRACTION"."LOGDATA_ANNOTATED_ANALYSIS"
where ("ULTRAFAST_DEV"."MSV_DEV1_EXTRACTION"."LOGDATA_ANNOTATED_ANALYSIS"."SERIAL_NUMBER" = '4402' and "ULTRAFAST_DEV"."MSV_DEV1_EXTRACTION"."LOGDATA_ANNOTATED_ANALYSIS"."SLOWLOG" = 0 and "ULTRAFAST_DEV"."MSV_DEV1_EXTRACTION"."LOGDATA_ANNOTATED_ANALYSIS"."LOG_INDEX" < 111)
or ("ULTRAFAST_DEV"."MSV_DEV1_EXTRACTION"."LOGDATA_ANNOTATED_ANALYSIS"."SERIAL_NUMBER" = '4105' and "ULTRAFAST_DEV"."MSV_DEV1_EXTRACTION"."LOGDATA_ANNOTATED_ANALYSIS"."SLOWLOG" = 1 and "ULTRAFAST_DEV"."MSV_DEV1_EXTRACTION"."LOGDATA_ANNOTATED_ANALYSIS"."LOG_INDEX" < 222)
group by "ULTRAFAST_DEV"."MSV_DEV1_EXTRACTION"."LOGDATA_ANNOTATED_ANALYSIS"."SERIAL_NUMBER", "ULTRAFAST_DEV"."MSV_DEV1_EXTRACTION"."LOGDATA_ANNOTATED_ANALYSIS"."SLOWLOG"

OTrieger

@mikael_svalgaard
Per what I know Alteryx does this for disambiguation and safety reasons, especially when using the Visual Query Builder (in the Input Data tool or In-DB tools).

Try to check the box "Open on SQL Editor tab by default" so it doesn't keep opening the visual builder.