# \#aml

**URL:** https://community.holistics.io/tag/aml/2.md

[Latest](https://community.holistics.io/latest.md) · [Categories](https://community.holistics.io/categories.md) · [Tags](https://community.holistics.io/tags.md)

---

## [\[Launched\] 🎨 As-code color palettes: Manage color palettes through AML for better reusability](https://community.holistics.io/t/launched-as-code-color-palettes-manage-color-palettes-through-aml-for-better-reusability/2641)

<div class="topic-metadata">

**Author:** [@minhnguyen123](https://community.holistics.io/u/minhnguyen123)\
**Replies:** 2\
**Last updated:** [July 28, 2026, 3:14am UTC](https://community.holistics.io/t/launched-as-code-color-palettes-manage-color-palettes-through-aml-for-better-reusability/2641 "2026-07-28T03:14:09Z")

</div>

Hi there :waving\_hand: We’re thrilled to introduce our new Color Palette as-code — bringing color palette management directly into your AML workspace. Define palettes once in code and reference them anywhere, with full …

---

## [\[Launched\] Local development with AI agents](https://community.holistics.io/t/launched-local-development-with-ai-agents/2719)

<div class="topic-metadata">

**Author:** [@Khai\_To](https://community.holistics.io/u/Khai_To)\
**Replies:** 0\
**Last updated:** [June 3, 2026, 3:25am UTC](https://community.holistics.io/t/launched-local-development-with-ai-agents/2719 "2026-06-03T03:25:55Z")

</div>

Local Development with AI Agents is now in beta. Use the AI tools you already know (Claude Code, Cursor, GitHub Copilot) alongside Holistics through Model Context Protocol (MCP). Local agents bring richer development to…

---

## [Dbt column descriptions not accessible via MCP](https://community.holistics.io/t/dbt-column-descriptions-not-accessible-via-mcp/2711)

<div class="topic-metadata">

**Author:** [@Ian\_McLaren](https://community.holistics.io/u/Ian_McLaren)\
**Replies:** 1\
**Last updated:** [May 13, 2026, 10:24am UTC](https://community.holistics.io/t/dbt-column-descriptions-not-accessible-via-mcp/2711 "2026-05-13T10:24:05Z")

</div>

Hi all, wanted to raise something I discovered while testing Holistics’ AI capabilities against our dbt-integrated datasets, in case others have hit this. We use the Holistics dbt integration to sync column descriptions…

---

## [DATA QUERY API Endpoint](https://community.holistics.io/t/data-query-api-endpoint/2579)

<div class="topic-metadata">

**Author:** [@Abdel](https://community.holistics.io/u/Abdel)\
**Replies:** 1\
**Last updated:** [January 20, 2026, 7:08am UTC](https://community.holistics.io/t/data-query-api-endpoint/2579 "2026-01-20T07:08:03Z")

</div>

It would be incredibly valuable to have a REST API endpoint for querying Holistics datasets programmatically. A CUBE-style API would unlock major benefits, including: Automated and flexible reporting Integrations with …

---

## [Build your data catalog right in the Dashboard](https://community.holistics.io/t/build-your-data-catalog-right-in-the-dashboard/2508)

<div class="topic-metadata">

**Author:** [@Khai\_To](https://community.holistics.io/u/Khai_To)\
**Replies:** 0\
**Last updated:** [July 22, 2025, 3:10pm UTC](https://community.holistics.io/t/build-your-data-catalog-right-in-the-dashboard/2508 "2025-07-22T15:10:48Z")

</div>

Tired of copy-pasting metric definitions every time they change? With our ​string interpolation ​ feature, your dashboard’s metric catalog stays in sync ​automatically​. One source of truth—no more manual edits! How to …

---

## [\[Launched\] Better syntax validation for Canvas Dashboard](https://community.holistics.io/t/launched-better-syntax-validation-for-canvas-dashboard/2519)

<div class="topic-metadata">

**Author:** [@Khai\_To](https://community.holistics.io/u/Khai_To)\
**Replies:** 0\
**Last updated:** [August 14, 2025, 10:49am UTC](https://community.holistics.io/t/launched-better-syntax-validation-for-canvas-dashboard/2519 "2025-08-14T10:49:24Z")

</div>

:fire: Why this feature? Some of our customers were struggling with cryptic field reference errors that only showed up when trying to publish dashboards. No clear error messages, no way to navigate to probl…

---

## [\[Launched\] Viz-aware AQL: Metrics that automatically adapt to your charts](https://community.holistics.io/t/launched-viz-aware-aql-metrics-that-automatically-adapt-to-your-charts/2524)

<div class="topic-metadata">

**Author:** [@Khai\_To](https://community.holistics.io/u/Khai_To)\
**Replies:** 0\
**Last updated:** [August 22, 2025, 10:31am UTC](https://community.holistics.io/t/launched-viz-aware-aql-metrics-that-automatically-adapt-to-your-charts/2524 "2025-08-22T10:31:56Z")

</div>

:fire: Why this feature? Ever created the same metric 5 times just because users wanted to view data by month, quarter, AND year? Yeah, we fixed that. :light\_bulb: How it works Context-aware functions: Ne…

---

## [Support datetime formating in AML](https://community.holistics.io/t/support-datetime-formating-in-aml/1307)

<div class="topic-metadata">

**Author:** [@SterlingParamoreMSE](https://community.holistics.io/u/SterlingParamoreMSE)\
**Replies:** 4\
**Last updated:** [September 16, 2025, 5:24pm UTC](https://community.holistics.io/t/support-datetime-formating-in-aml/1307 "2025-09-16T17:24:09Z")

</div>

It looks like Holistics only supports formatting of numbers and dates. I would also like to be able to format my datetimes. I have tried applying a date format to a datetime field, but it is not recognized in preview m…

---

## [Override nested properties impacts hidden parameter](https://community.holistics.io/t/override-nested-properties-impacts-hidden-parameter/2466)

<div class="topic-metadata">

**Author:** [@anya.conti](https://community.holistics.io/u/anya.conti)\
**Replies:** 6\
**Last updated:** [July 1, 2025, 2:10pm UTC](https://community.holistics.io/t/override-nested-properties-impacts-hidden-parameter/2466 "2025-07-01T14:10:45Z")

</div>

When using the override nested properties functionality as part of extensions, most of it works as expected. We’re able to override just the label, or the definition, and use almost all the other inherited parameters. H…

---

## [Launched: Introducing Dynamic Schema](https://community.holistics.io/t/launched-introducing-dynamic-schema/2315)

<div class="topic-metadata">

**Author:** [@Khai\_To](https://community.holistics.io/u/Khai_To)\
**Replies:** 0\
**Last updated:** [October 11, 2024, 7:30am UTC](https://community.holistics.io/t/launched-introducing-dynamic-schema/2315 "2024-10-11T07:30:44Z")

</div>

Hey everyone! :wave: I wanted to follow up on our Dynamic Data Sources post with another cool feature you might find useful: ​Dynamic Schema​. :bar\_chart: ​Dynamic Schema for Dev/Prod Environments​ For those of you who…

---

## [Forbidden characters in query model](https://community.holistics.io/t/forbidden-characters-in-query-model/2493)

<div class="topic-metadata">

**Author:** [@radema](https://community.holistics.io/u/radema)\
**Replies:** 2\
**Last updated:** [June 27, 2025, 7:52am UTC](https://community.holistics.io/t/forbidden-characters-in-query-model/2493 "2025-06-27T07:52:18Z")

</div>

Hi everyone, in our environment we are facing a limitation related to query models which contains filter conditions related to strings with forbidden characters. In our specific case, we need to filter on string like “a…

---

## [Launched: Code Search for Lineage Tracking & Refactoring 🔎](https://community.holistics.io/t/launched-code-search-for-lineage-tracking-refactoring/2399)

<div class="topic-metadata">

**Author:** [@vu.duong](https://community.holistics.io/u/vu.duong)\
**Replies:** 2\
**Last updated:** [May 19, 2025, 12:55am UTC](https://community.holistics.io/t/launched-code-search-for-lineage-tracking-refactoring/2399 "2025-05-19T00:55:28Z")

</div>

Hi there, fellow data builders! :man\_raising\_hand: We hear you! We know how important it is to keep track of your data connections and make changes without breaking things. That’s why we’ve been working hard on somethin…

---

## [Show all fields in Custom Data View](https://community.holistics.io/t/show-all-fields-in-custom-data-view/2447)

<div class="topic-metadata">

**Author:** [@chinh.dm](https://community.holistics.io/u/chinh.dm)\
**Replies:** 1\
**Last updated:** [April 25, 2025, 4:16am UTC](https://community.holistics.io/t/show-all-fields-in-custom-data-view/2447 "2025-04-25T04:16:26Z")

</div>

I want to create a view for my dataset. To add custom field, I need to manually type its name like this: view { model public\_dashboard\_widgets { field id field dashboard\_id field tenant\_id f…

---

## [Launched: Trace File Changes On GitHub/GitLab 🕵](https://community.holistics.io/t/launched-trace-file-changes-on-github-gitlab/2398)

<div class="topic-metadata">

**Author:** [@vu.duong](https://community.holistics.io/u/vu.duong)\
**Replies:** 0\
**Last updated:** [February 20, 2025, 11:23am UTC](https://community.holistics.io/t/launched-trace-file-changes-on-github-gitlab/2398 "2025-02-20T11:23:59Z")

</div>

Tracing and investigating file changes has never been easier! :tada: What’s New Now you can directly access your files on GitHub / GitLab with a single click, right from the Holistics interface: View source code dire…

---

## [Include Custom AQL Dimensions in Validation API or Report Validator](https://community.holistics.io/t/include-custom-aql-dimensions-in-validation-api-or-report-validator/2378)

<div class="topic-metadata">

**Author:** [@Bob\_Adams](https://community.holistics.io/u/Bob_Adams)\
**Replies:** 2\
**Last updated:** [February 5, 2025, 12:52pm UTC](https://community.holistics.io/t/include-custom-aql-dimensions-in-validation-api-or-report-validator/2378 "2025-02-05T12:52:21Z")

</div>

Hi Holistics Team, We have been getting a lot of value out of the Project Validation API and Report Validator features as a part of our development workflow. One issue we have occasionally run into is around custom AQL…

---

## [Query Model Persistence with Postgres Help](https://community.holistics.io/t/query-model-persistence-with-postgres-help/2365)

<div class="topic-metadata">

**Author:** [@celiasjr](https://community.holistics.io/u/celiasjr)\
**Replies:** 4\
**Last updated:** [January 23, 2025, 2:18am UTC](https://community.holistics.io/t/query-model-persistence-with-postgres-help/2365 "2025-01-23T02:18:25Z")

</div>

We have successfully implemented persistence schedules and have views and table written to postgres. This may be a stupid question but if we are using postgres for visualizations (dashboards), does holistics automatical…

---

## [Launched: 🧰 New Git workflow in Development Workspace](https://community.holistics.io/t/launched-new-git-workflow-in-development-workspace/2070)

<div class="topic-metadata">

**Author:** [@vu.duong](https://community.holistics.io/u/vu.duong)\
**Replies:** 0\
**Last updated:** [September 10, 2024, 10:50am UTC](https://community.holistics.io/t/launched-new-git-workflow-in-development-workspace/2070 "2024-09-10T10:50:55Z")

</div>

Note: This update is for users who have enabled the Git workflow. If you’re using the default Non-Git workflow in Modeling 4.0, this update won’t affect you. Hi all :raising\_hand\_man: , A while ago we rolled out the …

---

## [Launched: Introducing Dynamic Data Sources!](https://community.holistics.io/t/launched-introducing-dynamic-data-sources/2140)

<div class="topic-metadata">

**Author:** [@Khai\_To](https://community.holistics.io/u/Khai_To)\
**Replies:** 1\
**Last updated:** [November 25, 2024, 8:53am UTC](https://community.holistics.io/t/launched-introducing-dynamic-data-sources/2140 "2024-11-25T08:53:45Z")

</div>

Hey everyone! We’ve got something new that we think you’ll love: Dynamic Data Sources. This feature is designed to make your life a bit easier by letting you switch data sources based on who’s viewing your report or …

---

## [Launched: Validate Project with Validation API and GitHub Action](https://community.holistics.io/t/launched-validate-project-with-validation-api-and-github-action/2288)

<div class="topic-metadata">

**Author:** [@Khanh\_Tran](https://community.holistics.io/u/Khanh_Tran)\
**Replies:** 0\
**Last updated:** [November 18, 2024, 7:33am UTC](https://community.holistics.io/t/launched-validate-project-with-validation-api-and-github-action/2288 "2024-11-18T07:33:10Z")

</div>

Introduction The Validation API allows you to validate your project outside of Holistics, enabling smooth integration with CI/CD workflows. This feature is particularly useful in scenarios such as: Validating updates b…

---

## [Launched: ⤵️ Switching Branches with URL](https://community.holistics.io/t/launched-switching-branches-with-url/2136)

<div class="topic-metadata">

**Author:** [@vu.duong](https://community.holistics.io/u/vu.duong)\
**Replies:** 1\
**Last updated:** [October 12, 2024, 2:44am UTC](https://community.holistics.io/t/launched-switching-branches-with-url/2136 "2024-10-12T02:44:45Z")

</div>

How is it going, everyone? :raising\_hand\_man: I’m excited to share some improvement to how you access shared URLs in Development Workspace! Previously, when someone shared a URL to an object in their working branch, y…

---

## [Launched: Auto Publish with Publish API and GitHub Action 🤖](https://community.holistics.io/t/launched-auto-publish-with-publish-api-and-github-action/2119)

<div class="topic-metadata">

**Author:** [@Khanh\_Tran](https://community.holistics.io/u/Khanh_Tran)\
**Replies:** 5\
**Last updated:** [October 11, 2024, 4:25am UTC](https://community.holistics.io/t/launched-auto-publish-with-publish-api-and-github-action/2119 "2024-10-11T04:25:28Z")

</div>

Introduction The Publish API enables you to publish your project externally from Holistics, facilitating seamless integration with CI/CD workflows. By doing so, it leverages the full potential of an as-code approach, enh…

---

## [Persistence Job fails due to not being able to find a dataset](https://community.holistics.io/t/persistence-job-fails-due-to-not-being-able-to-find-a-dataset/2109)

<div class="topic-metadata">

**Author:** [@jediger](https://community.holistics.io/u/jediger)\
**Replies:** 1\
**Last updated:** [September 26, 2024, 8:14am UTC](https://community.holistics.io/t/persistence-job-fails-due-to-not-being-able-to-find-a-dataset/2109 "2024-09-26T08:14:33Z")

</div>

I set up a cron job to refresh a persistent QueryModel, and the job fails at the end with this message: ERROR - Fail to transform data. Dataset \`graphql\_logs\` not found There is definitely a dataset with that name in …

---

## [Launched: AQL Ad-hoc Fields](https://community.holistics.io/t/launched-aql-ad-hoc-fields/2099)

<div class="topic-metadata">

**Author:** [@minhthanh3145](https://community.holistics.io/u/minhthanh3145)\
**Replies:** 0\
**Last updated:** [September 18, 2024, 3:11am UTC](https://community.holistics.io/t/launched-aql-ad-hoc-fields/2099 "2024-09-18T03:11:51Z")

</div>

Have you ever needed to calculate a formula that’s not yet in the dataset? Well, let’s AQL Ad-hoc Fields come to the rescue! With AQL Ad-hoc Fields, you can define fields that stay only within your reports. Why wait for…

---

## [Launched: Exciting Update - New Custom AQL Field builder UI! 🚀](https://community.holistics.io/t/launched-exciting-update-new-custom-aql-field-builder-ui/1934)

<div class="topic-metadata">

**Author:** [@Tai\_Nguyen](https://community.holistics.io/u/Tai_Nguyen)\
**Replies:** 0\
**Last updated:** [May 9, 2024, 8:51am UTC](https://community.holistics.io/t/launched-exciting-update-new-custom-aql-field-builder-ui/1934 "2024-05-09T08:51:57Z")

</div>

Hello Holistics Community :wave: We’re all excited about the potential of AQL and metric-centric thinking, but we also understand the complexities involved in constructing, testing, and debugging AQL within Holistics, w…

---

## [How to dynamically change column that is used for a measure based on a filter/parameter](https://community.holistics.io/t/how-to-dynamically-change-column-that-is-used-for-a-measure-based-on-a-filter-parameter/678)

<div class="topic-metadata">

**Author:** [@mabr](https://community.holistics.io/u/mabr)\
**Replies:** 3\
**Last updated:** [June 28, 2024, 5:23am UTC](https://community.holistics.io/t/how-to-dynamically-change-column-that-is-used-for-a-measure-based-on-a-filter-parameter/678 "2024-06-28T05:23:15Z")

</div>

Hi We have built 4 different attribution models for our website data. My goal is to build dashboards, where there is a filter/parameter/attribute where the user can choose their preferred attribution model. The logic w…

---

## [Support Python in Holistics](https://community.holistics.io/t/support-python-in-holistics/1960)

<div class="topic-metadata">

**Author:** [@Abdel](https://community.holistics.io/u/Abdel)\
**Replies:** 9\
**Last updated:** [June 19, 2024, 4:34pm UTC](https://community.holistics.io/t/support-python-in-holistics/1960 "2024-06-19T16:34:18Z")

</div>

Support Python can have a lot of benefits, whereof: dynamic model generation retrieving metric definition stored externally building logic based on env variables and many other benefits. See examples of how Cube.dev …

---

## [\[🚀 Launched\] Our brand new Analytics Query Language, AQL!](https://community.holistics.io/t/launched-our-brand-new-analytics-query-language-aql/1533)

<div class="topic-metadata">

**Author:** [@Khai\_To](https://community.holistics.io/u/Khai_To)\
**Replies:** 22\
**Last updated:** [May 6, 2024, 11:17am UTC](https://community.holistics.io/t/launched-our-brand-new-analytics-query-language-aql/1533 "2024-05-06T11:17:29Z")

</div>

Hey folks! We’ve got exciting news to share with you - we have been working on a brand new Analytics Query Language, AQL! :rocket: AQL Expression is the next-gen upgrade to our current Business Calculation mechanism, d…

---

## [Measure / tehcnique for dynamic calculation of % change over time periods](https://community.holistics.io/t/measure-tehcnique-for-dynamic-calculation-of-change-over-time-periods/1924)

<div class="topic-metadata">

**Author:** [@Chris\_Wood](https://community.holistics.io/u/Chris_Wood)\
**Replies:** 4\
**Last updated:** [May 9, 2024, 9:14am UTC](https://community.holistics.io/t/measure-tehcnique-for-dynamic-calculation-of-change-over-time-periods/1924 "2024-05-09T09:14:42Z")

</div>

Hey Guys, Im evaluating Holistics over Looker. Im trying to understand how i would code a measure that allows me to have % change in my chart, in looker this is easy to do in built in table calculations . In SQL this wou…

---

## [Role Playing Models / Model Aliases](https://community.holistics.io/t/role-playing-models-model-aliases/754)

<div class="topic-metadata">

**Author:** [@DataGeekDude](https://community.holistics.io/u/DataGeekDude)\
**Replies:** 12\
**Last updated:** [April 2, 2024, 7:24am UTC](https://community.holistics.io/t/role-playing-models-model-aliases/754 "2024-04-02T07:24:21Z")

</div>

Hi All, Star schema modelling is a common form of modelling used in BI reporting layers. For instance see the following for definitions and usage: When creating a star schema you can link the same dimension table mu…

---

## [Launched: Role-playing dimension with AML Extend](https://community.holistics.io/t/launched-role-playing-dimension-with-aml-extend/1900)

<div class="topic-metadata">

**Author:** [@minhthanh3145](https://community.holistics.io/u/minhthanh3145)\
**Replies:** 1\
**Last updated:** [April 19, 2024, 8:21am UTC](https://community.holistics.io/t/launched-role-playing-dimension-with-aml-extend/1900 "2024-04-19T08:21:47Z")

</div>

Hey everyone :wave: We’re excited to introduce a new function in AML called Extend that helps you extend and re-use data models, datasets and dashboards easily. This reusability mechanism is very useful for implementin…

[Next page](https://community.holistics.io/tag/aml/2.md?match_all_tags=true&page=1&tags%5B%5D=aml)
