Who likes to rewrite ✍️ the same piece of code every time? Nobody!
Atlan gives users the mighty power of SQL to query data. On top of that, it also allows users to save their favorite or frequently used queries to avoid writing the same SQL statements again and again.
It is not uncommon to rerun the same queries, so this feature helps users to save both time ⏱️ and effort.
🛠️ Step-by-Step Guide to Save Queries
STEP 1: Go to the Query tab
Click on the data table and go to the "Query" tab. (This is the second tab from the top.)
STEP 2: Write your query
Type out the SQL query to query your data, or you can also use the "Build Query" option.
STEP 3: Save the query
Click on "Save", the first option from the top, to save the query. Give it a name and description for quick identification.
Saving a query in Atlan for future use
🤝 Public Queries
Often a team has a list of frequently used SQL queries, shared with colleagues over Slack, email, etc.
Atlan lets you create public SQL queries that you can share with your colleagues. This lets you build on top of your colleague's work instead of starting from scratch.
Public saved queries
🔎 Easy To Search
All saved queries whether public or private can be searched via Atlan global search and via glossary terms as well. As soon as you save a query, you will get an option to attach a glossary term to it, just like you get for other assets.
Attach glossary terms
👀 Note: If no glossary term is attached to your saved query, you will not be able to search t from the Glossary section of the product.
✅ Attach Status Tags
To be very clear to your fellow SQL mates, you can give a status tag to your saved query. It will help everyone know if the query is ready to use, WIP, or has some issues.
Saved SQL query is also an asset. Therefore just like other data assets, status tags can be attached to saved queries also.