Default schema for connection

MRvLuijpen
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

  • Clément_Stenac
    Clément_Stenac Dataiker, Dataiku DSS Core Designer, Registered Posts: 753 Dataiker
    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.

Setup Info
    Tags
      Help me…