How to reduce database connection size?

[bsharbo]

Hello everyone. We are trying to pull in a standard query for one of our business units.  The query pulls in about 5-15 rows of data for ~100 columns.

Unfortunately when put into Alteryx in a standard input data flow, and then the workflow is saved, the size of the workflow becomes 70 MB.  This is causing all kinds of problesm with Alteryx for sharing the workflow / timing / lag / memory concerns...

I tried saving the flow with just 1 record as a 'sample' by using "update sample" in the system, but it doesn't seem like the number of results are affecting the size of the Alteryx Workflow...

Does anyone have any ideas on how to make the size of the flow significantly smaller?  The only real Idea I have is to use a stored procedure to do this, however I would prefer to avoid this option if possible...

         Note: If I do build a stored procedure and call the stored proc (instead of hard-coding the query) the size of the workflow drops back to ~150 kb instead of 60 MB).

[MarqueeCrew]

I would like to see the workflow.  I've never experienced something like that.  When a workflow is large, it has been because I have stored (e.g. text input) a large amount of data or because it has a high definition jpg inside of it.  If you PM me your email address I have time in the next hour (until 4:00 pm Eastern) where I could help you via WebEx.

Thanks,

Mark

[bsharbo · Accepted solution]

It turns out it was due to white space.  The person who wrote the query and pasted it into the sql editor had hundreds of extra white space (spaces) at the end of each line of code in the query.

Turns out alteryx doesn't get rid of this white space at save time, and was turning a ~150 kb query into a 70 MB file....

So just be aware that if you want to copy a query into Alteryx, make sure to get rid of all the additional white space in the query!