Skip to main content
Link
Menu
Expand
(external link)
Document
Search
Copy
Copied
FeatureBase Cloud
Frequently Asked Questions
Glossary
Data cardinality
Bitmap index overview
Equality-encoded bitmaps
Bit-slice bitmaps
Roaring Bitmap Format
RBF page allocation
Data modeling low-cardinality data
Getting started
Signup to cloud
Connect to cloud
Evaluate FeatureBase with a billion-row database
Sign in to cloud
Create custom databases
Manage databases
Create a small database
Evaluate featurebase at scale
Create custom database
Cloud database details
Cloud database states
Cloud query and ingestion stats
Delete database
Manage tables
Create tables
Add columns
Copy query endpoint
Drop column
Delete table
Manage data
Running queries
Query sample data
Run queries in Cloud GUI
SQL guide
Statements
SHOW DATABASES
DROP DATABASE
CREATE TABLE
SHOW CREATE TABLE
SHOW TABLES
ALTER TABLE
SHOW COLUMNS
CREATE VIEW
INSERT
EXPLAIN execution
BULK INSERT
SELECT
KILL QUERY
SQL hints
FLATTEN()
Data types & constraints
BOOL
DECIMAL
ID
INT
STRING
SET & SETQ
TIMESTAMP
VARCHAR
VECTOR
Functions
ASCII()
CHAR()
CHARINDEX()
COALESCE()
DATETIMEADD()
DATETIMEDIFF()
DATETIMEFROMPARTS()
DATETIMENAME()
DATETIMEPART()
DATE_TRUNC()
FORMAT()
IDENTIFIER()
LEN()
LOWER()
LTRIM()
OFFSET()
PARSETIMESTAMP()
PREFIX()
RANGEQ()
REPLACEALL()
REVERSE()
RTRIM()
SET
STR()
STRINGSPLIT()
SUBSTRING()
SUFFIX()
TANIMOTO_COEFFICIENT()
TOTIMESTAMP()
TRIM()
TUPLE()
UPPER()
VECTOR DISTANCE
Expressions
Operators
SQL examples
FeatureBase SQL issues
Issue - unexpected values returned on query
FeatureBase system tables
Manage authentication
Create API Key
Update Key Description
Revoke Key
PQL guide
Tools
fbsql CLI SQL tool
Install or upgrade fbsql
Connect to cloud db
Running SQL queries
Output flags
SQL output flags
fbsql loader command
loader TOML configuration
fbsql loader examples
Example Impala data source
Example Kafka data source
Example PostgreSQL data source
Example fbsql loader ingest
Python client library
Install python client
Connect to Cloud
Query your database
Python client examples
Manage organization
Organization ID
Update billing contact
Update organization
Update technical contact
Upgrade to a paid account
View usage and invoices
Manage users
View users
Invite users
Update user role
Update user details
Activate or deactivate users
Reference - Cloud user roles
Reference - Cloud user status
My account
Activate account
Update account
Accept invitation to new organization
Home
FAQ
API
SQL
Status
Support
SQL guide
SQL hints
SQL Hints
SELECT hints tell queries how to access data in a specified table.
Table of contents
FLATTEN()