OMomniapp
Connections

List connections

Changed on
get/api/v1/connections

Request

  • Base URL
    https://omniapp.co (the document declares no server; this is the origin it was published from)
  • URL
    https://omniapp.co/api/v1/connections
  • Auth
    HTTP bearer

Query parameters

databasestring

Filter by database name (case-insensitive contains)

Example:analytics
dialectstring

Filter by dialect(s). Comma-separated list for multiple values

Example:snowflake,bigquery
includeDeletedboolean

Include soft-deleted connections in results

namestring

Filter by connection name (case-insensitive contains)

Example:Production
sortDirection'asc' | 'desc'

Sort direction

Example:desc
sortField'database' | 'dialect' | 'name'

Field to sort by

Example:name

Response

List of connections

Example response

{
  "connections": [
    {
      "authenticationType": "snowflake-password",
      "baseRole": "QUERIER",
      "createdAt": "2024-01-15T10:30:00Z",
      "database": "analytics_db",
      "defaultSchema": "public",
      "dialect": "snowflake",
      "host": "myaccount",
      "id": "550e8400-e29b-41d4-a716-446655440000",
      "includeSchemas": [
        "public",
        "analytics"
      ],
      "inferRelationshipsFromColumnNames": true,
      "name": "Production Snowflake",
      "port": 5432,
      "queryTimeoutSeconds": 900,
      "updatedAt": "2024-01-15T10:30:00Z",
      "username": "analytics_user",
      "warehouse": "COMPUTE_WH"
    }
  ]
}

Changes

  • 255b22cfc05fRevision changes
    • info

      added the required property // to the response with the status

  • 3939110e279bRevision changes
    • breaking

      added the pattern ^(?:\s*(bigquery|mysql|postgres|redshift|exasol|snowflake|motherduck|mssql|fabric|databricks|databricks_lakebase|clickhouse|trino|athena|starrocks|mariadb|oracle|sap_hana)\s*(?:,\s*(bigquery|mysql|postgres|redshift|exasol|snowflake|motherduck|mssql|fabric|databricks|databricks_lakebase|clickhouse|trino|athena|starrocks|mariadb|oracle|sap_hana)\s*)*)?$ to the query request parameter dialect