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 closed 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 closed 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 ask questions from sample data or write queries β€” no SQL knowledge required! 

Ask questions from sample data

Atlan AI can help you interact with and gain meaningful insights from your data estate. When viewing a table or view asset profile, select an Atlan AI-generated question or ask your own question in natural language from your sample data and save the SQL queries for future use.

Once you have asked your question, Atlan AI will run a SQL query on the selected asset and query the entire dataset β€” and not just the sample data β€” to generate an answer for you.

Atlan currently supports asking questions from sample data for the following data sources:

 

To use Atlan AI to ask questions from sample data:

  1. From the left menu of any screen, click Assets.
  2. Click an asset to open its asset profile.
  3. From the asset profile, click the Sample data tab.
  4. To the right of the search bar under Sample data, click the Ask Atlan AI button to ask a question from your sample data.
  5. To ask a question, you can either:
    • Type your own question in the Ask questions about your data field β€” try to be as specific as possible to get the most accurate results.
    • Select a question from the Atlan AI-suggested questions.
  6. Click the send button to ask your question.
  7. Once Atlan AI has generated a result, you can:
    • View the results under the Results tab.
    • Click the SQL tab to view the SQL query for the question.
    • Click the clipboard icon to copy the query.
    • Click Save query to save the query.
    • Click Open in Insights to view or run the query in the Insights query editor.
  8. Next to the question bar, click the X button to return to sample data preview.

You can now ask questions from sample data using Atlan AI! πŸŽ‰

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