Evaluate and transform column data types If the data source does not communicate the type…