Databricks SQL Warehouse - Authorization

In order to get started with the Databricks SQL Warehouse Blueprints, you will need generate an access token for programatic SQL access. Additionally, you will need to obtain the Server Host address as well as the HTTP Path for the SQL warehouse. This guide will outline how to obtain all necessary fields.

Obtaining an Access Token

On the sidebar, navigate to the SQL Warehouses tab. This will pull up the active warehouses in your workspace.

Select the Warehouse that the blueprints will be connecting to

In bottom right corner of the Connection details tab, select the Create a personal access token link, then select Generate new token

This will prompt you to specify a comment and a lifetime. For the comment, you can put Shipyard Blueprints, and the lifetime can be left blank (meaning no expiration)

Be sure to copy the access token and save it a secure location

Obtaining the Server Host and HTTP Path

Both the Server Host and HTTP can be found in the Connection details of a SQL Warehouse.

Granting Appropriate Access

In order for the blueprints to run successfully, they will need read/write access for both tables and schemas. Have your Databricks Admin run the following for the email associated with the access token created for Shipyard:
```sql
-- for the catalog in use
GRANT USE CATALOG ON CATALOG TO
;

GRANT CREATE ON CATALOG TO
;

-- for the schema in use
GRANT CREATE ON SCHEMA TO
;

GRANT SELECT ON SCHEMA TO
;

GRANT MODIFY ON SCHEMA TO
;
```