About DataloopBill

DataloopBill · 03-17-2023

Hello!I have a BQ table that contains values like 10.0055858585 and 0.069872323 in a column that is a STRING type.I converted the STRING to a NUMBER and cast it as an INTEGER, but am getting an error when I try to SUM these values - which seems right...

DataloopBill · 03-10-2023

Hello!I’ve been working in Looker trying for at least an hour to try to cast this string format (in a table column in Big Query) 2023-01-06T00:00:00.000Z to a timestamp.I found examples that cover everything but how to handle the “T” and the “Z” in t...

DataloopBill · 03-20-2023

Hey all!I got a great answer from Looker Support (love these folks!)...in the first option we can also add another function such as trunc or round depending on how we want this data to be processed.Code for the examples:sql: CAST(ROUND(CAST(${string_...

DataloopBill · 03-15-2023

How about this? dimension: date { type: date_time datatype: timestamp sql: ${TABLE}.date ;; }Alternatively, you can leave type as string if you want the full string Thanks Dawid. I appreciate the assist, but that didn’t solve for my specific needs.

DataloopBill · 03-15-2023

Hey all!I got a reply from Looker Support. This works and I hope it helps others: For this case we can use this sql parameter in our date dimension, please let me know if it works for you!sql:PARSE_TIMESTAMP('%Y-%m-%dT%H:%M:%E*SZ', ${TABLE}.column);;

My Stats

NDBrowder's Bio

Badges DataloopBill Earned

Recent Activity

How do I sum values that start as strings and have decimal points

How do you handle this string 2023-01-06T00:00:00.000Z when casting as timestamp

Re: How do I sum values that start as strings and have decimal points

Re: How do you handle this string 2023-01-06T00:00:00.000Z when casting as timestamp

Re: How do you handle this string 2023-01-06T00:00:00.000Z when casting as timestamp