Default Record Limits on Input Data Tool for SQL Queries

Question

On the Input Data Tool, the first row for options is "Record Limit." Is there a way to default this record limit number? Is there a user preference that can be set?

For example, every time I open a new workflow and insert a Input Data tool, then the Record Limit option is set to 100 (or some other number). If I want to change the record limit or remove it, then I could change that option.

Practical purpose example, if we have a database that charges per SQL query size, then we would want the initial test queries to sample data with a record limit as a default.

Brian_Stoffel · Answer

@aliabedi - I like the ideas, but I'm looking for a default setting already setup for users. I wonder if the "Record Limits for All Inputs" can be a default user preference. For example, all inputs are set at 100 records, until the user changes to all records.

fledinku · Answer

Hello Brian,

This can be done on a workflow level following these steps:

Left-click the canvas to bring up the Workflow Configurations.

From here, you select the Runtime tab. Where it says “Record Limit for All Inputs,” you can enter the number of records that should be processed when running the workflow.

Another approach could be using the in-db tools; this ensures that the data is kept in the database and not queried to your local memory cache. That way, saving you from reoccurring costs every time you run the workflow

In-Database Overview | Alteryx Help

Hopefully this helps.