Configuration

Redshift

Latitude Docs

Introduction

Installation

Windows compatibility

Common issues and solutions when using Latitude

Troubleshooting

Learn how to use the Latitude CLI to manage your Latitude projects

Latitude CLI

Learn about the structure of a Latitude project

Project structure

Learn how to declare environment variables for your Latitude projects

Environment variables

Learn how to extend the functionality of Latitude projects installing any npm dependency

Installing dependencies

Basic example

Learn how to create an API to your data with the Latitude framework

Create an API

Find a list of curated templates to help get you started

Templates

Deploy to Latitude Cloud with a single command

Latitude Cloud

Build a Latitude project in a Docker container

Building your app

Build a Latitude project as a NodeJS application

NodeJS build

Embedding a Latitude data app using an iframe

Iframe embedding

How to create and configure sources within your Latitude project

Create and configure sources

Learn how to declare secrets for your Latitude sources

Source credentials

Additional configuration to control the data behaviour in Latitude.

Additional configuration

How to connect to databases using SSH tunneling

SSH Tunneling

Athena

Bigquery

How to configure your ClickHouse database

Clickhouse

CSV files

How to configure your Databricks warehouse

Databricks

DuckDB

How to configure your Microsoft SQL database

Microsoft SQL

MySQL

How to configure your PostgreSQL Database

PostgreSQL

How to configure your Snowflake warehouse

Snowflake

SQLite

Supabase

Trino

How to configure your project to start retrieving data

Queries setup

Learn the basics of queries, the syntax and how to reference sources

SQL Syntax

Learn how the cache layer works when executing your queries and views.

Cache Layer

Modify and optimize SQL code with the flexibility of variables

Variables

Parameters

Adjust your SQL code dynamically according to conditions

Conditions

Learn how to use loops to repeat SQL code from a list of elements.

Loops

Learn how to include code from another query

Reference Queries

Dynamically executes SQL queries, ideal for generating SQL code with runtime-known values.

Run Query

Converts data types in Latitude logic blocks, ensuring that SQL operations are performed with the correct data type.

Cast Methods

Insert values into SQL queries without parametization

Interpolation

Configure the behaviour of the data in Latitude queries.

Query configuration

Materialized Queries

Learn how to use views to create custom layouts for your data apps.

How views work

Learn how to use the layout components in your views

Layout

Global Parameters

Signed Parameters

Running queries

Read and display the value of global parameters in your views.

{param(...)}

Learn how to use if / else statements in your views

{#if ... }

Display custom content based on the results of a query

{#await ... }

Learn how to use the `each` block helper to iterate over an array or object

{#each ... }

{@const ... }

Personalize the theme of your Latitude Views

Theming

How to use Tailwind classes to style your components

Component styles

Learn more about the Svelte syntax and how to use it in your Latitude projects

Svelte syntax

Learn how to include elements in the head of your document.

Head

How to install the react package in your project

How to embed Latitude views in your React app

Embedding Views

useQuery

QueryResult

Customize the look and feel of specific Latitude components in your views

Built-in layout components for your React app

Guides

Sources

Queries

Views

React

Get started

Render text in your data app with the Text component

Text

Alert

Use Card to display content in a flexible and extensible container

Card

Create a regular input to control parameters in your queries

Regular input

Create a dropdown with options for a parameter.

Select

Create a date input to control parameters in your queries

Date

How to create and configure the Table visualization

Table

How to create and configure the Line chart

Line Chart

How to create and configure the Bar chart

Bar Chart

How to create and configure the Area chart

Area Chart

How to create and configure the Scatter chart

Scatter Chart

How to create and configure a Mixed Types Chart

Mixed Types Chart

How to create and configure the Pie chart

Pie Chart

How to create and configure the Funnel Chart

Funnel Chart

Add buttons to your views to update the data in your app

Run button

Link

How to create and configure the Funnel chart

How to create and configure the Mixed chart

Mixed Chart

Button

A text input component for your React app

Configuration

Sources

​Configuration

Configuration