Skip to main content

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​

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

  2. Select the Warehouse that the blueprints will be connecting to

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

  1. 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)

  1. 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:

-- for the catalog in use
GRANT USE CATALOG ON CATALOG <catalog> TO
<shipyard-token>;

GRANT CREATE ON CATALOG <catalog> TO 
<shipyard-token>;

-- for the schema in use
GRANT CREATE ON SCHEMA <schema> TO 
<shipyard-token>;

GRANT SELECT ON SCHEMA <schema> TO 
<shipyard-token>;

GRANT MODIFY ON SCHEMA <schema> TO 
<shipyard-token>;