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.

Perform data modeling before creating tables to avoid issues.

Table primary key

The table ID column (_id) is used as the table primary key and must uniquely represent a record in your table.

UI Type SQL data type Data source table unique key
Number id Positive integer
String string String key or a combination of columns used to create a unique key

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

Managing tables in FeatureBase Cloud

Managing tables using the Cloud API

Joining tables

Tables that exist in the same database can be joined.

Next step