Search code examples
azureazure-data-lakeazure-synapsepolybase

Polybase over Data Lake - what is the OAuth_2.0_Token_EndPoint?

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?

Solution

  • 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.