Databases

A Database is where all of your data is securely stored. Whenever you "Load to Database" with Dropbase, it is stored in your database. Databases are also where you query data from. Each Workspace is linked to one Database instance. Note that importing data through Worksheets simply imports the data for preview and does not automatically load your data to the database until you explicitly click on the "Load to Database" step.

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 account, we automatically set up a 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. The Database Manager organizes your data following an interface similar to how you manage folders and files in your computer. A Database has one or more folders, and each folder than have one or more tables. Through the Database Manager, you can add/remove/organize folders and tables, view/edit any of the data in your Database, and import new CSV/Excel files directly to your Database.

Workspaces

A Workspace is where you and your team can collaborate and manage all your data. You can invite teammates to join your Workspace or you can join someone else's Workspace.

In Dropbase, one subscription corresponds to one workspace. You can create more than one workspace if you desire, but that will require more than one subscription plan. If you need consolidated company billing across multiple workspaces, please contact our sales team.

If you invite someone to a Workspace, they will have access to all the current and future Workbooks, Pipelines, and other resources created in that Workspace. You can invite someone with different access levels e.g. Admins, Editors, and Viewers.

Workspaces consist of one or more Workbooks.

Workbooks

A Workbook is a collection of Worksheets (tabs). Dropbase Workbooks are similar to Excel Workbooks or Google Spreadsheets.

Worksheets

Worksheets are individual spreadsheet tabs where you do data work. Dropbase Worksheets are similar to a sheet/tab in an Excel file or Google Sheets. From a UI perspective, Worksheets consist of 2 main visual components, a Spreadsheet View and a sidebar that displays your Dataflow. A Dataflow is a series of Steps that define how your data will be processed or cleaned. You can think of them as a data cleaning recipe.

To use Worksheets, you must first import some data. Data can come from files or online sources. You have the option to add processing steps to your data and load it to the database, or just use the Worksheet to run queries and view your data in a Spreadsheet view.

A set of Import, Processing, and Load to Database Steps in a Worksheet can be deployed as a Pipeline.

Dataflow

The Dataflow is one of the 2 main UI components of a Worksheet. It visually displays a sequential view of all the Steps that are being applied in a Worksheet. The Dataflow shows Import, Processing, and Load to Database Steps.