README.md

metadata

title: ThoughtSpot Demo Builder
emoji: 🚀
colorFrom: blue
colorTo: purple
sdk: gradio
sdk_version: 4.44.1
app_file: app.py
pinned: false
license: mit
python_version: '3.11'

Demo Wire - AI-Powered Demo Builder

A powerful Gradio-based application that automatically generates and deploys complete demo environments for ThoughtSpot, including Snowflake schemas, data population, and semantic model creation.

Deployed on Hugging Face Spaces: This app can be deployed to HF Spaces for easy access. See DEPLOYMENT.md for setup instructions.

🚀 Features

• AI-Powered Research: Automatically researches companies and industries using LLM
• Schema Generation: Creates optimized Snowflake DDL based on business context
• Data Population: Generates realistic demo data with strategic outliers
• ThoughtSpot Integration: Deploys connections, tables, and semantic models
• Interactive UI: Clean, intuitive Gradio interface with real-time progress updates

🛠️ Tech Stack

• Frontend: Gradio (Python web UI)
• Backend: Python 3.12+
• Database: Snowflake
• Analytics: ThoughtSpot
• AI: OpenAI GPT models
• Data Generation: Faker library

📋 Prerequisites

• Python 3.12+
• Snowflake account with appropriate permissions
• ThoughtSpot Cloud account
• OpenAI API key

🚀 Quick Start

1. Clone the repository

   git clone https://github.com/yourusername/demo-wire.git
   cd demo-wire
   

2. Set up virtual environment

   python -m venv demo_wire
   source demo_wire/bin/activate  # On Windows: demo_wire\Scripts\activate
   

3. Install dependencies

   pip install -r requirements.txt
   

4. Configure environment variables

   cp .env.example .env
   # Edit .env with your credentials
   

5. Run the application

   python demo_prep.py
   

6. Open your browser Navigate to http://localhost:7860

⚙️ Configuration

Create a .env file with the following variables:

# OpenAI
OPENAI_API_KEY=your_openai_api_key

# Snowflake
SNOWFLAKE_USER=your_username
SNOWFLAKE_PASSWORD=your_password
SNOWFLAKE_ACCOUNT=your_account
SNOWFLAKE_WAREHOUSE=your_warehouse
SNOWFLAKE_DATABASE=your_database
SNOWFLAKE_SCHEMA=your_schema

# ThoughtSpot
THOUGHTSPOT_URL=your_thoughtspot_url
THOUGHTSPOT_USERNAME=your_username
THOUGHTSPOT_PASSWORD=your_password

🎯 Usage

1. Enter Company Information: Company name, URL, and industry
2. Start Research: AI analyzes the company and industry
3. Create DDL: Generate optimized Snowflake schema
4. Generate Data: Create realistic demo data with outliers
5. Deploy: Deploy to Snowflake and ThoughtSpot

📁 Project Structure

demo-wire/
├── demo_prep.py              # Main Gradio application
├── schema_utils.py           # Schema parsing and generation utilities
├── thoughtspot_deployer.py   # ThoughtSpot deployment logic
├── snowflake_auth.py         # Snowflake authentication
├── demo_personas.py          # Demo persona configurations
├── prompts.py                # LLM prompt templates
├── requirements.txt          # Python dependencies
├── docs/                     # Documentation
├── tests/                    # Test files
└── results/                  # Generated demo results

🧪 Testing

Run the test suite:

python -m pytest tests/

🤝 Contributing

1. Fork the repository
2. Create a feature branch (git checkout -b feature/amazing-feature)
3. Commit your changes (git commit -m 'Add amazing feature')
4. Push to the branch (git push origin feature/amazing-feature)
5. Open a Pull Request

📄 License

This project is licensed under the MIT License - see the LICENSE file for details.

🙏 Acknowledgments

• ThoughtSpot for the analytics platform
• Snowflake for the data warehouse
• OpenAI for the AI capabilities
• Gradio for the web interface

📚 Development Notes

Development notes and sprint planning are stored in dev_notes/ (not committed to version control).

📞 Support

For support, email support@demo-wire.com or create an issue in this repository.

---

Built with ❤️ for the ThoughtSpot community