---
title: "Atomic Fields"
slug: "atomic-fields"
updated: 2024-04-10T16:35:49Z
published: 2024-04-10T16:35:49Z
canonical: "docs.datajet.app/atomic-fields"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.datajet.app/llms.txt
> Use this file to discover all available pages before exploring further.

# Atomic Fields

Atomic fields are the sub-set of fields that have been created by loading from file. These fields will show up in the following ways:

- As "Imported" in the [Data Audit](/v1/docs/data-audit) report
- As "Atomic=true" in the [Context Panel](/v1/docs/context-panel-getting-started) property panel
- As "Imported" in the [Template Dialog](/v1/docs/template-collection)
- As "Atomic=true" in the [Properties](/v1/docs/database-right-click-menus) dialog

### Viewing Atomic Field Status

#### Data Audit - Method

The [Data Audit](/v1/docs/data-audit) report lists the method used to create a field. Atomic fields are those with method of "Imported"

![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1712750857845.png)

#### Context Panel - Property

The property tab in the [context panel](https://docs.datajet.app/docs/en/instant-insights-profiles?highlight=undefined#context-panel) indicates the Atomic field status of the field that is selected in the [Database Tree](/v1/docs/database-tree)

![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1712750949865.png)Context Panel Property Screen

#### Template Dialog

The [Template dialog](/v1/docs/template-collection) (accessed by [**Project Explorer**](/v1/docs/project-explorer-overview) **| Templates | Right-click | Create Template**) filters fields according to their source type: Engineering/Imported

![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1712751122805.png)Edit Field Template

#### Properties Dialog

The properties dialog (accessed by right-clicking a field in the Database Tree and selecting "Properties" displays the Atomic status of the field. Imported fields will show {} as source JSON

![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1712754214070.png)

### Billing Report

Details of atomic fields are output when data is exported using the [ExportCampaignDataSet](/v1/docs/exportcampaigndataset) method. An output report is generated that lists the following:

- atomicExportFields[] - lists the atomic fields used in the generation of the fields in the export file.   Engineered fields will not be listed, but the atomic fields from which they were derived will be included.
- atomicDatasetFields[] - lists the atomic fields used in the query that selected the rows to be included in an export.   Engineered fields will not be listed, but the atomic fields from which they were derived will be listed.
- atomicFieldDetail[] - list the non-null count of atomic fields as listed in atomicExportFields[]

![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1711124886127.png)

### Changing Atomic Field Status

In some cases it is necessary to treat [engineered](/v1/docs/baked-fields) fields as if they were atomic fields. This can be done using the [SetAtomicFields](/v1/docs/setatomicfields) API:

![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1712766761795.png)

```json
[
  {
    "method": "SetAtomicFields",
    "template": "sales_imported_to_atomic",
    "project": "SDJ-DJDemo2023",
    "description": "Set atomic fields using a template"
  },
  {
    "method": "SetAtomicFields",
    "table": "sales",
    "project": "SDJ-DJDemo2023",
    "description": "Set atomic fields for a whole table"
  },
  {
    "method": "SetAtomicFields",
    "fields": [
      "customer.first order",
      "customer.recency"
    ],
    "description": "Set atomic fields using a field list",
    "project": "SDJ-DJDemo2023"
  }
]
```

![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1712750629578.png)

"table,template,fields are exclusive keys"