Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!
The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

Alteryx Designer Desktop Ideas

Share your Designer Desktop 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.

 

 

14 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 Alumni (Retired)
Status changed to: Not Planned
 
JP2
7 - Meteor

We are now having workflows fail based on this issue please change and agree the default sizes are way too large.  Please change