About Queries

Querying

In Raven it is possible to query indexed tables and brick data. To query data, go to the Query tab.

Queries are written in PostgreSQL. Results of the query will be displayed in a table and can be exported as an Excel or as an Arrow file.

Configuring query results

In some cases the query results might contain columns that aren't correctly typed. To update the type of these columns, click the cogwheel button on the top right of the result table. A tab where open where you can configure the types correctly.

Using the Arrow file

Arrow files can be loaded into python using the pyarrow module.

The script below shows how to do so:

import pyarrow as pa

fp = "/path/to/arrow/file/export.arrow"

with open(fp, "rb") as f:

stream = pa.input_stream(f)

table = pa.ipc.open_stream(stream).read_all()

dataframe = table.to_pandas(split_blocks=True, self_destruct=True)

This will give you a pandas DataFrame you can use for further analysis.