Specifiy or select non default schema when pulling external source from Azure SQL server using JDBC
In previous versions of Aperture Data Studio is stated that their were bug fixes related to SQL Server:
- You can now preview and load data from other schemas, not just the connected user’s default schema.
A current using version 2.0.0
I am connecting to Azure SQL and during the Add Data, select tables I only see the tables without schema prefix.
Appears that if there is more than one schema in the database specified in the connection string, then we hit an error even thought schema was specified as part of JDBC connection. I understand there is a limitation between JDBC and MS SQL and the schema cannot be used in the connection string.
So it has recognised the database and seen the tables.
Following a debug on SQL server I can observe that the schema is not passed into the SQL statement/Stored Proc.
This workaround would fix this problem.