crate / crate/cratedb-toolkit

[I/O] Interface: `ctk load` vs. `CREATE INGEST RULE`

Open
#524 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
10
Forks
5
Avg merge
7d 5h
Merged PRs (30d)
7

Description

## About

Once upon a time, CrateDB had an Ingestion Framework which provided the `CREATE INGEST RULE` command. Maybe use that syntax to provide another interface to `ctk load`?

## Synopsis

```sql
CREATE INGEST RULE rule_name
ON source_ident
[WHERE condition]
INTO table_ident
```

## Example

```sql
CREATE INGEST RULE mqtt_v4_rule
ON mqtt
WHERE topic like 'v4/%'
INTO mqtt_v4
```

## References

- https://cratedb.com/docs/crate/reference/en/3.3/admin/ingestion/
- https://cratedb.com/docs/crate/reference/en/3.3/sql/statements/create-ingest-rule.html
- https://cratedb.com/blog/getting-started-cratedb-mqtt-endpoint

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.