---
schema_version: "1"
id: 010d81157d606b09bdc73cfa5618713c54140b18d2c6b1acfdb1ea1d4e13ff9a
title: columns Properties
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/analytics/bi_dev_guide_json/guides/bi-dbjson-steps-columns.md
canonical_url: https://developer.salesforce.com/docs/analytics/bi-dev-guide-json/guide/bi-dbjson-steps-columns.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 8fb7513ca6f3120d6d229f604f2c7e0abaa9ca692a0ba7f50a879cadce45982e
products:
  - Analytics Dashboard JSON Developer Guide
  - analytics
---

# columns Properties

Use the `columns` property to add a column to a step query source in Compact form 2.0.

## Example: Aggregate measure column defined in Compact form 2.0

```nolang
"columns": [
    {
        "field": [
            "sum",
            "Amount"
        ]
    }
]

```

## Example: Non-aggregate columns defined in Compact form 2.0

```nolang
"columns": [
    {
        "field": "Customer_Name",
        "name": "Customer_Name"
    },
    {
        "field": "Product_Name",
        "name": "Product_Name"
    },
    {
        "field": "Profit",
        "name": "Profit"
    }
]

```

## Example: Formula column defined in Compact form 2.0

```nolang
"columns": [
    {
        "formula": "A*2",
        "name": "B"
    }
]

```