Tables

In Aleph, tables are the building blocks of your data analysis. They store data from various sources and allow you to manipulate and combine this data to gain valuable insights. Let's delve into each type of table and learn how to use them effectively.

Integration Tables

Integration Tables are automatically generated when you set up integrations with external data sources like NetSuite, Ramp, or Salesforce. They are labeled with the logo of the integration source in the Tables section of the Aleph web app. Each row in a table represents a transaction or record from the source system and the data in these rows cannot be edited directly in Aleph.

Change a Dimension to a Measure in a Table

Every column of a table can be categorized either as a dimension or as a measure. You can to into any integration table in Aleph and switch from to to another.

Go to https://app.getaleph.com/tables, select the table and click into any column to change it do a dimension or to a measure.

Aleph Tables

Aleph Tables are custom tables that you create and manage directly within Aleph. They can be identified by the Aleph logo in the Tables section of the Aleph web app. Creating Aleph tables allows you to push data directly from your spreadsheets into Aleph.

Calculated Tables

Calculated Tables are created by combining or transforming existing tables using SQL queries. These tables allow you to merge data from different sources, perform calculations, and create new data structures. A common use case is to combine actual data from your ERP (e.g., NetSuite) and budget data from a custom Aleph Table to create a Budget vs. Actuals table.

Data Warehouse Tables

Data Warehouse Tables allow you to connect directly to your external data warehouse (e.g., Snowflake) to access and use the data stored there via Aleph.