Databricks icon

Databricks

Interact with Databricks API

Unity Catalog → Get Table

AI-generated

Overview

This node operation retrieves detailed information about a specific table within the Unity Catalog in Databricks. It is useful for scenarios where users need to access metadata or properties of a table identified by its full name in the format 'catalog.schema.table'. For example, a data engineer or analyst might use this operation to fetch schema details or table attributes before performing further data processing or analysis.

Use Case Examples

  1. Retrieve metadata for the table 'main.default.sales_data' to understand its schema and properties before running queries.
  2. Fetch details of a specific table to verify its existence and configuration within a data governance workflow.

Properties

Name Meaning
Table The full name of the table to access, specified in the format 'catalog.schema.table'. This property is required for the 'Get Table' operation and supports selection from a list or manual entry.

Output

JSON

  • json - The JSON response containing detailed information about the specified table retrieved from the Unity Catalog API.

Dependencies

  • Databricks API with appropriate authentication token

Troubleshooting

  • Ensure the 'fullName' property is correctly formatted as 'catalog.schema.table'. Incorrect formatting will cause errors.
  • Verify that the API credentials have sufficient permissions to access the Unity Catalog and the specified table.
  • Network or API errors will be logged; check connectivity and API status if requests fail.
  • If the table does not exist or is inaccessible, the API will return an error which should be handled appropriately.

Links

Discussion