> ## Documentation Index
> Fetch the complete documentation index at: https://docs.peaka.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Get SQL Alchemy Driver

> Returns the SQL Alchemy connection string for connecting to Peaka's query engine. SQL Alchemy supports only one catalog at a time, so a <code>catalogName</code> must be provided.


<span style={{display: "flex", gap: "10px", flexDirection: "row", alignItems: "center"}}>
  <img src="https://cdn.peaka.com/badges/partner-api-key-badge.png" />

  <img src="https://cdn.peaka.com/badges/project-api-key-badge.png" />
</span>


## OpenAPI

````yaml get /supportedDrivers/sql_alchemy
openapi: 3.0.1
info:
  title: Peaka Gateway API
  description: Peaka Gateway API Documentation
  version: '1.0'
servers:
  - url: https://partner.peaka.studio/api/v1
    description: Default Server URL (US Zone)
  - url: https://partner.eu.peaka.studio/api/v1
    description: EU Zone
security:
  - bearerAuth: []
paths:
  /supportedDrivers/sql_alchemy:
    get:
      tags:
        - Supported Drivers
      summary: Get SQL Alchemy Driver
      description: >
        Returns the SQL Alchemy connection string for connecting to Peaka's
        query engine. SQL Alchemy supports only one catalog at a time, so a
        <code>catalogName</code> must be provided.
      operationId: getSqlAlchemyDriver
      parameters:
        - name: catalogName
          in: query
          description: >-
            Catalog name. 


            Drivers such as sql_alchemy supports only one catalog at a time. So
            specific catalog name must be provided in order to use. 
          required: true
          schema:
            type: string
          example: sampleHubSpotCatalog
      responses:
        '200':
          description: Url for given driver
          content:
            '*/*':
              schema:
                type: string
              examples:
                SQL_ALCHEMY driver with Catalog provided:
                  description: >-
                    Drivers such as sql_alchemy supports only one catalog at a
                    time. So specific catalog name must be provided in order to
                    use.
                  value:
                    SQL_ALCHEMY: >-
                      peaka://dbc.peaka.studio:4567/sampleCatalog?http_scheme=https&extra_credential=[["peakaKey","gk4aUnCO.IYxkP1NxP67YkVViqYGZe3INpUAr04TE"]]&access_token=true
                SQL_ALCHEMY driver without Catalog not provided:
                  description: >-
                    Drivers such as sql_alchemy supports only one catalog at a
                    time. So specific catalog name must be provided in order to
                    use. The user should replace {catalogName} with the catalog
                    desired.
                  value:
                    SQL_ALCHEMY: >-
                      peaka://dbc.peaka.studio:4567/{catalogName}?http_scheme=https&extra_credential=[["peakaKey","gk4aUnCO.IYxkP1NxP67YkVViqYGZd4INpUAr04TE"]]&access_token=true
components:
  securitySchemes:
    bearerAuth:
      type: http
      description: >-
        Use the Authorization header with the value 'Bearer <apiKey>' to
        authenticate. Partner API Keys have full access; Project API Keys are
        limited to their project scope. Learn more:
        https://docs.peaka.com/api-reference/authentication
      scheme: bearer
      bearerFormat: Api Key

````