This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

User Attribute System Time Zone Update

Posted on 12-01-2022 08:50 AM
CJC
New Member
Reply posted on --/--/---- --:-- AM

Hello:

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

https://community.looker.com/looker-api-77/setting-user-attribute-using-looker-api-28100

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.  

Solved Solved
0 3 275
Topic Labels
Jump to Solution
0 Likes
1 ACCEPTED SOLUTION

Posted on --/--/---- --:-- AM
CJC
New Member
Reply posted on --/--/---- --:-- AM

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 ...

View solution in original post

Jump to Solution
0 Likes
3 REPLIES 3
Top Labels in this Space