Skip to main content Link Menu Expand (external link) Document Search Copy Copied

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:

  • tables with columns
  • columns with data types and constraints.

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

Table of contents

Before you begin

Data modeling

You can duplicate your existing RDBMS data structures within FeatureBase.

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

  • determine the specific data they wish to query
  • take advantage of FeatureBase-specific data types and constraints
  • run queries on the data to test if the structure meets expectations

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

Table primary key

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

Column data types and constraints

Naming standard

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

  • lower-case alphabetic characters
  • numbers 0-9
  • dash - and underscore _ characters.

  • table names can be up to 230 characters in length

  • column names can be up to 64 characters in length

View tables

  • Click Databases > database name > Tables.

Managing tables in FeatureBase Cloud

Managing tables using the Cloud API

Managing tables using SQL

Joining tables

Tables that exist in the same database can be joined.

Next step