Course Overview
ClickHouse Database Objects

Table Functions

Lesson #9

In this lesson we will:

  • Introduce the table function abstraction;
  • Demonstrate how they are used in practice.

ClickHouse Table Functions

A core ClickHouse concept to be aware of is table functions. These are essentially functions which create a table abstraction over some data source, in a way that they can be used within the FROM clause of a query.

Two examples we will be using in this lesson are the URL and the S3 table functions.

Join our mailing list for regular insights:

We help businesses build and run real-time data, analytics and AI platforms based on ClickHouse.

© 2023 Ensemble Analytics. All Rights Reserved.