MD_GET_FLIGHT

Preview

This feature is in preview and is subject to change.

Returns the FlightSummary fields for a single Flight. For version-specific content (source code, requirements, config), use MD_GET_FLIGHT_VERSION.

Users can fetch Flights they have created. Admins can fetch Flights they own as well as any Flight in the organization.

Syntax

SELECT * FROM MD_GET_FLIGHT(flight_id := '<flight_id>');

Parameters

Parameter	Type	Required	Description
flight_id	UUID	Yes	Identifier of the Flight.

Return columns

Column	Type	Description
flight_id	UUID	The Flight identifier.
flight_name	VARCHAR	The current name.
schedule_cron	VARCHAR	The current cron expression, or NULL for on-demand only.
schedule_status	VARCHAR	Schedule state (for example, SCHEDULE_STATUS_ACTIVE or SCHEDULE_STATUS_DISABLED), or NULL when the Flight has no schedule.
status	VARCHAR	Flight status (for example, JOB_STATUS_ACTIVE). Not the schedule state — see schedule_status.
current_version	UINTEGER	The latest version number.
created_at	TIMESTAMP WITH TIME ZONE	Creation timestamp.
updated_at	TIMESTAMP WITH TIME ZONE	Last update timestamp.
owner_name	VARCHAR	The user who owns the Flight.

Examples

SELECT flight_id, flight_name, schedule_cron, current_version
FROM MD_GET_FLIGHT(flight_id := '80000000-0000-0000-0000-000000000001');

Related

• MD_LIST_FLIGHTS — List all Flights.
• MD_GET_FLIGHT_VERSION — Fetch a specific version's content.
• get_flight MCP tool — AI-agent equivalent.