Add data source based on custom query

[zqian]

Hi,

From a cloud database, is it possible to use custom query results as data source, instead of pulling in all individual tables?

Thanks,

-Zhen

[Marc_Dillon]

Nope.

[zqian]

OK. I build a view in the database using the custom query. The view
contains 178068 records.

Now the problem is that AppSheet would timeout connecting to this view.
Should I upgrade to the Enterprise plan?

Thanks,
-Zhen

[Marc_Dillon · Accepted solution]

Try limiting the View to only a few records at first, load it into the app, then remove the limit.

You'll need an enterprise plan anyways for an app connected to a cloud database.