Back to Strixa
Connect anything.
Integrations & Functions
Connect anything.
Calculate everything.
Strixa ships native connectors for every major database, cloud warehouse, SaaS tool, and file format — plus a full expression engine so analysts stay in the semantic layer, not in SQL editors.
50+
Data Connectors
200+
Formula Functions
6
Source Categories
6
Function Categories
Relational Databases
PostgreSQL
MySQL
MariaDB
MS SQL Server
Oracle
SQLite
CockroachDB
Neon
Cloud Data Warehouses
Snowflake
BigQuery
Redshift
Databricks
ClickHouse
DuckDB
Firebolt
Azure Synapse
SaaS & Business Apps
Salesforce
HubSpot
Stripe
Google Sheets
Airtable
Jira
Zendesk
Shopify
Intercom
QuickBooks
Mixpanel
Amplitude
Cloud Storage & Files
Amazon S3
Google Cloud Storage
Azure Blob
CSV / Excel
Parquet
JSON / NDJSON
SFTP
ORC
Streaming & Real-time
Apache Kafka
AWS Kinesis
Google Pub/Sub
RabbitMQ
Apache Pulsar
NoSQL & APIs
MongoDB
Redis
REST API
GraphQL
Elasticsearch
Cassandra
Built-in Formula Functions
200+ functions
Aggregations
SUM()AVG()COUNT()DISTINCT_COUNT()MIN()MAX()MEDIAN()PERCENTILE()STDDEV()VARIANCE()FIRST()LAST()
Date & Time
DATE_TRUNC()DATEADD()DATEDIFF()DATE_FORMAT()NOW()TODAY()EXTRACT()QUARTER()WEEK_OF_YEAR()EOMONTH()TIMESTAMP()
String
CONCAT()UPPER()LOWER()TRIM()LTRIM()RTRIM()REPLACE()LEFT()RIGHT()LEN()SUBSTR()CHARINDEX()REGEXP()SPLIT_PART()
Math
ROUND()CEIL()FLOOR()ABS()POW()SQRT()MOD()LOG()LOG10()EXP()SIGN()TRUNC()
Logic & Conditionals
IF()IIF()CASE WHENCOALESCE()NULLIF()IN()NOT IN()BETWEEN()IS NULLIS NOT NULLANDOR
Window Functions
RANK()DENSE_RANK()ROW_NUMBER()LAG()LEAD()RUNNING_SUM()RUNNING_AVG()FIRST_VALUE()LAST_VALUE()NTILE()PERCENT_RANK()
Type Conversion
CAST()CONVERT()TO_DATE()TO_NUMBER()TO_VARCHAR()TO_BOOLEAN()TO_TIMESTAMP()TRY_CAST()
Array & JSON
JSON_EXTRACT()JSON_VALUE()ARRAY_AGG()ARRAY_LENGTH()ARRAY_CONTAINS()FLATTEN()PARSE_JSON()