SQL Connector Schema Provider not showing error

Matthew Davis (Engineering Manager) 1 year ago updated 8 months ago 1

Noticed today that if you've got a database connector, and the account you're connecting with has access to the database but no roles assigned (db_reader etc) then a request schema will not show an error - it will instead show that there are no schema fields.

Test agent completes without issue.

The only way to show the error (no SELECT permission), you have to manually add a schema field and attempt an import.

The schema provider should display this same error when attempting to get the schema.

Affected Versions:
Fixed by Version: