Answered by:

USQL Problem getting Credentials for external SQL database

Question

Im trying to do a CREATE DATA SOURCE in USQL, but I can't fetch the Credentials object from the ADLA catalog.

I have created it using the new PowerShell approach at https://docs.microsoft.com/en-us/powershell/module/azurerm.datalakeanalytics/new-azurermdatalakeanalyticscatalogcredential?view=azurermps-5.0.0

In this old days you could use CREATE CREDENTIALS, but this is deprecated. I need to create the MyCredentials object for putting on the CREDENTIALS=MyCredentials part of the CREATE DATA SOURCE statement.

All replies

Strange - it works now when I compile against the online Data Lake Analytics Account (the dropdown atop the USQL script in VS2017).

I followed the guide you mention, but it gave a wierd compile error mentioning something about OPTION ; near the point in the code where the credentials were. This was gone about 90 minutes after I posted, so maybe it was some
latency issue?!