SQL Statements

Run SQL queries on your data using the following methods:

• FeatureBase Cloud API
• FeatureBase fbsql CLI tool

• FeatureBase Cloud GUI query editor

Before you begin

• FeatureBase SQL guide

SELECT statement

• SELECT statement

SHOW statements

• SHOW CREATE TABLE
• SHOW TABLES
• SHOW COLUMNS
• SHOW DATABASES

TABLE statements

• CREATE TABLE
• ALTER TABLE
• DROP TABLE

VIEW statements

• CREATE VIEW

DATABASE statements

• DROP DATABASE

INSERT statements

• INSERT
• BULK INSERT

System statements

• KILL QUERY statement

Further Information

• BULK INSERT using CSV file
• BULK INSERT using NDJSON data source
• BULK INSERT using Parquet data source
• BULK INSERT using ORC data source

---