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