我想知道我该怎么做以及这对您是否有意义。

我有一个用 Python 编写的 Dash 应用程序，其中：

1) I make the connection to my Databases (Python).
2) Perform several queries in SQL to obtain the data I need (Python). 
3) If need, manipulate the query response with Python to obtain the 
   desired metric (Python).
4) Build the plots (Python, Plotly, Dash) 

这个 Dash 应用程序在服务器上，我为此付费。

另一方面，我正在评估将此应用程序迁移到其他应用程序，将之前的项目替换为：

1) Make the connection to the databases with Google BigQuery
2) Perform the queries in SQL to obtain the data I need with Google 
   BigQuery.
3) If I need, manipulate the query response with Python to obtain the 
   desired metric. 
4) Build the plots or dashboard with Google Data Studio.

那么，有可能吗？我对每一点都有一些疑问：

1) To make the connection to my databases with Google BigQuery? Do I 
   have to migrate my datasets to Google Cloud to use them?
2) I assume that you can perform queries with SQL normally with Google 
   BigQuery, I need to do several JOINS,etc.
3) Can I add a Python script to manipulate my data in Google BigQuery?

因此，我不会有一个应用程序，而是有几个关于 Google Data Studio 的报告。