Lesson 13. Create External Tables In Your Own Azure SQL Database
https://factsanddimensions.co.uk
Facts and Dimensions provide 1000s of tables of publicly available stats and reference data, ready to query immediately.
See how create the external tables you need in your own Azure SQL Database. Especially useful so you can query your data and join our data.
REMEMBER, you need to request your base password from Facts and Dimensions for this to work. That is a different password to your normal password.
Code from the video
declare @sql varchar(max)
declare @Username varchar(max) = '' --Your Facts and Dimensions username.
declare @Username_Base_Password varchar(max) = '' --Different password to usual. Facts and Dimensions will email it to you on request.
declare @Username_Base varchar(max)
set @Username_Base = @Username + '_Base'
set @sql = '
create DATABASE SCOPED CREDENTIAL ' + @Username_Base + '_Credential
WITH IDENTITY = ''' + @Username_Base + '@factsanddimensions'',
SECRET = ''' + @Username_Base_Password + ''';'
print @sql
exec(@sql)