skills.rest
yu-iskw
yu-iskwCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

edit-parameters

Define and modify dynamic Lightdash semantic layer parameters with YAML.

3|Updated Feb 13, 2026
Search Tags:#configuration#parameters#dbt#semantic layer#lightdash#sql templating
One-click install
npx skills add https://github.com/yu-iskw/dbt-heros --skill edit-parameters
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: edit-parameters
Source: https://github.com/yu-iskw/dbt-heros/tree/main/plugins/lightdash-development/skills/edit-parameters
Command: npx skills add https://github.com/yu-iskw/dbt-heros --skill edit-parameters

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill streamlines the management of dynamic parameters within the Lightdash semantic layer, allowing for flexible and user-configurable query behavior without direct SQL modification.

Core Features & Use Cases

  • Dynamic Parameter Definition: Create reusable variables at the project or model level.
  • Type Safety: Enforces supported parameter types (string, number, date).
  • SQL Templating: Enables referencing parameters within SQL queries using ${lightdash.parameters.name}.
  • Use Case: A marketing analyst can use this skill to define a start_date parameter for a sales report, allowing them to easily change the reporting period without altering the underlying SQL.

Quick Start

Use the edit-parameters skill to add a new string parameter named 'customer_segment' with a default value of 'SMB' to the 'customers' model.

Frequently Asked Questions about edit-parameters

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

FAQPage Schema
How do I define dynamic parameters in a Lightdash semantic layer?▼

You can define dynamic parameters in Lightdash by adding specific YAML structures at the project or model level. This enables flexible, user-configurable query behavior without requiring direct SQL modification.

How do I reference dynamic parameters in SQL queries using Lightdash?▼

You reference dynamic parameters in SQL queries using the templating syntax `${lightdash.parameters.name}`. This allows you to inject parameter values directly into your SQL logic within the semantic layer.

What parameter types are supported for SQL templating in Lightdash?▼

Lightdash enforces type safety for SQL templating parameters, supporting `string`, `number`, and `date` types. This ensures valid data formats are used when parameters are injected into SQL queries.

Can I configure a default reporting period parameter without altering the underlying SQL?▼

Yes, you can define a parameter such as `start_date` with a default value to allow analysts to change reporting periods dynamically. This modifies query behavior on the fly without altering the underlying SQL.

What is the difference between project-level and model-level parameter configurations in Lightdash?▼

Project-level parameters are reusable across all models in the Lightdash semantic layer, while model-level parameters are scoped to a specific model. Both require adherence to specific YAML structures for definition.

Related Skills

Explore More Data & Analytics Skills→
yu-iskwyu-iskw
3

Compile Project

Validate dbt and Lightdash project configurations locally using the Lightdash CLI.

Community
Intermediate
yu-iskwyu-iskw
3

Edit Dimensions

Define and modify Lightdash dimensions in dbt model column configurations.

Community
Intermediate
yu-iskwyu-iskw
3

Validate Project

Validate local Lightdash YAML configurations against remote project content.

Community
Intermediate
ivanshamaevivanshamaev
14

dbt-macros

Build dbt Jinja macros for reusable SQL with adapter.dispatch and run_query guards.

Community
Intermediate