# Lightdash ## Docs - [Welcome to Lightdash](https://lightdash-docs-many-to-many.mintlify.site/introduction.md): Lightdash instantly turns your dbt project into a full-stack BI platform. - [Setting up a new project](https://lightdash-docs-many-to-many.mintlify.site/get-started/setup-lightdash/intro.md): This tutorial is for people who are new to Lightdash and would like to learn how to set up a new project. We'll show you how to get your dbt project Lightdash-ready, how to explore your data in Lightdash, and how to add metrics to your project. - [Create your first project](https://lightdash-docs-many-to-many.mintlify.site/get-started/setup-lightdash/get-project-lightdash-ready.md) - [Update your project connection](https://lightdash-docs-many-to-many.mintlify.site/get-started/setup-lightdash/connect-project.md) - [An intro to metrics and dimensions](https://lightdash-docs-many-to-many.mintlify.site/get-started/setup-lightdash/intro-metrics-dimensions.md) - [Querying tables](https://lightdash-docs-many-to-many.mintlify.site/get-started/setup-lightdash/using-explores.md): Now that you've connected your dbt project to Lightdash, it's time to start exploring your data. - [How to create metrics](https://lightdash-docs-many-to-many.mintlify.site/get-started/setup-lightdash/how-to-create-metrics.md) - [Inviting teammates to your Lightdash project](https://lightdash-docs-many-to-many.mintlify.site/get-started/setup-lightdash/invite-new-users.md): You can only share things with people you've invited to your Lightdash project. Users with **Admin** access to your project can invite users. - [Share insights with your team](https://lightdash-docs-many-to-many.mintlify.site/get-started/setup-lightdash/sharing-insights.md) - [ Learning to explore data in Lightdash](https://lightdash-docs-many-to-many.mintlify.site/get-started/exploring-data/intro.md): This tutorial is for people who are new to Lightdash and would like to explore the tables, charts and dashboards in their Lightdash project. We'll go over how to use Tables and the Explore view, how to share your insights, and how to build dashboards. - [Exploring your content](https://lightdash-docs-many-to-many.mintlify.site/get-started/exploring-data/exploring-your-content.md) - [An intro to metrics and dimensions](https://lightdash-docs-many-to-many.mintlify.site/get-started/exploring-data/intro-metrics-dimensions.md) - [Using Tables and the Explore view](https://lightdash-docs-many-to-many.mintlify.site/get-started/exploring-data/using-explores.md) - [Sharing with your team](https://lightdash-docs-many-to-many.mintlify.site/get-started/exploring-data/sharing-insights.md): It's time to share your hard work with the world! - [Creating dashboards](https://lightdash-docs-many-to-many.mintlify.site/get-started/exploring-data/dashboards.md) - [Using dashboards](https://lightdash-docs-many-to-many.mintlify.site/guides/interactive-dashboards.md) - [AI agents](https://lightdash-docs-many-to-many.mintlify.site/guides/ai-agents.md) - [Lightdash MCP](https://lightdash-docs-many-to-many.mintlify.site/guides/lightdash-mcp.md) - [Spotlight](https://lightdash-docs-many-to-many.mintlify.site/guides/metrics-catalog.md): Spotlight is a suite of features designed to put Metrics front and center. It simplifies data exploration, making it easy for business users to focus on metrics without dealing with complex tables or time dimensions. - [Chart types](https://lightdash-docs-many-to-many.mintlify.site/references/chart-types.md): Results tables can be useful for finding specific numbers or checking out your data, but it's usually easier to see trends and make sense of your data using charts. - [Scheduled deliveries](https://lightdash-docs-many-to-many.mintlify.site/guides/how-to-create-scheduled-deliveries.md): Scheduled deliveries let you send a dashboard or saved chart, and their results to people via email or Slack - even to people who don't have an account in your Lightdash instance. - [Alerts](https://lightdash-docs-many-to-many.mintlify.site/guides/how-to-create-alerts.md): Alerts enable you to receive notifications via email or Slack when the value of a saved chart meets your specified conditions. - [Using the Slack integration](https://lightdash-docs-many-to-many.mintlify.site/guides/using-slack-integration.md) - [Using Filters](https://lightdash-docs-many-to-many.mintlify.site/guides/limiting-data-using-filters.md) - [Formatting your fields](https://lightdash-docs-many-to-many.mintlify.site/guides/formatting-your-fields.md) - [Custom charts](https://lightdash-docs-many-to-many.mintlify.site/references/custom-charts.md): Custom charts are available in Beta for those that want additional customization and an extended library of charts. The charts are powered by [vega-lite](https://vega.github.io/vega-lite/examples/) - the link will take you to some example galleries of what you can build using this powerful charting… - [Using custom fields](https://lightdash-docs-many-to-many.mintlify.site/references/custom-fields.md): The fields that you see in your `dimensions` and `metrics` are created by the people maintaining your Lightdash project. But, you can create new custom dimensions or metrics for quick calculations and binning on the fly. On this page, we'll explain what custom dimensions and metrics are and how to u… - [Custom tooltips](https://lightdash-docs-many-to-many.mintlify.site/references/custom-tooltip.md) - [Chart version history](https://lightdash-docs-many-to-many.mintlify.site/guides/version-history.md): You can roll back to previous versions of charts in Lightdash. In case you make a mistake or simply want to go back to a previous version of a chart you built, you can easily revert back to previous versions of your charts. It's a great way to keep track of changes and revert back to previous versio… - [How to promote content](https://lightdash-docs-many-to-many.mintlify.site/guides/how-to-promote-content.md): Promoting content enables you to copy content from one project to another. It's especially useful when working with preview or development projects. You can promote charts created in your development projects to production, so it's easy to test and make changes without the fear of breaking things in… - [Table calculations](https://lightdash-docs-many-to-many.mintlify.site/references/table-calculations.md): Table calculations make it easy to create metrics on the fly (for example, aggregating the data in your table over some window, or getting a running total of a column). - [SQL templates](https://lightdash-docs-many-to-many.mintlify.site/guides/table-calculations/sql-templates.md): Use our SQL templates to get started with your table calculations! - [Percent change from previous](https://lightdash-docs-many-to-many.mintlify.site/guides/table-calculations/table-calculation-sql-templates/percent-change-from-previous.md): The percent change gives you the percent change in a value compared to the value in the row above it. - [Percent of previous value](https://lightdash-docs-many-to-many.mintlify.site/guides/table-calculations/table-calculation-sql-templates/percent-of-previous-value.md) - [Percent of column total](https://lightdash-docs-many-to-many.mintlify.site/guides/table-calculations/table-calculation-sql-templates/percent-of-total-column.md): The percent of the column total will give you the percentage of each value in the column out of the total sum of the values in the column. - [Percent of group/pivot total](https://lightdash-docs-many-to-many.mintlify.site/guides/table-calculations/table-calculation-sql-templates/percent-of-group-pivot-total.md): The percent of the group/pivot total will give you the percentage of each value in a group out of the total sum of the values for that group. - [Rank in column](https://lightdash-docs-many-to-many.mintlify.site/guides/table-calculations/table-calculation-sql-templates/rank-in-column.md): Ranking values in a column is when you set every value as a number either higher than or lower than the other values. The lowest value (rank = 1) indicates the value with the first rank in your set of values. - [Running total](https://lightdash-docs-many-to-many.mintlify.site/guides/table-calculations/table-calculation-sql-templates/running-total.md): Running totals give you the sum of a value + all of the previous values in that column. - [Rolling window](https://lightdash-docs-many-to-many.mintlify.site/guides/table-calculations/table-calculation-sql-templates/rolling-window.md): Rolling windows, or lookbacks, calculate metrics like rolling averages using the current row combined with N previous rows. This can be useful for smoothing out volatile time series data to better understand long term trends. - [Developing in Lightdash](https://lightdash-docs-many-to-many.mintlify.site/get-started/develop-in-lightdash/intro.md): This tutorial is for people who are new to Lightdash and would like to develop their existing Lightdash project. We'll go over how to use Tables and the Explore view, how to develop Tables in your project, adding your first metrics, and some more advanced configurations for your Lightdash project's… - [Exploring your content](https://lightdash-docs-many-to-many.mintlify.site/get-started/develop-in-lightdash/exploring-your-content.md) - [An intro to metrics and dimensions](https://lightdash-docs-many-to-many.mintlify.site/get-started/develop-in-lightdash/intro-metrics-dimensions.md) - [How to query from tables](https://lightdash-docs-many-to-many.mintlify.site/get-started/develop-in-lightdash/using-explores.md) - [How to create dimensions](https://lightdash-docs-many-to-many.mintlify.site/get-started/develop-in-lightdash/how-to-create-dimensions.md) - [How to create metrics](https://lightdash-docs-many-to-many.mintlify.site/get-started/develop-in-lightdash/how-to-create-metrics.md) - [How to share insights with your team](https://lightdash-docs-many-to-many.mintlify.site/get-started/develop-in-lightdash/sharing-insights.md) - [The Lightdash CLI](https://lightdash-docs-many-to-many.mintlify.site/guides/cli/intro.md): The Lightdash CLI is the recommended way to develop your dbt + Lightdash project. It makes development faster and easier, as well as giving you options for building more powerful automation to manage your Lightdash instance. Here are some guides to get you started! - [How to install the Lightdash CLI](https://lightdash-docs-many-to-many.mintlify.site/guides/cli/how-to-install-the-lightdash-cli.md): The Lightdash CLI is the recommended way to develop your dbt + Lightdash project. It makes development faster and easier, as well as giving you options for building more powerful automation to manage your Lightdash instance. - [Authenticating your CLI (login)](https://lightdash-docs-many-to-many.mintlify.site/guides/cli/cli-authentication.md) - [Upgrading your Lightdash CLI](https://lightdash-docs-many-to-many.mintlify.site/guides/cli/how-to-upgrade-cli.md) - [Autogenerate Lightdash-ready .yml files for your models](https://lightdash-docs-many-to-many.mintlify.site/guides/cli/how-to-auto-generate-schema-files.md): The beauty of Lightdash is that we're pretty well synced with your dbt project. So, in Lightdash, Tables actually come from dbt models that have been defined in your dbt project's `.yml` files. - [Lightdash Preview](https://lightdash-docs-many-to-many.mintlify.site/guides/cli/how-to-use-lightdash-preview.md): Preview projects are temporary Lightdash projects where you can safely experiment with your metrics, dimensions and charts without affecting your production project. - [Sync your changes with Lightdash deploy](https://lightdash-docs-many-to-many.mintlify.site/guides/cli/how-to-use-lightdash-deploy.md) - [Test your changes with Lightdash compile](https://lightdash-docs-many-to-many.mintlify.site/guides/cli/how-to-compile-your-lightdash-project.md): If you've connected Lightdash to GitHub, you can setup a `github action` and get Lightdash to compile your project and test your changes whenever you open a pull request. - [Lightdash Validate](https://lightdash-docs-many-to-many.mintlify.site/guides/cli/how-to-use-lightdash-validate.md): You can check to see if your changes break any of the content in your project using `lightdash validate`. This command will run the validator which will return a list of content in your project that is broken and details about the errors. - [The Lightdash semantic layer](https://lightdash-docs-many-to-many.mintlify.site/guides/lightdash-semantic-layer.md): In this guide we explain everything you need to know about the Lightdash semantic layer: how it works, where you can use it, benefits, and challenges. - [Adding and managing Tables](https://lightdash-docs-many-to-many.mintlify.site/guides/adding-tables-to-lightdash.md) - [How to create metrics](https://lightdash-docs-many-to-many.mintlify.site/guides/how-to-create-metrics.md) - [How to create dimensions](https://lightdash-docs-many-to-many.mintlify.site/guides/how-to-create-dimensions.md) - [How to join tables](https://lightdash-docs-many-to-many.mintlify.site/guides/how-to-join-tables.md): Learn how to add joins to your YAML files to connect different models to each other. - [Creating tailored tables from a single dbt model](https://lightdash-docs-many-to-many.mintlify.site/guides/explores.md): You can use the `explores` configuration in your Lightdash Semantic Layer to curate multiple ways to query from the same table for different audiences. - [Preview projects](https://lightdash-docs-many-to-many.mintlify.site/references/preview-projects.md): **Preview projects** are temporary Lightdash projects where you can safely experiment with your metrics, dimensions and charts without affecting your production project. - [Validating your content](https://lightdash-docs-many-to-many.mintlify.site/references/validating-your-content.md): Broken content is not useful content. We've built tools in Lightdash to help validate your content so you can keep it useful and we'll notify you when it isn't. - [SQL runner](https://lightdash-docs-many-to-many.mintlify.site/references/sql-runner.md): The SQL runner is used to build ad-hoc queries or charts using totally custom SQL. - [Virtual views](https://lightdash-docs-many-to-many.mintlify.site/references/virtual-views.md): Virtual Views are created in the [SQL Runner](/references/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. - [dbt write-back](https://lightdash-docs-many-to-many.mintlify.site/references/dbt-write-back.md): dbt Write-Back allows you to develop your models and Metrics in Lightdash and write back these changes to your dbt project. Writing back to dbt will create a new branch and pull request in your project so you can save and manage these changes. - [Dashboards as code](https://lightdash-docs-many-to-many.mintlify.site/references/dashboards-as-code.md): You can download your charts and dashboards as code, make changes, then upload your changes back to your Lightdash project using the CLI. Content as code is also useful for creating new Lightdash projects where you want the content to be copied from an existing project and added to your new project. - [How to use parameters](https://lightdash-docs-many-to-many.mintlify.site/guides/using-parameters.md) - [How to filter a dashboard in the URL](https://lightdash-docs-many-to-many.mintlify.site/guides/filtering-dashboard-in-url.md) - [How to set up Lightdash YAML validation for VS Code](https://lightdash-docs-many-to-many.mintlify.site/guides/vs-code-yaml-validation.md) - [Renaming models, metrics, and dimensions](https://lightdash-docs-many-to-many.mintlify.site/guides/renaming-models-and-fields.md) - [Metrics reference](https://lightdash-docs-many-to-many.mintlify.site/references/metrics.md) - [Dimensions reference](https://lightdash-docs-many-to-many.mintlify.site/references/dimensions.md): Dimensions are the columns in your table. They are the "attributes" of your data. For example, `user_id` in your users table is a dimension. - [Tables reference](https://lightdash-docs-many-to-many.mintlify.site/references/tables.md): You can run queries against the tables in your Lightdash project. - [Joins reference](https://lightdash-docs-many-to-many.mintlify.site/references/joins.md): Joins let you connect different models to each other so that you can explore more than one model at the same time in Lightdash and see how different parts of your data relate to each other. - [Lightdash CLI reference](https://lightdash-docs-many-to-many.mintlify.site/references/lightdash-cli.md): The Lightdash CLI is the recommended way to develop your Lightdash project. It makes development faster and easier, as well as giving you options for building more powerful automation to manage your Lightdash projects. - [Caching](https://lightdash-docs-many-to-many.mintlify.site/references/caching.md): Caching can reduce the overall number of queries that Lightdash executes against your data warehouse. Learn more about the types of caching and how to enable caching in this doc. - [lightdash.config.yml reference](https://lightdash-docs-many-to-many.mintlify.site/references/lightdash-config-yml.md): The lightdash.config.yml file allows you to configure project-wide settings for your Lightdash project, including spotlight and parameters. - [SQL variables](https://lightdash-docs-many-to-many.mintlify.site/references/sql-variables.md): When writing SQL in your Lightdash models, you can use the following references to template you SQL and make it more reusable - [Feature Maturity Levels](https://lightdash-docs-many-to-many.mintlify.site/references/feature-maturity-levels.md): We use standardized maturity levels to help you understand the stability and availability of features as we develop them - [Spaces](https://lightdash-docs-many-to-many.mintlify.site/references/spaces.md): Once you've used Lightdash for a while, your team will probably end up with a lot of saved charts and dashboards. Spaces let you organize your saved charts and dashboards. - [Pinning](https://lightdash-docs-many-to-many.mintlify.site/guides/pinning.md) - [Personal access tokens](https://lightdash-docs-many-to-many.mintlify.site/references/personal_tokens.md) - [Roles and permissions](https://lightdash-docs-many-to-many.mintlify.site/references/roles.md) - [User attributes](https://lightdash-docs-many-to-many.mintlify.site/references/user-attributes.md): User attributes provide a way to customise Lightdash charts, dashboards, and other behaviour depending on the user that is logged in. For example, you could only show your sales team members data that are relevant to their region. - [Creating multiple projects](https://lightdash-docs-many-to-many.mintlify.site/guides/how-to-create-multiple-projects.md): With Lightdash, you can have a single organization (e.g. Lightdash), and multiple projects within that organization (e.g. Production, Jaffle Shop, etc.) - [Customizing the appearance of your project](https://lightdash-docs-many-to-many.mintlify.site/guides/customizing-the-appearance-of-your-project.md) - [Add the Slack integration](https://lightdash-docs-many-to-many.mintlify.site/guides/adding-slack-integration.md) - [Usage analytics](https://lightdash-docs-many-to-many.mintlify.site/references/usage-analytics.md): To understand who is accessing content or running queries in your Lightdash projects, we've built usage analytics to help you track this. - [Groups](https://lightdash-docs-many-to-many.mintlify.site/references/groups.md): Groups are a way to manage access to multiple users at the same time. A user can belong to multiple groups. - [SCIM Integration](https://lightdash-docs-many-to-many.mintlify.site/references/scim-integration.md) - [dbt Projects](https://lightdash-docs-many-to-many.mintlify.site/references/dbt-projects.md): You can easily make changes in dbt and see them updated in your Lightdash project. - [Slack integration](https://lightdash-docs-many-to-many.mintlify.site/references/slack-integration.md): Below is everything you need to know about the Lightdash Slack integration. - [Google Sheets](https://lightdash-docs-many-to-many.mintlify.site/references/google-sheets.md): Syncs let you send your chart results to a Google Sheet in your Google Drive on a schedule. - [How to embed content](https://lightdash-docs-many-to-many.mintlify.site/guides/how-to-embed-content.md): Lightdash allows you to embed your dashboards using expirable URLs and tokens (embed URLs from now on). This is a great way to enable self-serve analytics in your own application and platform by leveraging the insights you've got in Lightdash and making them available to your own users. - [Embedding reference](https://lightdash-docs-many-to-many.mintlify.site/references/embedding.md): You can embed Lightdash content in your website or application securely using Lightdash embedding. - [React SDK](https://lightdash-docs-many-to-many.mintlify.site/references/react-sdk.md): Reference documentation for the Lightdash React SDK, used for Embedding. - [Self-Host Lightdash](https://lightdash-docs-many-to-many.mintlify.site/self-host/self-host-lightdash.md) - [Lightdash Cloud vs. Self-Hosted](https://lightdash-docs-many-to-many.mintlify.site/self-host/lightdash-cloud-vs-self-hosted.md): Lightdash is open-source and licensed under the MIT license. This means that you are free to self-host Lightdash on your own infrastructure but without any warranty or support from the Lightdash team. - [Self-host Lightdash using docker compose](https://lightdash-docs-many-to-many.mintlify.site/self-host/self-host-lightdash-docker-compose.md) - [Self-Host Lightdash with Restack](https://lightdash-docs-many-to-many.mintlify.site/self-host/self-host-lightdash-restack.md) - [Updating Lightdash to the latest version](https://lightdash-docs-many-to-many.mintlify.site/self-host/update-lightdash.md) - [Configure a Slack integration for self-hosted Lightdash](https://lightdash-docs-many-to-many.mintlify.site/self-host/customize-deployment/configure-a-slack-app-for-lightdash.md) - [Configure a Github integration for self-hosted Lightdash](https://lightdash-docs-many-to-many.mintlify.site/self-host/customize-deployment/configure-github-for-lightdash.md) - [Configure Lightdash to use an external database](https://lightdash-docs-many-to-many.mintlify.site/self-host/customize-deployment/configure-lightdash-to-use-an-external-database.md) - [Configure Lightdash to use external storage](https://lightdash-docs-many-to-many.mintlify.site/self-host/customize-deployment/configure-lightdash-to-use-external-object-storage.md) - [Configure logging for Lightdash](https://lightdash-docs-many-to-many.mintlify.site/self-host/customize-deployment/configure-logging-for-lightdash.md) - [Configure Prometheus metrics for self-hosted Lightdash](https://lightdash-docs-many-to-many.mintlify.site/self-host/customize-deployment/configure-prometheus-metrics-for-self-hosted-lightdash.md) - [Configure SMTP for Lightdash email notifications](https://lightdash-docs-many-to-many.mintlify.site/self-host/customize-deployment/configure-smtp-for-lightdash-email-notifications.md) - [Configure a standalone scheduler worker for self-hosted Lightdash](https://lightdash-docs-many-to-many.mintlify.site/self-host/customize-deployment/configure-standalone-scheduled-worker.md) - [Add headless browser on self-hosting](https://lightdash-docs-many-to-many.mintlify.site/self-host/customize-deployment/enable-headless-browser-for-lightdash.md): We use a chrome headless browser to generate images from your charts and dashboards so we can send them via email or Slack. - [Enable the scheduler in self-hosted Lightdash](https://lightdash-docs-many-to-many.mintlify.site/self-host/customize-deployment/enable-scheduler-in-self-hosted-lightdash.md) - [Environment variables](https://lightdash-docs-many-to-many.mintlify.site/self-host/customize-deployment/environment-variables.md) - [Configure a Google Sheets integration for self-hosted Lightdash](https://lightdash-docs-many-to-many.mintlify.site/self-host/customize-deployment/google-sheets-integration.md): In this guide we will show you how you can [upload to Google Sheets in scheduled deliveries](/references/google-sheets) and upload results from Google Sheets on `charts` on your on self-hosted Lightdash server. - [Resource recommendations](https://lightdash-docs-many-to-many.mintlify.site/self-host/customize-deployment/recommended-resources.md): The recommended resource requests for each Lightdash component are as follows - [Secure Lightdash with HTTPS](https://lightdash-docs-many-to-many.mintlify.site/self-host/customize-deployment/secure-lightdash-with-https.md): To run Lightdash in production it is highly recommended to secure it with HTTPS. This is usually done using your cloud provider's load balancer or ingress controller. Optionally you could use a proxy service like \[nginx\]([https://www.nginx.com/](https://www.nginx.com/)) or [traefik](https://traefi… - [Configure Lightdash to use passwords or SSO for authentication](https://lightdash-docs-many-to-many.mintlify.site/self-host/customize-deployment/use-sso-login-for-self-hosted-lightdash.md) - [FAQs](https://lightdash-docs-many-to-many.mintlify.site/faqs.md) - [Contact Us](https://lightdash-docs-many-to-many.mintlify.site/contact/contact_info.md): There are a few ways you can get in touch with the team. Here's which one to use depending on your situation: - [Guide to package-lock.yml in dbt](https://lightdash-docs-many-to-many.mintlify.site/dbt-guides/dbt-package-lock.md): Learn what dbt's package-lock.yml file does, why it matters for your data projects, and how to manage it effectively. - [Migrating to dbt 1.10: Fix Meta and Tags Configuration Warnings](https://lightdash-docs-many-to-many.mintlify.site/dbt-guides/dbt-1.10-migration.md): Learn how to fix dbt 1.10 deprecation warnings for `meta` and `tags` properties, and migrate your project automatically with MetaMove. - [Migrating to dbt Fusion](https://lightdash-docs-many-to-many.mintlify.site/dbt-guides/dbt-fusion-migration.md): Learn how to migrate from dbt Core or dbt Cloud to the new dbt Fusion engine, including preparation steps, requirements, and best practices. - [Lightdash API](https://lightdash-docs-many-to-many.mintlify.site/api-reference/v1/introduction.md) - [Get apiv1snowflakessois authenticated](https://lightdash-docs-many-to-many.mintlify.site/api-reference/projects/get-apiv1snowflakessois-authenticated.md) - [Get apiv1projects validate](https://lightdash-docs-many-to-many.mintlify.site/api-reference/projects/get-apiv1projects-validate.md): Get validation results for a project. This will return the results of the latest validation job. - [Post apiv1projects validate](https://lightdash-docs-many-to-many.mintlify.site/api-reference/projects/post-apiv1projects-validate.md): Validate content inside a project. This will start a validation job and return the job id. - [Delete apiv1projects validate](https://lightdash-docs-many-to-many.mintlify.site/api-reference/projects/delete-apiv1projects-validate.md): Deletes a single validation error. - [Get apiv1analyticsuser activity](https://lightdash-docs-many-to-many.mintlify.site/api-reference/projects/get-apiv1analyticsuser-activity.md) - [Post apiv1analyticsuser activity download](https://lightdash-docs-many-to-many.mintlify.site/api-reference/projects/post-apiv1analyticsuser-activity-download.md) - [Get apiv1projects spaces](https://lightdash-docs-many-to-many.mintlify.site/api-reference/projects/get-apiv1projects-spaces.md): List all spaces in a project - [Post apiv1projects rename](https://lightdash-docs-many-to-many.mintlify.site/api-reference/projects/post-apiv1projects-rename.md) - [Post apiv1projects renamechart](https://lightdash-docs-many-to-many.mintlify.site/api-reference/projects/post-apiv1projects-renamechart.md) - [Get apiv1projects renamechart fields](https://lightdash-docs-many-to-many.mintlify.site/api-reference/projects/get-apiv1projects-renamechart-fields.md): Get a list of fields for this chart's explore to be used when renaming a chart in the UI - [Get apiv1projects](https://lightdash-docs-many-to-many.mintlify.site/api-reference/projects/get-apiv1projects.md): Get a project of an organiztion - [Get apiv1projects charts](https://lightdash-docs-many-to-many.mintlify.site/api-reference/projects/get-apiv1projects-charts.md): List all charts in a project - [Get apiv1projects chart summaries](https://lightdash-docs-many-to-many.mintlify.site/api-reference/projects/get-apiv1projects-chart-summaries.md): List all charts summaries in a project - [Get apiv1projects groupaccesses](https://lightdash-docs-many-to-many.mintlify.site/api-reference/projects/get-apiv1projects-groupaccesses.md): List group access for projects - [Post apiv1projects calculate total](https://lightdash-docs-many-to-many.mintlify.site/api-reference/projects/post-apiv1projects-calculate-total.md): Calculate all metric totals from a metricQuery - [Post apiv1projects calculate subtotals](https://lightdash-docs-many-to-many.mintlify.site/api-reference/projects/post-apiv1projects-calculate-subtotals.md) - [Get apiv1projects user credentials](https://lightdash-docs-many-to-many.mintlify.site/api-reference/projects/get-apiv1projects-user-credentials.md) - [Patch apiv1projects user credentials](https://lightdash-docs-many-to-many.mintlify.site/api-reference/projects/patch-apiv1projects-user-credentials.md) - [Get apiv1projects custom metrics](https://lightdash-docs-many-to-many.mintlify.site/api-reference/projects/get-apiv1projects-custom-metrics.md) - [Patch apiv1projects metadata](https://lightdash-docs-many-to-many.mintlify.site/api-reference/projects/patch-apiv1projects-metadata.md): Update project metadata like upstreamProjectUuid we don't trigger a compile, so not for updating warehouse or credentials - [Get apiv1projects dashboards](https://lightdash-docs-many-to-many.mintlify.site/api-reference/projects/get-apiv1projects-dashboards.md) - [Post apiv1projects dashboards](https://lightdash-docs-many-to-many.mintlify.site/api-reference/projects/post-apiv1projects-dashboards.md) - [Patch apiv1projects dashboards](https://lightdash-docs-many-to-many.mintlify.site/api-reference/projects/patch-apiv1projects-dashboards.md) - [Post apiv1projects createpreview](https://lightdash-docs-many-to-many.mintlify.site/api-reference/projects/post-apiv1projects-createpreview.md) - [Patch apiv1projects schedulersettings](https://lightdash-docs-many-to-many.mintlify.site/api-reference/projects/patch-apiv1projects-schedulersettings.md) - [Get apiv1projects tags](https://lightdash-docs-many-to-many.mintlify.site/api-reference/projects/get-apiv1projects-tags.md) - [Post apiv1projects tags](https://lightdash-docs-many-to-many.mintlify.site/api-reference/projects/post-apiv1projects-tags.md) - [Delete apiv1projects tags](https://lightdash-docs-many-to-many.mintlify.site/api-reference/projects/delete-apiv1projects-tags.md) - [Patch apiv1projects tags](https://lightdash-docs-many-to-many.mintlify.site/api-reference/projects/patch-apiv1projects-tags.md) - [Put apiv1projects tagsyaml](https://lightdash-docs-many-to-many.mintlify.site/api-reference/projects/put-apiv1projects-tagsyaml.md) - [Get apiv1projects chartscode](https://lightdash-docs-many-to-many.mintlify.site/api-reference/projects/get-apiv1projects-chartscode.md): Charts as code - [Get apiv1projects dashboardscode](https://lightdash-docs-many-to-many.mintlify.site/api-reference/projects/get-apiv1projects-dashboardscode.md) - [Post apiv1projects charts code](https://lightdash-docs-many-to-many.mintlify.site/api-reference/projects/post-apiv1projects-charts-code.md) - [Post apiv1projects dashboards code](https://lightdash-docs-many-to-many.mintlify.site/api-reference/projects/post-apiv1projects-dashboards-code.md) - [Post apiv1projects dbt cloudwebhook](https://lightdash-docs-many-to-many.mintlify.site/api-reference/projects/post-apiv1projects-dbt-cloudwebhook.md) - [Post apiv1projects refresh](https://lightdash-docs-many-to-many.mintlify.site/api-reference/projects/post-apiv1projects-refresh.md) - [Get apiv1projects explores](https://lightdash-docs-many-to-many.mintlify.site/api-reference/projects/get-apiv1projects-explores.md) - [Put apiv1projects explores](https://lightdash-docs-many-to-many.mintlify.site/api-reference/projects/put-apiv1projects-explores.md) - [Get apiv1projects explores 1](https://lightdash-docs-many-to-many.mintlify.site/api-reference/projects/get-apiv1projects-explores-1.md) - [Post apiv1projects explores compilequery](https://lightdash-docs-many-to-many.mintlify.site/api-reference/projects/post-apiv1projects-explores-compilequery.md) - [Post apiv1projects explores downloadcsv](https://lightdash-docs-many-to-many.mintlify.site/api-reference/projects/post-apiv1projects-explores-downloadcsv.md) - [Get apiv1bigqueryssodatasets](https://lightdash-docs-many-to-many.mintlify.site/api-reference/projects/get-apiv1bigqueryssodatasets.md) - [Get apiv1bigqueryssois authenticated](https://lightdash-docs-many-to-many.mintlify.site/api-reference/projects/get-apiv1bigqueryssois-authenticated.md) - [Get apiv1user](https://lightdash-docs-many-to-many.mintlify.site/api-reference/my-account/get-apiv1user.md): Get authenticated user - [Post apiv1user](https://lightdash-docs-many-to-many.mintlify.site/api-reference/my-account/post-apiv1user.md): Register user - [Put apiv1usermeemailotp](https://lightdash-docs-many-to-many.mintlify.site/api-reference/my-account/put-apiv1usermeemailotp.md): Create a new one-time passcode for the current user's primary email. The user will receive an email with the passcode. - [Get apiv1usermeemailstatus](https://lightdash-docs-many-to-many.mintlify.site/api-reference/my-account/get-apiv1usermeemailstatus.md): Get the verification status for the current user's primary email - [Get apiv1usermeallowedorganizations](https://lightdash-docs-many-to-many.mintlify.site/api-reference/my-account/get-apiv1usermeallowedorganizations.md): List the organizations that the current user can join. This is based on the user's primary email domain and the organization's allowed email domains. - [Post apiv1usermejoinorganization](https://lightdash-docs-many-to-many.mintlify.site/api-reference/my-account/post-apiv1usermejoinorganization.md): Add the current user to an organization that accepts users with a verified email domain. This will fail if the organization email domain does not match the user's primary email domain. - [Delete apiv1userme](https://lightdash-docs-many-to-many.mintlify.site/api-reference/my-account/delete-apiv1userme.md): Delete user - [Get apiv1userwarehousecredentials](https://lightdash-docs-many-to-many.mintlify.site/api-reference/my-account/get-apiv1userwarehousecredentials.md): Get user warehouse credentials - [Post apiv1userwarehousecredentials](https://lightdash-docs-many-to-many.mintlify.site/api-reference/my-account/post-apiv1userwarehousecredentials.md): Create user warehouse credentials - [Delete apiv1userwarehousecredentials](https://lightdash-docs-many-to-many.mintlify.site/api-reference/my-account/delete-apiv1userwarehousecredentials.md): Delete user warehouse credentials - [Patch apiv1userwarehousecredentials](https://lightdash-docs-many-to-many.mintlify.site/api-reference/my-account/patch-apiv1userwarehousecredentials.md): Update user warehouse credentials - [Get apiv1userlogin options](https://lightdash-docs-many-to-many.mintlify.site/api-reference/my-account/get-apiv1userlogin-options.md): Get login options - [Get apiv1usermepersonal access tokens](https://lightdash-docs-many-to-many.mintlify.site/api-reference/my-account/get-apiv1usermepersonal-access-tokens.md): List personal access tokens - [Post apiv1usermepersonal access tokens](https://lightdash-docs-many-to-many.mintlify.site/api-reference/my-account/post-apiv1usermepersonal-access-tokens.md): Create personal access token - [Delete apiv1usermepersonal access tokens](https://lightdash-docs-many-to-many.mintlify.site/api-reference/my-account/delete-apiv1usermepersonal-access-tokens.md): Delete personal access token - [Patch apiv1usermepersonal access tokens rotate](https://lightdash-docs-many-to-many.mintlify.site/api-reference/my-account/patch-apiv1usermepersonal-access-tokens-rotate.md): Rotate personal access token - [Get apiv1useraccount](https://lightdash-docs-many-to-many.mintlify.site/api-reference/my-account/get-apiv1useraccount.md): Get account information - [Get apiv1orgattributes](https://lightdash-docs-many-to-many.mintlify.site/api-reference/user-attributes/get-apiv1orgattributes.md): Get all user attributes - [Post apiv1orgattributes](https://lightdash-docs-many-to-many.mintlify.site/api-reference/user-attributes/post-apiv1orgattributes.md): Creates new user attribute - [Put apiv1orgattributes](https://lightdash-docs-many-to-many.mintlify.site/api-reference/user-attributes/put-apiv1orgattributes.md): Updates a user attribute - [Delete apiv1orgattributes](https://lightdash-docs-many-to-many.mintlify.site/api-reference/user-attributes/delete-apiv1orgattributes.md): Remove a user attribute - [Post apiv1sshkey pairs](https://lightdash-docs-many-to-many.mintlify.site/api-reference/ssh-keypairs/post-apiv1sshkey-pairs.md) - [Get apiv1projects sqlrunnertables](https://lightdash-docs-many-to-many.mintlify.site/api-reference/sql-runner/get-apiv1projects-sqlrunnertables.md) - [Get apiv1projects sqlrunnerfields](https://lightdash-docs-many-to-many.mintlify.site/api-reference/sql-runner/get-apiv1projects-sqlrunnerfields.md) - [Post apiv1projects sqlrunnerrun](https://lightdash-docs-many-to-many.mintlify.site/api-reference/sql-runner/post-apiv1projects-sqlrunnerrun.md) - [Post apiv1projects sqlrunnerrunpivotquery](https://lightdash-docs-many-to-many.mintlify.site/api-reference/sql-runner/post-apiv1projects-sqlrunnerrunpivotquery.md) - [Get apiv1projects sqlrunnerresults](https://lightdash-docs-many-to-many.mintlify.site/api-reference/sql-runner/get-apiv1projects-sqlrunnerresults.md): Get results from a file stored locally - [Get apiv1projects sqlrunnersaved](https://lightdash-docs-many-to-many.mintlify.site/api-reference/sql-runner/get-apiv1projects-sqlrunnersaved.md): Get saved sql chart - [Delete apiv1projects sqlrunnersaved](https://lightdash-docs-many-to-many.mintlify.site/api-reference/sql-runner/delete-apiv1projects-sqlrunnersaved.md): Delete sql chart - [Patch apiv1projects sqlrunnersaved](https://lightdash-docs-many-to-many.mintlify.site/api-reference/sql-runner/patch-apiv1projects-sqlrunnersaved.md): Update sql chart - [Get apiv1projects sqlrunnersavedslug](https://lightdash-docs-many-to-many.mintlify.site/api-reference/sql-runner/get-apiv1projects-sqlrunnersavedslug.md): Get saved sql chart - [Get apiv1projects sqlrunnersavedslug results job](https://lightdash-docs-many-to-many.mintlify.site/api-reference/sql-runner/get-apiv1projects-sqlrunnersavedslug-results-job.md): Schedules a job to get its results - [Get apiv1projects sqlrunnersaved results job](https://lightdash-docs-many-to-many.mintlify.site/api-reference/sql-runner/get-apiv1projects-sqlrunnersaved-results-job.md): Schedules a job to get its results - [Post apiv1projects sqlrunnersaved](https://lightdash-docs-many-to-many.mintlify.site/api-reference/sql-runner/post-apiv1projects-sqlrunnersaved.md): Create sql chart - [Post apiv1projects sqlrunnerrefresh catalog](https://lightdash-docs-many-to-many.mintlify.site/api-reference/sql-runner/post-apiv1projects-sqlrunnerrefresh-catalog.md): Refresh the catalog cache - [Post apiv1projects sqlrunnervirtual view](https://lightdash-docs-many-to-many.mintlify.site/api-reference/sql-runner/post-apiv1projects-sqlrunnervirtual-view.md): Create a virtual-view - [Put apiv1projects sqlrunnervirtual view](https://lightdash-docs-many-to-many.mintlify.site/api-reference/sql-runner/put-apiv1projects-sqlrunnervirtual-view.md) - [Delete apiv1projects sqlrunnervirtual view](https://lightdash-docs-many-to-many.mintlify.site/api-reference/sql-runner/delete-apiv1projects-sqlrunnervirtual-view.md): Delete a virtual-view - [Post apiv1projects sqlrunnerpreview](https://lightdash-docs-many-to-many.mintlify.site/api-reference/sql-runner/post-apiv1projects-sqlrunnerpreview.md): Preview write back from SQL runner - [Post apiv1projects sqlrunnerpull request](https://lightdash-docs-many-to-many.mintlify.site/api-reference/sql-runner/post-apiv1projects-sqlrunnerpull-request.md): Write back from SQL runner - [Get apiv1projects spotlighttableconfig](https://lightdash-docs-many-to-many.mintlify.site/api-reference/spotlight/get-apiv1projects-spotlighttableconfig.md) - [Post apiv1projects spotlighttableconfig](https://lightdash-docs-many-to-many.mintlify.site/api-reference/spotlight/post-apiv1projects-spotlighttableconfig.md) - [Delete apiv1projects spotlighttableconfig](https://lightdash-docs-many-to-many.mintlify.site/api-reference/spotlight/delete-apiv1projects-spotlighttableconfig.md) - [Get apiv1projects spaces](https://lightdash-docs-many-to-many.mintlify.site/api-reference/spaces/get-apiv1projects-spaces.md): Get details for a space in a project - [Delete apiv1projects spaces](https://lightdash-docs-many-to-many.mintlify.site/api-reference/spaces/delete-apiv1projects-spaces.md): Delete a space from a project - [Patch apiv1projects spaces](https://lightdash-docs-many-to-many.mintlify.site/api-reference/roles-&-permissions/patch-apiv1projects-spaces.md): Update a space in a project - [Post apiv1projects spaces](https://lightdash-docs-many-to-many.mintlify.site/api-reference/roles-&-permissions/post-apiv1projects-spaces.md): Create a new space inside a project - [Post apiv1projects spaces share](https://lightdash-docs-many-to-many.mintlify.site/api-reference/roles-&-permissions/post-apiv1projects-spaces-share.md): Grant a user access to a space - [Delete apiv1projects spaces share](https://lightdash-docs-many-to-many.mintlify.site/api-reference/roles-&-permissions/delete-apiv1projects-spaces-share.md): Remove a user's access to a space - [Post apiv1projects spaces groupshare](https://lightdash-docs-many-to-many.mintlify.site/api-reference/roles-&-permissions/post-apiv1projects-spaces-groupshare.md): Grant a group access to a space - [Delete apiv1projects spaces groupshare](https://lightdash-docs-many-to-many.mintlify.site/api-reference/roles-&-permissions/delete-apiv1projects-spaces-groupshare.md): Remove a group's access to a space - [Get apiv1projects access](https://lightdash-docs-many-to-many.mintlify.site/api-reference/roles-&-permissions/get-apiv1projects-access.md): Get access list for a project. This is a list of users that have been explictly granted access to the project. There may be other users that have access to the project via their organization membership. - [Post apiv1projects access](https://lightdash-docs-many-to-many.mintlify.site/api-reference/roles-&-permissions/post-apiv1projects-access.md): Grant a user access to a project - [Get apiv1projects user](https://lightdash-docs-many-to-many.mintlify.site/api-reference/roles-&-permissions/get-apiv1projects-user.md): Get a project explicit member's access. There may be users that have access to the project via their organization membership. - [Delete apiv1projects access](https://lightdash-docs-many-to-many.mintlify.site/api-reference/roles-&-permissions/delete-apiv1projects-access.md): Remove a user's access to a project - [Patch apiv1projects access](https://lightdash-docs-many-to-many.mintlify.site/api-reference/roles-&-permissions/patch-apiv1projects-access.md): Update a user's access to a project - [Patch apiv1orgusers](https://lightdash-docs-many-to-many.mintlify.site/api-reference/roles-&-permissions/patch-apiv1orgusers.md): Updates the membership profile for a user in the current user's organization - [Get apiv1slackchannels](https://lightdash-docs-many-to-many.mintlify.site/api-reference/integrations/get-apiv1slackchannels.md): Get slack channels - [Put apiv1slackcustom settings](https://lightdash-docs-many-to-many.mintlify.site/api-reference/integrations/put-apiv1slackcustom-settings.md): Update slack notification channel to send notifications to scheduled jobs fail - [Get apiv1slackis authenticated](https://lightdash-docs-many-to-many.mintlify.site/api-reference/integrations/get-apiv1slackis-authenticated.md): Check if the user has an OpenID identity for Slack - [Get apiv1slack](https://lightdash-docs-many-to-many.mintlify.site/api-reference/integrations/get-apiv1slack.md) - [Delete apiv1slack](https://lightdash-docs-many-to-many.mintlify.site/api-reference/integrations/delete-apiv1slack.md) - [Get apiv1slackimage](https://lightdash-docs-many-to-many.mintlify.site/api-reference/integrations/get-apiv1slackimage.md) - [Get apiv1slackinstall](https://lightdash-docs-many-to-many.mintlify.site/api-reference/integrations/get-apiv1slackinstall.md) - [Get apiv1gdriveget access token](https://lightdash-docs-many-to-many.mintlify.site/api-reference/integrations/get-apiv1gdriveget-access-token.md): Get access token for google drive - [Post apiv1gdriveupload gsheet](https://lightdash-docs-many-to-many.mintlify.site/api-reference/integrations/post-apiv1gdriveupload-gsheet.md): Upload results from query to Google Sheet - [Get apiv1share](https://lightdash-docs-many-to-many.mintlify.site/api-reference/share-links/get-apiv1share.md): Get a share url from a short url id - [Post apiv1share](https://lightdash-docs-many-to-many.mintlify.site/api-reference/share-links/post-apiv1share.md): Given a full URL generates a short url id that can be used for sharing - [Get apiv1schedulers logs](https://lightdash-docs-many-to-many.mintlify.site/api-reference/schedulers/get-apiv1schedulers-logs.md): Get scheduled logs - [Get apiv1schedulers list](https://lightdash-docs-many-to-many.mintlify.site/api-reference/schedulers/get-apiv1schedulers-list.md): List all schedulers with pagination, search, and sorting - [Get apiv1schedulers](https://lightdash-docs-many-to-many.mintlify.site/api-reference/schedulers/get-apiv1schedulers.md): Get a scheduler - [Delete apiv1schedulers](https://lightdash-docs-many-to-many.mintlify.site/api-reference/schedulers/delete-apiv1schedulers.md): Delete a scheduler - [Patch apiv1schedulers](https://lightdash-docs-many-to-many.mintlify.site/api-reference/schedulers/patch-apiv1schedulers.md): Update a scheduler - [Patch apiv1schedulers enabled](https://lightdash-docs-many-to-many.mintlify.site/api-reference/schedulers/patch-apiv1schedulers-enabled.md): Set scheduler enabled - [Get apiv1schedulers jobs](https://lightdash-docs-many-to-many.mintlify.site/api-reference/schedulers/get-apiv1schedulers-jobs.md): Get scheduled jobs - [Get apiv1schedulersjob status](https://lightdash-docs-many-to-many.mintlify.site/api-reference/schedulers/get-apiv1schedulersjob-status.md): Get a generic job status This method can be used when polling from the frontend - [Post apiv1schedulerssend](https://lightdash-docs-many-to-many.mintlify.site/api-reference/schedulers/post-apiv1schedulerssend.md): Send a scheduler now before saving it - [Post apiv1projects explores rununderlyingdataquery](https://lightdash-docs-many-to-many.mintlify.site/api-reference/exploring/post-apiv1projects-explores-rununderlyingdataquery.md): Run a query for underlying data results - [Post apiv1projects explores runquery](https://lightdash-docs-many-to-many.mintlify.site/api-reference/exploring/post-apiv1projects-explores-runquery.md): Run a query for explore - [Post apiv1projects sqlquery](https://lightdash-docs-many-to-many.mintlify.site/api-reference/exploring/post-apiv1projects-sqlquery.md): Run a raw sql query against the project's warehouse connection - [Post apiv1saved results](https://lightdash-docs-many-to-many.mintlify.site/api-reference/charts/post-apiv1saved-results.md): Run a query for a chart - [Post apiv1saved chart and results](https://lightdash-docs-many-to-many.mintlify.site/api-reference/charts/post-apiv1saved-chart-and-results.md) - [Get apiv1saved history](https://lightdash-docs-many-to-many.mintlify.site/api-reference/charts/get-apiv1saved-history.md): Get chart version history from last 30 days - [Get apiv1saved version](https://lightdash-docs-many-to-many.mintlify.site/api-reference/charts/get-apiv1saved-version.md): Get chart version - [Post apiv1saved version results](https://lightdash-docs-many-to-many.mintlify.site/api-reference/charts/post-apiv1saved-version-results.md): Run a query for a chart version - [Post apiv1saved rollback](https://lightdash-docs-many-to-many.mintlify.site/api-reference/charts/post-apiv1saved-rollback.md): Rollback chart to version - [Post apiv1saved calculate total](https://lightdash-docs-many-to-many.mintlify.site/api-reference/charts/post-apiv1saved-calculate-total.md): Calculate metric totals from a saved chart - [Post apiv1saved promote](https://lightdash-docs-many-to-many.mintlify.site/api-reference/charts/post-apiv1saved-promote.md): Promote chart to its upstream project - [Get apiv1saved promotediff](https://lightdash-docs-many-to-many.mintlify.site/api-reference/charts/get-apiv1saved-promotediff.md): Get diff from chart to promote - [Post apiv1saved downloadcsv](https://lightdash-docs-many-to-many.mintlify.site/api-reference/charts/post-apiv1saved-downloadcsv.md): Download a CSV from a saved chart uuid - [Get apiv1projects pinned lists items](https://lightdash-docs-many-to-many.mintlify.site/api-reference/content/get-apiv1projects-pinned-lists-items.md): Get pinned items - [Patch apiv1projects pinned lists itemsorder](https://lightdash-docs-many-to-many.mintlify.site/api-reference/content/patch-apiv1projects-pinned-lists-itemsorder.md): Update pinned items order - [Post apiv2content move](https://lightdash-docs-many-to-many.mintlify.site/api-reference/content/post-apiv2content-move.md): Move a single item (Chart, Dashboard, Space) to another space - [Post apiv2contentbulk action move](https://lightdash-docs-many-to-many.mintlify.site/api-reference/content/post-apiv2contentbulk-action-move.md): Move multiple items (Charts, Dashboards, Spaces) to another space - [Get apiv1org](https://lightdash-docs-many-to-many.mintlify.site/api-reference/organizations/get-apiv1org.md): Get the current user's organization - [Put apiv1org](https://lightdash-docs-many-to-many.mintlify.site/api-reference/organizations/put-apiv1org.md): Creates a new organization, the current user becomes the Admin of the new organization. This is only available to users that are not already in an organization. - [Patch apiv1org](https://lightdash-docs-many-to-many.mintlify.site/api-reference/organizations/patch-apiv1org.md): Update the current user's organization - [Delete apiv1org](https://lightdash-docs-many-to-many.mintlify.site/api-reference/organizations/delete-apiv1org.md): Deletes an organization and all users inside that organization - [Get apiv1orgprojects](https://lightdash-docs-many-to-many.mintlify.site/api-reference/organizations/get-apiv1orgprojects.md): Gets all projects of the current user's organization - [Post apiv1orgprojects](https://lightdash-docs-many-to-many.mintlify.site/api-reference/organizations/post-apiv1orgprojects.md) - [Get apiv1orgusers](https://lightdash-docs-many-to-many.mintlify.site/api-reference/organizations/get-apiv1orgusers.md): Gets all the members of the current user's organization - [Get apiv1orgusers 1](https://lightdash-docs-many-to-many.mintlify.site/api-reference/organizations/get-apiv1orgusers-1.md): Get the member profile for a user in the current user's organization by uuid - [Get apiv1orgusersemail](https://lightdash-docs-many-to-many.mintlify.site/api-reference/organizations/get-apiv1orgusersemail.md): Get the member profile for a user in the current user's organization by email - [Delete apiv1orguser](https://lightdash-docs-many-to-many.mintlify.site/api-reference/organizations/delete-apiv1orguser.md): Deletes a user from the current user's organization - [Get apiv1orgallowedemaildomains](https://lightdash-docs-many-to-many.mintlify.site/api-reference/organizations/get-apiv1orgallowedemaildomains.md): Gets the allowed email domains for the current user's organization - [Patch apiv1orgallowedemaildomains](https://lightdash-docs-many-to-many.mintlify.site/api-reference/organizations/patch-apiv1orgallowedemaildomains.md): Updates the allowed email domains for the current user's organization - [Get apiv1orggroups](https://lightdash-docs-many-to-many.mintlify.site/api-reference/organizations/get-apiv1orggroups.md): Gets all the groups in the current user's organization - [Post apiv1orggroups](https://lightdash-docs-many-to-many.mintlify.site/api-reference/organizations/post-apiv1orggroups.md): Creates a new group in the current user's organization - [Get apiv1orgcolor palettes](https://lightdash-docs-many-to-many.mintlify.site/api-reference/organizations/get-apiv1orgcolor-palettes.md) - [Post apiv1orgcolor palettes](https://lightdash-docs-many-to-many.mintlify.site/api-reference/organizations/post-apiv1orgcolor-palettes.md) - [Delete apiv1orgcolor palettes](https://lightdash-docs-many-to-many.mintlify.site/api-reference/organizations/delete-apiv1orgcolor-palettes.md) - [Patch apiv1orgcolor palettes](https://lightdash-docs-many-to-many.mintlify.site/api-reference/organizations/patch-apiv1orgcolor-palettes.md) - [Post apiv1orgcolor palettes active](https://lightdash-docs-many-to-many.mintlify.site/api-reference/organizations/post-apiv1orgcolor-palettes-active.md) - [Get apiv1notifications](https://lightdash-docs-many-to-many.mintlify.site/api-reference/notifications/get-apiv1notifications.md): Gets notifications for a user based on the type - [Patch apiv1notifications](https://lightdash-docs-many-to-many.mintlify.site/api-reference/notifications/patch-apiv1notifications.md): Update notification - [Post apiv1projects metricsexplorer runmetricexplorerquery](https://lightdash-docs-many-to-many.mintlify.site/api-reference/metrics-explorer/post-apiv1projects-metricsexplorer-runmetricexplorerquery.md): Run a metrics explorer query - [Post apiv1projects metricsexplorer runmetrictotal](https://lightdash-docs-many-to-many.mintlify.site/api-reference/metrics-explorer/post-apiv1projects-metricsexplorer-runmetrictotal.md) - [Get apiv1groups](https://lightdash-docs-many-to-many.mintlify.site/api-reference/user-groups/get-apiv1groups.md): Get group details - [Delete apiv1groups](https://lightdash-docs-many-to-many.mintlify.site/api-reference/user-groups/delete-apiv1groups.md): Delete a group - [Patch apiv1groups](https://lightdash-docs-many-to-many.mintlify.site/api-reference/user-groups/patch-apiv1groups.md): Update a group - [Put apiv1groups members](https://lightdash-docs-many-to-many.mintlify.site/api-reference/user-groups/put-apiv1groups-members.md): Add a Lightdash user to a group - [Delete apiv1groups members](https://lightdash-docs-many-to-many.mintlify.site/api-reference/user-groups/delete-apiv1groups-members.md): Remove a user from a group - [Get apiv1groups members](https://lightdash-docs-many-to-many.mintlify.site/api-reference/user-groups/get-apiv1groups-members.md): View members of a group - [Post apiv1groups projects](https://lightdash-docs-many-to-many.mintlify.site/api-reference/user-groups/post-apiv1groups-projects.md): Add project access to a group - [Delete apiv1groups projects](https://lightdash-docs-many-to-many.mintlify.site/api-reference/user-groups/delete-apiv1groups-projects.md): Remove project access from a group - [Patch apiv1groups projects](https://lightdash-docs-many-to-many.mintlify.site/api-reference/user-groups/patch-apiv1groups-projects.md): Update project access for a group - [Get apiv1githubinstall](https://lightdash-docs-many-to-many.mintlify.site/api-reference/get-apiv1githubinstall.md): Install the Lightdash GitHub App and link to an organization - [Get apiv1githubconfig](https://lightdash-docs-many-to-many.mintlify.site/api-reference/get-apiv1githubconfig.md) - [Get apiv1githuboauthcallback](https://lightdash-docs-many-to-many.mintlify.site/api-reference/get-apiv1githuboauthcallback.md): Callback URL for GitHub App Authorization also used for GitHub App Installation with combined Authorization - [Delete apiv1githubuninstall](https://lightdash-docs-many-to-many.mintlify.site/api-reference/delete-apiv1githubuninstall.md) - [Get apiv1githubreposlist](https://lightdash-docs-many-to-many.mintlify.site/api-reference/get-apiv1githubreposlist.md) - [Post apiv1projects git integrationpull requestscustom metrics](https://lightdash-docs-many-to-many.mintlify.site/api-reference/git-integration/post-apiv1projects-git-integrationpull-requestscustom-metrics.md) - [Post apiv1projects git integrationpull requestscustom dimensions](https://lightdash-docs-many-to-many.mintlify.site/api-reference/git-integration/post-apiv1projects-git-integrationpull-requestscustom-dimensions.md) - [Post apiv1dashboards promote](https://lightdash-docs-many-to-many.mintlify.site/api-reference/dashboards/post-apiv1dashboards-promote.md): Promote dashboard to its upstream project - [Get apiv1dashboards promotediff](https://lightdash-docs-many-to-many.mintlify.site/api-reference/dashboards/get-apiv1dashboards-promotediff.md): Get diff from dashboard to promote - [Get apiv1csv](https://lightdash-docs-many-to-many.mintlify.site/api-reference/exports/get-apiv1csv.md): Get a Csv - [Post apiv1commentsdashboards ](https://lightdash-docs-many-to-many.mintlify.site/api-reference/comments/post-apiv1commentsdashboards-.md): Creates a comment on a dashboard tile - [Get apiv1commentsdashboards](https://lightdash-docs-many-to-many.mintlify.site/api-reference/comments/get-apiv1commentsdashboards.md): Gets all comments for a dashboard - [Delete apiv1commentsdashboards ](https://lightdash-docs-many-to-many.mintlify.site/api-reference/comments/delete-apiv1commentsdashboards-.md): Deletes a comment on a dashboard - [Patch apiv1commentsdashboards ](https://lightdash-docs-many-to-many.mintlify.site/api-reference/comments/patch-apiv1commentsdashboards-.md): Resolves a comment on a dashboard - [Get apiv1projects datacatalog](https://lightdash-docs-many-to-many.mintlify.site/api-reference/catalog/get-apiv1projects-datacatalog.md): Get catalog items - [Get apiv1projects datacatalog metadata](https://lightdash-docs-many-to-many.mintlify.site/api-reference/catalog/get-apiv1projects-datacatalog-metadata.md): Get catalog metadata for tables - [Get apiv1projects datacatalog analytics](https://lightdash-docs-many-to-many.mintlify.site/api-reference/catalog/get-apiv1projects-datacatalog-analytics.md): Get catalog analytics for tables - [Get apiv1projects datacatalog analytics 1](https://lightdash-docs-many-to-many.mintlify.site/api-reference/catalog/get-apiv1projects-datacatalog-analytics-1.md): Get catalog analytics for fields - [Get apiv1projects datacatalogmetrics](https://lightdash-docs-many-to-many.mintlify.site/api-reference/catalog/get-apiv1projects-datacatalogmetrics.md): Get metrics catalog - [Get apiv1projects datacatalogmetrics ](https://lightdash-docs-many-to-many.mintlify.site/api-reference/catalog/get-apiv1projects-datacatalogmetrics-.md): Get metric by table and metric name - [Get apiv1projects datacatalogmetrics with time dimensions](https://lightdash-docs-many-to-many.mintlify.site/api-reference/catalog/get-apiv1projects-datacatalogmetrics-with-time-dimensions.md): Get metrics with time dimensions - [Get apiv1projects datacatalog segment dimensions](https://lightdash-docs-many-to-many.mintlify.site/api-reference/catalog/get-apiv1projects-datacatalog-segment-dimensions.md): Get dimensions that can be used to segment metrics - [Post apiv1projects datacatalog categories](https://lightdash-docs-many-to-many.mintlify.site/api-reference/catalog/post-apiv1projects-datacatalog-categories.md) - [Delete apiv1projects datacatalog categories](https://lightdash-docs-many-to-many.mintlify.site/api-reference/catalog/delete-apiv1projects-datacatalog-categories.md) - [Patch apiv1projects datacatalog icon](https://lightdash-docs-many-to-many.mintlify.site/api-reference/catalog/patch-apiv1projects-datacatalog-icon.md) - [Get apiv1projects datacatalogmetricstree](https://lightdash-docs-many-to-many.mintlify.site/api-reference/catalog/get-apiv1projects-datacatalogmetricstree.md) - [Post apiv1projects datacatalogmetricstreeedges](https://lightdash-docs-many-to-many.mintlify.site/api-reference/catalog/post-apiv1projects-datacatalogmetricstreeedges.md) - [Delete apiv1projects datacatalogmetricstreeedges ](https://lightdash-docs-many-to-many.mintlify.site/api-reference/catalog/delete-apiv1projects-datacatalogmetricstreeedges-.md) - [Get apiv1projects datacatalogmetricshas](https://lightdash-docs-many-to-many.mintlify.site/api-reference/catalog/get-apiv1projects-datacatalogmetricshas.md): Check if there are any metrics in catalog - [Get results](https://lightdash-docs-many-to-many.mintlify.site/api-reference/query/get-results.md): Retrieves paginated results from a previously executed async query using its UUID - [Cancel query](https://lightdash-docs-many-to-many.mintlify.site/api-reference/query/cancel-query.md): Cancels a running async query and discards any partial results - [Execute metric query](https://lightdash-docs-many-to-many.mintlify.site/api-reference/query/execute-metric-query.md): Executes a metric query asynchronously against your data warehouse using dimensions, metrics, filters, and sorts - [Execute saved chart](https://lightdash-docs-many-to-many.mintlify.site/api-reference/query/execute-saved-chart.md): Executes a saved chart query asynchronously with optional parameter overrides - [Execute dashboard chart](https://lightdash-docs-many-to-many.mintlify.site/api-reference/query/execute-dashboard-chart.md): Executes a chart within a dashboard context asynchronously with inherited dashboard filters - [Execute underlying data](https://lightdash-docs-many-to-many.mintlify.site/api-reference/query/execute-underlying-data.md): Executes a query to retrieve underlying raw data for drilling down into aggregated values - [Execute SQL query](https://lightdash-docs-many-to-many.mintlify.site/api-reference/query/execute-sql-query.md): Executes a raw SQL query asynchronously against your data warehouse for custom queries - [Execute SQL chart](https://lightdash-docs-many-to-many.mintlify.site/api-reference/query/execute-sql-chart.md): Executes a saved SQL chart query asynchronously with optional chart configurations - [Execute dashboard SQL chart](https://lightdash-docs-many-to-many.mintlify.site/api-reference/query/execute-dashboard-sql-chart.md): Executes a SQL chart within a dashboard context asynchronously with inherited filters - [Download results](https://lightdash-docs-many-to-many.mintlify.site/api-reference/query/download-results.md): Downloads query results in various formats with custom formatting options - [Get apiv2projects parameters](https://lightdash-docs-many-to-many.mintlify.site/api-reference/v2/get-apiv2projects-parameters.md) - [Put apiv2projects parameters](https://lightdash-docs-many-to-many.mintlify.site/api-reference/v2/put-apiv2projects-parameters.md) - [Get apiv2feature flag](https://lightdash-docs-many-to-many.mintlify.site/api-reference/v2/get-apiv2feature-flag.md): Get feature flag - [Get apiv2content](https://lightdash-docs-many-to-many.mintlify.site/api-reference/v2/get-apiv2content.md): Get content (charts, dashboards, spaces) ## OpenAPI Specs - [swagger](https://raw.githubusercontent.com/lightdash/lightdash/refs/heads/main/packages/backend/src/generated/swagger.json) ## Optional - [About Us](https://www.lightdash.com/about) - [Community](https://join.slack.com/t/lightdash-community/shared_invite/zt-2wgtavou8-VRhwXI~QbjCAHQs0WBac3w) - [Blog](https://www.lightdash.com/blog)