We are using AtScale AI-link for that purpose, it works very well as it uses AtScale capabilities to speed up querying very large data sets. But, it is not free.
Use the API to run a query. The results can be in several formats including a json representation and csv. You can see a sample here: https://github.com/looker-open-source/sdk-codegen/blob/main/examples/python/run_look_with_filters.py