Formatting a string to time on BigQuery?
<p>I've got a huge (1.5GB) CSV file, with dates in it in the format 2014-12-25. I have managed to upload it to BigQuery with the format <code>string</code> for this column. I'm wondering if I can transform this in situ to a <code>datetime</code> format, without having to download the data, parse it and send it back?</p>

<p>I have used the BigQuery GUI (newbie) but am happy to use the CLI if this will make it easier.</p>