LabKey Support
LabKey Support
Sign In
Home
Documentation
Support
Download
Developers
JavaScript is disabled. For the full experience enable JavaScript in your browser.
Messages
Max Column Number
General Server Forum (Inactive)
View Message
view list
print
Max Column Number
marcia hon
2017-11-27 10:58
Status: Closed
Hello,
I wish to upload a dataset. It has thousands of columns.
Please let me know what size and dimensions is possible to upload. Also, how could this be uploaded.
Thanks
Marcia
Jon (LabKey DevOps) responded:
2017-12-05 21:03
Hi Marcia,
The limitations are imposed by the database server you're using.
For PostgreSQL (
https://www.postgresql.org/about
), it's anywhere from 250 to 1600 depending on the column type per table.
For Microsoft SQL (
https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server
), it's 1024 columns per non-wide table.
If your datasource has "thousands" of columns, there would be no way to upload this data into LabKey, not without breaking up the data across multiple tables.
Regards,
Jon