By default, Buster will pull in all tables and columns that are accessible to the read-only user that you provisioned. Buster does not store your data. We only use your database metadata.
Toggle columns on and off
Any columns that are toggled on will be query-able by your end users. Do not include columns that:
- Are deprecated
- Aren’t relevant to the questions that your users will ask
- Contain data integrity issues
You do not need to include tables or columns necessary for joins. Buster will still map across relationships in your database to answer questions.
Access control validation
The columns that you enable and disable during this step will be used as access controls. Every query that Buster generates will be validated against what you’ve enabled and disabled.
For example, in the image above we’ve turned off the
phone columns in the
contacts table. The following is an example of a user dialog with these access controls in place:
- User asks: “Show me all of the emails for our contacts”
- Buster begins query generation process…
- Query generated is
SELECT email FROM contacts;
- Buster validates if the user has access to the
contactstable, then checks to see if the user has access to the
- In this case, Buster prevents the query from running because the
- Buster responds: “I’m sorry but I don’t have access to the data you are requesting.”
Please note, you are able to come back and change which columns are toggled on/off at any time after onboarding.