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.
Click on the data table and go to the "Query" tab. (This is the second tab from the top.)
Type out the SQL query to query your data, or you can also use the "Build Query" option.
Click on "Save", the first option from the top, to save the query. Give it a name and description for quick identification.
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.
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.
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.