When Apache Superset runs a query, I want to save the results to S3 so they can be further reused and not lost.
How can I configure the default output directory for Apache Superset?
Asked
Active
Viewed 1,134 times
2
-
Were you able to store and load query results from S3? – Explorer Apr 16 '21 at 00:02
1 Answers
1
Superset is a reporting tool, so the result of the queries are used for creating charts, filters, etc. For your purpose (reusing a result), I think you should have a look to Superset Cache (more info here or in the official page)
If you want to store the data in a CSV file in S3, I recommend that you use an ETL tool or a custom development (with Python for instance), but that would mean defining the view in the database level (so it can be accessed from the ETL), and then reuse the view in Superset
Carlos Moreno
- 141
- 2
- 6