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
Tinybird is not affiliated with, associated with, or sponsored by ClickHouse, Inc. ClickHouse® is a registered trademark of ClickHouse, Inc.
Updated