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

How do I upload data to FeatureBase Cloud?

Upload data from a CSV file to a new destination table.

You can also upload CSV 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

CSV file structure

Your CSV data file needs the following structure:

  • Optional header row
  • First column is a unique identifier
  • Each item of data is separated by commas
  • New line is a new row

Uploading data to a table

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

Step 1: Select a file to upload

  • Click Upload a file.
  • Select the CSV file from the browser.
  • Click The first row contains column labels if your CSV contains a header row.
  • Click Done.

Step 2: Select column data types

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
  • Click more_vert on the column.
  • Click Update.
  • Select a type from the Type dropdown menu.
  • Set a constraint if required.
  • Click Update Column.

User cannot procced until all column data types have been selected.

Step 3: Name your 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