Catalog API

The Fusion Catalog is a collection of one or more analytics projects, and each project is a collection of data assets, such as tables or relations. Fusion comes with a built-in project called "fusion".

The Fusion Catalog API provides access to assets by data analysis applications that can perform SQL or Solr queries. It includes endpoints for finding, retrieving, and manipulating projects and assets using basic keyword and metadata-driven search.

By default, non-admin Fusion users do not have access to Catalog objects. However, the Catalog API itself does not enforce any permissions, so a user who bypasses the auth proxy has full access to all projects and assets. An admin can grant permissions to Catalog endpoints for users; see Access Control.

For PUT and POST requests, these are valid JSON body attributes:

Name Type Description

projectId

String

The project name

name

String

The asset name

assetType

DataAssetType

One of: + * project * table * relation * field * udf * metric

description

String

A string describing this asset

sourceUri

String

A URI to the data source

owner

String

The user that owns the asset

ownerEmail

String

The owner’s email address

tags

Set<String>

A set of arbitrary category strings

format

String

The format of the underlying data source

options

List<String>

A list of options for the underlying data source

filters

List<String>

A set of Solr query parameters to filter the request

sql

String

A SQL statement to execute

cacheOnLoad

boolean

'True' to cache the dataset in Spark on catalog project initialization

dependsOn

List<String>

A list of other assets to load before initializing this data asset

createdOn

Date

The asset’s creation date, in ISO-8601 format; otherwise the current timestamp is used

Example

Add a "ratings" table to the "movielens" project:

curl -XPOST -H "Content-type:application/json" \
-d '{
  "name": "ratings",
  "assetType": "table",
  "projectId": "movielens",
  "description": "movie ratings data",
  "tags": ["movies"],
  "format": "solr",
  "cacheOnLoad": true,
  "options": ["collection -> movielens_ratings", "fields -> user_id,movie_id,rating,rating_timestamp"]
}' "http://$FUSION/api/v1/catalog/movielens/assets"