> ## Documentation Index
> Fetch the complete documentation index at: https://lightdash-mintlify-87860eff.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Virtual views

> Virtual Views are created in the [SQL Runner](/guides/developer/sql-runner) and allow other users to reuse your custom SQL queries in Lightdash. They get listed in your `Tables` and can be used like the tables that come from your dbt project.

<Info>
  **A Virtual View won't be saved to or managed in your dbt project.**

  If you're expecting to use this query regularly, we recommend [writing it back to dbt](/guides/developer/dbt-write-back).
</Info>

## Create a Virtual View

To create a Virtual View from the SQL Runner, select the `Create Virtual View` option from the `save` drop-down.

<Frame>
  <img src="https://mintcdn.com/lightdash-mintlify-87860eff/e1Q3UTV06fXqB-Lw/images/guides/developer/virtual-views/create-virtual-view-561e25141894abbe7b7613343ea5c563.jpg?fit=max&auto=format&n=e1Q3UTV06fXqB-Lw&q=85&s=c8210059b360dc5f7b2ecb32fdb25b36" alt="" width="3061" height="1306" data-path="images/guides/developer/virtual-views/create-virtual-view-561e25141894abbe7b7613343ea5c563.jpg" />
</Frame>

Your Virtual View will appear in the list of Tables available to explore in Lightdash. Everyone in your team can use Virtual Views to build queries and charts just like they would any other Table.

<Frame>
  <img src="https://mintcdn.com/lightdash-mintlify-87860eff/e1Q3UTV06fXqB-Lw/images/guides/developer/virtual-views/using-virtual-views-ffc9321842862ae0f198c885aa1a9f54.jpg?fit=max&auto=format&n=e1Q3UTV06fXqB-Lw&q=85&s=2dc7b98c6fa15de204b9c1b082a12235" alt="" width="3004" height="1331" data-path="images/guides/developer/virtual-views/using-virtual-views-ffc9321842862ae0f198c885aa1a9f54.jpg" />
</Frame>

## Edit or delete a Virtual View

To edit a Virtual View, you need to open it in the Explorer, then beside the name, there's a three-dot-menu where you can choose to `edit` or `delete` the Virtual View.

<Frame>
  <img src="https://mintcdn.com/lightdash-mintlify-87860eff/e1Q3UTV06fXqB-Lw/images/guides/developer/virtual-views/edit-delete-virtual-view-0f3ec1b5b343f2a5ca156ffe0075e658.jpg?fit=max&auto=format&n=e1Q3UTV06fXqB-Lw&q=85&s=b79b70499d62db0f2ee1471ea42c8161" alt="" width="2959" height="1351" data-path="images/guides/developer/virtual-views/edit-delete-virtual-view-0f3ec1b5b343f2a5ca156ffe0075e658.jpg" />
</Frame>

Any changes you make will affect all existing content built using the Virtual View.
