Skip to main content
Last updated on

Explore sample data with Genie Code

Sample Data Explorer with Genie Code provides a conversational interface for discovering and exploring datasets in your workspace. Use natural language to ask questions about your data without writing SQL. Using table metadata and row-level samples, Sample Data Explorer generates SQL queries that you can either review manually or configure to run automatically.

Sample Data Explorer supports the following table types:

  • Managed, external, and foreign tables
  • Views and materialized views
  • Streaming tables
  • Vector search indices

Sample Data Explorer demo

Requirements​

You must have the SELECT privilege on the target table, as well as USE SCHEMA on the parent schema, and USE CATALOG on the parent catalog.

Exploring sample data​

To explore sample data for a table:

  1. In your Databricks workspace, click Data icon. Catalog.

  2. Select the table that you want to explore.

  3. Click the Sample data tab.

  4. In the prompt box, ask Sample Data Explorer a question about the data. Typical questions involve:

    • Asking about table prooperties: "Is there a field with contact information?"
    • Getting quick stats: "How many trips happened after 8pm?"
    • Debugging and running half-based SQL: "select deployable_account_id, order by descending DATE."

  5. Genie Code returns an answer to your question, along with a generated SQL query. If it's your first time using Sample Data Explorer, it might prompt you to choose how queries are executed:

    • Click Yes to have Genie Code automatically run generated queries. Genie Code runs the query and returns the answer immediately.
    • Click No, run manually to review the generated SQL before running it.

  6. If Sample Data Explorer is configured to run queries manually, it displays the Run query and Open in Editor buttons after each response. Click Run query to execute the query, or Open in Editor to modify it.

You can modify the auto-run setting at any time by clicking the Kebab menu icon. icon to the right of the prompt box, then select Auto-run queries or Run manually.

Configure auto-run queries for Sample Data Explorer

On this page