---
schema_version: "1"
id: 0b49d6648d29e2366d4a72bf981404d8e7bba2be6a73c5c4d2d253e9b7cdfe10
title: ARRAY_LENGTH
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/data-cloud/data-cloud-query-guide/references/data-cloud-sql-reference/scalar-func/array-func/array-length.md
canonical_url: https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/array-length.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 104d40b4754dd918ca4dec1535cea581982940cf2dc5809bdf9b0f6e445f8e97
products:
  - Data 360 Query Guide
  - Data 360 Developer Documentation
---
# `ARRAY_LENGTH`

**Applies to:** ✅ Data 360 SQL ✅ Tableau Hyper API

Returns the total number of elements in an array.

## Syntax

```sql
array_length(<array>)
```

## Arguments

### Required

- `<array>`: The array to measure.

## Returns

Returns an integer that represents the total number of elements in the array.

## Considerations

- Returns the count of all elements including NULL and duplicate values.
- For an empty array, returns 0.

## Examples

### Count Array Elements

Determine the number of elements in an array.

```sql
SELECT array_length(array[1, 2, 3]) AS element_count;
```

Returns `3`, counting all elements in the array.

## Related Documentation

- [Array Data Type](https://developer.salesforce.com/docs/data/data-cloud-query-guide/datatype/array.md)