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.

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.
status	VARCHAR	Schedule status (for example, JOB_STATUS_ACTIVE).
current_version	INTEGER	The latest version number.
created_at	TIMESTAMP WITH TIME ZONE	Creation timestamp.
updated_at	TIMESTAMP WITH TIME ZONE	Last update timestamp.

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.