I'm working on a workbench in DI to append features and attributes to a new data model in a SQL eGDB, and I'm wondering if it's possible to create a new database version of a user selected sde connection file, and then create writers of all of the feature classes and append the features in the workbench.
What would be the correct workflow be to write to a user specified database version in a workbench?
Based on your title, I assume you mean a geodatabase version created by a database user, is that correct?
The ESRI ArcSDE format writer supports Version Type...
If the user schema exists and is configured in your sde connection file then its just a matter of configuring your Geodatabase Connection file properties in the Workbench. I don't have any user schema in my geodatabase but if I had them they will show up on the Choose SDE Version dialog.
You also have an option to configure the version on your SDE connection file within ArcGIS Pro, if you want to. This is the defauly version type on the format in Workbench.
Let me now if you have further questions.