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:
FQDNaddressToLineaddressToLineWithInlinesaddressToSymbolazureBlobStorageazureBlobStorageClusterbuildIdcatboostEvaluatecosncurrentDatabasecurrentProfilescurrentRolescurrentSchemascurrentUsercurrent_databasecurrent_schemascurrent_userdatabasedefaultProfilesdefaultRolesdeltaLakedemangledictionarydisplayNameenabledProfilesenabledRolesexecutablefilefileClusterfilesystemAvailablefilesystemCapacityfilesystemFreefilesystemUnreservedfullHostNamegcsgenerateRandomStructuregetClientHTTPHeadergetMacrogetOSKernelVersiongetServerPortgetSettingglobalVariablehasColumnInTablehasThreadFuzzerhdfshdfsClusterhivehostNamehostnamehudiicebergindexHintinitialQueryIDinitial_query_idinputjdbcJSONRemoveDynamoDBAnnotationslogTraceloopmeiliMatchmeilisearchmergemergeTreeIndexmongodbodbcossredisremoteremoteSecurereverseDNSQueryrevisions3s3ClusterSCHEMAserverUUIDshardCountshardNumshowCertificatesleepsleepEachRowsqlitetcpPorttidunnestDynamoDBStructureuptimeurlClusteruserversionviewviewExplainviewIfPermittedzookeeperSessionUptime
Private beta¶
Tinybird supports the following ClickHouse table functions upon request:
mysqlurl
ClickHouse settings¶
Tinybird supports the following ClickHouse settings:
aggregate_functions_null_for_emptyjoin_use_nullsgroup_by_use_nullsjoin_algorithmdate_time_output_format
Tinybird is not affiliated with, associated with, or sponsored by ClickHouse, Inc. ClickHouse® is a registered trademark of ClickHouse, Inc.