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