Get SQL Alchemy Driver

Drivers such as sql_alchemy supports only one catalog at a time. So specific catalog name must be provided in order to use.

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.

Peaka

Welcome to the home of Peaka documentation

Peaka Documentation

Get started with Project Operations: Learn how you can start a new project in Peaka.

How to create a project

Get started with Project Operations: Learn how you can clone an existing project in Peaka.

How to clone a project in Peaka

Get started with Project Operations: Learn how you can delete a project in Peaka.

How to delete a project in Peaka

Get started with Project Operations: Learn how you can change the name of your Peaka project.

How to rename a project in Peaka

Get started with Project Operations: Learn how you can share a read-only copy of your project in Peaka.

How to send a copy of a project to another user

Get started with Project Operations: Learn how you can collaborate by sharing your Peaka project.

How to share a project with another user

Learn about Peaka Queries and how you can harness their power

What is a Peaka Query?

Learn about Peaka Tables and how you can use them to manage your data

What is a Peaka Table?

Learn about Peaka Big Table and how you can use it to manage your data

What is a Peaka Big Table?

Learn about the differences between Peaka Table and Peaka Big Table

Differences of Peaka Table and Peaka Big Table

Learn how you can create your first query in Peaka

Creating a Peaka Query

Learn how you can create your first internal table in Peaka

Creating a Peaka Table

Learn how you can connect your data using a SaaS connector

Connecting data using a SaaS connector

Learn about 3 basic concepts for organizing your data in Peaka

What are catalogs, schemas, and virtual tables?

CDC - PostgreSQL Setup Documentation

CDC - MySQL Setup Documentation

CDC - MongoDB Setup Documentation

CDC - MariaDB Setup Documentation

Introduction

Read Project

Update Project

Delete Project

List Projects

Create Project

List API Keys

Create API Key

Delete API Key

Get Connection

Update Connection

Delete Connection

List Connections

This endpoint allows you to create a new connection for a specified project.

You need to provide the project ID and the connection details in the request body.

The connection details include the name, type, and credentials required for the connection.

Depending on the connection type, additional parameters may be required under credentials.

You can view the list of supported connection types by calling the /connections/config endpoint.

You can switch examples from the second dropdown of the sample request component. (cURL (first dropdown) - Stripe Connection Request (second dropdown))

**Note**: Typically, the connection creation process involves the following steps:
1. First, learn about the connection type and the required parameters by calling the /connections/config endpoint.
2. Create a connection request with the required parameters.
3. If the connection requires Oauth2 authorization, there may be additional steps to follow. See https://docs.peaka.com/how-to-guides/how-to-create-oauth2-based-connections-via-peaka for more information.

**Example**:
- POSTGRES Connection Configuration:

GET /connections/config endpoint displays all of the connection types.

GET /connection/config/POSTGRES endpoint displays the POSTGRES connection configuration.

The definition of the POSTGRES connection configuration is as follows:
``` json
    {
        "connectionType": "POSTGRES",
        "connectionTypeLabel": "PostgreSQL",
        "name": "PostgreSQL",
        "authorizationType": "custom",
        "credentialSchemaType": "postgres_credential_schema",
        "category": "Database",
        "configuration": [
            {
                "fieldName": "url",
                "fieldType": "text",
                "required": true,
                "description": "URL"
            },
            {
                "fieldName": "port",
                "fieldType": "number",
                "required": true,
                "description": "Port"
            },
            {
                "fieldName": "user",
                "fieldType": "text",
                "required": true,
                "description": "User"
            },
            {
                "fieldName": "password",
                "fieldType": "text",
                "required": true,
                "description": "Password"
            },
            {
                "fieldName": "databaseName",
                "fieldType": "text",
                "required": true,
                "description": "Database Name"
            },
            {
                "fieldName": "useSsl",
                "fieldType": "boolean",
                "required": true,
                "description": "Use SSL"
            }
        ],
        "documentationUrl": "https://docs.peaka.com/integrations/postgresql"
    }
```

According to the POSTGRES connection configuration, the connection request should include the following parameters (respecting to the required flag):
- url: URL of the host IP or domain
- port: Port number
- user: User of the database
- password: Password of the user
- databaseName: Name of the database
- useSsl: Boolean value to indicate whether to use SSL

``` json
{
    "name": "examplePostgre",
    "type": "POSTGRES",
    "credential": {
        "url": "<host ip or domain>",
        "port": 5432,
        "user": "userOfYourDB",
        "password": "passwordOfUser",
        "databaseName": "yourDBName",
        "useSsl": false
    }
}
```



Create Connection

Get connection detail by ID. Returns only non-sensitive information.

Get Connection Detail

List all connection configurations.
This will return a list of all connection configurations available in the system.

List Connection Config

Get Connection Config

This callback/webhook is used while creating a new connection with Oauth2. See https://docs.peaka.com/how-to-guides/how-to-create-oauth2-based-connections-via-peaka for more information.

Oauth2 Callback

List Catalogs

Create Catalog

Read Catalog

Delete Catalog

List Schemas

List Tables

List Columns

Create Table

Delete Table

See Data -> Catalog / List Tables for more details.

Add Column

Update Column

Delete Column

See Data -> Catalog / List Columns for more details.

Create BI Table

Delete BI Table

List BI Tables

Add BI Column

Update BI Column

Delete BI Column

List BI Columns

Read Query

Update Query

Delete Query

List Queries

Create Query

Execute Query

Create a semantic catalog

Create a semantic table

Share a semantic table

Delete a semantic table

Create Cache

Create Batch Cache

Update Cache Settings

Delete Cache

Update Cache Incrementally

Full Refresh Cache

Get Cache Status

Get All Cache Statuses of a Project

Get All Cache Statuses of a Catalog

Init Session (Deprecated)

Init Session

List Supported Drivers

Get JDBC Driver

Update Metadata

Update Relation From Metadata

Delete Relation From Metadata

Generate categorical values from the the column.

Generate semantics for the table

Add Relation To Metadata

List of golden sqls for the project.

Create golden sql for the project

Get Project Metadata

Get Project Catalog Metadata Relations

Generate sample ai questions for the project

Delete golden sql from the project.

Update AI Chat History Thread Name

Delete AI Chat History

Ask Question To AI Agent

Get AI Chat History

What is Embedded Peaka?

Peaka as a Data Source

Peaka as a Data Management Backend

Peaka as a Data Management Tool with UI

Introduction to how to use SQL with Peaka.

DESCRIBE

EXECUTE

PREPARE

SELECT

SHOW CATALOGS

SHOW COLUMNS

SHOW SCHEMAS

VALUES

Data types

Aggregate functions

Array functions and operators

Binary functions and operators

Bitwise functions

Comparison functions and operators

Conditional Expressions

Date and time functions and operators

Decimal functions and operators

HyperLogLog Functions

JSON functions and operators

Lambda expressions

Machine learning functions

Quantile digest functions

Regular expression functions

Set Digest functions

String functions and operators

Table functions

Teradata functions

URL functions

UUID Functions

Window functions

Introduction to SQL routines

Example SQL routines

BEGIN

CASE

DECLARE

FUNCTION

ITERATE

LEAVE

LOOP

REPEAT

RETURN

WHILE

Discover a seamless integration process! Learn how to connect ActiveCampaign to Peaka effortlessly for streamlined transactions.

ActiveCampaign

Discover a seamless integration process! Learn how to connect Airtable to Peaka effortlessly for streamlined transactions.

Airtable

Discover a seamless integration process! Learn how to connect Amazon Redshift to Peaka effortlessly for streamlined transactions.

Amazon Redshift

Discover a seamless integration process! Learn how to connect Amazon RDS to Peaka effortlessly for streamlined transactions.

Amazon RDS

Discover a seamless integration process! Learn how to connect BigQuery to Peaka effortlessly for streamlined transactions.

BigQuery

Discover a seamless integration process! Learn how to connect Clickhouse to Peaka effortlessly for streamlined transactions.

Clickhouse

Discover a seamless integration process! Learn how to connect Databricks to Peaka effortlessly for streamlined transactions.

Databricks

Discover a seamless integration process! Learn how to connect Dynamics 365 to Peaka effortlessly for streamlined transactions.

Dynamics 365

Discover a seamless integration process! Learn how to connect ElasticSearch to Peaka effortlessly for streamlined transactions.

ElasticSearch

Discover a seamless integration process! Learn how to connect Excel 365 to Peaka effortlessly for streamlined transactions.

Excel 365

Discover a seamless integration process! Learn how to connect Facebook Ads to Peaka effortlessly for streamlined transactions.

Facebook Ads

Discover a seamless integration process! Learn how to connect Firebase to Peaka effortlessly for streamlined transactions.

Firebase

Discover a seamless integration process! Learn how to connect Github to Peaka effortlessly for streamlined transactions.

Github

Discover a seamless integration process! Learn how to connect Google Ads to Peaka effortlessly for streamlined transactions.

Google Ads

Discover a seamless integration process! Learn how to connect Google Analytics to Peaka effortlessly for streamlined transactions.

Google Analytics

Discover a seamless integration process! Learn how to connect Google Sheets to Peaka effortlessly for streamlined transactions.

Google Sheets

Discover a seamless integration process! Learn how to connect HubSpot to Peaka effortlessly for streamlined transactions.

API Documentation

Projects

Projects -> Api Key

Connections

Data -> Catalogs

Data -> Internal Tables

Data -> Queries

Data -> Semantic Catalogs

Data -> Cache

Embedded Peaka Api

Supported Drivers

Data -> Metadata

AI -> Agent

Get SQL Alchemy Driver

Query Parameters

Response