= azure_table_storage
:type: input
:status: beta
:categories: ["Services","Azure"]



////
     THIS FILE IS AUTOGENERATED!

     To make changes, edit the corresponding source file under:

     https://github.com/redpanda-data/connect/tree/main/internal/impl/<provider>.

     And:

     https://github.com/redpanda-data/connect/tree/main/cmd/tools/docs_gen/templates/plugin.adoc.tmpl
////

// © 2024 Redpanda Data Inc.


component_type_dropdown::[]


Queries an Azure Storage Account Table, optionally with multiple filters.

Introduced in version 4.10.0.


[tabs]
======
Common::
+
--

```yml
# Common config fields, showing default values
input:
  label: ""
  azure_table_storage:
    storage_account: ""
    storage_access_key: ""
    storage_connection_string: ""
    storage_sas_token: ""
    table_name: Foo # No default (required)
```

--
Advanced::
+
--

```yml
# All config fields, showing default values
input:
  label: ""
  azure_table_storage:
    storage_account: ""
    storage_access_key: ""
    storage_connection_string: ""
    storage_sas_token: ""
    table_name: Foo # No default (required)
    filter: ""
    select: ""
    page_size: 1000
```

--
======

Queries an Azure Storage Account Table, optionally with multiple filters.
== Metadata
This input adds the following metadata fields to each message:

- table_storage_name
- row_num

You can access these metadata fields using xref:configuration:interpolation.adoc#bloblang-queries[function interpolation].

== Fields

=== `storage_account`

The storage account to access. This field is ignored if `storage_connection_string` is set.


*Type*: `string`

*Default*: `""`

=== `storage_access_key`

The storage account access key. This field is ignored if `storage_connection_string` is set.


*Type*: `string`

*Default*: `""`

=== `storage_connection_string`

A storage account connection string. This field is required if `storage_account` and `storage_access_key` / `storage_sas_token` are not set.


*Type*: `string`

*Default*: `""`

=== `storage_sas_token`

The storage account SAS token. This field is ignored if `storage_connection_string` or `storage_access_key` are set.


*Type*: `string`

*Default*: `""`

=== `table_name`

The table to read messages from.


*Type*: `string`


```yml
# Examples

table_name: Foo
```

=== `filter`

OData filter expression. Is not set all rows are returned. Valid operators are `eq, ne, gt, lt, ge and le`


*Type*: `string`

*Default*: `""`

```yml
# Examples

filter: PartitionKey eq 'foo' and RowKey gt '1000'
```

=== `select`

Select expression using OData notation. Limits the columns on each record to just those requested.


*Type*: `string`

*Default*: `""`

```yml
# Examples

select: PartitionKey,RowKey,Foo,Bar,Timestamp
```

=== `page_size`

Maximum number of records to return on each page.


*Type*: `int`

*Default*: `1000`


