Access CSV of a query result without publicly sharing


#1

Hi all,

I discovered yesterday how easy it is to access an up-to-date CSV of a metabase query when publicly sharing the question, which I for example import into a Google spreadsheet (=IMPORTDATA("http://metabaseserver.com/public/question/xxxx.csv)), without having to manually export the CSV.

Is there any way to do this without publicly sharing the question, e.g. allowing only users being logged in Metabase to retrieve the CSV?

(using Metabase 30.4, Chromium on Linux OS)

Thanks!
/Simon


#2

You can download it from the question.
image


#3

Thanks Andrew. I know about that, but that’s exactly what I don’t want to do, because it would require me to re-download the CSV every time I want to get up-to-date data.
Instead I want to use a link to the CSV results that is regenerated automatically and not stored locally.


#4

I see. If you set it to email, you’ll also receive the csv as an attachment,


#5

That will still require me to manually download the attached CSV.
In this precise case I would use this to group several Metabase results into one spreadsheet (there for sure are better tools than spreadsheets to do that, but that’s a different question!), so I can’t afford to download CSVs from multiple sources or emails every time I want to update the data in the spreadsheet.
The public sharing of CSV files beautifully allows this, is there really no way to access the CSV through a http link while being logged in on Metabase?


#6

I think you need to use the API: