Generate examples and trusted dashboards

looker-open-source / looker-explore-assistant

A React Application for interacting with Looker data through natural language.

MIT License

110 stars 75 forks source link

Generate examples and trusted dashboards #110

Closed colin-roy-ehri closed 1 month ago

colin-roy-ehri commented 1 month ago

Added generate examples script to the explore-assistant-examples
- Generates query examples based on system activity
- Copied from a previously standalone notebook
- Prompts fixed to prevent hallucination
- Auto-upload feature for generated examples
Added optional trusted dashboards for increased context
- Trusted dashboard table to terraform
- upload script modification to load trusted dashboard lkml files
- Use the trusted dashboards in the cloud function backend

google-cla[bot] commented 1 month ago

Thanks for your pull request! It looks like this may be your first contribution to a Google open source project. Before we can look at your pull request, you'll need to sign a Contributor License Agreement (CLA).

View this failed invocation of the CLA check for more information.

For the most up to date status, view the checks section at the bottom of the pull request.

colin-roy-ehri commented 1 month ago

I forgot to mention, there is also an improved prompt which includes reformatted content from the Looker date/time filter documentation. This has improved the creation of datetime filters dramatically.

colin-roy-ehri commented 1 month ago

Improved error handling for 3 cases:

When user specifies both BQ and CF backend variables
When the vertex API is not enabled
When the cloud function returns a 500, prevent CORS errors which obfuscate the real error