azure_table_storage

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

Introduced in version 4.10.0.

  • Common

  • Advanced

# 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)
# 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 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

# 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: ""

# 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: ""

# Examples

select: PartitionKey,RowKey,Foo,Bar,Timestamp

page_size

Maximum number of records to return on each page.

Type: int

Default: 1000