Apache Impala (Preview)
Apache Impala (incubating) is the open source, native analytic database for Apache Hadoop. Connect to your Impala database to read data from tables.
This connector is available in the following products and regions:
| Service | Class | Regions |
|---|---|---|
| Logic Apps | Standard | All Logic Apps regions except the following: - Azure Government regions - Azure China regions - US Department of Defense (DoD) |
| Power Automate | Premium | All Power Automate regions except the following: - US Government (GCC) - US Government (GCC High) - China Cloud operated by 21Vianet - US Department of Defense (DoD) |
| Power Apps | Premium | All Power Apps regions except the following: - US Government (GCC) - US Government (GCC High) - China Cloud operated by 21Vianet - US Department of Defense (DoD) |
| Contact | |
|---|---|
| Name | Microsoft |
| URL | Microsoft LogicApps Support Microsoft Power Automate Support Microsoft Power Apps Support |
| Connector Metadata | |
|---|---|
| Publisher | Microsoft |
| Website | https://impala.apache.org/ |
| Privacy policy | https://www.apache.org/foundation/policies/privacy.html |
Creating a connection
The connector supports the following authentication types:
| Default | Parameters for creating connection. | All regions | Shareable |
Default
Applicable: All regions
Parameters for creating connection.
This is shareable connection. If the power app is shared with another user, connection is shared as well. For more information, please see the Connectors overview for canvas apps - Power Apps | Microsoft Docs
| Name | Type | Description | Required |
|---|---|---|---|
| Server | string | Server | True |
| Authentication | string | Authentication type | |
| Username | securestring | Username | |
| Password | securestring | Password | |
| Gateway | gatewaySetting | On-prem gateway (see https://docs.microsoft.com/data-integration/gateway for more details | |
| Encrypt Connection | bool | Encrypt Connection |
Throttling Limits
| Name | Calls | Renewal Period |
|---|---|---|
| API calls per connection | 100 | 60 seconds |
Actions
| Get row |
Retrieves a single row from an Impala table |
| Get rows |
Retrieves rows from an Impala table |
| Get tables |
Retrieves tables from an Impala database |
Get row
Retrieves a single row from an Impala table
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Name of database
|
dataset | True | string |
Name of database |
|
Name of table
|
table | True | string |
Name of table |
|
Row id
|
id | True | string |
Unique identifier of the row to retrieve |
Returns
Get rows
Retrieves rows from an Impala table
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Name of database
|
dataset | True | string |
Name of database |
|
Name of table
|
table | True | string |
Name of table |
|
Filter Query
|
$filter | string |
An ODATA filter query to restrict the entries returned (e.g. stringColumn eq 'string' OR numberColumn lt 123). |
|
|
Order By
|
$orderby | string |
An ODATA orderBy query for specifying the order of entries |
|
|
Skip Count
|
$skip | integer |
Number of entries to skip (default = 0) |
|
|
Maximum Get Count
|
$top | integer |
Maximum number of entries to retrieve (default = 256) |
|
|
Select Query
|
$select | string |
Specific fields to retrieve from entries (default = all). |
Returns
Get tables
Retrieves tables from an Impala database
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Name of database
|
dataset | True | string |
Name of database |
Returns
- Body
- TablesList
Definitions
Table
| Name | Path | Type | Description |
|---|---|---|---|
|
Name
|
Name | string | |
|
DisplayName
|
DisplayName | string |
TablesList
| Name | Path | Type | Description |
|---|---|---|---|
|
value
|
value | array of Table |