We are planning to use a Azure blob storage (csv file in a container) as a External data source in our Azure SQL database. We need to Possibly importing data from this CSV to a table , planning to use a Bulk insert.
The Admin user on the database is performing the below operations
1) creating a database scoped credential
2) creating a external data source with this credential.
when invoking the bulk insert, it returns that the credentials created cannot be found or does not have access. I am using the admin user on the database. There is no way to grant anything to this user otherwise. what could be wrong?
