I'm encountering an issue where I'm trying to create a sink from Risingwave to our database, but it seems that the sink query is trying to create the sink in the public
schema, while the materialized view we are creating is in the test
schema in Risingwave. Is there a way to specify the schema and table to sink the data from Risingwave?
Dat Nguyen
Asked on Jun 15, 2023
Try using the currentSchema
parameter in your JDBC connection string to specify the schema. For example:
jdbc:<postgresql://localhost:5432/mydatabase?currentSchema=myschema>