Supported syntax¶
Tinybird supports the following statements and functions in queries.
SQL statements¶
The only statement you can use in Tinybird's queries is SELECT
. The SQL clauses for SELECT
are fully supported.
All other SQL statements are handled by Tinybird's features.
ClickHouse® functions¶
You can use most functions from the latest version of ClickHouse. See ClickHouse.
Unsupported functions¶
The following functions aren't supported and don't work in Tinybird:
FQDN
addressToLine
addressToLineWithInlines
addressToSymbol
azureBlobStorage
azureBlobStorageCluster
buildId
catboostEvaluate
cosn
currentDatabase
currentProfiles
currentRoles
currentSchemas
currentUser
current_database
current_schemas
current_user
database
defaultProfiles
defaultRoles
deltaLake
demangle
dictionary
displayName
enabledProfiles
enabledRoles
executable
file
fileCluster
filesystemAvailable
filesystemCapacity
filesystemFree
filesystemUnreserved
fullHostName
gcs
generateRandomStructure
getClientHTTPHeader
getMacro
getOSKernelVersion
getServerPort
getSetting
globalVariable
hasColumnInTable
hasThreadFuzzer
hdfs
hdfsCluster
hive
hostName
hostname
hudi
iceberg
indexHint
initialQueryID
initial_query_id
input
jdbc
JSONRemoveDynamoDBAnnotations
logTrace
loop
meiliMatch
meilisearch
merge
mergeTreeIndex
mongodb
odbc
oss
redis
remote
remoteSecure
reverseDNSQuery
revision
s3
s3Cluster
SCHEMA
serverUUID
shardCount
shardNum
showCertificate
sleep
sleepEachRow
sqlite
tcpPort
tid
unnestDynamoDBStructure
uptime
urlCluster
user
version
view
viewExplain
viewIfPermitted
zookeeperSessionUptime
Private beta¶
Tinybird supports the following ClickHouse table functions upon request:
mysql
url
ClickHouse settings¶
Tinybird supports the following ClickHouse settings:
aggregate_functions_null_for_empty
join_use_nulls
group_by_use_nulls
join_algorithm
date_time_output_format