How to use Atlan AI for data exploration

🧪 Preview feature! This feature is only available to select users for a limited period of time. The purpose of this private preview is to allow participating users to experiment with the feature and provide valuable feedback. Once released in its final generally-available form, Atlan AI will be a paid addition to your Atlan suite. If you'd like to participate in the private preview, reach out to your customer success manager for more information.
🤓 Who can do this? Before using Atlan AI, you will need your admin user to enable Atlan AI in your Atlan workspace.

Use Atlan AI to write queries — no SQL knowledge required! 

Write SQL queries

Atlan AI can help you write SQL queries more efficiently to get the insights you need. You can use Atlan AI in the Insights query editor to:

  • Generate — generate SQL queries from natural language statements
  • Edit — modify existing queries based on your prompts
  • Fix — debug and fix issues with your queries
  • Explain — explain complex queries in natural language

 

To use Atlan AI to write queries:

  1. From the left menu of any screen, click Insights.
  2. Under the Explorer tab, find the asset you want to query:
    1. Use the Select database dropdown to choose another database, if necessary.
    2. Search for the asset by name in the search bar, or browse for it in the tree structure.
  3. In the Insights query editor, to generate a SQL query, you can either:
    • Press Shift twice in the query editor to open the Atlan AI menu and click Generate.
    • In the top right of the query editor, next to Save, click the Atlan AI button and then click Generate.
  4. For Generate, in the Ask Atlan AI to write queries field, type a question or describe the task you want to accomplish — try to be as specific as possible to get the most accurate results.
  5. Click the send button to generate a SQL query based on your prompt.
  6. Once Atlan AI has generated the query, you can either:
    • Click Apply to use the query and modify it as required.
    • Click Discard to discard the query.
  7. (Optional) In the top right of the query editor, next to Save, click the Atlan AI button and then from the dropdown:
    • Click Edit to modify the existing SQL query based on a revised prompt.
    • Click Fix to debug the SQL query and fix any issues. You can either click Apply to use the debugged query or click Discard to discard it.
    • Click Explain to generate a natural language explanation of the SQL query. You can either click Apply to add the explanation as a comment to the query or click Discard to discard it.
  8. Click the Run button to run the query.
  9. (Optional) To save the query, in the top right of the query editor, click the Save button.

You can now write SQL queries using Atlan AI! 🎉

Related articles

Was this article helpful?
0 out of 0 found this helpful