How do I manage tables in FeatureBase Cloud?

This page provides an overview of FeatureBase tables and links to guide you through creating, altering and dropping tables.

A table is a database object that stores data from external sources.

FeatureBase tables are similar to those in traditional relational databases:

The first column is automatically created on all tables and serves as the primary key.

Table of contents

Before you begin

You can duplicate your existing RDBMS data structures within FeatureBase.

But to get the best results, users should perform a Data modeling process to:

By performing Data Modeling, customers may reduce their raw data footprint by up to 90% and thus make queries even faster.

The _id column in each table represents the primary key and supports two data types:

Data type	Description	Example	Advantage	Disadvantage
`ID` data type	One or more contiguous blocks of positive integers	`7,8,9,10,11,12,...20,21,22,23,...`	Faster queries	Warning: performance and storage are adversely affected if values are non-contiguous
`String` data type	String literal values can be supplied in any order if used as primary key	“a23”, “s93kk”, “h82k”, “2023-02-10”,…	Automatically mapped to blocks of contiguous integers	Higher storage and performance costs

FeatureBase identifiers (including object names such as databases, tables and columns) start with a lower-case alphabetic character and can include: