Skip to main content

What's a project?

Within Latitude, your work is organized in projects. A project is an infinite canvas where you connect blocks together to build your queries and explore your data.

Every canvas has multiplayer real-time functionalities built-in, so collaborating with other teammates is as easy as sharing the project's URL with them. You don't have to think about saving or publishing your queries, creating single-use dashboards, or exporting your work. Share the link and you're done.

Canvas​

All projects start with a canvas, which is where you build queries. By using a canvas to explore data, you're no longer constrained by the limitations of one-dimensional tools like typical BI applications, so you can for example do parallel explorations or derivative queries without ever leaving your project.

Blocks​

Use blocks to interact with your data. You can use them to fetch data from your database or data warehouse, do transformations, or to visualize aggregated data directly in the canvas.

There are three kinds of blocks:

  • Sources: Pull data from your database or warehouse, you can select raw tables or dbt models directly.
  • Transformations: Connect transformations to sources or to other transformation blocks to join tables, aggregate outputs, filter data, or any other kind of data reshaping you might need to do.
  • Visualizations: Add charts directly to the canvas to see aggregated data visually.

To connect blocks, pull from the grey tabs you'll find at the top or the bottom of any block and drop them into any other compatible block.

Running queries​

We generate a separate SQL query for every block in your canvas, and you can run them independently or all at once.

To run all of your blocks and fetch updated data from your database or warehouse, click the green Run button you'll find at the top of the canvas when you're within a project.

Click the run button in a block to run it and all of its children. You can override this behavior by holding Alt while you click the button to just run the selected block and none of its children.