How to specify a schema when creating a sink in Risingwave?

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>

Jun 20, 2023Edited by