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 Sep 13, 2018 8:16 AM

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,

Analytics - Bigquery - Tableau Checkout Funnel.csv.zip 834 bytes

1. Re: Converting String Date to Date Format on Google BigQuery Live Connection

Shinichiro Murakami Sep 13, 2018 8:30 AM (in response to Geoffrey Bell)

HI Geoffrey,

Some datasource does not allow dateparse/makedate type of function.
If that's the case, only the way I know of is like this link. (Very trouble some though)

Converting a string to date (10.1)

Thanks,
Shin
1 of 1 people found this helpful
Like Show 1 Likes(1)

Actions
2. Re: Converting String Date to Date Format on Google BigQuery Live Connection

Shinichiro Murakami Sep 14, 2018 12:37 PM (in response to Geoffrey Bell)

HI Geoffrey Bell

Just following up.
If you have further questions, please reply to this.
If you think problem is solved, please mark my answer as correct / helped to close the thread not from inbox but from originals post.

Thanks,
Shin
Like Show 0 Likes(0)

Actions
3. Re: Converting String Date to Date Format on Google BigQuery Live Connection

Geoffrey Bell Oct 3, 2018 6:00 AM (in response to Shinichiro Murakami)

I ended up converting my BigQuery view to using the Standard SQL syntax and cast date as such:

CAST(CONCAT(SUBSTR(date,1,4),'-',SUBSTR(date,5,2),'-',SUBSTR(date,7,2)) AS DATE) AS Date,

This ended up being a more elegant solution for me but I can see your solution working for someone. I'll mark it as correct even though it was not the solution I ended up using.
Like Show 0 Likes(0)

Actions
4. Re: Converting String Date to Date Format on Google BigQuery Live Connection

Shinichiro Murakami Oct 3, 2018 6:57 AM (in response to Geoffrey Bell)

Hi Geoffrey

Thank you for sharing!

Shin
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

Converting String Date to Date Format on Google BigQuery Live Connection

1. Re: Converting String Date to Date Format on Google BigQuery Live Connection

2. Re: Converting String Date to Date Format on Google BigQuery Live Connection

3. Re: Converting String Date to Date Format on Google BigQuery Live Connection

4. Re: Converting String Date to Date Format on Google BigQuery Live Connection

Sign In or
Create your Account

Actions

More Like This

Sign In or Create your Account

Sign In or
Create your Account