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

How do I upload data to FeatureBase Cloud?

You can upload data to FeatureBase cloud using a specifically structured CSV file.

You can also upload data using the BULK INSERT statement

Before you begin

Naming standards

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

Upload file

Your CSV data file needs the following structure:

  • Header row
  • First item in the header row and each row is a unique identifier
  • Each row of data is comma-separated

Uploading data to a table

Table column names cannot be changed once the table is defined.

Step 1: Navigate to Upload Data

  • Click Databases > database name > Upload Data.

Step 2: Select a file to upload

  1. Click Upload a file.
  2. Select a file from the file browser.
  3. Click Done.

Step 3: Select column type for each column

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
  1. Click more_vert on the column.
  2. Click Update.
  3. Select a type from the Type dropdown menu.
  4. Click Update Column.

User cannot procced until all column types have been selected.

Step 4: Name the table and write data

You can download SQL statements automatically generated by FeatureBase if required:

  • DDL downloads the CREATE TABLE statement
  • DML downloads the BULK INSERT statement
  • Enter the table name.
  • Click Write my data.

Further information