What are you looking for?

01. The basics

On this documentation page, you can learn more about the Kondado platform, find tutorials, and answer all your questions to better enjoy your new data integration platform.

01. Creating pipelines

On this page, you are going to learn how to create pipelines.

01. Functions - Concept

On this page, you are going to learn how functions work.

01. How to create models

Learn about creating models in Kondado.

01. Via Kondado

Learn more about the Via Kondado data destination

02. Adding destinations

On this page, you are going to learn how to add destinations on your plataform.

02. Documenting models

On this page, you will learn more about documenting models.

02. Keys

On this page, you are going to learn about how keys work.

03. Adding sources

On this page, you are going to learn how to add sources on your platform.

03. Using functions

On this page, you are going to learn how to use functions.

Access Tokens

Learn how to create and manage Access Tokens on the Kondado platform.

ActiveCampaign

Learn how to add ActiveCampaign as a data source on Kondado

Amazon Ads

Amazon Ads data source on Kondado: Sponsored Products, Sponsored Brands, Sponsored Display, Sponsored TV and Amazon DSP reports, plus account, portfolio, campaign, ad group, keyword, target and ad registries, straight into your data warehouse.

API4COM

Learn how to add the API4COM data source on the Kondado platform.

Apple App Store

Learn how to add the Apple App Store data source on the Kondado platform.

ASAAS

Learn how to add the ASAAS data source on the Kondado platform.

Authorize Kondado for organizations with session duration control

Learn how to set up Kondado as a trusted app within your Google Workspace

AWS CloudWatch Metrics

Learn how to add the AWS CloudWatch Metrics data source on the Kondado platform.

Azure Table Storage

Learn how to add the Azure Table Storage data source on the Kondado platform.

BigQuery

Learn how to add the BigQuery data destination on the Kondado platform.

BigQuery

Learn how to add BigQuery as a data source on Kondado

BigQuery (Service Account) (destination)

Learn how to add the BigQuery (Service Account) destination on the Kondado platform.

BigQuery: How to Enable Billing (Error 403)

How to fix the 403 Billing error when using BigQuery as a destination in Kondado. Step-by-step guide to enable billing on your Google Cloud project.

Bitrix24 CRM

Learn how to add the Hotmart data source on the Kondado platform.

Blip (Take)

Learn how to add the Blip (Take) data source on the Kondado platform.

Brasil.io

Learn how to add the Brasil.io data source on the Kondado platform.

Cast to boolen

"Cast to boolean" function.

Cast to float

"Cast to float" function.

Cast to Int

"Cast to int" function.

Cast to text

"Cast to text" function.

ChatGPT

How to connect ChatGPT (Web, Desktop) and Codex (OpenAI's CLI) to Via Kondado via MCP — step by step, automatic OAuth flow, and tips.

ChatGPT Ads

ChatGPT Ads (OpenAI Ads) data source on Kondado: hourly, daily or monthly campaign performance, account, campaign, ad group, ad and audience registries, and ad previews, straight into your data warehouse.

Claude

How to connect Claude (Web, Desktop, and Code) to Via Kondado via MCP — step-by-step with screenshots, automatic OAuth flow, and troubleshooting tips.

ClickUp

Learn how to add the ClickUp data source on the Kondado platform.

Clockify

Learn how to add the Clockify data source on the Kondado platform.

Collection guests

Allows you to securely invite someone to configure a data source or destination in your Kondado account, with access limited exclusively to the setup process.

Common Connector Questions Guide

A comprehensive guide covering the most common questions and troubleshooting tips for Kondado's main connectors including Facebook, Google Ads, Google Analytics, Instagram, LinkedIn, and RD Station.

Correct Column Typing in Power BI/Excel with the Via Kondado Schema API

Learn how to use Power Query with the Via Kondado schema endpoint so every column lands with the correct type in Power BI or Excel — no more relying on sampling-based inference.

Criteo

Learn how to add the Criteo data source on the Kondado platform.

E-goi

Learn how to add the E-goi data source on the Kondado platform.

Excel

Learn how to add Excel as a data destination on Kondado.

Excel

Excel data source on Kondado: bring the worksheets of your Excel files on OneDrive or SharePoint (Microsoft 365) into your data warehouse, refreshed automatically.

Facebook

Learn how to add the Facebook data source on the Kondado platform.

Facebook - page metrics

Learn more about the available Facebook page metrics

Facebook Ads Report (Looker Studio)

Learn how to use the Facebook Ads Report template in Looker Studio created by Kondado

Facebook Ads Report (Power BI)

Learn how to use the Facebook Ads report template in Power BI created by Kondado

Freshdesk

Learn how to add the Freshdesk data source on the Kondado platform.

FTP

Learn how to add the FTP data source on the Kondado platform.

Getting Started with the Kondado API

Overview of the Kondado API, including base URL, authentication using access tokens, and request rate limits.

Google Ads (Adwords)

Learn how to add the Google Ads data source on the Kondado platform.

Google Ads (Adwords) - Reference for reports metrics and dimensions

Reference for reports metrics and dimensions of the Google Adwords data source.

Google Ads and Facebook Ads Report (Looker Studio)

Learn how to use the Google Ads and Facebook Ads Report template in Looker Studio created by Kondado

Google Ads Report (Looker Studio)

Learn how to use the Google Ads Report template in Looker Studio created by Kondado

Google Ads Report (Power BI)

Learn how to use the Google Ads Report template in Power BI created by Kondado

Google Analytics (GA4)

Learn how to add the Google Analytics (GA4) data source on the Kondado platform.

Google Analytics (GA4) - Reference for metrics and dimensions

Learn how to add the Google Analytics (GA4) data source on the Kondado platform.

Google Analytics (GA4) Looker Studio Report

Learn more about Kondado's Power BI template for GA4.

Google Analytics (GA4) Power BI Report

Learn more about Kondado's Power BI template for GA4.

Google Cloud Storage

Learn the process of incorporating the Google Cloud Storage data source into the Kondado platform.

Google Play Store

Learn how to add the Google Play Storedata source on the Kondado platform.

Google Search Console (Google Webmasters)

Learn how to add the Google Search Console (Google Webmasters) data source on the Kondado platform.

Google Sheets

Learn how to add the Google Sheets data destination on the Kondado platform.

Google Sheets

Learn how to add the Google Sheets data source on the Kondado platform.

Granatum

Learn how to add the Granatum data source on the Kondado platform.

Hash SHA-512 with key

"Hash SHA-512 with key" function.

Hi Platform

Learn how to add the Hi Platform data source on the Kondado platform.

Hotmart

Learn more about Kondado's Hotmart data source

How to Add a Kondado Table to Looker Studio

This step-by-step guide explains how to add Kondado data to Looker Studio for pipelines using the Via Kondado destination. Learn how to obtain the table URL from Kondado and configure it as a data source in Looker Studio.

How to Change Savepoint in Bulk and Load More Data

Learn how to change the savepoint of multiple pipelines at once to load older historical data into your Kondado dashboards.

How to Connect Supabase as a Destination in Kondado

Step-by-step guide to configure Supabase as a PostgreSQL destination in Kondado, including IPv4 setup, Session Pooler, and credentials.

How to Read Via Kondado Data in Google Sheets (IMPORTDATA)

Guide to read Via Kondado data directly in Google Sheets using the IMPORTDATA function. Import integrated data with automatic refresh.

How to Use Power Query in Excel with Via Kondado

Guide to connect Via Kondado to Excel Desktop using Power Query. Import integrated data directly into your spreadsheets with automatic refresh.

HubSpot

Learn how to add the Hubspot data source on the Kondado platform.

Huggy

Learn how to add the Huggy data source on the Kondado platform.

InfluxDB v1.x

Learn how to add the InfluxDB v1.x data source on the Kondado platform.

Infusionsoft (Keap)

Learn how to add the Infusionsoft (Keap) data source on the Kondado platform.

Instagram

Learn the process of incorporating the Instagram data source into the Kondado platform.

Instagram Looker Studio Report

Learn more about Kondado's Power BI template for Organic Instagram.

Instagram Power BI Report

Learn more about Kondado's Power BI template for Organic Instagram.

Invitations to Add Sources and Destinations

How to create secure invitations via the API to allow temporary users to add sources or destinations without granting account access.

Jira

Learn how to add the Jira data source on the Kondado platform.

JSOnify

"JSONify" function.

Kondado

Learn how to add the Kondado data source on the Kondado platform.

Kondado IPs

For some Kondado destinations and data sources it may be necessary to release the Kondado IPs shown in this page.

Kondado Plan vs Via Kondado — Which Limit Was Reached?

Understand the difference between Kondado Plan alerts (records/pipelines) and Via Kondado limits (accesses/cells) — and how to tell which one triggered your alert.

Linkedin

Learn how to add the Linkedin data source on the Kondado platform.

Logs

How to retrieve and paginate execution logs for Pipelines and models using the API.

Looker Studio Via Kondado - Count Distinct issue

How to solve the count distinct issue on looker studio via kondado connection

Looker Studio Via Kondado Connection

Learn how to create the Looker Studio Via Kondado Connection

MailChimp

Learn how to add the MailChimp data source on the Kondado platform.

Mandrill

Learn how to add the Mandrill data source on the Kondado platform.

Meetime

Learn how to add the Meetime data source on the Kondado platform.

Mercado Libre Report Looker Studio

Complete guide to the Mercado Livre Report on Looker Studio by Kondado

Mercado Libre Report Power BI

Complete guide to the Mercado Libre Report in Power BI by Kondado

Mercado Livre (Mercado Libre)

Documentation about Mercado Libre Data Source

Metabase Via Kondado Connection

Connect Metabase to your Via Kondado destination through the PostgreSQL endpoint (kdb.kondado.io). Step-by-step setup with screenshots.

Metadata in Kondado

Learn about Metadata in Kondado.

Microsoft Advertising (Bing)

Learn how to add the Microsoft Ads data source on the Kondado platform.

Microsoft Advertising (Bing) - Reference for reports metrics and dimensions

Reference for reports metrics and dimensions of the Microsoft Advertising data source.

Microsoft SQL Server

Learn how to add the SQL Server data destination on the Kondado platform.

Microsoft SQL Server

Learn how to add microsoft sql server as a data source

Microsoft SQL Server SSH (data source)

Learn how to add the Microsoft SQL Server SSH data source on the Kondado platform.

Mixpanel

Learn how to add the Mixpanel data source on the Kondado platform.

Models

Learn how to check the execution and operational status of a model using its model_id.

Monday.com

Learn how to add the monday.com data source on the Kondado platform.

MongoDB

Learn how to add the MongoDB data source on the Kondado platform.

Movidesk

Learn how to add the Movidesk data source on the Kondado platform.

MySQL

Learn how to add the MySQL data destination on the Kondado platform.

MySQL

Learn how to add MySQL as a data source on Kondado

MySQL SSH

Learn how to create the MySQL SSH destination on Kondado.

MySQL SSH (data source)

Learn how to add the MySQL SSH data source on the Kondado platform.

Notifications

Kondado notifications alert users about important events in their environment, such as pipeline failures, report completions, and plan limit warnings. General notifications appear in the alert bell, while focused notifications show only alerts related to the specific pipeline, model, or destination being viewed, helping users quickly identify issues and take action.

Notion

Learn how to add the Notion data source on the Kondado platform.

Oracle

Learn how to add the Oracle data source on the Kondado platform.

Parent Collections

How to list available sources and destinations that can be created using the API.

Parent Pipelines

How to list available Pipeline types for a given source using the API.

Pinterest Ads

Pinterest Ads connector documentation

Pipedrive

Learn the process of incorporating the Pipedrive data source into the Kondado platform.

Pipefy

Learn how to add the Pipefy data source on the Kondado platform.

Pipelines

How to run, monitor, and duplicate Pipelines using the API.

Plans and limits

On this page, you will see more about our plans and limits.

PostgreSQL

Learn how to add the PostgreSQL data destination on the Kondado platform.

PostgreSQL

Learn how to create a PostgreSQL data source on Kondado

PostgreSQL SSH

Learn how to add the PostgreSQL SSH connector (data source) on the Kondado platform.

Power BI Via Kondado Connection

Learn how to create the Power BI Via Kondado Connection

Privacy Policy

Our Privacy Policy

Pushwoosh

Learn how to add the Pushwoosh data source on the Kondado platform.

Query Builder

Learn how to use Query Builder to query data in Via Kondado without writing SQL. Includes manual mode and AI assistant.

RD Station CRM Looker Studio Report

Connect your RD Station CRM data to Looker Studio for comprehensive sales analytics including deals, tasks, and sales performance metrics.

RD Station CRM Power BI Report

Connect your RD Station CRM data to Power BI for comprehensive sales analytics including deals, tasks, and sales performance metrics.

RD Station Marketing Looker Studio Report

Learn more about Kondado's Looker Studio template for RD Station Marketing

RD Station Marketing Power BI Report

Learn more about Kondado's Power BI template for RD Station Marketing

RDStation

RDStation data source on the Kondado platform

RDStation CRM

Learn how to add the RDStation CRM data source on the Kondado platform.

Recruiterbox

Learn how to add the Recruiterbox data source on the Kondado platform.

Redshift

Learn how to add the Redshift data destination on the Kondado platform.

Redshift SSH

Learn how to add the Redshift SSH destination on the Kondado platform.

Remove EQL

"Remove EQL" function.

S3

Learn how to add the S3 data destination on the Kondado platform.

S3 (data source)

Learn how to add the S3 (data source) data source on the Kondado platform.

Salesforce

Learn how to add the Salesforce data source on the Kondado platform.

Salesforce Marketing Cloud

Learn how to add the Salesforce Marketing Cloud data source on the Kondado platform.

Shopify

Learn how to add the Shopify data source on the Kondado platform.

Stripe

Stripe data source on Kondado: charges, PaymentIntents, refunds, disputes, balance transactions, payouts, customers, invoices and line items, subscriptions and items, products, prices, coupons, checkout sessions, payment links, events and 30 more objects from your Stripe account, straight into your data warehouse.

Tableau Via Kondado Connection

Connect Tableau to your Via Kondado destination through the PostgreSQL connector (kdb.kondado.io). Step-by-step setup with screenshots.

Taboola

Learn how to add the Taboola data source on the Kondado platform.

Temporary Power BI adjustment for uninterrupted report access

Learn how to apply a temporary adjustment in Power BI Desktop to continue viewing reports normally without the corporate authentication requirement.

Terms of Service

Our terms of service

Tiendanube (Nuvemshop)

Learn how to add the Tiendanube/Nuvemshop data source on the Kondado platform.

TikTok Ads

Learn how to add the Tiktok Ad data source on the Kondado platform.

TikTok Organic

TikTok Organic connector documentation on the Kondado platform

Toggl

Learn how to add Toggl as a data source on Kondado

Trello

Kondado's Trello data source documentation

Twilio

Learn how to add the Twilio data source on the Kondado platform.

User management

On this page, you will learn more about users management.

UUID

"UUID" function.

Via Kondado: KSQL Reference

KSQL is Kondado's JSON-based query language for Via Kondado. This reference covers the complete syntax including filters, aggregations, JOINs, transformations, and more.

VTEX

See how to connect VTEX to Kondado and pipelines available

VTEX Looker Studio Report

Learn more about Kondado's Looker Studio template for VTEX

VTEX Power BI Report

Learn more about Kondado's Power BI template for VTEX

Webhook

Learn how to add the Webhook data source on the Kondado platform.

Wootric

Learn how to add the Wootric data source on the Kondado platform.

X Ads

X Ads connector documentation

Your account

How to manage your Kondado user's e-mail, time zone, notifications, password, two-factor authentication (MFA) and teams.

Your First Pipeline: Step-by-Step Guide

The real Kondado onboarding flow: from the Welcome page to your pipelines running. Step-by-step guide with screenshots.

YouTube

Learn how to add the YouTube data source on the Kondado platform.

Zendesk

Learn the process of adding the Zendesk data source into the Kondado platform.

Zendesk Chat

Learn how to add the Zendesk Chat data source on the Kondado platform.