Skip to content

New python module for accessing SDS ClickHouse Database

Jason Brudvikrequested to merge
create-clickhouse-client into main

This is the first step in creating a python client for the SDS clickhouse database.

It's pretty simple at the moment:

  • search for exact matches of PV names in the database
  • the data queries for now are limited to:
    • pv name
    • start time
    • end time

The plan is to add more search and query functionality in the future.

The returned data format is a dictionary of polars dataframes. I don't know if this is the best choice or not, but currently ops-data-client is setup to use this, and polars seems easier to work with than pandas.

Merge request reports