Hello henry and thank you for your feedback.
Indeed, primarily for AI purposes, we have begun documenting our main tables and columns in dbt. This documentation is directly pushed to Snowflake and can be retrieved using the following commands:
DESC TABLE XXXX.XXXXX; to get column descriptions. I noticed in the query history that Dust performs these kinds of queries, which is why I was curious if it was used to provide more context to the assistants.
SELECT table_name, comment FROM information_schema.tables; to obtain the table description.
It would be incredibly beneficial for us to handle documentation in dbt alone, without needing to insert instructions into the agent. This ensures that everyone using the table is working with the correct guidance.
