Core Concepts and terms

Project

A project in QuickTable is like a folder that helps you organize your data and workflow. Using a project, you can manage a collection of related items: datasets and recipes. As part of creating a project, you can create or load multiple datasets. Next, you create multiple recipes for them. A recipe is a set of instructions or steps that you want QuickTable to act on. These actions transform your raw data into a form that is ready to be consumed by your data pipeline.

Dataset

In QuickTable, a dataset simply means a set of data—rows or records that are divided into columns or fields. When you create a project, you connect to or upload the data that you want to transform or analyze. QuickTable can work with data from 100+ data sources, as well as uploaded and formatted files. It can also connect directly to a growing list of databases or integrate with applications through Fivetran.

For QuickTable, a dataset is a read-only connection to your data. Your raw data remains intact. Only datasets output through QuickTable is actively modified.

Connection

QuickTable uses Connections to load your data. Therefore, to integrate your data sources within QuickTable, you need to create a Connection first. There are two types of connections: Database and Application. QuickTable reads the data in the Database via a JDBC connection, whereas the integration with an Application is established through Fivetran. An instance of your data is read through the connection, but the original data remains intact; QuickTable does not modify your raw data. The operations and transformations in the applied recipes only affect the resulting data.

Recipe

A recipe is a set of instructions or steps you want to perform on your data. A recipe can contain many steps, and each step can contain several actions. You can use the transformation tools on the toolbar to specify what you wish to apply to your data. You can save the output of the recipe by using the Export option to download a copy of the resulting data to your local storage or export it as a new dataset.

Job

The process of running a recipe is called a job. QuickTable executes the instructions you defined in a recipe using a job. You can schedule your jobs to run on a pre-set time, run jobs on demand, or configure multiple schedules.