Skip to main content
Link
Menu
Expand
(external link)
Document
Search
Copy
Copied
FeatureBase help
Concepts
Glossary
Bitmap data overview
Data modeling overview
Time Quantums
Time To Live (TTL)
A True Crime Story
Cloud
Cloud Quick Start Guide
Signup to cloud
Login to cloud
Programmatic Access
Manage databases
Database shapes
Create cloud database
Evaluate featurebase at scale
Cloud database disk utilization
Cloud database versions
Cloud database states
Delete database
Manage cloud ingestion
Manage tables
Create tables
Add columns
Copy query endpoint
Drop column
Drop table
Query data
Configuration
Manage my account
Activate account
Update account
Move account
Manage users
View users
Invite users
Update user role
Update user details
Activate or deactivate users
Reference - move Cloud users
Reference - Cloud user roles
Reference - Cloud user status
Manage organization
Update organization
Update billing contact
Update technical contact
Cloud troubleshooting
Limit reached error
Integer precision loss error
Database "Unknown"
Community
Install on Linux
Install on MacOS
Install on Windows
Startup & connect
Community authentication
Authentication groups
Azure-AD setup
FeatureBase keygen
Mutual TLS
TLS authentication
TLS user auth tokens
Import data
CSV datafile reference
CSV ingester flags
CSV ingest examples
Kafka Avro Delete Reference
Kafka Avro Ingest Reference
SQL source reference
SQL ingester reference
SQL ingest examples
Dataframe consumer
Consumer ingest examples
Ingester configuration
Ingesters
Kafka Static Ingest Reference
Community configuration
Backup FeatureBase
Configuration flags
FeatureBase SQL CLI
Resize cluster
Restore FeatureBase
Scaling
Sizing database
Community API
SQL Queries over HTTP endpoint
APIs
GRPC API
HTTP API
Web API
Troubleshooting
Issue with Mac startup
Issue running SQL
Community setup
Community Getting started
Community quickstart
Host system
Community monitoring
Datadog monitoring
Log rotation
Monitoring
Query databases
Grafana connector
Python client library
PQL guide
PQL Options
PQL Read
PQL ALL
PQL APPLY()
PQL ARROW()
PQL CONSTROW()
PQL COUNT()
PQL DIFFERENCE()
PQL DISTINCT()
PQL EXTRACT()
PQL GROUPBY()
PQL INCLUDESCOLUMN()
PQL INTERSECT()
PQL LIMIT()
PQL MAX()
PQL MIN()
PQL NOT()
PQL PERCENTILE()
PQL ROW()
PQL ROWS()
PQL SORT()
PQL SUM()
PQL TOPK()
PQL TOPN()
PQL UNION()
PQL UNIONROWS()
PQL XOR()
PQL Write
PQL CLEAR()
PQL CLEARROW()
PQL DELETE()
PQL SET()
PQL STORE()
SQL guide
Statements
CREATE TABLE
ALTER TABLE
CREATE VIEW
INSERT
BULK INSERT
BULK INSERT CSV example
BULK INSERT Parquet example
BULK INSERT JSON example
DROP DATABASE
SHOW DATABASES
SELECT
SHOW CREATE TABLE
SHOW TABLES
SHOW COLUMNS
Data types & constraints
BOOL
DECIMAL
ID
IDSET
IDSETQ
INT
STRING
STRINGSET
STRINGSETQ
TIMESTAMP
SQL functions
ASCII()
CHAR()
CHARINDEX()
DATETIMEADD()
DATETIMEDIFF()
DATETIMEFROMPARTS()
DATETIMENAME()
DATETIMEPART()
DATE_TRUNC()
FORMAT()
LEN()
LOWER()
LTRIM()
PREFIX()
REPLACEALL()
REVERSE()
RTRIM()
SETCONTAINS()
SETCONTAINSALL()
SETCONTAINSANY()
STR()
STRINGSPLIT()
SUBSTRING()
SUFFIX()
TOTIMESTAMP()
TRIM()
UPPER()
Expressions
Operators
System Tables
Tools
fbsql
Install fbsql
fbsql-Kafka
Featurebase home
Glossary
API docs
Docs on GitHub
Contact us
Community
Query databases
Query databases
Table of contents
Grafana connector
Python client library