---
title: "Look up connections by path"
method: POST
path: "/v2/connection/{connectionId}/lookup"
tags: ["Connections"]
---

# Look up connections by path

`POST /v2/connection/{connectionId}/lookup`

## Request

- Base URL: `https://api.sigmacomputing.com`
- URL: `https://api.sigmacomputing.com/v2/connection/{connectionId}/lookup`
- Auth: HTTP bearer

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](https://help.sigmacomputing.com/reference/list-connections) endpoint.

  Different connections support different paths:

  - For a Snowflake connection, you can specify `DATABASE.SCHEMA.TABLE`, `DATABASE.SCHEMA.STORED_PROCEDURE`, or a less-specific path.
  - For Amazon Redshift, you can specify `SCHEMA.TABLE`, `SCHEMA.STORED_PROCEDURE`, 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).

## Path parameters

- `connectionId` string, required

## Request body

- object
  - `path` union, required
    - string[]
    - string[]
    - string[]
    - unknown[]
      - unknown

## Response `200`

The response body.

- ConnectionsLookupConnectionResponse200
  - `kind` 'scope' | 'table' | 'semanticView' | 'metricView' | 'stored-procedure', required
  - `inodeId` string, required
  - `url` string, required

---

[API](https://skmtc.dev/sigmacomputing/apis/sigma-rest-api.md) - [All operations](https://skmtc.dev/sigmacomputing/apis/sigma-rest-api/llms.txt) - [OpenAPI document](https://skmtc.dev/sigmacomputing/apis/sigma-rest-api/revisions/fb6036208c49?raw)