Documentation
Everything you need to get started with AI-powered data agents
Getting Started
Prerequisites
- • Access to a supported data warehouse (Snowflake, BigQuery, PostgreSQL, etc.)
- • Admin permissions to create service accounts and grant access
- • Basic understanding of your warehouse's schema and tables
Step 1: Connect Your Warehouse
The first step is to connect our AI agents to your data warehouse. This process takes about 5-10 minutes and only requires read-only access to your data.
What You'll Need:
- Service account credentials for your warehouse
- Read access to INFORMATION_SCHEMA (for schema discovery)
- Read access to the schemas/tables you want to analyze
Security First
We recommend creating a dedicated read-only service account specifically for Myriade. This ensures we can never modify your data and you maintain full control over what we can access.
Step 2: First Query Walkthrough
Once connected, try asking your first question. Here's what to expect:
Step 3: Understanding Agent Responses
Every agent response includes:
1. Exploration Log
See which tables and columns the agent examined to answer your question
2. SQL Queries
Review all queries executed, with explanations for complex logic
3. Results & Insights
Get your answer with supporting data and statistical context
4. Quality Notes
Any data quality issues or assumptions made during analysis
Supported Platforms
We support all major data warehouses and SQL databases. Setup varies slightly by platform but typically takes 5-10 minutes.
Snowflake
Connect using standard Snowflake credentials or OAuth.
View setup instructions →
1. Create a read-only role:
CREATE ROLE MYRIADE_READER; GRANT USAGE ON WAREHOUSE COMPUTE_WH TO ROLE MYRIADE_READER; GRANT USAGE ON DATABASE PROD_DB TO ROLE MYRIADE_READER; GRANT USAGE ON SCHEMA PROD_DB.PUBLIC TO ROLE MYRIADE_READER; GRANT SELECT ON ALL TABLES IN SCHEMA PROD_DB.PUBLIC TO ROLE MYRIADE_READER;
2. Create service account and assign role
3. Provide credentials in Myriade dashboard
BigQuery
Connect using service account key or OAuth.
View setup instructions →
1. Create service account in GCP Console
2. Grant BigQuery Data Viewer role
3. Download JSON key file
4. Upload key in Myriade dashboard
PostgreSQL
Connect to any PostgreSQL database (including RDS, Cloud SQL, etc.)
View setup instructions →
1. Create read-only user
2. Grant SELECT permissions on desired schemas
3. Ensure network access (whitelist IP if needed)
4. Provide connection string in Myriade dashboard
MotherDuck
Connect using MotherDuck service token.
View setup instructions →
1. Generate service token in MotherDuck console
2. Configure read-only permissions
3. Provide token in Myriade dashboard
Security & Permissions
Security First Approach
We take data security seriously. Our platform is designed with multiple layers of protection to keep your data safe.
What Data Access Is Needed
- INFORMATION_SCHEMA: To discover tables and columns
- SELECT permissions: To query your data tables
- NO write access: We never modify your data
- NO DDL permissions: We can't create, alter, or drop objects
Read-Only Mode
All warehouse connections operate in read-only mode by default. This means:
- We can only SELECT data, never INSERT, UPDATE, or DELETE
- We cannot modify schemas or table structures
- We cannot execute stored procedures or functions that modify data
- All queries are logged and auditable
How to Grant Permissions
We recommend following the principle of least privilege:
- Create a dedicated service account for Myriade
- Grant only SELECT permissions on schemas you want analyzed
- Restrict access to sensitive tables if needed
- Use row-level security if your warehouse supports it
- Regularly audit access logs in your warehouse
FAQ / Troubleshooting
How do I revoke access if needed?
Simply disable or delete the service account in your warehouse. This immediately cuts off all access. You can also remove the connection from the Myriade dashboard.
Can I limit which tables Myriade can see?
Yes! Only grant SELECT permissions on the schemas and tables you want analyzed. The agent will only work with data it has access to.
What if my warehouse has complex permissions?
Myriade respects your warehouse's native permission system. We see exactly what the service account you created can see—no more, no less.
How many queries does Myriade run?
It depends on the complexity of your question. Simple queries might run 3-5 SQL statements (exploration + analysis). Complex questions might run 10-20 as the agent explores your schema and data.
Will this increase my warehouse costs?
The compute cost is typically minimal—similar to what a data analyst would use doing the same work manually. We optimize queries and cache results where possible. Most teams see net savings from reduced manual work.
Connection failed - what should I check?
Common issues and solutions:
- Verify service account credentials are correct
- Check network/firewall rules allow connections
- Ensure INFORMATION_SCHEMA access is granted
- Confirm warehouse/database names are correct
- Check if account is active and not suspended
Need More Help?
Our team is here to help you get set up and answer any questions.