Which BI tools promote ad-hoc work to definitions?

Quoted from Databricks’s docsWhen a local metric view is ready for broader use, you can promote it to Unity Catalog for global use.

Quoted from Snowflake’s docsThese suggestions analyze SQL query history to find frequently used SQL expressions that are not yet represented in the Semantic Model or view.

Quoted from Omni’s docsOnce added to the workbook model, you can then promote the calculation to the shared model.

Quoted from Hex’s docsIt’s also possible to create a new component from a single cell by clicking the cell’s 3-dot menu and selecting New component from cell.

Quoted from Sigma’s docsYou can also create a data model from a table in a workbook.

Quoted from BigQuery’s docsLogical views let you save a SQL query as a virtual table, which helps you reuse query logic and simplify access to your data.

Quoted from Looker’s docsIncorporate custom logic: Convert important and commonly used custom fields or table calculations into LookML dimensions and measures.

Quoted from Tableau’s docsAll of these refinements become part of the metadata contained in the data source that you publish and maintain.

Quoted from Power BI’s docsYou can add DAX query scoped measures to the model using CodeLens update model actions or the Update model with changes button.

Quoted from Metabase’s docs[Ask a question][question] using either the query builder or the SQL editor, or select an existing saved question that you want to convert to a model.

Quoted from Alteryx’s docsIn addition to building a macro from scratch, you have the option to convert an existing workflow (or a portion of the workflow) to a macro.

Quoted from MotherDuck’s docsAfter a session where you analyzed data, explored tables, or worked through a task with an agent, save the reusable context that emerged as a Guide.

Quoted from Mode’s docsYou can create a dataset directly from a SQL query in an existing report, as long as the query has run successfully and returned a non-zero number of rows.