Save Queries

How to save your SQL queries inside Atlan

๐Ÿ’พ Save queries

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

๐Ÿš€ Superpowers

๐Ÿค 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

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.

Status tags for saved queries