Try your hand at analyzing royal sentiment in Dataiku DSS! Learn more

default schema of a connection

Level 3
Level 3
default schema of a connection

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

0 Kudos
1 Reply
Dataiker
Dataiker

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

0 Kudos