malloy-patterns

Index Malloy documentation topics and patterns for language reference and rendering.

95|24|Updated Sep 16, 2024
One-click install
npx skills add https://github.com/malloydata/publisher --skill malloy-patterns
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: malloy-patterns
Source: https://github.com/malloydata/publisher/tree/main/skills/malloy-patterns
Command: npx skills add https://github.com/malloydata/publisher --skill malloy-patterns

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill provides a comprehensive index of Malloy documentation topics and patterns, helping users discover and understand the language reference, common patterns, rendering, and experimental features available in Malloy.

Core Features & Use Cases

  • Documentation Index: Access a curated list of Malloy documentation topics for quick reference.
  • Language Reference: Learn about sources, queries, views, fields, aggregates, joins, filters, expressions, and functions.
  • Common Patterns: Understand and implement patterns like YoY, cohorts, percent of total, and more.
  • Rendering & Visualization: Explore rendering options and visualization techniques for Malloy models.
  • Database Dialects: Get information on supported database dialects like BigQuery, DuckDB, PostgreSQL, and Snowflake.
  • Experimental Features: Learn about experimental features and their usage.
  • Multi-File & Computed Sources: Understand how to use imports, computed sources, and access modifiers.
  • Other Topics: Access information on notebooks, MalloySQL, Python package, Jupyter, publishing, REST API, MCP for AI Agents, and troubleshooting.

Quick Start

Use the malloy-patterns skill to get information on a specific Malloy topic, such as "How do I use window functions in Malloy?".

Frequently Asked Questions about malloy-patterns

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

FAQPage Schema
How do I implement common data patterns like year-over-year or cohorts in Malloy?

Malloy patterns documentation provides indexed access to common analytical patterns like year-over-year, cohorts, and percent of total calculations. You can discover and implement these patterns directly in your Malloy models for data processing and visualization tasks.

Does Malloy support database dialects like BigQuery, DuckDB, PostgreSQL, and Snowflake?

Yes, Malloy supports database dialects like BigQuery, DuckDB, PostgreSQL, and Snowflake. This Skill provides indexed documentation detailing how Malloy's language reference, queries, and rendering features operate across these supported database platforms.

What is the best way to learn Malloy language reference for sources, views, and joins?

The best way to learn Malloy language reference is through this Skill's indexed documentation, which covers sources, queries, views, fields, aggregates, joins, filters, expressions, and functions. It organizes these topics for quick discovery and implementation in your data models.

How do I render data visualizations in Malloy models?

To render data visualizations in Malloy, this Skill indexes documentation topics covering rendering options and visualization techniques. You can explore these indexed topics to understand and implement visual outputs for your Malloy models and queries.

Can I use Malloy with Jupyter notebooks and the Python package?

Yes, you can use Malloy with Jupyter notebooks and the Python package. This Skill indexes documentation on notebooks, the Python package, MalloySQL, and Jupyter integration to help you configure and execute your Malloy data processing workflows.

How do I use imports and computed sources in Malloy multi-file projects?

For Malloy multi-file projects, this Skill indexes documentation on imports, computed sources, and access modifiers. You can use these indexed topics to understand how to structure, import, and manage complex Malloy models across multiple files.