lookml-review

Convert LookML models to Malloy semantic models by analyzing business logic and relationships.

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

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill bridges the gap between LookML and Malloy, automating the process of converting LookML models into semantic models for Malloy, streamlining the data modeling process.

Core Features & Use Cases

  • LookML to Malloy Conversion: Automates the conversion of LookML files into Malloy models.
  • Prior Art Analysis: Analyzes LookML files to extract business logic, relationships, and curation decisions.
  • Two Modes: Supports both LookML with live data and LookML-only modes for validation.
  • Reference Files: Utilizes reference files to coordinate the conversion process and ensure accuracy.
  • Use Case: Ideal for data analysts and architects who need to migrate LookML models to Malloy for better semantic modeling capabilities.

Quick Start

Run the lookml-review skill on your LookML files to automatically generate Malloy models.

Frequently Asked Questions about lookml-review

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

FAQPage Schema
How do I convert LookML models to Malloy semantic models?

Converting LookML to Malloy involves analyzing your LookML files to extract business logic, relationships, and curation decisions, then generating corresponding Malloy models. The process requires a Malloy environment to execute successfully.

What is the difference between live data and LookML-only conversion modes?

LookML-only mode validates conversion using only the LookML files, while live data mode connects to your database to verify the converted Malloy semantic models against actual query results during the transformation process.

Do I need a Malloy environment to migrate from LookML?

Yes, a Malloy environment is required to migrate from LookML. You must also provide your LookML files and utilize reference files to coordinate the semantic model conversion process and ensure structural accuracy.

How does semantic model conversion handle existing business logic in LookML?

The conversion process analyzes prior art in your LookML files to extract existing business logic, data relationships, and curation decisions, ensuring these rules translate accurately into the new Malloy semantic models.

Can I validate LookML to Malloy conversion without a live database connection?

Yes, you can validate conversion without a live database connection using LookML-only mode. This mode analyzes and transforms the LookML files independently to support structural validation of the semantic models.