CODEWITHSUNDEEP
azure-data-factory
Dhiraj
Dhiraj

Reputation: 3696

What is the upper limit of ADF string variable?

Is there any character limit on ADF string variable ? I am trying to store a big script in ADF variable , which seems to be working fine but this is a dynamic script so I wonder if there is any storage limit to it? My use case is that based on some tabular input , I am forming a script and need to send it to some compute , I didn't find any other solution apart from using a string variable.

Upvotes: 1

Views: 3572

Answers (1)

Leon Yue
Leon Yue

Reputation: 16401

There isn't upper limit of the ADF string variable. No documents talked about it and can't find any useful messages.

But I tested and found that you can set variable value length until you get the browser SBOX_FATAL_MEMORY_EXECEEDED error. I put a 16M string to the variable value: enter image description here

You also could set a big size string as the variable value to prove that. The key is that I don't know the how to get the SBOX_FATAL_MEMORY. I googled and found nothing about it.

Hope it's useful for you.

Upvotes: 2

Related Questions