Connect
Also in Cloud

azure_table_storage

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

Introduced in version 4.10.0.

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.

  • Common

  • Advanced

input:
  label: ""
  azure_table_storage:
    storage_account: ""
    storage_access_key: ""
    storage_connection_string: ""
    storage_sas_token: ""
    table_name: "" # No default (required)
input:
  label: ""
  azure_table_storage:
    storage_account: ""
    storage_access_key: ""
    storage_connection_string: ""
    storage_sas_token: ""
    table_name: "" # No default (required)
    filter: ""
    select: ""
    page_size: 1000

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 access key for the storage account. Use this field along with storage_account for authentication. This field is ignored when the storage_connection_string field is populated.

Type: string

Default: ""

storage_account

The storage account to access. This field is ignored when the storage_connection_string field is populated, unless the connection string does not contain the AccountName parameter.

Type: string

Default: ""

storage_connection_string

The connection string for the storage account. This field is required if storage_account is not set.

If the storage_connection_string field does not contain the AccountName parameter value, specify it in the storage_account field.

Type: string

Default: ""

storage_sas_token

The SAS token for the storage account. Use this field along with storage_account for authentication. This field is ignored when either the storage_connection_string or storage_access_key fields are populated.

Type: string

Default: ""

table_name

The table to read messages from.

Type: string

# Examples:
table_name: Foo