Cloudera Docs

Enabling impersonation and user dependent-cache for a data connection

User impersonation allows Cloudera Data Visualization to run queries in Cloudera Data Warehouse on behalf of logged in users through a trusted service account. Enabling impersonation and user-dependent cache ensures that queries respect user-specific permissions, and that cache is handled based on individual users, improving security and performance.

  1. On the main navigation bar, click DATA.

    The Data view appears, open on the Datasets tab.

  2. In the side bar, click the Edit button to the right of the connection you want to change.

    The Edit Data Connection modal window appears.

  3. Switch to the Advanced tab and configure impersonation.
    • Impersonation – Runs queries as the user who is logged in to Cloudera Data Visualization even when the connection is made with a different (trusted) user.
    • Trusted Impersonation – Runs queries as the user who is logged into Cloudera Data Visualization, applicable to secure connections.
  4. Optional: Enable user-dependent cache.

    When you enable impersonation or trusted impersonation, the User-dependent cache option becomes available. If you enable it, the user name will be saved to cache. This ensures that if for example a public dashboard created by one user is loaded by another, the second user cannot access the original cache.

  5. At the bottom of the modal, click TEST.
  6. If the connection is verified, click SAVE.
After the operation succeeds, the name of the new type of connection appears on the side navigation bar.