Skip to main content

Building Datamaps

Designing, Transforming, and Validating data logic​

Manual / Code Mode​

Code Mode allows advanced users to build and refine Datamaps using code (e.g., SQL).

Key capabilities:

  • Write custom queries or scripts to shape the data.
  • Override or augment Low-code transformations.
  • Use advanced logic not easily expressed in the visual builder.

Code Mode

Running a Query​

The Run Query action allows users to validate the SQL logic applied before publishing or instantiating a Datamap. Running a query helps confirm that the current transformation produces the expected results, schema, and performance characteristics.

When users click Run, Fabric executes the generated SQL and displays the output in the Results section.

The Results view includes:

  • Preview Table
    A tabular output of the query result (limited sample or full result depending on warehouse configuration).

  • Execution Metadata
    Information about the query execution, such as:

    • Number of rows returned (e.g., 100 rows)
    • Result size (e.g., 9 KB fetched)
    • Runtime duration (e.g., 3 seconds)

  • Export Options
    Users can export the result set as a CSV file for additional validation, debugging, or offline analysis.

Run Results

Publish Version​

Once a Datamap is configured and validated, users can publish them:

  • Save the Datamap definition along with:
    • Version name or number.
    • Description or change notes.
    • Metadata (tags, domain, owners).
  • This version becomes a stable reference point that can be instantiated or promoted.

Published versions help ensure reproducibility and governance over changes.

Promote Datamap to Data Marketplace​

After the Datamap is stable and producing the intended output, it can be promoted:

Add or confirm essential metadata:

  • Title
  • Creator
  • Subject
  • Description
  • Tags
  • Product thumbnails
  • Publisher
  • Contributor
  • Date
  • Type
  • Format
  • Identifier
  • Source
  • Language
  • Relation
  • Coverage
  • Rights
  • Access rules
  • Download rules
  • Technical requirements
  • Ontology

Promote to the Data Marketplace as a Data Product.

Once promote the product becomes visible to other users for discovery and reuse.