Forum Discussion

kmd's avatar
kmd
Contributor
2 years ago

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.
Metadata
EricOsmanski's avatar
EricOsmanski
Valued Contributor

I am not aware of a list that current exists, but Stage Attributes are limited to 100. Annotations and Text fields don't have a max character limit, but I believe would be limited to a 2GB storage max. 

kmd's avatar
kmd
Contributor
2 years ago

Thanks very much for letting me know that! 

  • TonyToniTone's avatar
    TonyToniTone
    Contributor II
    2 years ago

    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.  

     

    • DanielWillis's avatar
      DanielWillis
      Valued Contributor
      2 years ago

      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.