We are experimenting with the AI API provided by cube.dev that enables natural language prompts to be transformed into REST-API ready queries. The data model determines the guard rails for the query-generator to make sure consistent output is provided.
The analytics agent demo shown below is built on top of the 'ABD Iowa' demonstration dataset which is visualised in Looker Studio. The data model that guides the large language model is codified in GitHub and the core transformations are done using dbt and hosted on BigQuery. This demo is under continuous development and will improve over time.