Inspire EMEA 2022 On-Demand is live! Watch now, and be sure to save the date for Inspire 2023 in Las Vegas next May.

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

Input/Dynamic Input options for .yxdb and other local files

I have several .yxdb files that I’ve been appending to daily from a SQL Server table in order to extend the length of time that data is retained.

They’re massive tables, but I may only need one or two rows. 

I had hoped to decrease the time it takes to get data from them by running a query on them (or a dynamic query/input) as opposed to using a filter or joining on an existing data set which would have equal values that would produce the same result as a filter.

Essentially, the input of .yxdb would have the option of inputting the full table or a SQL query just like a data connection.

2 Comments
Ned
Alteryx Alumni (Retired)
YXDB is designed for fast simple interchange of data and has no indexes. It is really just meant to be a better CSV file. You should take a look at using SQLite files for your needs. It supports exactly what you are asking for.
Community_Admin
Alteryx
Alteryx
Status changed to: Inactive