About CJC

CJC · 12-16-2022

Current Looker version: 22.6.43Application Time Zone: UTCUser Specific Time Zones: EnabledDatabase: Microsoft SQL Server 2017+Database Time Zone: UTCA few questions relating to Looker time zones. When creating a dashboard, each new tile defaults to U...

User Attribute System Time Zone Update · 12-01-2022

Hello:Looking for thoughts on ways to mass-update user time zones in Looker. I’ve seen other discussions like this onehttps://community.looker.com/looker-api-77/setting-user-attribute-using-looker-api-28100stating that because time zone is a system s...

CJC · 06-30-2022

Very new to Looker. What determines the internals behind how Looker converts a filter to a datetime? For example, I have a field that’s setup in Looker as follows:dimension_group: some_start_date { type: time timeframes:[time, hour_of_day, date, week...

CJC · 12-20-2022

Doing some research and I think this link may answer the first few questions I had: https://help.looker.com/hc/en-us/articles/4420200309267-How-do-I-make-my-dashboard-timezone-listen-to-the-timezone-defined-in-my-embed-URL-Community-The last question...

CJC · 12-06-2022

For anyone who comes across this, I was able to write an update script to update each user’s timezone in the database’s user table as there were thousands of users to update and the UI wasn’t a feasible option. UPDATE USERSET ... WHERE ...

CJC · 12-02-2022

Update: What’s the best way to update user TZs through code (API, etc), as the previous note mentions it’s a system setting and there are difficulties in using the API to update that attribute.

CJC · 06-30-2022

To add to the above as I can no longer edit the original message - what is causing Looker to convert this to a DATETIME instead of a DATETIME2? Is there a minimum Looker version that supports Datetime2?

My Stats

CJC's Bio

Badges CJC Earned

Recent Activity

Dashboard / Tile Timezone Defaults

User Attribute System Time Zone Update

Date Filter CASTING

Re: Dashboard / Tile Timezone Defaults

Re: User Attribute System Time Zone Update

Re: User Attribute System Time Zone Update

Re: Date Filter CASTING