ODBC view - maximum number of fields


I’m creating an odbc view on one of our objects with lots of properties/attributes/relationships.

It looks like I’m limited to creating a view with a maximum of 55 fields. Is this correct or is something going wrong? I can’t find it mentioned in any docs that I’ve looked at.



Hi, we have come across this too. We just created multiple views to cope with big data objects.


This limit is correct, we are limited on the size of the View by the underlying database architecture.

As Kevin mentioned, for wider datasets you may need to divide into two or more Views.

Great. Thanks Kevin and Bob. I suspected it was a limitation but because I couldn’t find it in any documents I wasn’t 100% sure.