azure_table_storage

Type:

Available in: Cloud, Self-Managed

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

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'

page_size

Maximum number of records to return on each page.

Type: int

Default: 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

storage_access_key

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

Type: string

Default: ""

storage_account

The storage account to access. 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