CSV overwrite to have larger data without having a set amount thus causing errors

Ebony Chance shared this idea ago

Idea Logged

CSV - View

When a CSV cache table is first created, it inspects the size of all the data in the CSV file and sets the database column's numeric precision accordingly. This makes sure that the columns don't have to take up more space than they need, but it has the side effect of not being editable by Yellowfin and that is where this issue comes in.

Thus when the updated value is quite a bit larger, this causes the database field to overflow and the database throws an error.

We would like to know if it is possible to allow a larger amount of data to be uploaded. Maybe we can have specific limits set through an option?