RisingWave Community - How can I make a connection to Cassandra for data enrichment in RisingWave?

One way to connect Cassandra for data enrichment in RisingWave is by using a UDF to lookup the external table.
You can check the example provided in the RisingWave documentation for querying external data in PostgreSQL via RisingWave.
Another approach is to stream the Cassandra CDC to a Kafka topic and subscribe to the topic in RisingWave to get the table updated automatically.
Consider self-managed UDF Server to ensure performance and consistency in the RW cluster.
The ability to access sources through jdbc/odbc for 'not streaming' sources is on the roadmap for RisingWave.
Replicating a table from Cassandra to RisingWave may not be the best option due to existing PK-optimized access in Cassandra.