Failed to Import Schema from Azure SQL Database to Data Factory

  Kiến thức lập trình

Each time I try to load a table using Azure Data Factory from Azure SQL I run into issue of Loading Schema, I really don’t know what is responsible for this. Solutions and Suggestions would be highly appreciated

I tried using my Azure SQL Username and Paaword to login which was successfull but Importing Schema fails after a successfull connection

New contributor

Attamah Chikaodili is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

Your issue may be permission related. Ensure you are connected with a user which has dbmanager or suitable admin role, then execute this:

USE [YourDatabaseName];
GRANT VIEW DEFINITION TO [YourUserName];

LEAVE A COMMENT