FROM

FROM repository[:tag] [AS alias]

Bases the output of the splitfile on a certain revision of the remote/local repository. If AS alias is specified, the repository is cloned into alias and the current contents of alias destroyed. Otherwise, the current output repository (passed to the executor) is used.

FROM can also be used to perform Docker-like multistage builds.

For example:

FROM internal_data:latest AS stage_1
CREATE TABLE visible_staff AS SELECT name, age FROM staff WHERE is_restricted = FALSE

FROM EMPTY AS stage_2
FROM stage_1 IMPORT {SELECT * FROM visible_staff} AS visible_staff