2

I'm trying to connect my Azure SQL Data Warehouse to my Datalake, following the microsoft guide.

Microsoft give the following code sample, but do not clarify what the OAuth_2.0_Token_EndPoint is and where to find it in the Azure portal.

CREATE DATABASE SCOPED CREDENTIAL ADLCredential
WITH
IDENTITY = '<client_id>@<OAuth_2.0_Token_EndPoint>',
SECRET = '<key>'

How do I work out what this should be?

Neil P
  • 2,920
  • 5
  • 33
  • 64

2 Answers2

3

This is documented here: https://learn.microsoft.com/en-us/azure/data-lake-store/data-lake-store-authenticate-using-active-directory#step-4-get-the-oauth-20-token-endpoint-only-for-java-based-applications

In the portal, go to AAD, click App registrations, then click Endpoints.

Alexandre Gattiker
  • 749
  • 3
  • 5
0

Taken from @BenV's Answer

Go to https://login.windows.net/YOURDIRECTORYNAME.onmicrosoft.com/.well-known/openid-configuration and you'll see a bunch of URLs containing your tenant ID.

Once you are at that link, look for the entry for "token_endpoint". Copy and paste this value into the code posted above.

Community
  • 1
  • 1
Neil P
  • 2,920
  • 5
  • 33
  • 64