
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
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.
email
and 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
contacts
table, then checks to see if the user has access to theemail
column. - In this case, Buster prevents the query from running because the
email
column is toggled off. - Buster responds: “I’m sorry but I don’t have access to the data you are requesting.”
If you turn off a table or column after it has been used to answer a user’s question, that user will no longer be able to retrieve data for that question.