dremio-analytics

Query Dremio to retrieve CRM, billing, and business analytics data.

Updated Feb 14, 2026
One-click install
npx skills add https://github.com/Shakudo-io/opencode-skills --skill dremio-analytics
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: dremio-analytics
Source: https://github.com/Shakudo-io/opencode-skills/tree/main/dremio-analytics
Command: npx skills add https://github.com/Shakudo-io/opencode-skills --skill dremio-analytics

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Businesses often need to combine CRM, billing, and operational data to generate actionable analytics. This skill provides a streamlined way to query Dremio's data lakehouse to surface customer insights, revenue metrics, and deal history for reporting and decision making.

Core Features & Use Cases

  • Dremio-based access to CRM data (HubSpot deals, contacts) and billing data (invoices, subscriptions) for unified analytics.
  • Deterministic and async query patterns with helper functions to fetch results and build dashboards.
  • Use cases include generating customer 360 profiles, revenue dashboards, and quarterly business reviews from data lakehouse sources.

Quick Start

Login to Dremio if required and run a simple query to retrieve the first 10 CRM records.

Frequently Asked Questions about dremio-analytics

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I query HubSpot CRM data stored in a Dremio data lakehouse?

To query HubSpot CRM data from a Dremio data lakehouse, you use provided helper functions to execute SQL queries and retrieve results. This process surfaces customer insights and deal history for unified reporting.

What is the best way to combine CRM and billing data for revenue dashboards?

The best way to combine CRM and billing data for revenue dashboards is by querying a unified Dremio data lakehouse. This approach surfaces revenue metrics, subscriptions, and deal history to support actionable business analytics.

Do I need Dremio authentication to retrieve business analytics?

Yes, you need Dremio authentication to retrieve business analytics. The query process requires authenticated access to securely fetch CRM records, billing information, and operational data from the lakehouse.

Can I generate customer 360 profiles using Dremio query helper functions?

Yes, you can generate customer 360 profiles using Dremio query helper functions. These helpers apply deterministic and async query patterns to fetch CRM and billing results, building comprehensive customer views.

How does Dremio handle query timeouts and errors when fetching large datasets?

Dremio handles query timeouts and errors when fetching large datasets through built-in helper functions that apply proper error handling and async query patterns. This ensures results are retrieved reliably without process failures.