> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-mintlify-8a08bda2.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

> Allows to perform queries on data exposed via an Apache Arrow Flight server.

# arrowFlight

Allows to perform queries on data exposed via an [Apache Arrow Flight](/concepts/features/interfaces/arrowflight) server.

**Syntax**

```sql theme={null}
arrowFlight('host:port', 'dataset_name' [, 'username', 'password'])
```

**Arguments**

* `host:port` — Address of the Arrow Flight server. [String](/reference/data-types/string).
* `dataset_name` — Name of the dataset or descriptor available on the Arrow Flight server. [String](/reference/data-types/string).
* `username` - Username to use with basic HTTP style authentication.
* `password` - Password to use with basic HTTP style authentication.
  If `username` and `password` are not specified, it means that authentication is not used
  (that will work only if the Arrow Flight server allows it).

**Returned value**

* A table object representing the remote dataset. The schema is inferred from the Arrow Flight response.

**Example**

```sql title="Query" theme={null}
SELECT * FROM arrowFlight('127.0.0.1:9005', 'sample_dataset') ORDER BY id;
```

```text title="Response" theme={null}
┌─id─┬─name────┬─value─┐
│  1 │ foo     │ 42.1  │
│  2 │ bar     │ 13.3  │
│  3 │ baz     │ 77.0  │
└────┴─────────┴───────┘
```

**See Also**

* [Arrow Flight](/reference/engines/table-engines/integrations/arrowflight) table engine
* [Apache Arrow Flight SQL](https://arrow.apache.org/docs/format/FlightSql.html)