'S3 to Redshift: "Unknown boolean format"

I am trying to load data from a csv file from S3 to Redshift... and it contains data as 1.0 and 0.0 . how can i process this successfully. thanks
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
