4 Replies Latest reply on Oct 3, 2018 6:57 AM by Shinichiro Murakami

    Converting String Date to Date Format on Google BigQuery Live Connection

    Geoffrey Bell

      Anyone familiar with setting up live connections to Google BigQuery?

       

      I realize this probably doesn't sound like a difficult question but I'm hitting my head against my desk not able to figure it out.

       

      I've got a live connection with a BigQuery view and in my view I have date casting as date in this format: yyyy-mm-dd

       

      When I connect the source with Tableau it views date as a string and I have tried all of the usual methods to convert it to date but they all seem to produce NULLs for every row when I do.

       

      I've provided a sample csv with a few rows of my data but the issue is really with the live connection where certain functions MAKEDATE etc. are not available.

       

      Thanks for any help you can provide!

       

      Cheers,