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 detailstab, select theCreate a personal access tokenlink, then selectGenerate 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
;
```