How to automatically write dbt SQL queries using AI
With AI Data Sidekick, you can use artificial intelligence to ✨automatically✨ write SQL queries in dbt Cloud.
Analytics engineers spend the majority of their days working with SQL inside of dbt. Repetitive tasks, like writing queries, add up over time.
That’s why AirOps created an AI-assisted tool that takes the manual labor out of writing SQL in dbt Cloud.
Automatically write SQL in dbt Cloud using AI
Data Sidekick combines the power of AI with context from your data warehouse to take the grunt work out of common data tasks, including writing SQL.
You can ask a question using natural language and immediately get a properly formatted SQL query to input into dbt Cloud.
In addition to drafting dbt SQL queries, you can also use Sidekick’s collection of AI-powered data apps to:
- Auto document table schemas ✍️
- Generate a full Python script from a dbt model 🐍
- Optimize queries to improve speed and trim your warehouse bill 💸
- Suggest questions a specific database table can answer 🧐
… and more. We’re always developing new AI data apps, too.
The best part? Sidekick is completely free for individual users.
See Data Sidekick in action
Curious about how Sidekick performs in the wild? See what Kyle Dempsey, Head of CX and Solutions Architecture at AirOps, has to say about using it to automatically write SQL queries in dbt.