Missed guide docs

[st1page]

At the same time, we have other features only having documents in "Develop - SQL references" section.
https://github.com/risingwavelabs/risingwave-docs/issues/2442#issue-2455230362

We need to fullfill them in the "Manage data" section

• create sink into table
• AS CHANGELOG
• distinct/dedup
• group top 1 with distinct & order clause
• append only
• flush & DML's durability https://docs.risingwave.com/docs/next/sql-flush/

[kwannoel]

We also need to explain the difference between source and table in our docs.

CREATE SOURCE does not guarantee that distinct relations reading from the same source will be processing the same set of updates between each epoch. The caveat is if the source is a shared source, then each relation reading from the same source will process the same set of updates between each epoch. This also means we can't have a strongly consistent global state for these relations, only eventual consistency.

CREATE TABLE guarantees that distinct relations reading from the same source, materialized as a table, will process the same set of updates between each epoch. This means we will have a strongly consistent global state.

I recommend putting this doc under the sources page: https://docs.risingwave.com/docs/current/sources/. And linking it as a note in each source page perhaps, in case users want to read up more.

[st1page]

We also need to explain the difference between source and table in our docs.

CREATE SOURCE does not guarantee that distinct relations reading from the same source will be processing the same set of updates between each epoch. The caveat is if the source is a shared source, then each relation reading from the same source will process the same set of updates between each epoch. This also means we can't have a strongly consistent global state for these relations, only eventual consistency.

CREATE TABLE guarantees that distinct relations reading from the same source, materialized as a table, will process the same set of updates between each epoch. This means we will have a strongly consistent global state.

I recommend putting this doc under the sources page: https://docs.risingwave.com/docs/current/sources/. And linking it as a note in each source page perhaps, in case users want to read up more.

Currently the difference is noted here https://docs.risingwave.com/docs/current/data-ingestion/#table-with-connectors, But the consistency issue is not mentioned