datasource add csv

[nogeek-cn]

Is your feature request related to a problem? Please describe.

Since CSV does not have a data format, there is currently no range filtering for the number format in CSV, which may be necessary.

For non-software practitioners, it is still a bit troublesome to build a MySQL or PG data source, if you can add a pre-set data type change transformation or the like to the CSV data source, so that the number column can support range queries,

this may be a good extension for Metabase users, because the barrier to entry is lower.

I need this feature as well

Describe the solution you'd like

Describe alternatives you've considered

Markenson/csv-metabase-driver#38

---

---

what can id do???

less than or grather than

How important is this feature to you?

Additional context

Markenson/csv-metabase-driver#38

[ignacio-mb]

Hi @nogeek-cn Metabase will try to match the type based on several factors (field values and field name, for example).

Can you share an example of the data in which it's not converted to the type you want? Thanks

[nogeek-cn]

Thanks ，this is file

test.csv

alse can see this data

姓名,总分,语文,数学,外语,物理,化学,道德与法治
mic,428.5,82,70,38.5,32,30,43
tom,557,98,94,71.5,61,43.5,56
james,472,88,71,56,41,32,50
hhh,44,2,45,66,77,88,99
aaaa,566,74,32,74,36,42,22

i use this driver

https://github.com/Markenson/csv-metabase-driver

---

OK

i input this file.

in metabase change clumn to Scope .

thanks

ok,

except to can filter user "less than" or "greate than"

@ignacio-mb

[paoliniluis]

I think that the problem is on the custom driver

[ignacio-mb]

It is indeed the driver, because using our new CSV upload feature I can use the proper Score (number) filters. Why are you using the driver and not the our CSV feature?

[paoliniluis]

@nogeek-cn please contact the builder of the custom driver for this