Look up connections by path

post https://api.sigmacomputing.com/v2/connection/{connectionId}/lookup

This endpoint returns details about the fully qualified path to an object in a specific connection by connection ID.

Usage notes

Retrieve the connectionId by calling the /v2/connections endpoint.

Different connections support different paths:

For a Snowflake connection, you can specify DATABASE.SCHEMA.TABLE or a less-specific path.
For Amazon Redshift, you can specify SCHEMA.TABLE or a less-specific path.
For Databricks, you can specify CATALOG.SCHEMA.TABLE or a less-specific path.

Connection path details include the connection path ID, called the inodeId in the response, and the type of object in the connection path, either a table or a scope (database, schema, catalog, or other higher-level object).