Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

The Default Value For a 1073741823 V_String is ridiculous and never useful. Change it!

Who needs a 1073741823 sized string anyways?  No one, or close enough to no one.  But, if you are creating some fancy new properties in the formula tool and just cranking along and then you see that your **bleep** data stream is 9G for nine rows of data you find yourself wondering what the hell is going on.  And then, you walk your way way down the workflow for a while finding slots where the default 1073741823 value got set, changing them to non-insane sized strings, and the your data flow is more like 64kb and your workflow runs in 3 seconds instead of 30 seconds.  

 

Please set the default value for formula tools to a non-insane value that won't be changed by default by 99.99999% of use cases.  Thank you.

 

 

13 Comments
ChrisK
Alteryx
Alteryx

Thanks for the info. I'll look into it. I'm still puzzled -- the upper limit on a variable string is just a check, it shouldn't be reserving anything. That's different from a fixed string where things might be reserving that amount of space.

paulhardmanarlo
5 - Atom

Also when you try to use In DB Data Stream In to pump data in to Snowflake, it tries to create a table with a 1 billion byte column, which is obviously ridiculous...

 

Error: Data Stream In (15): Error creating table "SCHEMA.PUBLIC.MYTABLE": SQL compilation error: error line 1 at position 106Invalid character length: 1,073,741,823. Must be between 1 and 16,777,216.CREATE TABLE "SCHEMA.PUBLIC.MYTABLE" ("column1" varchar(255),"column2" varchar(1073741823),"column3" varchar(1073741823),"column4" varchar(1073741823),"Sum" NUMBER(20,0),"column5" char(64))

CristonS
Alteryx Community Team
Alteryx Community Team
Status changed to: Not Planned