Implementing Row-Level Data Security in Looker - Looker Webinars

Sdílet
Vložit
  • čas přidán 1. 08. 2024
  • In this webinar we delve into the intricacies of implementing row-level data security in Looker. We guide you through the process of setting up dynamic, row-level filters for a Looker explore using user attributes and the access_filter parameter.
    In this webinar, we discuss:
    -The importance of row-level filtering and its typical use cases.
    -The step-by-step process of setting up user attributes for row-level security.
    -How to determine the appropriate field in your view for data filtering.
    -The role of the access_filter parameter in controlling data visibility.
    -Best practices for setting user attribute values at the group level for easier maintenance.
    Think of this as a chance to enhance your data security practices in Looker.
    TIMESTAMPS
    0:01 Webinar Preamble
    2:30 Datatonic Introduction
    5:26 Looker Security Overview
    11:41 Overview of Row Level Security In Looker
    13:58 Static vs Dynamic Row Level Security In Looker
    16:25 Live Demo
    31:20 Webinar Summary and Conclusion
    37:26 Q&A
  • Věda a technologie

Komentáře • 3

  • @bhargavimoorthy2203
    @bhargavimoorthy2203 Před 6 měsíci

    This is a fabulous content, explained with much clarity. Thanks for all the efforts!! 👍

  • @user-ek3uw8vc9l
    @user-ek3uw8vc9l Před 11 měsíci

    Hi Dino, thanks for the great content! Do you know if its possible for the group creation and users assignment to be dynamic as well?
    For example if we have thousands of brands, is it possible to read brand/users_assigned from a predefined table in a database instead of creating groups one by one in looker? Thanks

    • @user-ek3uw8vc9l
      @user-ek3uw8vc9l Před 11 měsíci

      Solved my own question :) we can apply the access_filter based on the system email attribute.
      access_filter: {
      field: products.brand_manager #should match the user login email
      user_attribute: email
      }