Prompt user for value and use for sql where clause

[Matthew_Brown]

Is there a way to seed an apps data by requesting user input via prompt/form, prior to loading, and then passing that to a where clause in SQL?

Example - If I have a long sync time, or a dataset of 1 million rows (ex. sku lookup)…what is the best way to only get the necessary data in the app?

Has anyone partitioned on SQL?

I am doing an apples to apples comparison of a 17k 15 column dataset…google sheet vs. aws sql…

• google sheet is 17 seconds sync time
• sql is 29 seconds
  both of these are wide open with no security filters.