英文:
How to connect Apache Superset Excel Power Query for data retrieval
问题
我正在尝试通过Apache Superset将数据拉入Excel Power Query。
现在我必须：
- 运行SQL查询
- 将数据保存为
.csv文件 - 手动将这些文件导入Excel
我正在寻找一些替代方法（即更智能的方法），以自动化从Superset提取数据到Excel，类似于Power Query连接器的方式。
英文:
I am trying to pull data into Excel Power Query through Apache Superset.
Right now I have to:
- run SQL queries
- save the data to
.csvfiles - manually import these files into Excel
I'm looking for some alternative (i.e. smarter) way to automate this process of extracting data from Superset into Excel through something like Power Query connectors.
答案1
得分: 1
Apache Superset不存储任何数据，它将SQL查询发送到源数据库。直接查询源数据库会更高效。如果因某种原因必须经过Superset，您可以考虑发起API调用来获取图表数据，如在Github上讨论的这里所述。
英文:
Apache Superset doesn't store any data, it sends SQL queries to source databases. It would be more efficient for you to query the source database(s) directly.
If for some reason you must go through Superset, you could look into making API calls to fetch a chart's data, as discussed here on Github.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论