Would it be possible for CloudQuery to create a database/schema if it is not existing, instead of showing an error?
Yes! Which plugin are you using? If PostgreSQL, then you can use migrate_mode: forced
in the destination spec.
Ah, great! Can it be used in append mode?
Actually, one sec - just to clarify, you mean schema or tables?
I am trying to understand how the schema in PostgreSQL relates to the search_path
. Specifically, could someone clarify the concept of a schema as a namespace in PostgreSQL? How does it connect to the search_path
setting? Any details or examples would be greatly appreciated!
I see, in that case we don’t create the schema at the moment. We can look into it (I thought about recreating the tables if they are not migratable).
No, just covering the use case. I have a proper user:pass bot. The entire config, like db_name:schema
, could be created if it is not existing.