Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Availability to update MDL file to design semantic model instead of using UI modeling page #630

Open
Candytigers opened this issue Aug 29, 2024 · 0 comments

Comments

@Candytigers
Copy link

Is your feature request related to a problem? Please describe.
When I try to design semantic model in the modeling page in UI, I found the limitation of creating complex calcuated field(e.g. only one expression and one column is supported to create new calculated field in UI) and more efforts are needed when we have lots of columns and relationships to define.

Describe the solution you'd like
A clear and concise description of what you want to happen.

Could we have the flexibility of updating the underlying mdl file and implement it directly instead of using the UI modeling page? For example, if I want to create a new calculated filed called 'total_sales_quantity_last_year', can I do it by updating mdl file which could be relected to semantic modeling and used in AI service:

{
"name" : "total_sales_quantity_last_year",
"type" : "INT64",
"isCalculated" : true,
"notNull" : false,
"expression" : "lag(sales.quantify,1) over (partition by product.product_name order by date_trunc("YEAR",sales_date) asc)",
"properties" : {
"description" : ""
}

Currently, I am able to find the mdl file in Docker files under Wren Engine, but when I try to edit and save it, it seems the updates don't reflect to the modeling page in UI.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant