Allow per-field length declaration for varchar and char types in BI Connector
Usually in defining schemas for SQL databases, you can specify a max length for the size of a char or varchar column. It'd be nice to have the ability to do that in a schema that's passed to the mongosqld BI Connector process.
The only option now is to specify a max varchar size that applies to all varchar fields. It'd be nice to be able to define this on a per field basis.
This is an issue for a customer I'm working with because of the way their BI tool allocates memory for temporary objects created when bridging the SQL data source and their front-end app -- shorter varchars can significantly improve memory utilization and latency.
1
vote
Peter Kim
shared this idea