We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

altering dataset_values table columns size

Anurag
Regular Contributor
Regular Contributor

Hi All,

We are trying to use Dataset for 1 of our requirements and we could see the max size of columns in dataset_values table is varchar(255). Is there any way we can increase this limit? 

Anurag_0-1693973831423.png

Thanks

6 REPLIES 6

DixshantValecha
Saviynt Employee
Saviynt Employee

I appreciate you reaching out to Saviynt Forums. We are investigating this and will keep you posted.

DixshantValecha
Saviynt Employee
Saviynt Employee

Please let us know more about your use case and why it is necessary to alter the size of dataset_values table columns

Hi @DixshantValecha, we want to use the dataset as lookup table to store long information like email ids, addresses, UI configurations and SQL queries.

These lookup values then can be used in placeholder we have in our backend code (connected with saviynt using native APIs) and the size of lookup value can go up to 3000 characters.

DixshantValecha
Saviynt Employee
Saviynt Employee

Hi @Anurag,

Please accept our sincere thanks for the update. We are looking into this and will keep you posted.

DixshantValecha
Saviynt Employee
Saviynt Employee

Hi @Anurag,

I appreciate your recent update. In light of the suggestion you've made, we recommend submitting this as an Enhancement Request through the Saviynt Idea Portal.

You can access the portal via the following link: Saviynt Idea Portal or by visiting ideas.saviynt.com.

Once your request has been submitted on the Ideas Portal, we kindly request that you expedite the process by engaging with a Professional Services (PS) or Customer Success Manager (CSM) representative from Saviynt who is aligned with your account. Their assistance can help ensure the prompt consideration of your enhancement request.

Please let me know if further assistance is needed on this.

Hi @Anurag,

We kindly request that you inform us of the efficacy of the recommendation provided above as a potential solution. Your feedback on whether the suggested approach has resolved the issue would be greatly appreciated. Your input is invaluable in ensuring that we address any outstanding concerns promptly and effectively. Thank you for your cooperation, and we look forward to hearing from you.