Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
default schema of a connection
Added on July 24, 2020 1:00PM
Likes: 0
Replies: 1
Marc Robert
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 you don't enter anything a schema in a connection the default schema used is <username> and that previously it was <dbo>?
If so, can we change it back?
Thanks in advance
Marc Robert
Answers
-
Hi Marc,
The default schema behavior shouldn't have changed. For "dbo", this is typically the default schema that is used in SQLServer specifically. Other databases may have different schemas that they default to so the behavior might not be the same across all connections.
Could you clarify which connection type you are referring to and if you are observing different behavior? If so, could you include screenshots of what you are seeing (including the corresponding connection settings of the particular connection you are using)?
Thanks,
Andrew
