Azure Table (Beta)
Azure Table Storage is a NoSQL key-value store that provides highly scalable and cost-effective storage for structured, non-relational data. It is ideal for applications that need to store large volumes of semi-structured data while supporting fast queries based on partition and row keys. As part of Azure Storage, it integrates seamlessly with other Azure services and offers high availability and durability.
Prerequisites
The following prerequisites must be met for a user to create and test a successful connection.
- The Azure Table server must be accessible from the iceDQ server.
- Valid credentials to access the data.
- Azure Table Custom JDBC version 23 or above.
This connector is currently in Beta version and should not be used in production environments.
Authentication Mechanism
The following authentication mechanism is supported.
- Azure Access Key
Connection Properties
Use one or more properties from the table below to create a valid connection. Properties marked with an asterisk (*) are required.
| Name | Description | Example Values |
|---|---|---|
| Connection Name * | A unique name that identifies the connection. | Prod_sales_data |
| Driver * | Driver used to establish the connection. By default, one driver is available. | Azure Table Custom JDBC |
| Storage Type * | The type of storage on the Azure account - Azure Table or Azure Cosmos DB Table | Azure Table |
| Type * | The connection type, either System Connection or User Connection. Refer Connections for more details. | System |
| Storage Account Name * | The storage account name used for authentication. | prod_storageaccount |
| Access Key * | The access key used to authenticate the connection to the storage account. | Wsrgaezbh2576ies4r6u796 |
Custom Properties
The following optional connection properties can be configured based on user requirements.
| Property | Default Value | Possible Values | Description |
|---|---|---|---|
| Readonly | true | true/false | Specifies if the connection is read-only. |
| ConnectionLifeTime | 0 | Integer (seconds) | Lifetime of the connection in seconds. |
| ConnectOnOpen | N/A | true/false | Whether to connect automatically when opening the connection. |
| MultiThreadCount | N/A | Integer | Number of threads used for parallel processing. |
| Pagesize | N/A | Integer | Number of rows per page for data retrieval. |
| AzureEnvironment | N/A | String | Azure cloud environment (e.g., AzurePublic, AzureUSGovernment). |
| BatchSize | N/A | Integer | Number of records processed per batch. |
| Timeout | N/A | Integer (seconds) | Connection timeout in seconds. |
Supported Datatypes
The following datatypes are supported.
- BIGINT (INT64)
- BIT (BOOLEAN)
- FLOAT (DOUBLE)
- INT (INT32)
- TIMESTAMP (DATETIME)
- VARCHAR (STRING)