Solid Lab Environment Setup Guide

What You'll Build

A complete lab environment with:

• Snowflake database with 509 tables across 15 schemas (SunSpectra dataset)
• Solid tenant integrated for natural language queries
• Sample data ready for testing, training, and demos

Prerequisites

• Snowflake account with.ACCOUNTADMIN access
• Python 3.8+
• GitHub access to: https://github.com/solid-data-public/snowflake-sunspectra-lab

Setup Steps

Step 1: Create Snowflake Database & Load Data

Follow the instructions here to set up your Snowflake database and load all 509 tables:

https://github.com/solid-data-public/snowflake-sunspectra-lab

Step 2: Request Solid Lab Tenant

Contact Solid team and provide:

• This is for a lab/testing environment
• Organization name
• List of users

Wait 1-2 business days for provisioning

Step 3: Configure Solid Connection

Follow the complete setup instructions here: docs.getsolid.ai/docs/snowflake

Use these values when configuring:

• Warehouse: COMPUTE_WH
• Database: SUNSPECTRA_ANALYTICS
• Role: SOLID_ROLE

Step 4: Test & Validate

Run sample queries in Solid or Snowflake:

• "Show me total revenue by region."
• "What are the top 10 customers by account balance?"

Pre-built SQL queries: sample_queries.sql

Success Checklist

• 509 tables loaded across 15 schemas
• Solid tenant connected to Snowflake
• Sample queries return results
• Team can access the environment

Resources