Skip to main content

Static Tables

To query smaller or rarely changing datasets from files without importing it into a database or data warehouse, Cluvio provides Static Tables. With static tables, you can:

  • Upload files directly to Cluvio.
  • Query file data using SQL, powered by the Apache DataFusion query engine.
  • Join data from multiple files, since all static tables are in the same predefined datasource, called Static Tables.
  • Create reports from file data.

Static Tables are listed on the datasources overview page.

Static Tables Static Tables

Creating Static Tables​

Currently static stables can only be created by uploading CSV files. Additional file types as well as the ability to pull data from URLs or Google Sheets will be available in the future.

Using Static Tables​

Static tables are automatically available on the predefined Static Tables datasource:

  1. Open the report editor.
  2. Select Static Tables as the datasource.
  3. Write SQL queries using DataFusion SQL.
tip

Cluvio uses the PostgreSQL dialect with DataFusion SQL, so you can use e.g. the :: operator for type casting.

Static Tables Query Static Tables Query

Static tables are fully integrated with many Cluvio features:

  • Use Filters to parameterise queries.
  • Create SQL drop-down filters based on static table data.
  • The SQL editor offers code completion for table and column names, DataFusion SQL functions and inline documentation with links to detailed references.
  • The Datasource Almanac provides schema information for all static tables and pre-defined queries for ad hoc exploration.

Data Size Limits​

Your Cluvio plan determines the total data size across all static tables. You can see your current usage below the list of static tables on the datasources overview page.

Data size is calculated using a consistent measure independent of the source file format:

  • Empty values: 1 byte, regardless of type
  • Boolean values: 1 byte
  • Numbers: 8 bytes
  • Date/Time/DateTime values: 16 bytes
  • Strings: UTF-8 byte length

For example, a table with 10,000 rows and 5 columns (2 strings averaging 20 characters, 2 numbers, 1 date) would use approximately 640 KB of your available static data size.

When to Use Static Tables​

Static Tables work well for:

  • Small reference datasets like product catalogs, region mappings, or category lists.
  • One-time data analysis of exported files, e.g. from third-party tools.
  • Ad-hoc reporting on datasets that don't change frequently.
  • Evaluation of data before importing it into a database or data warehouse.

Static Tables in Cluvio are complementary to regular datasources and not a replacement for a data warehouse or a ETL/ELT pipeline. For production analytics workloads with large amounts of data that grows daily, use a dedicated data warehouse where you ingest new data continuously and connect it as a regular Cluvio datasource.