---
schema_version: "1"
id: c035a720295560ef4071b399726bbfc5ec454f472604f7d428920f9bed88ed03
title: ARRAY_REMOVE_AT
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-remove-at.md
canonical_url: https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/array-remove-at.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 9c699ceff3557a4c1328fff3d896f2f6fab47279f147532e844feb3fe917ea0c
products:
  - Data 360 Query Guide
  - Data 360 Developer Documentation
---
# `ARRAY_REMOVE_AT`

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

Returns an array with the element at a specified position removed.

## Syntax

```sql
array_remove_at(<array>, <position>)
```

## Arguments

### Required

- `<array>`: The source array.
- `<position>`: The 1-based index of the element to remove.

## Returns

Returns an array with the element at the specified position removed.

## Considerations

- Validate positions before use to avoid unexpected behavior with out-of-bounds values. If you provide a position out-of-bounds no array elements are removed.

## Examples

### Remove at Position

Remove the element at index 2.

```sql
SELECT array_remove_at(array[1, 3, 5, 3], 2) AS result;
```

Returns `array[1, 5, 3]`, removing the element at position 2.

## Related Documentation

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