Transform input number recommended limit

Is there a transforms input number approximate limit we should avoid getting over ? I am building a union that’s meant to scale and we could potentially reach thousands of inputs. Although they will be light and I will use the union_many from transforms.verbs.dataframes, would you recommend to split the transform and union intermediate unions, or should I not worry about that ?