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
Power Automate Premium All Power Automate regions except the following:
     -   US Government (GCC)
     -   US Government (GCC High)
Power Apps Premium All Power Apps regions except the following:
     -   US Government (GCC)
     -   US Government (GCC High)

Creating a connection

To connect your account, you will need the following information:

Name Type Description
Server string

Server

Authentication string

Authentication type

Username securestring

Username

Password securestring

Password

Gateway gatewaySetting

Throttling Limits

Name Calls Renewal Period
API calls per connection10060 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

The outputs of this operation are dynamic.

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

The outputs of this operation are dynamic.

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