Prerequisites

Connecting ServiceTitan to Peaka

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

ServiceTitan

Peaka

Welcome to 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

CDC - Oracle Setup Documentation

Introduction

Servers

Authentication

Understanding the core components and their relationships in the Peaka API ecosystem.

Structure

Retrieves all the organizations accessible by the authenticated user.

An Organization is the highest-level resource that can contain multiple Workspaces.


List Organizations

Returns the specified Organization.

An Organization is the highest-level resource that can contain multiple Workspaces.


Read Organization

Read Workspace

Update Workspace

Delete Workspace

Returns all workspaces under the specified Organization.

A Workspace is used to group Projects within an Organization.


List Workspaces

Create Workspace

Read Project

Update Project

Delete Project

Fetches all projects within the given Workspace.

A unit of work where queries, data tables, and semantic catalogs are managed. Projects live inside workspaces.


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

Table Statistics

Table is Cached

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

Import CSV

Get Sample CSV

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

List Parametric Tables

Create Parametric Table

Delete Parametric Table

Init Session (Deprecated)

Init Session

List Supported Drivers

Get SQL Alchemy Driver

Get JDBC Driver

Update Metadata ai usage per catalog level

Update Metadata ai usage per schema level

Update Metadata

Update Relation From Metadata

Delete Relation From Metadata

Generate categorical values from the column.

Delete categorical values from the column meta and remove the scheduled job

Generate semantics for the table

Add Relation To Metadata

Refresh Project 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

Semantic query metadata for the project.

Semantic query golden sqls 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

Chat with agent via stream

Chat with agent

Delete ai-agent thread

Get ai-agent thread

Get png image of current ai workflow

List ai-agent threads

Update ai-agent thread display name

Transpile a sql query into given dialect

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

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

Integrations

​Prerequisites

​Connecting ServiceTitan to Peaka

Prerequisites

Connecting ServiceTitan to Peaka