There are a bunch of ways in Lightdash that you can manage access and visibility of Tables. Here are few options:
How do I manage which of my dbt models are shown as Tables in Lightdash?
Managing which Tables are seen by everyone.
To manage what shows up in your list of Tables available to explore, you can use the tables configuration in your project settings. Learn more about how to do this in the docs here.
How do I use a Table in a join, but hide it from the list of Tables in the sidebar?
I want to join a table to another one in Lightdash, but I don't want it to be explorable on its own (i.e. it shouldn't appear in the list of Tables).
I have Table B which is joined to Table A. Table B is really only useful when it's joined to Table A, it shouldn't be explored on its own or used as the starting point of a query. So, I want to hide it from the list of Tables but still have it appear joined to Table A. Here's how to do this.
How do I hide the fields from intermediate joined Tables?
I'm using an intermediate table to join two tables together. I don't want the intermediate table's fields to show up in the Explore view.
I have Tables joined to my Table A like A <> B <> C. Table B is really an intermediate table used to join C, so I don't want its fields to show up in the Explore view. Here's how to do this.
How do I hide/limit access to some Tables from some users, but not others?
I want to make some Tables available to certain users, but not everyone in Lightdash.
I have some Tables which I only want some people in my organization to have access to query/view (e.g. PII data, or sensitive financial data). You can use user attributes to manage the access to Tables and any content built from these Tables in your Lightdash instance. Here's how to do this.