How to Use dwagent.ai

A step-by-step guide to getting started with your AI data warehouse assistant

1️⃣

Connect Your Database

Start by connecting your data warehouse to dwagent.ai. We support major platforms including Snowflake, BigQuery, and Redshift.

To connect your database:

  1. Navigate to the Databases section in your dashboard
  2. Click "Add Database Connection"
  3. Select your database type
  4. Enter your connection details
  5. Test the connection
2️⃣

Ask Questions in Natural Language

Use the Query Builder to ask questions about your data in plain English. Our AI will translate your questions into optimized SQL queries.

Example queries:

  • "Show me total sales by region for last quarter"
  • "What are our top 10 customers by revenue?"
  • "Compare product performance year over year"
3️⃣

Review and Execute Queries

Review the generated SQL, make adjustments if needed, and execute your query. Results are displayed instantly with visualization options.

Features available:

  • SQL preview and editing
  • Query optimization suggestions
  • Multiple visualization types
  • Export results in various formats
4️⃣

Save and Share Insights

Save your queries and visualizations for future use. Share insights with your team or schedule automated reports.

Sharing options:

  • Save queries as templates
  • Share via URL or export
  • Schedule automated reports
  • Set up email notifications