Looking for list of max character limitations for metadata, including annotations
Anyone have something they use?
Seems like OS has never provided a nice little reference like this.
Thanks in advance for anything anyone wants to share.
Forum Discussion
If you have access to SQL Server Management Studio on-premise, the table columns are defined with the properties such as Data Type and Length of what is allowed for the value in the column. For source data that is imported into OneStream through a Workflow, the data records are inserted into the StageSourceData table. This table and its columns are defined for the Data Type and Length and can be found through the Properties option. Something like this:
If you don't have access to SQL Server Management Studio either locally or through your organization, then you probably don't have access to this level of information. I would suggest creating a separate post requesting an enhancement of the OneStream Documentation team to kindly provide this level of documentation.
Just as an FYI, if you really want to see the column definitions you can use a data adapter to query something like:
SELECT *
FROM information_schema.columns
WHERE table_name = 'StageSourceData'
ORDER BY ordinal_position
SQL Server has some stored procedures that do the same thing but OneStream/data adapters seem to block them as unsafe.