parameters{ RegexPattern as string } source(allowSchemaDrift: true, validateSchema: false, inferDriftedColumnTypes: true, isolationLevel: 'READ_UNCOMMITTED', format: 'table') ~> SourceTable SourceTable derive(TenantPattern = toString($RegexPattern), TenantName = regexExtract( toString(byName('Comments')), toString($RegexPattern), 1)) ~> DerivedColumn1 DerivedColumn1 sink(allowSchemaDrift: true, validateSchema: false, deletable:false, insertable:true, updateable:false, upsertable:false, recreate:true, format: 'table', skipDuplicateMapInputs: true, skipDuplicateMapOutputs: true, errorHandlingOption: 'stopOnFirstError') ~> SinkTemp