dremio-client 0.10.1

Python client for Dremio. See https://dremio.com

Dremio client

The un-official python client for Dremio’s REST API. This enables both administrators and data scientists to get the most out of Dremio in Python

• Documentation: https://dremio-client.readthedocs.io.

• Github: https://github.com/rymurr/dremio_client

• PyPI: https://pypi.python.org/pypi/dremio_client

• Free software: Apache Software License 2.0

Features

• Cross platform support

• All Pythons between 2.7 - 3.7 supported

• Full support for Dremio’s REST API

• Optional Support for Dremio’s ODBC or experimental Arrow Flight capabilities

• Rich config file support via confuse yaml config library. Simple to create a client (config stored in a yaml file)

  from dremio_client import init
  client = init() # initialise connectivity to Dremio via config file
  catalog = client.data # fetch catalog
  vds = catalog.space.vds.get() # fetch a specific dataset
  df = vds.query() # query the first 1000 rows of the dataset and return as a DataFrame
  pds = catalog.source.pds.get() # fetch a physical dataset
  pds.metadata_refresh() # refresh metadata on that dataset

• CLI interface for integration with scripts

  $ dremio_client query --sql 'select * from sys.options'
  {'results':results}
  $ dremio_client refresh-metadata --table 'my.vds.name'
  {'result':'ok'}

• Catalog autocompletion in Jupyter Notebooks

Status

This is still alpha software and is relatively incomplete. Contributions in the form of Github Issues or Pull requests are welcome. See CONTRIBUTING

TODO

• see issues

History

0.1.0 (2019-07-04)

• First code, unreleased.

0.2.4 (2019-08-13)

• Alpha quality release with partial implementation of features. First PyPI release.

0.3.0 (2019-08-14)

• Beta quality release for GET based endpoints

0.5.0 (2019-10-30)

• Most endpoint supported

• flight support with tls & auth

• minor bugfixes

0.6.3 (2020-01-29)

• All endpoints supported

• lots of bugfixes

• utilities for building spaces/folders vds

• removed recordclass library in favor of attrs

0.8.4 (2020-01-29)

• history re-written

0.8.8 (2020-02-19)

• minor bug fixes

0.8.9 (2020-02-19)

• ensure use correct name for Spaces

0.8.11 (2020-03-09)

• bug fixes when creating sources and folders

0.9.2 (2020-03-17)

• add promote endpoint

• update versions from pyup

0.10.1 (2020-03-19)

• fix ssl verify flag in cli