SHOW CREATE

SHOW CREATE returns FeatureQL or generated SQL that reconstructs named persisted features.

SHOW CREATE FEATURE | FEATURES
    [(metadata_options)]
    [feature_name [, feature_name ...]]

SHOW CREATE FEATURE | FEATURES
    [(metadata_options)]
    [feature_name [, feature_name ...]]

Without a language option, SHOW CREATE returns self-contained FeatureQL with dependencies in topological order. (LANGUAGE DUCKDB), (LANGUAGE TRINO), or (LANGUAGE DATAFUSION) returns generated SQL for that dialect. Serving uses DATAFUSION.

SHOW CREATE FEATURES (LANGUAGE DUCKDB)
    FM.SALES.NET_REVENUE;

ON BRANCH name; then SHOW CREATE FEATURES with no names dumps the net overlay as runnable FeatureQL: surviving upserts, and DROP FEATURES IF EXISTS for names the overlay dropped that main had. A name created and dropped on the branch only is omitted. Run that script without ON BRANCH to apply it on HEAD. See Branch overlays .

For workflow examples, see Statement tools .