How to expand AnySql Model table list

Legacy Contributor

I am finally approaching an Enterprise Location milestone.  I have a SqlServer Database Location point connecting to a local database, and want to publish data to DataLake.  However, only the first few tables are available to the Add Object dialog.

How do I expand this list to include all tables ? 

 

Note:  I built the COR tables provided by the Enterprise Connector, they default to the "dbo" schema.  

Legacy Contributor

The Enterprise connector defaults to the "sa" username



The value of DEFAULT_SCHEMA is ignored if the user is a member of the sysadmin fixed server role. All members of the sysadmin fixed server role have a default schema of dbo.



sa is sysadmin and defaults to dbo.



Solution is to create a new user, then under Databases, Security, Users, Properties, Owned Schemas assign the user to the schema that owns the tables. After I did this, I was able to see all tables in my Add Objects dialog