There are a LOT of options available - as you can see:

When I talk to other data teams the most popular options are:

• Use your Data warehouse tool (Snowflake Cortex, Databricks Genie)
• Build custom agents with general agent tooling (Claude, Dust)
• Use your BI tool AI feature (Hex, Looker)
• Migrate to an AI-native BI tool (Omni)
• Build in-house analytics agent
• Buy a native text to SQL tool (textQL, Cube, dot, etc.)

This is how I prioritized options to test:

• First, try the most popular tools (Snowflake, Omni, Dust, Dagster compass, Hex, Genie)
• Then, try to build something on my own (Claude + MCP)
• Finally, test solutions that are natively built for this (Cube, textQL & co)