Actions42
- Genie Actions
- Databricks SQL Actions
- Unity Catalog Actions
- Model Serving Actions
- Files Actions
- Vector Search Actions
Overview
This node integrates with the Databricks API, specifically supporting multiple resources including Unity Catalog. For the Unity Catalog - List Tables operation, it retrieves a list of tables within a specified schema and catalog in your Databricks workspace.
This is useful when you want to programmatically explore or audit the data assets registered in Unity Catalog, automate workflows that depend on table metadata, or dynamically populate UI elements based on available tables.
Example use cases:
- Automatically fetching all tables in a schema before running data quality checks.
- Building dashboards that reflect current data assets without manual updates.
- Integrating with other systems that require knowledge of available tables for ETL or reporting.
Properties
| Name | Meaning |
|---|---|
| Catalog | Select a Unity Catalog to work with. The list is automatically populated from your Databricks workspace. |
| Schema | Select a schema from the chosen catalog. The list is dynamically loaded based on the selected catalog. |
Output
The output JSON contains an array of tables retrieved from the specified catalog and schema. Each item in the output corresponds to a table object as returned by the Databricks Unity Catalog API. The exact structure depends on the API response but typically includes table names, types, creation timestamps, and other metadata.
No binary data output is produced by this operation.
Dependencies
- Requires an active Databricks workspace with Unity Catalog enabled.
- Needs an API authentication token (API key or personal access token) configured in n8n credentials to authorize requests.
- The node uses the Databricks REST API endpoints under
/api/2.1/unity-catalog/.
Troubleshooting
Common issues:
- Invalid or expired API token leading to authorization errors.
- Selecting a catalog or schema that does not exist or to which the token lacks access.
- Network connectivity problems preventing API calls.
Error messages:
API Error: 401 Unauthorized— Check that your API token is valid and has sufficient permissions.API Error: 404 Not Found— Verify that the catalog and schema names are correct and exist in your workspace.Network Error: No response received from server— Confirm network connectivity and that the Databricks host URL is correctly configured.
Resolution tips:
- Refresh or regenerate your API token if authorization fails.
- Use the node’s dropdowns to select catalogs and schemas to avoid typos.
- Ensure your Databricks workspace URL and credentials are properly set in n8n.