redash
redash copied to clipboard
getredash
CSV still a viable DataSource
Discussed in https://github.com/getredash/redash/discussions/6078
Originally posted by sourkidk June 4, 2023 I'm hoping to use csv files published to a url as datasource, and I can see in the documentation the syntax for how it should be done. However, there doesn't seem to be a datasource type that matches this use, and I cannot get the query to execute in other types.
Here's a link to the doc page.
https://redash.io/help/data-sources/querying/csv-excel-files
Just tested using the CSV source and query:
url: https://pkgstore.datahub.io/core/country-list/data_csv/data/d7c9d7cfb42cb69f4422dec222dbbaa8/data_csv.csv
And it works ok
There was a problem with excel and csv querys but it should have been fixed with this PR https://github.com/getredash/redash/pull/6439
There was a problem with excel and csv querys but it should have been fixed with this PR #6439
looks like the problem is still here( - https://images2.imgbox.com/0c/87/DfJfLPGA_o.png how can i avoid this error?
@kupletist, it looks like your source is of type 'Query results'
it needs to be of type CSV
Hi Rutson! But i don't have such a data source at self-hosted Redash, unfortunately - https://redash.io/help/data-sources/querying/supported-data-sources
Oh, that's odd. Also self hosted (v10.1.0). If I go to Settings then + New Data Source I see CSV as an option
Sorry for my next question: just upgraded, but how to get to Initial Setup screen? Redash throws me only to Login screen, but i need to get to the first screen, with admin setup... (can't login, cause all accounts have been deleted). maybe there is some easy way, with changing .env file, for example...
I don't know that I'm afraid, but we're definitely off topic now - maybe try https://github.com/getredash/redash/discussions/ ?
Did you use this guide? https://redash.io/help/open-source/admin-guide/how-to-upgrade. If you can't make it work you may try ,as @rutson said, to open a new discussion.