Dremio Plugin for Intake based on pyarrow Flight
To install the intake-dremio plugin, execute the following command
conda install -c conda-forge intake-dremio
or:
pip install intake-dremio
When installing from the pyviz channel and conda-forge conda channels, you must ensure that libarrow-flight is also installed:
conda install -c pyviz -c conda-forge intake-dremio libarrow-flight
This is because conda-forge has split up pyarrow into individual packages as of pyarrow 16.
An Intake catalog referencing a Dremio dataset consists of the uri pointing to the Dremio instance along with a username and password and a SQL expression (sql_expr), e.g.:
sources:
  dremio_vds:
    driver: dremio 
    args:
        uri: grpc+tcp://{{ env(DREMIO_USER) }}:{{ env(DREMIO_PASSWORD) }}@x.x.x.x:32010  
        sql_expr: SELECT * FROM TABLE ORDER BY "timestamp" ASC