Hi Team. When using an SQL data source, I noticed that we have the option to point directly to a table or to a view. My data source is a MySQL table with potentially millions of rows. Most of these rows are irrelevant for any given user, so to limit sync volume I am thinking I could set up user specific views on my single data source. e.g: - User Mary would connect to view “Mary” from the data source - User John would connect to view “John” from the same data source
Then at sync time, Appsheet would only pull rows that are relevant to that user. This would have very low impact on the MySQL servers and would void the need to maintain partitioned data tables.
I am not seeing a way to do this in appsheet. Is there one? Otherwise this could be a useful feature.