About vfx1

vfx1 · 10-30-2020

GCS documentation states time_zone can be used as JDBC connection string parameter. Testing Bigquery connection confirms:Can connectJDBC string: jdbc:BQDriver::xxxxxxx/looker_scratch?withServiceAccount=true&...&time_zone=Asia/Kolkata&readTimeout=2400...

vfx1 · 04-29-2020

I came across the need to show a floating point coefficient in the rows and then use it in a calculation to generate a measure. Due to a known limitation of BigQuery - floats can’t be used in PARTITION BY - Looker shows an SQL error. Consider the fol...

vfx1 · 03-07-2019

Consider the following code: view: datetime { derived_table: { sql: SELECT CURRENT_DATETIME as dt;; # Bigquery dialect } dimension_group: dt { type: time timeframes: [ date, month ] sql: ${TABLE}.dt ;; datatype: datetime } } explore: datetime {} This...

vfx1 · 02-28-2022

@mohiit_jain3 - You can’t use the `dimension_group: ` syntax in this case, but you CAN create multiple `dimensions:` that have the same `group_label` value, and it will result in the same output/functionality @fabio1 Fabio, I think my hack works with...

vfx1 · 02-25-2022

@mohiit_jain3 @fabio1 Of course Fabio is right - my example was just a template assuming you have a source data of two columns - one ts (timestamp) and one bigquery compatible timezone tz (string).Then putting the following statements should worksql:...

vfx1 · 02-24-2022

I am not able to convert my UTC timestamp column to a local destination timezone using a different column in my BigQuery database. The complete scenario is, I have a column timezone in one my destination table in which I am trying to convert my curre...

vfx1 · 02-10-2022

Hi Mohit,Your field is of type “DATETIME”. Looker doesn’t really like it. You have a few potential fixes - all force looker to convert it to TIMESTAMP:if you don’t care about the timezone, declare: “datatype: date” within the dimension group if you d...

vfx1 · 06-04-2020

izzy: RSVP’ing will also grant developer access to the model. I filled the form few weeks back but didn’t get developer access. Could you pls check? Thanks.

My Stats

vfx1's Bio

Badges vfx1 Earned

Recent Activity

Looker doesn't seem to respect 'time_zone' parameter in Bigquery JDBC connection string

FLOAT can't be used as dimension in pivot tables (BigQuery)

Dimension_group w/ type "time" doesn't work with datatype: datetime for BigQuery

Re: Convert UTC to local time zone in Looker (have bigquery database)

Re: Convert UTC to local time zone in Looker (have bigquery database)

Re: Convert UTC to local time zone in Looker (have bigquery database)

Re: Date fields throwing error

Re: [RSVP] Data Explorers Guild 2: Tuesday June 16