fn_registry/python/functions/metabase/metabase_execute_query.md

name, kind, lang, domain, version, purity, signature, description, tags, uses_functions, uses_types, returns, returns_optional, error_type, imports, params, output, tested, tests, test_file_path, file_path

name	kind	lang	domain	version	purity	signature	description	tags	uses_functions	uses_types	returns	returns_optional	error_type	imports	params	output	tested	tests	test_file_path	file_path
metabase_execute_query	function	py	infra	1.0.0	impure	def metabase_execute_query(client: MetabaseClient, database_id: int, sql: str, max_results: int = 0) -> dict	Ejecuta query SQL ad-hoc contra Metabase sin guardarla como card. Util para exploracion rapida. Endpoint: POST /api/dataset.	metabase query execute sql dataset api python extractor				false	error_go_core	httpx	name desc client instancia autenticada de MetabaseClient name desc database_id ID de la base de datos contra la que ejecutar la query name desc sql sentencia SQL a ejecutar (sin guardar como card) name desc max_results límite de filas a retornar (0=default 2000)	dict: resultados con status, row_count, running_time, data.columns, data.rows	false			python/functions/metabase/cards.py

Ejemplo

result = metabase_execute_query(client, 1, "SELECT * FROM users LIMIT 10")
print(f"{result['row_count']} filas en {result['running_time']}ms")

Notas

Misma respuesta que metabase_execute_card. Default 2000 filas, override con max_results.