Hmm, interesting question. Since we don’t have any answers yet may I ask you a question - do you have an example of what like this could be these practises or how it can be simplified?
PS: Not sure that it can help but JdbcIO allows to set a query with “ValueProvider” option which can be helpful to parametrise your transform with values that are only available during pipeline execution and can be used for pipeline templates [1]. [1] https://cloud.google.com/dataflow/docs/guides/templates/creating-templates > On 17 Mar 2021, at 14:06, Thomas Fredriksen(External) > <[email protected]> wrote: > > Hello everyone, > > I was wondering what is considered best-practice when writing SQL statements > for the JdbcIO connector? > > Hand-writing the statements and subsequent preparedStatementSetter causes a > lot of bloat and is not very manageable. > > Thank you/ > > Best Regards > Thomas Li Fredriksen
