Documentation

Community

Blog

Peaka

API Reference

SQL Reference

Integrations

BI Tools

DB Drivers

JEXL

Flows

How to Guides

Blogs

Peaka Studio

Support

List API Keys

API key. It is a secret and should not be shared. Please store it securely. You will not be able to see it again.

Welcome to the home of Peaka documentation

Peaka Documentation

Introduction

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.

HubSpot

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

Instagram

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

Intercom

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

JIRA Cloud

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

LinkedIn Ads

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

Mailchimp Marketing

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

Mailchimp Transactional

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

MariaDB

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

MongoDB

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

MSSQL

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

MySQL

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

Neo4J

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

Odoo

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

OpenAI

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

Oracle

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

Pinecone

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

Pipedrive

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

PostgreSQL

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

ProfitWell

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

Provet Cloud

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

Quickbooks Online

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

Qdrant

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

Salesforce

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

SAP HANA

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

Segment

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

SendGrid

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

ServiceTitan

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

Shopify

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

SingleStore

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

Slack

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

SnowFlake

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

Stripe

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

Twilio

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

Upstash Vector

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

Weaviate

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

Youtube Analytics

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

Zendesk

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

Zoho CRM

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

Zoom

Learn how you can use Peaka in Looker Studio

Looker Studio

Peaka and Metabase integration brings together the power of Peaka's data platform with the visualization capabilities of Metabase's business intelligence platform. With this integration, customers can leverage Peaka's robust data processing and management capabilities to feed into Metabase’s intuitive and interactive dashboards. This allows users to create compelling analytics dashboards that provide meaningful insights into their data.

Metabase

Welcome to the installation guide for integrating Apache Preset with Peaka. As a leading data platform, Peaka provides seamless integration with various business intelligence and data visualization platforms, including Apache Preset. This document will guide you through the step-by-step process to set up this integration, enabling you to unlock the full potential of your data. Please follow each step carefully to ensure a successful setup.

Preset

Welcome to the installation guide for integrating Apache Superset with Peaka. As a leading data platform, Peaka provides seamless integration with various business intelligence and data visualization platforms, including Apache Superset. This document will guide you through the step-by-step process to set up this integration, enabling you to unlock the full potential of your data. Please follow each step carefully to ensure a successful setup.

Superset

Welcome to the installation guide for integrating Tableau with Peaka. As a leading data platform, Peaka provides seamless integration with various business intelligence and data visualization platforms, including Tableau. This document will guide you through the step-by-step process to set up this integration, enabling you to unlock the full potential of your data. Please follow each step carefully to ensure a successful setup.

Tableau

Welcome to the installation guide for integrating Tableau Web Data Connector with Peaka. As a leading data platform, Peaka provides seamless integration with various business intelligence and data visualization platforms, including Tableau Web Data Connector. This document will guide you through the step-by-step process to set up this integration, enabling you to unlock the full potential of your data. Please follow each step carefully to ensure a successful setup.

Tableau Web Data Connector

Learn how to use Peaka's RAG Capabilities with a sample project.

Use any Rest API in RAG with Peaka and Pinecone

Discover the [Peaka](https://peaka.com/) python driver

Python Driver

Discover the [Peaka](https://peaka.com/) NodeJS driver

NodeJS Driver

Welcome to the documentation for the Peaka JDBC Driver – your gateway to seamless integration with the powerful Peaka data platform. This JDBC driver serves as a bridge between your Java application and the Peaka platform, enabling you to retrieve and manipulate data with ease and efficiency.
Let's dive in and unlock new possibilities for your data-driven projects with the Peaka JDBC Driver!

JDBC Driver

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.

API Documentation

Projects

Projects -> Api Key

Connections

Data -> Catalogs

Data -> Internal Tables

Data -> Queries

Data -> Semantic Catalogs

Data -> Cache

Embedded Peaka

Supported Drivers

List API Keys

Path Parameters

Response