The Azure Blob Storage Connector, known by the type name blob
, exposes stored procedures to leverage resources stored in Azure Blob Storage.
Type Name
blob
Connection Properties
Template name: blob
Appropriate translator name: ufile
Properties:
accountName
(required)accountKey
sasToken
containerName
(required)defaultEndpointsProtocol
prefix
batchSize
min-pool-size
(default:0
)max-pool-size
(default:100
)
Connector-specific Connection Properties
Property name | Description |
---|---|
accountName | Azure account name |
accountKey | Azure account key |
sasToken | SAS token |
defaultEndpointsProtocol | Default endpoint protocol |
containerName | Name of the Azure container |
prefix | The |
sasToken
and accountKey
are mutually exclusive: either a SAS Token or an Account Key must be specified.
Examples
1. Connecting using an Account Key:
CALL SYSADMIN.createConnection(
name
=>
'blob'
, jbossCLITemplateName =>
'blob'
, connectionOrResourceAdapterProperties =>
'accountName=<accountName>,accountKey=<accountKey>,defaultEndpointsProtocol=https,containerName=<container name>'
);;
CALL SYSADMIN.createDataSource(
name
=>
'blob'
, translator =>
'ufile'
, modelProperties =>
'importer.useFullSchemaName=false'
, translatorProperties =>
''
);;
2. Connecting using a SAS Token:
Example
CALL SYSADMIN.createConnection(
name
=>
'blob'
, jbossCLITemplateName =>
'blob'
, connectionOrResourceAdapterProperties =>
'accountName=<accountName>,sasToken=<sasToken>,defaultEndpointsProtocol=https,containerName=<container name>'
);;
CALL SYSADMIN.createDataSource(
name
=>
'blob'
, translator =>
'ufile'
, modelProperties =>
'importer.useFullSchemaName=false'
, translatorProperties =>
''
);;
Prefix
The prefix allows to limit the result set.
- The 'Prefix' property value gets passed in
connectionOrResourceAdapterProperties
; - All procedures of the connector automatically take the prefix into consideration: e.g., calling
listFiles(pathAndPattern => NULL)
still applies the prefix from the data source settings; - If the data source has a prefix configured, and a
pathAndPattern
gets passed, the values get concatenated. For example, if a data source is configured with prefixa/b
, andlistFiles(pathAndPattern => 'c/d')
gets called, this results ina/b/c/d
.