Skip to content
ADL Docs
Get Started Concepts Using the App Templates Reference

Data Objects

The Data Objects screen is where you define the core building blocks of your data solution. A data object typically represents a table, view, or query in your target database.

What you can do here

Section titled “What you can do here”

Create and manage data objects

Section titled “Create and manage data objects”
  • Add new data objects to your project, specifying a name and the connection where the object lives.
  • Edit existing objects — update names, descriptions, and other properties.
  • Delete objects you no longer need.
  • Browse all objects in your project using the list view.

Define columns (Data Items)

Section titled “Define columns (Data Items)”

Each data object contains Data Items — the columns or fields that make up its structure. For each Data Item, you can set:

  • Name — The column name.
  • Data type — The SQL data type (e.g., INT, NVARCHAR(100), DATE).
  • Nullability — Whether the column allows null values.
  • Ordinal position — The column’s order in the table.
  • Default value — An optional default for the column.

Set up business keys

Section titled “Set up business keys”

Business keys identify which columns uniquely define a record in your data object. This is essential for patterns like Data Vault, where business keys drive how data is loaded and linked.

Manage relationships

Section titled “Manage relationships”

Relationships link data objects to each other, similar to foreign keys. They help ADL understand how your data objects connect, which is useful for templates that generate join logic or relationship documentation.

Apply classifications

Section titled “Apply classifications”

Tag your data objects and individual data items with classifications like PII, Sensitive, or any custom labels your project uses. These classifications can be referenced by templates to generate appropriate handling logic.

Configure template mappings

Section titled “Configure template mappings”

Template mappings tell ADL which templates should be used to generate output for each data object. You can assign one or more templates to any data object.

Add extensions

Section titled “Add extensions”

Extensions are custom key-value pairs that let you attach any additional metadata to your data objects. Templates can reference extensions to customize their output — for example, storing a schema name or a deployment flag.

Tips

Section titled “Tips”
  • Start with connections first — Before creating data objects, make sure you’ve set up your Data Connections so you have somewhere to assign each object.
  • Use the Metadata Importer — If you have an existing database, you can import its structure directly instead of creating objects by hand.
  • Check the Graph view — The Graph screen gives you a visual map of your data objects and their relationships.
Section titled “Related”