Checks

A Check is a unit of data validation. You can use Checks to specify how you want Dropbase to validate your incoming data. For example, a Check can be used to specify that a number in a column data must fall within a predetermined range or that the text format in a column data must have an email pattern. When Dropbase runs validations, it incorporates any Check applied to a column. If the column data conforms to the Check specification then data passes validation. If the column data does not conform to the Check specification then data fails validation and Dropbase highlights the specific cells that do not conform to the Check.

Cleaning Steps

Cleaning Steps consist of one or more steps applied to data that you've imported (and that you want to clean before loading it to the database). Steps are a unit of data cleaning. Every cleaning action you make on your data requires a Step. Cleaning Steps are visually displayed as a sequential view of all the steps that are being applied to your data.

Databases

A Database is where all of your data is securely stored. Whenever you "Load to Database" with Dropbase, we actually load and store the data in your database. Databases are also where you query data from. Each Workspace is linked to one Database instance. Note that you need to explicitly click on the "Load to Database" step to actually store the data in your database. If you import data but don't load to database, the data is only available for preview but not actually in the database.

Dropbase manages and maintains the database for you. This means that you don't need any engineering or technical effort to set it up. Once you create a Dropbase workspace, we automatically set up a secure and highly scalable database that you can start using immediately.

Database Manager

The Database Manager helps you view and manage all of your data in one place. It gives you a central view of your entire Database using a simple an intuitive interface. A Database has one or more folders (the technical term is a schema), and each folder has one or more tables. Through the Database Manager, you can add/remove/organize folders and tables, view and filer any of the data in your Database, and import new CSV or Excel files directly to your Database.

Dropmail

A Dropmail is a type of data request that allows external partners or external collaborators to send you CSV or Excel files via email attachments. Each Dropmail is an unique email address that is tied to a specific table (and a corresponding set of cleaning steps). Once set up, external partners can send you send data—right from their email to your Database. You can also forward any email containing CSV or Excel file attachments to a Dropmail.

Integrations

Dropbase can integrate with any tool that can connect to a database. Once you have connected your favorite tools to Dropbase Database, you can access your data stored in the database from those tools. We have a list of partners we integrate with out of the box. If you need to connect to Dropbase Database from a partner we haven’t added, email support@dropbase.io and request a new integration.

Pipelines

A Pipeline defines a pre-determined set of actions about how to process your data between a source-destination pair. We currently have two types of pipelines: a File Upload pipeline and a Dropmail pipeline.

When you run a Pipeline, data is extracted from a source file, automatically cleaned according to the specified Cleaning Steps, and finally loaded to the specified table in your Database.

Spreadsheet UI

The Dropbase Spreadsheet UI consist of 2 visual components: 1) a grid/table view of your data on the left and 2) a sidebar on the right that displays your Cleaning Steps.