# Refresh data from bigquery **URL:** \ **Category:** Ask for Help\ **Created:** [February 10, 2023, 9:32am UTC](https://community.glideapps.com/t/refresh-data-from-bigquery/57752 "2023-02-10T09:32:55Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Larry\_engineer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/larry_engineer/32/18874_2.png) [@Larry\_engineer](https://community.glideapps.com/u/Larry_engineer)\ **Post date:** [February 10, 2023, 9:32am UTC](https://community.glideapps.com/t/refresh-data-from-bigquery/57752/1 "2023-02-10T09:32:56Z")
Is there a way to refresh the data from BigQuery automatically with the same query? ---
**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 10, 2023, 11:55pm UTC](https://community.glideapps.com/t/refresh-data-from-bigquery/57752/2 "2023-02-10T23:55:42Z")
@SantiagoPerez can you help with this question? Thank you. ---
**Author:** ![Yasin\_Hassanien](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yasin_hassanien/32/9042_2.png) [@Yasin\_Hassanien](https://community.glideapps.com/u/Yasin_Hassanien)\ **Post date:** [February 11, 2023, 4:51pm UTC](https://community.glideapps.com/t/refresh-data-from-bigquery/57752/3 "2023-02-11T16:51:52Z")
Can you explain again exactly by an example in order yo help? ---
**Author:** ![Larry\_engineer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/larry_engineer/32/18874_2.png) [@Larry\_engineer](https://community.glideapps.com/u/Larry_engineer)\ **Post date:** [February 11, 2023, 5:04pm UTC](https://community.glideapps.com/t/refresh-data-from-bigquery/57752/4 "2023-02-11T17:04:43Z")
Umm… For example, as I understand if we are using BigQuery as a data source, we are creating a query and saving a copy of the data in Glide. Any update to the data only happens in Glide. However, any update to the Bigquery dataset, as I understand, will not change the data in Glide, and I will have to manually re-query. I’m looking for ways where I can automate the process. ---
**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 11, 2023, 11:22pm UTC](https://community.glideapps.com/t/refresh-data-from-bigquery/57752/5 "2023-02-11T23:22:54Z")
I don’t have experience with this, but I think it would be a weird integration if your updates to BigQuery don’t transfer to Glide. And should it also be a 2-way sync? ---
**Author:** ![Yasin\_Hassanien](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yasin_hassanien/32/9042_2.png) [@Yasin\_Hassanien](https://community.glideapps.com/u/Yasin_Hassanien)\ **Post date:** [February 12, 2023, 7:26am UTC](https://community.glideapps.com/t/refresh-data-from-bigquery/57752/6 "2023-02-12T07:26:02Z")
Got you, Well this won’t be easy, and the only way is to do a refresh to have the data appear as the to add data it has to be done via make or a 3rd party automation such as zapier or n8n The issue is the update is not realtime in Big Data sets it has to be reloaded with every refresh or attaching a reload query action to do so while doing an back action or a certian action, and sometimes in my cases I added a refresh button for the users to refresh in order to see changes as Glide is using Firebase for realtime sync how ever bigquery and bigtables are not as they are storing huge data sets and glide only asks the DB to get only a certain data to view ---
**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:** [February 12, 2023, 11:36am UTC](https://community.glideapps.com/t/refresh-data-from-bigquery/57752/7 "2023-02-12T11:36:50Z")
Hola, I have also not worked with BigQuery as a data source in Glide, if you can share some screenshots regarding how a SQL query is constructed and fired from Glide, it would help us a lot. If there is a way to insert/use a dummy parameter in Glide’s configuration, we could use this hack while Glide launches a native tool for it. > [@Automatic Toggle Trigger bulb](https://community.glideapps.com/t/automatic-toggle-trigger/37324): > > Hola a todos! Testing an idea to get something automatic able to fire any event based on time, I could create something that I called “Automatic Toggle Trigger” (if you have a better name, go ahead… I can change it!). The idea is simple and has 5 components (columns): [image] Time: It’s the current time generated by Glide using Now() function. Due to Glide’s heartbeat is set to 10 sec, our triggers can’t be faster than 10 sec unfortunately. SECTIME: The seconds of the current day Enable T… Saludos!