How to work with big query data > 100.000 rows?

Joachim_Mund · 12-01-2021 08:46 AM

Hi all,

we have a bigquery table with postcode and street which contains more than 1.000.000 rows

The app user enters the postcode and should get a dropdown list of all streets belonging to this postcode.

Unfortunately AppSheet only supports 100.000 rows which means that not all postcode/streets are available.

Is there any workaround for that issue?

Thanks and kind regards, Joachim

Marc_Dillon

Temporarily delete the data so that there are less rows. Load the Table into the app. Then put the data back.

Joachim_Mund

Thanks @Marc_Dillon I will try starting with a view having 25.000 rows.
Build the App, than change the view for more than 100.000 rows.

Joachim_Mund

Is data segmentation another option?
Do you know how to use this feature for my purpose?

Marc_Dillon

What do you mean by “data segmentation”?

Are you referring to partitions?

Joachim_Mund

I can divide my postcode / street into several datatables or views, but do not know how handle this in my case.

Joachim_Mund

this does not work, I would have wondered too

WillowMobileSys

What doesn’t work?

Joachim_Mund

Temporarily delete the data so that there are less rows. Load the Table into the app. Then put the data back.