Governed data.Plain English.Visible SQL.

An independent open-source .NET client, terminal application and automation toolkit for Databricks Genie Agents. Genie lives in the Databricks web UI. This puts it in your terminal, your scripts and your C#.

Generated SQL can be wrong in ways that read as correct. LakeSpeak keeps the statement, its bound values and the message ids, so you can check the answer yourself.

You need a Genie Agent that already exists in your workspace and is shared with you. LakeSpeak cannot create one.

Failures you can branch on

The client validates its configuration when you first resolve it, not on the first call. Failures arrive as a GenieException carrying aGenieFailureKind you can switch on.

Cells reach you as strings, exactly as Databricks returned them. A DECIMAL never goes through a double on the way.

• Authentication
• Authorization
• AgentNotFound
• ConversationNotFound
• MessageFailed
• MessageCancelled
• PollingTimeout
• RateLimited
• QueryResultExpired
• QueryExecutionFailed
• MalformedResponse
• UnsupportedResult
• Network
• Unexpected

→ Runnable quickstart, built in CI so it cannot drift

        using LakeSpeak.Genie;
using Microsoft.Extensions.DependencyInjection;

services.AddLakeSpeak(options => options.Profile = "production");

var genie = provider.GetRequiredService<IGenieClient>();

try
{
    var response = await genie.AskAsync(
        agentId: salesAgentId,
        question: "Which customers had the largest revenue decline?",
        cancellationToken: cancellationToken);

    Console.WriteLine(response.Text);

    // The SQL, so a human can check the answer.
    if (response.Query is { Sql: { } sql })
    {
        Console.WriteLine(sql);
    }
}
catch (GenieException ex) when (ex.Kind == GenieFailureKind.Authorization)
{
    // Fixed with a Databricks grant, not in code.
}
      

Compiled against LakeSpeak.Genie from nuget.org on every pull request, so this cannot quietly stop being real code.