title: Google Big Query - loading a csv file - Error while reading table
body: <p>I'm trying to upload a report in CSV fotmat to Google Big Query.
  The report contains the following column names:</p>
  
  <blockquote>
    <p>Adjustment Type; Day; Country; Asset ID; Asset Title; Asset Labels; Asset
    Channel ID; Asset Type; Custom ID; TMS; EIDR; UPC; Season; Episode
    Title; Episode Number; Director; Studio; Owned Views; YouTube Revenue Split
    : Auction; YouTube Revenue Split : Reserved; YouTube Revenue Split :
    Partner Sold YouTube Served; YouTube Revenue Split : Partner Sold
    Partner Served; YouTube Revenue Split; Partner Revenue : Auction; Partner
    Revenue : Reserved; Partner Revenue : Partner Sold YouTube
    Served; Partner Revenue : Partner Sold Partner Served; Partner Revenue</p>
  </blockquote>
  
  <p>After creating the table for this report, the column names and types look as follows:</p>
  
  <pre><code>[
   {
     "name": "Adjustment_Type",
     "type": "STRING"
   },
   {
     "name": "Day",
     "type": "STRING"
   },
   {
     "name": "Country",
     "type": "STRING"
   },
   {
     "name": "Asset_ID",
     "type": "STRING"
   },
   {
     "name": "Asset_Title",
     "type": "STRING"
   },
   {
     "name": "Asset_Labels",
     "type": "STRING"
   },
   {
     "name": "Asset_Channel_ID",
     "type": "STRING"
   },
   {
     "name": "Asset_Type",
     "type": "STRING"
   },
   {
     "name": "Custom_ID",
     "type": "STRING"
   },
   {
     "name": "TMS",
     "type": "STRING"
   },
   {
     "name": "EIDR",
     "type": "STRING"
   },
   {
     "name": "UPC",
     "type": "STRING"
   },
   {
     "name": "Season",
     "type": "STRING"
   },
   {
     "name": "Episode_Title",
     "type": "STRING"
   },
   {
     "name": "Episode_Number",
     "type": "STRING"
   },
   {
     "name": "Director",
     "type": "STRING"
   },
   {
     "name": "Studio",
     "type": "STRING"
   },
   {
     "name": "Owned_Views",
     "type": "STRING"
   },
   {
     "name": "YouTube_Revenue_Split___Auction",
     "type": "FLOAT"
   },
   {
     "name": "YouTube_Revenue_Split___Reserved",
     "type": "FLOAT"
   },
   {
     "name": "YouTube_Revenue_Split___Partner_Sold_YouTube_Served",
     "type": "FLOAT"
   },
   {
     "name": "YouTube_Revenue_Split___Partner_Sold_Partner_Served",
     "type": "FLOAT"
   },
   {
     "name": "YouTube_Revenue_Split",
     "type": "FLOAT"
   },
   {
     "name": "Partner_Revenue___Auction",
     "type": "FLOAT"
   },
   {
     "name": "Partner_Revenue___Reserved",
     "type": "FLOAT"
   },
   {
     "name": "Partner_Revenue___Partner_Sold_YouTube_Served",
     "type": "FLOAT"
   },
   {
     "name": "Partner_Revenue___Partner_Sold_Partner_Served",
     "type": "FLOAT"
   },
   {
     "name": "Partner_Revenue",
     "type": "FLOAT"
   }
  ]
  </code></pre>
  
  <p>While trying to query the table, I'm getting the following error message: </p>
  
  <blockquote>
    <p>Could not parse 'YouTube Revenue Split : Auction' as double for field
    YouTube_Revenue_Split___Auction (position 18) starting at location 0
    (error code: invalid)</p>
  </blockquote>
  
  <p>Any idea, what could be the reason for this error?</p>