Bigquery to Retool Database


How to migrate data from Bigqyery to Retool Database, every day using workflow?

Query your BQ db, get the data, format it, insert into Retool db - are you looking for someone to provide you with the solution or are you asking if it is possible?

If someone could guide how to format the data properly while instering the data into the retool database

This really depends on what your Retool database looks like and what the data looks like you are getting from BigQuery - depending on that information it could be a simple effort or a complicated one....
Please supply actual data or at least some example data as it would be retrieved from your BQ db and provide the Retool DB specs...