Looker Connect Training

Help Center

Documentation

Community

Cloud Certifications

Solved

User Attribute System Time Zone Update

  • 1 December 2022
  • 3 replies
  • 29 views
C

Hello:

 

Looking for thoughts on ways to mass-update user time zones in Looker.  I’ve seen other discussions like this one

stating that because time zone is a system setting, it is not able to be updated via the API.  https://developers.looker.com/api/explorer/4.0/methods/User/update_user?sdk=py&s=update+user shows that it’s not listed as an available option, either.  

 

I know that TZs are able to be updated in the UI portal, but if there are thousands of users, it becomes a very time consuming operation to update each one manually.  

icon

Best answer by CJC 7 December 2022, 01:09

View original

3 replies

C

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.  

K
Rank

Hello CJC, 

At this time there is no programatic way of updating all users timezone via API. 

However, if this helps the admin does not really have to do this for all the users.

Users themselves can click on the profile icon / photo, go to account, update their timezone and save it. 

This will update the timezone for the user globally. 

C

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 USER
SET ... 
WHERE ...

 

Reply


Terms of Service