Default schema for connection
MRvLuijpen
Partner, L2 Admin, L2 Designer, Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Dataiku DSS Adv Designer, Registered, Dataiku DSS Developer, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Frontrunner 2022 Participant, Neuron 2023 Posts: 107 Neuron
Hello Community,
Is it correct that if in a connection no default schema is entered, the default value was 'dbo' previously, but lately it's <username>.
Is this a setting which we can change back to the 'dbo' default value?
Thanks in advance.
Marc Robert
Best Answer
-
Hi,
If nothing is entered within DSS, the choice of the default schema is up to your SQL Server, as DSS will not be sending any specific command for it. We do not see a reason within DSS that would have caused this to change.