--Step 1
use MASTER
IF NOT EXISTS (SELECT * FROM sys.databases WHERE NAME = 'SoftwareSmithPolyBase')
CREATE DATABASE SoftwareSmithPolyBase;
GO
use SoftwareSmithPolyBase
--Step 2 Create the data source
--Need PolyBase installed
CREATE EXTERNAL DATA SOURCE NYCTaxiExternalDataSource
WITH (LOCATION = 'abs://nyctlc@azureopendatastorage.blob.core.windows.net');
--accreditation
https://learn.microsoft.com/en-us/sql/relational-databases/polybase/polybase-get-started?view=sql-server-ver17&preserve-view=true
--housekeeping
use master
IF EXISTS (SELECT * FROM sys.databases WHERE NAME = 'SoftwareSmithPolyBase')
DROP DATABASE SoftwareSmithPolyBase;
GO
