Hi Retool Support,
- I have a table in mySQL
- I have a table in BigQuery
- I need to join the mySQL table and BigQuery table in Retool. Instead of:
i. Build a mysql_query '''SELECT * FROM mysql_table''' to load the table into Retool
ii Build a bigquery_query '''SELECT * FROM bigquery_table''' to load the table into Retool
iii Build a js_query to join mysql_query and bigquery_query
is there a way to join the two tables before they flow into Retool?