Historical redacted data handling

Check out this page in the docs. Here are some alternatives:

  • You could hide the column (Admin > Table Metadata) and disable native queries (because Metabase cannot hide anything at the SQL level). If you want to show the column’s “edited” version, you could create an SQL Model that calculates a column over the original table and build your questions starting from that model.
  • You could use data sandboxing (Pro and Enterprise) to hide or "edit" the column values that people will see (also doesn't affect native queries).
  • At the database level it's also possible (and affects native queries) but more involved, you can create a view without the column and modify Metabase's DB user's permissions to only let it see the view and not the complete table, for example.
1 Like