Raw attributes refer to the exact attribute names found within a database table. Users can leverage these attributes to create precise natural language queries by directly referencing them.
Referencing Raw Attributes in Queries
- When typing a query, use the
@
symbol to display a list of available tables and their attributes. - Users can then search and select a specific table or attribute from the list.
- Instead of writing general keywords like "game name" in plain English, users can directly reference the structured attribute, such as Casino_Details.Name.
Benefits of Using Raw Attributes
- Improves Query Precision – Ensures the query references the correct dataset.
- Enhances Query Structure – Reduces ambiguity by selecting specific database fields.
- Efficient Query Building – Autocomplete suggestions make it easier to find and use relevant attributes.
By explicitly selecting tables and attributes, users ensure their queries return accurate and relevant insights, optimising data retrieval.
Sample Query Using Raw Attributes
This query selects a list of bingo games and their total GGR for last month.
show @Bingo_Details.GameName and total @Bingo_Details.GGR for each game last month