"Default Tables" are the simplest types of Catalogs that can be added to the MinusX context. They automatically load the entire table list from the selected database (and are split by the schemas).
The agent can only see the tables selected in this list + any tables mentioned in the SQL query in the SQL Editor. You can always select/deselect tables like so:
The Default Tables are initialized to "Smart Defaults" based on your query history.
Smart Defaults
They comprise of tables present in SQL queries you may have written in cards or dashboards previously. We notice that this is mostly constant for a user, and is a great place to start. If you're ever unsure what tables to include, "Smart Defaults" is a good start.
Actual Context to MinusX
You can always see what MinusX views as context by clicking the Preview tab. MinusX sees the following structure for the selected tables:
tables:
- name: <table_1_name>
columns:
- name: <column_1_name>
type: <column_data_type>
unique_values: <~20 unique values of the TEXT column type>
has_more_values: <true/false>
Technical Details
Default Tables, under the hood, are just a special case of MinusX Catalogs. Each table is considered an entity, and each field is considered to be a dimension. There are no special metrics, or additional instructions included.