Database schema
rafael_rosado97
Partner, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 62 Partner
I have a connection to a postgres database. In this database there are two schemes.
Is there a way to specify which schema the datasets should be written to?
Operating system used: Ubuntu
Operating system used: Ubuntu
Tagged:
Answers
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,160 NeuronYes, this needs to be enabled in the PostgreSQL connection by a Dataiku Administrator. You can set the connection Schema to anything you want, including using a variable. You can also enable or disable the "Allow schema override" which as the screen states "If this is enabled, an option to choose a schema will be presented to users each time they create a managed dataset on this connection". Personally I think it's best to not enable the schema override and handle multi-schema outputs with variables.
