Instructions for Configuring Unity Catalog

Created by Matt Nolan, Modified on Tue, Jun 10 at 3:53 PM by Matt Nolan

Open Stardog Studio
Select Catalog from the database dropdown
Update Sample #1 with the serverAddress and Token for the account you wish to use to access the unity catalog
- Sample #1
  INSERT DATA { graph <tag:stardog:api:catalog:providers> {
  <urn:Unity_Catalog_Databricks> a <tag:stardog:api:catalog:DatabricksProvider> ;
  <tag:stardog:api:catalog:provider:serverAddress> "<example_endpoint_name.cloud.databricks.com:443>" ;
  <tag:stardog:api:catalog:provider:userName> "token" ;
  <tag:stardog:api:catalog:provider:password> "<Replace with Your Token Here>" ;
  <tag:stardog:api:catalog:provider:schedule> "0 0 0/12 ? * * *" .
  }}
Once updated, execute the query to update the access configuration
Open the catalog interface and verify that the connection is listed
Execute Jobs Query to collect the logs for the catalog using Sample #2 Query.
- Sample #2
  select * {
  graph <tag:stardog:api:catalog:jobs> {
  ?s <tag:stardog:api:catalog:message> ?o; stardog:catalog:completedAt ?o2
  }
  }
  order by DESC(?o2)
Send output.
Update the model definition by executing Sample #3.
- Sample #3
  insert data{
  <tag:stardog:api:catalog:provider:providedBy> a <http://www.w3.org/2002/07/owl#ObjectProperty> ;
  <https://schema.org/domainIncludes> <tag:stardog:api:catalog:databricks:Databricks> ;
  <https://schema.org/rangeIncludes> <tag:stardog:api:catalog:DatabricksProvider>.
  }
Once complete the synchronization job will run at some interval.
- Use Sample #2 query to validate the operation.