Skip to main content
You export a complete Databricks Genie result when you need every matching row for analysis or a CSV file. Genie responses return at most 5,000 rows. Athena can rerun the read-only SQL that Genie generates and save the complete result as a CSV asset, instead of relying on the limited response shown in the conversation.

How to save a full Genie result as a CSV

  1. Ask your question
  2. Read the Genie answer
  3. Check the query
  4. Ask for every row
  5. Athena exports the result
  6. Check the CSV details

​
Export the result

  1. Connect a Databricks Genie space as an MCP server using the Databricks connection guide. An MCP server makes the space’s tools available to Athena.
  2. Ask Athena your question through the connected Genie space.
  3. Ask Athena to export every result row as CSV using the SQL from that answer. You can include a name for the file.
  4. Select the export card’s arrow to see its details: the file name, row count and column names. Check them before continuing your analysis. The card has no Open button, so find the CSV in your workspace under the name you gave it.
For example, after Genie answers your question, ask: “Save every row from this query as a CSV asset named Order analysis. Use the SQL from the Genie answer.”

​
Handle an export failure

  1. Read the error returned by Athena.
  2. If no Databricks credential is available, reconnect the Databricks catalog and try again.
  3. If warehouse access fails, check that the connected account can use a SQL warehouse in the same Databricks workspace.
  4. If the result exceeds the export size limit, ask Athena to filter or aggregate the SQL, then export the smaller result.

​
Limits

  • The export tool is attached to a connected Genie MCP server for a specific space. A SQL catalog connection alone does not provide this Genie workflow.
  • The query runs with the identity used by that Genie connection. Its Databricks permissions still apply.
  • Only read-only SQL is accepted. The export does not change your source tables.
  • Exports have a 100 MB size limit. “Complete” means the complete result of the SQL you run, including any filters or limits already in that SQL.
  • Exporting reruns the query. If source data changes after the Genie answer, the CSV can contain different results.
  • The CSV contains column headers. Athena returns its asset, row count, column names, and a short preview after a successful export.