analytics-catalog-server/me.ahoo.wow.analytics.catalog.server/ClickHouseDatasetWarehouse

ClickHouseDatasetWarehouse

class ClickHouseDatasetWarehouse(client: Client) : DatasetWarehouse

The datasets' views on a ClickHouse server, over the host's client-v2 client: a publication creates its database if it is not there, runs its DDL and reads the view's columns back (a view whose column a dataset cannot serve, such as a map, is dropped again and refused); the end of a retirement drops the views. The account needs CREATE DATABASE, CREATE VIEW and DROP VIEW on the datasets' database, and SELECT on the sources the views read.

Constructors

constructor(client: Client)

Functions

create

open suspend override fun create(artifact: DatasetArtifact): List<SourceColumn>

describe

open suspend override fun describe(select: String): List<SourceColumn>?

Runs select for no row, so the server plans it against its tables as they are now (a DESCRIBE of a view may answer from the view's own metadata), and reads its columns' names and types from the result's header.

drop

open suspend override fun drop(database: String, views: List<String>)