Advanced Data Querying

For power users who need precise, custom analysis, Noros can execute SQL queries against your Cost and Usage Report (CUR) data. This gives you the flexibility to answer highly specific questions that go beyond standard cost breakdowns.

How It Works

Noros has access to your CUR data through secure, read-only connections. When you ask a question that requires detailed analysis, Noros constructs and executes queries against this data behind the scenes, returning the results directly in the conversation.

You don't need to write SQL yourself — just describe what you're looking for in plain language, and Noros will build and run the appropriate query.

What You Can Query

CUR data contains detailed line-item records of your cloud usage and costs. Through Noros, you can query:

• Resource-level costs — Spending on specific resources by ID

• Usage patterns — Detailed usage quantities and types

• Pricing details — On-demand vs. reserved vs. spot pricing breakdowns

• Data transfer — Cross-region and cross-service data transfer costs

• Tag-based analysis — Costs grouped by your custom resource tags

• Custom aggregations — Any combination of dimensions and metrics

Example Questions

Resource-Level Analysis

• "What are my top 10 most expensive resources?"

• "How much is resource i-0abc123def spending per day?"

• "Show me all resources that cost more than $100/day"

Data Transfer

• "What's our total data transfer cost by region?"

• "How much are we spending on cross-region data transfer?"

• "Break down data transfer costs between services"

Pricing Analysis

• "What percentage of our compute is on-demand vs. reserved?"

• "Show me daily spend for reserved vs. on-demand instances"

• "What's our spot instance usage and savings?"

Tag-Based Queries

• "What's our spend by environment tag?"

• "Show me costs for resources tagged with team=backend"

• "Which resources are untagged?"

Custom Analysis

• "What's our cost per GB of S3 storage by bucket?"

• "Show me hourly spend patterns for the past week"

• "What services have we started using in the past 30 days?"

Multi-Cloud Support

Advanced data querying is available for both AWS and GCP environments. Your billing data is normalized into a common format, so you can query it using the same natural language regardless of cloud provider.

Tips for Effective Queries

• Be specific about time ranges — "Last 7 days" or "March 2026" helps Noros scope the query efficiently.

• Name the dimensions you care about — "By service and region" is better than "show me everything."

• Ask follow-up questions — Start broad and drill down. Noros maintains context from previous queries in the conversation.

• Ask for tables — If you need structured data, ask Noros to present results in a table format.