1 ) Hit login_user to login as the user (https://docs.looker.com/reference/api-and-integration/api-reference/v3.1/api-auth#login_user)2) Use all_dashboards endpoint to get all the dashboards the user has access to and sort it on the last_viewed_at pa...

The problemLet's say you have a table like so:And you want to return only the first row of data in a single column.The solutionWe can accomplish this by using this function here:pivot_index(index(${number_of_sign_ups.count}, 1), row())The explanation...

The problemIf you are getting Non-Unique value/primary key (or sql_distinct_key), value overflow or collision when computing sum error and you've checked that you have a primary key and are also using a sum_distinct with sql_distinct_key, you should ...

Technically, the answer is yes. However, there are potential issues to consider:As noted in docs, this value must be unique for a given set of permissions, user attributes, and models. So, for example, if the different users will have different permi...

Hidden user attributes tend to be passwords or tokens so allowlisting URLs restricts where those passwords or tokens can be sent.You wouldn't want someone doing something like, I'm going to use this user attribute on a schedule to a random place so t...