# Glide Big Tables - pricing **URL:** \ **Category:** Ask for Help\ **Tags:** big-tables\ **Created:** [February 28, 2023, 12:43pm UTC](https://community.glideapps.com/t/glide-big-tables-pricing/58578 "2023-02-28T12:43:39Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![abdo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/abdo/32/36540_2.png) [@abdo](https://community.glideapps.com/u/abdo)\ **Post date:** [February 28, 2023, 12:43pm UTC](https://community.glideapps.com/t/glide-big-tables-pricing/58578/1 "2023-02-28T12:43:39Z")
How are Glide Big Tables currently priced? Every add row is an update. are there any other costs of using them? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [February 28, 2023, 1:18pm UTC](https://community.glideapps.com/t/glide-big-tables-pricing/58578/2 "2023-02-28T13:18:56Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/c/8ce355ec5c53859a0041585ef5cc5799d2649fd1.png) You must be on a Business or Enterprise plan to use it. I’m not entirely sure what they mean about the “query cost” here. Any clues @Darren_Murphy @Robert_Petitto ? > **[Glide Big Tables | Beta](https://www.glideapps.com/big-tables)** > > Get 10 million rows with Glide in one click. Build what you need without limits. ---
**Author:** ![abdo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/abdo/32/36540_2.png) [@abdo](https://community.glideapps.com/u/abdo)\ **Post date:** [February 28, 2023, 1:21pm UTC](https://community.glideapps.com/t/glide-big-tables-pricing/58578/3 "2023-02-28T13:21:40Z")
Im assuming no addition charges other than the update every time you add a row to the table if thats through an action from a glide app. Yes I’m on a business and looking to start using it soon. Was thinking of tracking user actions on the apps, but thats going to be very costly with updates ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 28, 2023, 1:21pm UTC](https://community.glideapps.com/t/glide-big-tables-pricing/58578/4 "2023-02-28T13:21:48Z")
> [@ThinhDinh](#): > > I’m not entirely sure what they mean about the “query cost” here I’m not sure either. I think this would be a question for @Sean_Martin ---
**Author:** ![Sean\_Martin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sean_martin/32/57816_2.png) [@Sean\_Martin](https://community.glideapps.com/u/Sean_Martin)\ **Post date:** [February 28, 2023, 1:36pm UTC](https://community.glideapps.com/t/glide-big-tables-pricing/58578/5 "2023-02-28T13:36:22Z")
Good question. Every time we query the data source that counts as an update. This is similar to how BigQuery works. ---
**Author:** ![abdo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/abdo/32/36540_2.png) [@abdo](https://community.glideapps.com/u/abdo)\ **Post date:** [March 26, 2023, 9:59am UTC](https://community.glideapps.com/t/glide-big-tables-pricing/58578/6 "2023-03-26T09:59:21Z")
Apologies if I’m still a bit confused. I don’t still get the big table pricing model. What is counted as a query? I have an app of 2 tabs based on 2 big tables. Orders & Order Items. The app is used to see every order & its items. There is no data update in the app. If a user searches an Order number using Glide’s built in search, would that count as a query? ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [March 26, 2023, 3:53pm UTC](https://community.glideapps.com/t/glide-big-tables-pricing/58578/7 "2023-03-26T15:53:33Z")
> [@abdo](#): > > If a user searches an Order number using Glide’s built in search, would that count as a query? I don’t think so. Instead, any query done from your APP to retrieve data will count as an update. With BT as you know, the entire data is not loaded into APP so you need to create queries to retrieve specific data and work with it. This is why there is no a rollup column (native) in this scenario for example. But just a curiosity: how many rows will your table have: 50k, 80k or 150k+ rows? If your tables are going to be used to be read-only, there are other options to do it (and cheaper I think). Saludos! ---
**Author:** ![abdo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/abdo/32/36540_2.png) [@abdo](https://community.glideapps.com/u/abdo)\ **Post date:** [March 26, 2023, 5:05pm UTC](https://community.glideapps.com/t/glide-big-tables-pricing/58578/8 "2023-03-26T17:05:59Z")
I’m planning what best options to store order history data. We have 3 main tables, Orders, Items, Bookings Tables will grow large quickly combined they will be over 150k+ rows. Currently I am splitting them into multiple Glide Tables. The app is just a user profile table and 3 big tables. So all tabs are based on the big tables only. And no other tables will query or access the data in the big tables. I don’t need the tables to update in real time or do any rollups etc…, this is past order history we only look into it when we get feedback or queries from customers. I still don’t understand though what a query is exactly or how much such a design would cost me. If i add data to the tables using the builder import feature. Will that consume or cost us anything? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [March 26, 2023, 7:11pm UTC](https://community.glideapps.com/t/glide-big-tables-pricing/58578/9 "2023-03-26T19:11:13Z")
With normal tables, Glide will load the entire dataset on the user’s device. With Big Tables, Glide can’t do that, so they have to load a small subset of the data. I don’t remember the number, but maybe up to 5k rows at once. Because it’s only a subset of the entire big table, Glide needs to re-query every time it needs to get another subset from the big table’s data. Every time it has to re-query that new subset, it counts against your update count. ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [March 26, 2023, 9:55pm UTC](https://community.glideapps.com/t/glide-big-tables-pricing/58578/10 "2023-03-26T21:55:46Z")
> [@abdo](#): > > I don’t need the tables to update in real time or do any rollups etc…, this is past order history we only look into it when we get feedback or queries from customers. if your data is marked as “historical” and does not need to be loaded into your app, you can use a service like this [sheet.best · Turn your google sheets into a REST API](https://sheet.best/#home) to consult it at any time with no problem and very fast. Only use or keep a decent amount of data (maybe 7-10 days associated working data?) to make your App lighter and when you need to check your past order history, just consult it via REST API. I hope it helps you. ---
**Author:** ![abdo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/abdo/32/36540_2.png) [@abdo](https://community.glideapps.com/u/abdo)\ **Post date:** [March 26, 2023, 11:24pm UTC](https://community.glideapps.com/t/glide-big-tables-pricing/58578/11 "2023-03-26T23:24:43Z")
Thank you. Very Interesting. Will give it a try. Are there examples or demos in the community of a glide app connecting to sheet.best to get data? ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [March 26, 2023, 11:41pm UTC](https://community.glideapps.com/t/glide-big-tables-pricing/58578/12 "2023-03-26T23:41:56Z")
Hola de nuevo, Honestly, I don’t know but I carried out my own REST API to test this idea and this was my result: [https://community.glideapps.com/t/a-google-sheet-working-as-a-rest-api-good-or-bad-idea](https://community.glideapps.com/t/a-google-sheet-working-as-a-rest-api-good-or-bad-idea) Currently, I have improved the solution and use other tricks to improve GS response time and works fine. I tested several services like _ **sheet.best** _ but in the end, sheet.best was the most versatile and robust. Saludos! ---
**Author:** ![Guy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/guy/32/55773_2.png) [@Guy](https://community.glideapps.com/u/Guy)\ **Post date:** [March 30, 2023, 6:44pm UTC](https://community.glideapps.com/t/glide-big-tables-pricing/58578/13 "2023-03-30T18:44:30Z")
I really hope they make the pricing as part of the packages and that’s it There are already too many triggers and payment restrictions It would be excessive and unprofitable ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [April 5, 2023, 3:31pm UTC](https://community.glideapps.com/t/glide-big-tables-pricing/58578/14 "2023-04-05T15:31:33Z")
> [@gvalero](#): > > With BT as you know, the entire data is not loaded into APP so you need to create queries to retrieve specific data and work with it. Hola @gvalero When you say need to create queries to retrieve specific data… do you mean with a 3rd party? Is there a way to query BT from a glide table similar to how BigQuery works as a data source? Thanks in advance. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [April 5, 2023, 3:35pm UTC](https://community.glideapps.com/t/glide-big-tables-pricing/58578/15 "2023-04-05T15:35:10Z")
Actually, that’s not correct. With Big Tables, the data is loaded as its needed, a little like a traditional client-server model. You don’t create queries, in fact there is no mechanism to do that. ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [April 5, 2023, 3:38pm UTC](https://community.glideapps.com/t/glide-big-tables-pricing/58578/16 "2023-04-05T15:38:43Z")
Ok I’m trying to understand how to replicate a filter I use in GoogleSheets… it is the last component to free myself of GSheet. Admittedly I haven’t used BigQuery. I’m just going off this screenshot which appears to load data into a glide table via a static query. ![Screen Shot 2023-04-02 at 12.10.25 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/0/1068002bbb94198043713f349fa2d74080824842.png) Perhaps I need to use BigQuery to achieve freedom from GSheet. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [April 5, 2023, 3:42pm UTC](https://community.glideapps.com/t/glide-big-tables-pricing/58578/17 "2023-04-05T15:42:54Z")
Yeah that’s Big Query, which is different to Big Tables. ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [April 5, 2023, 3:43pm UTC](https://community.glideapps.com/t/glide-big-tables-pricing/58578/18 "2023-04-05T15:43:03Z")
To be honest, I haven’t tested Glide with Big Tables but according to what I have seen in videos, you **can create queries internally**. This pic by @Eric_Penn is an example (but again, I can’t confirm if this is **optional or mandatory** ) ![Screen Shot 2023-04-02 at 12.10.25 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/0/1068002bbb94198043713f349fa2d74080824842.png) Saludos! ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [April 5, 2023, 3:48pm UTC](https://community.glideapps.com/t/glide-big-tables-pricing/58578/19 "2023-04-05T15:48:23Z")
The screenshot is from the docs about BigQuery not BT… perhaps that’s where the confusion is coming from. ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [April 5, 2023, 3:55pm UTC](https://community.glideapps.com/t/glide-big-tables-pricing/58578/20 "2023-04-05T15:55:33Z")
Ah ok! So we need to clarify all this 🥴 In fact, I swear/believe that BT is the same as BQ but Glide used a new expression to make it friendlier (like Firebase → Glide Table). [Next page](https://community.glideapps.com/t/glide-big-tables-pricing/58578.md?page=2)