# Lightdash

## Docs

- [Lightdash API](https://lightdash-friday-validation-demo.mintlify.app/api-reference/v1/introduction.md)
- [Recipes](https://lightdash-friday-validation-demo.mintlify.app/api-reference/v1/recipes.md): A collection of practical, copy-paste examples showing how to combine Lightdash API endpoints to achieve common workflows.
- [The Lightdash way: data access](https://lightdash-friday-validation-demo.mintlify.app/best-practice/lightdash-way.md): Our mission at Lightdash is to enable everybody in your company to answer their own questions using data.
- [Planning your dashboard: the Who, What and How of building great dashboards.](https://lightdash-friday-validation-demo.mintlify.app/best-practice/planning-your-dashboard.md): For those of you who are just getting started with building dashboards, it it can be useful to do some planning before you get your hands dirty and actually start building the thing.
- [Contact Us](https://lightdash-friday-validation-demo.mintlify.app/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:
- [FAQs](https://lightdash-friday-validation-demo.mintlify.app/contact/faqs.md)
- [Migrating to dbt 1.10: Fix Meta and Tags Configuration Warnings](https://lightdash-friday-validation-demo.mintlify.app/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-friday-validation-demo.mintlify.app/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.
- [Guide to package-lock.yml in dbt](https://lightdash-friday-validation-demo.mintlify.app/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.
- [Adding and managing Tables](https://lightdash-friday-validation-demo.mintlify.app/get-started/develop-in-lightdash/adding-tables-to-lightdash.md)
- [How to create dimensions](https://lightdash-friday-validation-demo.mintlify.app/get-started/develop-in-lightdash/how-to-create-dimensions.md)
- [How to create metrics](https://lightdash-friday-validation-demo.mintlify.app/get-started/develop-in-lightdash/how-to-create-metrics.md)
- [Developing in Lightdash](https://lightdash-friday-validation-demo.mintlify.app/get-started/develop-in-lightdash/intro.md): This guide is for people who are new to Lightdash and need to learn the developer workflow. We'll go over how to install and use the CLI, plus how to create metrics and dimensions.
- [Creating dashboards](https://lightdash-friday-validation-demo.mintlify.app/get-started/exploring-data/dashboards.md)
- [Exploring your content](https://lightdash-friday-validation-demo.mintlify.app/get-started/exploring-data/exploring-your-content.md)
- [Using dashboards](https://lightdash-friday-validation-demo.mintlify.app/get-started/exploring-data/interactive-dashboards.md)
- [Learning to explore data in Lightdash](https://lightdash-friday-validation-demo.mintlify.app/get-started/exploring-data/intro.md): This guide is for people who are new to Lightdash and want to learn the fundamentals of Lightdash: querying from tables, building charts and dashboards, and sharing with your team.
- [An intro to metrics and dimensions](https://lightdash-friday-validation-demo.mintlify.app/get-started/exploring-data/intro-metrics-dimensions.md)
- [Sharing with your team](https://lightdash-friday-validation-demo.mintlify.app/get-started/exploring-data/sharing-insights.md): It's time to share your hard work with the world!
- [Querying from tables and exploring your data](https://lightdash-friday-validation-demo.mintlify.app/get-started/exploring-data/using-explores.md)
- [Update your project connection](https://lightdash-friday-validation-demo.mintlify.app/get-started/setup-lightdash/connect-project.md)
- [Create your first project](https://lightdash-friday-validation-demo.mintlify.app/get-started/setup-lightdash/get-project-lightdash-ready.md)
- [Setting up a new project](https://lightdash-friday-validation-demo.mintlify.app/get-started/setup-lightdash/intro.md): This guide 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, connect your database and dbt project, and invite your team.
- [Inviting teammates to your Lightdash project](https://lightdash-friday-validation-demo.mintlify.app/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.
- [AI agents](https://lightdash-friday-validation-demo.mintlify.app/guides/ai-agents.md): No code, no complex tools, just type what you want to know. AI Agents use your saved dashboards and the metrics you've defined in Lightdash semantic layer, so your whole team can find answers faster.
- [Agent memory](https://lightdash-friday-validation-demo.mintlify.app/guides/ai-agents/agent-memory.md): How AI agents learn from your corrections and feedback
- [Best practices for AI agents](https://lightdash-friday-validation-demo.mintlify.app/guides/ai-agents/best-practices.md): Learn how to configure and optimize your AI agents for the best results
- [Data access control](https://lightdash-friday-validation-demo.mintlify.app/guides/ai-agents/data-access.md): Understand how AI agents access and use your data
- [Evaluations](https://lightdash-friday-validation-demo.mintlify.app/guides/ai-agents/evaluations.md): Test and validate your AI agent's performance with custom evaluation suites
- [Getting started with AI agents](https://lightdash-friday-validation-demo.mintlify.app/guides/ai-agents/getting-started.md): Learn how to create and configure your first AI agent in Lightdash
- [Self-improvement (Beta)](https://lightdash-friday-validation-demo.mintlify.app/guides/ai-agents/self-improvement.md): Enable AI agents to improve your semantic layer automatically
- [Using AI agents](https://lightdash-friday-validation-demo.mintlify.app/guides/ai-agents/using-ai-agents.md): Learn how to interact with AI agents in Lightdash and Slack
- [Verified Answers](https://lightdash-friday-validation-demo.mintlify.app/guides/ai-agents/verified-answers.md): Train your AI agent with high-quality examples for better, more consistent responses
- [Automate with CI/CD](https://lightdash-friday-validation-demo.mintlify.app/guides/cli/automate-cli-workflow.md): You can use Github actions or other CI/CD tools to automate the CLI workflow
- [Authenticating your CLI](https://lightdash-friday-validation-demo.mintlify.app/guides/cli/cli-authentication.md)
- [Autogenerate Lightdash-ready YAML files for your models](https://lightdash-friday-validation-demo.mintlify.app/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.
- [How to install the Lightdash CLI](https://lightdash-friday-validation-demo.mintlify.app/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.
- [Upgrading your Lightdash CLI](https://lightdash-friday-validation-demo.mintlify.app/guides/cli/how-to-upgrade-cli.md)
- [Deploy changes to production](https://lightdash-friday-validation-demo.mintlify.app/guides/cli/how-to-use-lightdash-deploy.md)
- [Preview local changes](https://lightdash-friday-validation-demo.mintlify.app/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.
- [Lightdash Validate](https://lightdash-friday-validation-demo.mintlify.app/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.
- [Configure your charts](https://lightdash-friday-validation-demo.mintlify.app/guides/configure-charts.md): Learn about the configuration options available for most chart types in Lightdash.
- [Using custom fields](https://lightdash-friday-validation-demo.mintlify.app/guides/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-friday-validation-demo.mintlify.app/guides/custom-tooltip.md)
- [Caching](https://lightdash-friday-validation-demo.mintlify.app/guides/developer/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.
- [Test changes with Lightdash compile](https://lightdash-friday-validation-demo.mintlify.app/guides/developer/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.
- [Dashboards as code](https://lightdash-friday-validation-demo.mintlify.app/guides/developer/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.
- [dbt model best practices for Lightdash](https://lightdash-friday-validation-demo.mintlify.app/guides/developer/dbt-model-best-practices.md): Learn how to structure your dbt models for optimal performance and usability in Lightdash.
- [dbt write-back](https://lightdash-friday-validation-demo.mintlify.app/guides/developer/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.
- [Creating tailored tables from a single dbt model](https://lightdash-friday-validation-demo.mintlify.app/guides/developer/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.
- [How to filter a dashboard in the URL](https://lightdash-friday-validation-demo.mintlify.app/guides/developer/filtering-dashboard-in-url.md)
- [Preview projects](https://lightdash-friday-validation-demo.mintlify.app/guides/developer/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.
- [Renaming models, metrics, and dimensions](https://lightdash-friday-validation-demo.mintlify.app/guides/developer/renaming-models-and-fields.md)
- [SQL runner](https://lightdash-friday-validation-demo.mintlify.app/guides/developer/sql-runner.md): The SQL runner is used to build ad-hoc queries or charts using totally custom SQL.
- [How to use parameters](https://lightdash-friday-validation-demo.mintlify.app/guides/developer/using-parameters.md)
- [Validating your content](https://lightdash-friday-validation-demo.mintlify.app/guides/developer/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.
- [Virtual views](https://lightdash-friday-validation-demo.mintlify.app/guides/developer/virtual-views.md): 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.
- [How to set up Lightdash YAML validation for VS Code](https://lightdash-friday-validation-demo.mintlify.app/guides/developer/vs-code-yaml-validation.md)
- [How to Embed Charts](https://lightdash-friday-validation-demo.mintlify.app/guides/embedding/charts.md): Learn how to embed individual Lightdash charts with minimal UI for focused, single-metric displays
- [How to Embed Dashboards](https://lightdash-friday-validation-demo.mintlify.app/guides/embedding/dashboards.md): Complete guide to embedding Lightdash dashboards with full configuration options for both iframe and React SDK methods
- [How to embed content](https://lightdash-friday-validation-demo.mintlify.app/guides/embedding/how-to-embed-content.md): Lightdash allows you to embed your content using expirable URLs and tokens. 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.
- [Filters reference](https://lightdash-friday-validation-demo.mintlify.app/guides/filters.md): Filters appear at the top of the Explore view and allow users to change the data being pulled in.
- [Formatting your fields](https://lightdash-friday-validation-demo.mintlify.app/guides/formatting-your-fields.md)
- [Alerts](https://lightdash-friday-validation-demo.mintlify.app/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.
- [Scheduled deliveries](https://lightdash-friday-validation-demo.mintlify.app/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.
- [How to promote content](https://lightdash-friday-validation-demo.mintlify.app/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…
- [Keyboard shortcuts](https://lightdash-friday-validation-demo.mintlify.app/guides/keyboard-shortcuts.md): Speed up your workflow with keyboard shortcuts in Lightdash
- [Lightdash semantic layer](https://lightdash-friday-validation-demo.mintlify.app/guides/lightdash-semantic-layer.md): Here we explain everything you need to know about the Lightdash semantic layer: how it works, where you can use it, benefits, and challenges.
- [Using Filters](https://lightdash-friday-validation-demo.mintlify.app/guides/limiting-data-using-filters.md): Filters appear at the top of the Explore view or dashboard and allow users to change the data being pulled into your charts.
- [Spotlight](https://lightdash-friday-validation-demo.mintlify.app/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.
- [How to do period-over-period analysis in Lightdash](https://lightdash-friday-validation-demo.mintlify.app/guides/period-over-period.md): Learn how to do period-over-period analysis in Lightdash with examples and best practices.
- [Table calculations](https://lightdash-friday-validation-demo.mintlify.app/guides/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-friday-validation-demo.mintlify.app/guides/table-calculations/sql-templates.md): Use our SQL templates to get started with your table calculations!
- [Percent change from previous](https://lightdash-friday-validation-demo.mintlify.app/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 group/pivot total](https://lightdash-friday-validation-demo.mintlify.app/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.
- [Percent of previous value](https://lightdash-friday-validation-demo.mintlify.app/guides/table-calculations/table-calculation-sql-templates/percent-of-previous-value.md)
- [Percent of column total](https://lightdash-friday-validation-demo.mintlify.app/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.
- [Rank in column](https://lightdash-friday-validation-demo.mintlify.app/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.
- [Rolling window](https://lightdash-friday-validation-demo.mintlify.app/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.
- [Running total](https://lightdash-friday-validation-demo.mintlify.app/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.
- [Using the Slack integration](https://lightdash-friday-validation-demo.mintlify.app/guides/using-slack-integration.md)
- [Chart version history](https://lightdash-friday-validation-demo.mintlify.app/guides/version-history.md): You can easily roll back to previous versions of charts in Lightdash.
- [Welcome to Lightdash](https://lightdash-friday-validation-demo.mintlify.app/introduction.md): Lightdash instantly turns your dbt project into a full-stack BI platform.
- [Lightdash Admin References](https://lightdash-friday-validation-demo.mintlify.app/references/admin.md): Below are reference docs for all admin functions and features in Lightdash.
- [Area chart](https://lightdash-friday-validation-demo.mintlify.app/references/chart-types/area-chart.md): Use area charts to show how values develop over time when the total is as important as its parts.
- [Bar chart](https://lightdash-friday-validation-demo.mintlify.app/references/chart-types/bar-chart.md): Use bar charts to compare things between different groups or track how a number changes over time.
- [Big value](https://lightdash-friday-validation-demo.mintlify.app/references/chart-types/big-value.md): Use big value charts to display a single value prominently.
- [Custom charts](https://lightdash-friday-validation-demo.mintlify.app/references/chart-types/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…
- [Funnel chart](https://lightdash-friday-validation-demo.mintlify.app/references/chart-types/funnel-chart.md): Use funnel charts to show pipeline performance, product conversion metrics, or any process with discrete stages.
- [Gauge](https://lightdash-friday-validation-demo.mintlify.app/references/chart-types/gauge.md): Use gauges to highlight a single value against a qualitative range, like performance against a target.
- [Horizontal bar chart](https://lightdash-friday-validation-demo.mintlify.app/references/chart-types/horizontal-bar-chart.md): Use horizontal bar charts when grouping by values with long labels or many possible values.
- [Line chart](https://lightdash-friday-validation-demo.mintlify.app/references/chart-types/line-chart.md): Use line charts to show changes in a number over a short or long period of time.
- [Map (Beta)](https://lightdash-friday-validation-demo.mintlify.app/references/chart-types/map.md): Use maps to display geographic data on an interactive map.
- [Mixed chart](https://lightdash-friday-validation-demo.mintlify.app/references/chart-types/mixed-chart.md): Use mixed charts to combine bars, lines, and scatter charts on the same visualization.
- [Chart types overview](https://lightdash-friday-validation-demo.mintlify.app/references/chart-types/overview.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.
- [Pie chart](https://lightdash-friday-validation-demo.mintlify.app/references/chart-types/pie-chart.md): Use pie charts to visualize data that adds up to a meaningful whole.
- [Scatter chart](https://lightdash-friday-validation-demo.mintlify.app/references/chart-types/scatter-chart.md): Use scatter charts to look at the relationship or correlation between two variables.
- [Table](https://lightdash-friday-validation-demo.mintlify.app/references/chart-types/table.md): Use tables for looking at tabular data or lists of things like user IDs or transactions.
- [Treemap chart](https://lightdash-friday-validation-demo.mintlify.app/references/chart-types/treemap-chart.md): Use treemap charts to show parts of a whole using nested rectangles.
- [Dimensions reference](https://lightdash-friday-validation-demo.mintlify.app/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.
- [Embedding reference](https://lightdash-friday-validation-demo.mintlify.app/references/embedding.md): Complete API reference for embedding Lightdash content securely using JWTs
- [Embedding with iframe](https://lightdash-friday-validation-demo.mintlify.app/references/iframe-embedding.md): Complete reference for embedding Lightdash content using iframes with JWTs in URL hash fragments
- [Lightdash Integration Reference Docs](https://lightdash-friday-validation-demo.mintlify.app/references/integrations.md): Reference docs for all integrations available on Lightdash.
- [dbt Projects](https://lightdash-friday-validation-demo.mintlify.app/references/integrations/dbt-projects.md): You can easily make changes in dbt and see them updated in your Lightdash project.
- [Google Sheets](https://lightdash-friday-validation-demo.mintlify.app/references/integrations/google-sheets.md): Syncs let you send your chart results to a Google Sheet in your Google Drive on a schedule.
- [Lightdash MCP](https://lightdash-friday-validation-demo.mintlify.app/references/integrations/lightdash-mcp.md)
- [Slack integration](https://lightdash-friday-validation-demo.mintlify.app/references/integrations/slack-integration.md): Below is everything you need to know about the Lightdash Slack integration.
- [Joins reference](https://lightdash-friday-validation-demo.mintlify.app/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-friday-validation-demo.mintlify.app/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.
- [lightdash.config.yml reference](https://lightdash-friday-validation-demo.mintlify.app/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.
- [Metrics reference](https://lightdash-friday-validation-demo.mintlify.app/references/metrics.md)
- [Organization credentials](https://lightdash-friday-validation-demo.mintlify.app/references/organization-credentials.md): Organization credentials allow admins to create reusable warehouse credentials at the organization level, making it easier for users to create projects securely.
- [Embedding with React SDK](https://lightdash-friday-validation-demo.mintlify.app/references/react-sdk.md): Reference documentation for the Lightdash React SDK for seamless embedding in React applications
- [SQL variables](https://lightdash-friday-validation-demo.mintlify.app/references/sql-variables.md): When writing SQL in your Lightdash models, you can use the following references to template your SQL and make it more reusable
- [Tables reference](https://lightdash-friday-validation-demo.mintlify.app/references/tables.md): You can run queries against the tables in your Lightdash project.
- [Add the Slack integration](https://lightdash-friday-validation-demo.mintlify.app/references/workspace/adding-slack-integration.md)
- [Custom Roles](https://lightdash-friday-validation-demo.mintlify.app/references/workspace/custom-roles.md): Custom roles allow you to create granular permission sets tailored to your organization's specific needs. With custom roles, you can define exactly which scopes (permissions) users should have, giving you fine-grained control over access to Lightdash features and resources.
- [Customizing the appearance of your project](https://lightdash-friday-validation-demo.mintlify.app/references/workspace/customizing-the-appearance-of-your-project.md)
- [Feature Maturity Levels](https://lightdash-friday-validation-demo.mintlify.app/references/workspace/feature-maturity-levels.md): We use standardized maturity levels to help you understand the stability and availability of features as we develop them
- [Groups](https://lightdash-friday-validation-demo.mintlify.app/references/workspace/groups.md): Groups are a way to manage access to multiple users at the same time. A user can belong to multiple groups.
- [Creating multiple projects](https://lightdash-friday-validation-demo.mintlify.app/references/workspace/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.)
- [Personal access tokens](https://lightdash-friday-validation-demo.mintlify.app/references/workspace/personal-tokens.md)
- [Personal warehouse connections](https://lightdash-friday-validation-demo.mintlify.app/references/workspace/personal-warehouse-connections.md): Learn when and how personal warehouse credentials are used in Lightdash projects.
- [Pinning](https://lightdash-friday-validation-demo.mintlify.app/references/workspace/pinning.md)
- [Project compilation history](https://lightdash-friday-validation-demo.mintlify.app/references/workspace/project-compilation-history.md): View the history of your project compilations to track changes, monitor deployments, and troubleshoot compilation issues.
- [Roles and permissions](https://lightdash-friday-validation-demo.mintlify.app/references/workspace/roles.md)
- [SCIM Integration](https://lightdash-friday-validation-demo.mintlify.app/references/workspace/scim-integration.md)
- [Service accounts](https://lightdash-friday-validation-demo.mintlify.app/references/workspace/service-accounts.md): Service accounts provide a userless alternative to Personal Access Tokens (PATs) when working with the Lightdash CLI or the API. They are created and managed at the organization level, can be assigned granular scopes, and remain valid even if the administrator who created them leaves the organizatio…
- [Spaces](https://lightdash-friday-validation-demo.mintlify.app/references/workspace/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.
- [Usage analytics](https://lightdash-friday-validation-demo.mintlify.app/references/workspace/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.
- [User attributes](https://lightdash-friday-validation-demo.mintlify.app/references/workspace/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.
- [Configure a Slack integration for self-hosted Lightdash](https://lightdash-friday-validation-demo.mintlify.app/self-host/customize-deployment/configure-a-slack-app-for-lightdash.md)
- [Configure a Github integration for self-hosted Lightdash](https://lightdash-friday-validation-demo.mintlify.app/self-host/customize-deployment/configure-github-for-lightdash.md)
- [Configure Lightdash to use an external database](https://lightdash-friday-validation-demo.mintlify.app/self-host/customize-deployment/configure-lightdash-to-use-an-external-database.md)
- [Configure Lightdash to use external storage](https://lightdash-friday-validation-demo.mintlify.app/self-host/customize-deployment/configure-lightdash-to-use-external-object-storage.md)
- [Configure logging for Lightdash](https://lightdash-friday-validation-demo.mintlify.app/self-host/customize-deployment/configure-logging-for-lightdash.md)
- [Configure Prometheus metrics for self-hosted Lightdash](https://lightdash-friday-validation-demo.mintlify.app/self-host/customize-deployment/configure-prometheus-metrics-for-self-hosted-lightdash.md)
- [Configure SMTP for Lightdash email notifications](https://lightdash-friday-validation-demo.mintlify.app/self-host/customize-deployment/configure-smtp-for-lightdash-email-notifications.md)
- [Configure a standalone scheduler worker for self-hosted Lightdash](https://lightdash-friday-validation-demo.mintlify.app/self-host/customize-deployment/configure-standalone-scheduled-worker.md)
- [Add headless browser on self-hosting](https://lightdash-friday-validation-demo.mintlify.app/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-friday-validation-demo.mintlify.app/self-host/customize-deployment/enable-scheduler-in-self-hosted-lightdash.md)
- [Enterprise License Keys](https://lightdash-friday-validation-demo.mintlify.app/self-host/customize-deployment/enterprise-license-keys.md): Access enterprise features on self-hosted Lightdash instances
- [Environment variables](https://lightdash-friday-validation-demo.mintlify.app/self-host/customize-deployment/environment-variables.md)
- [Configure a Google Sheets integration for self-hosted Lightdash](https://lightdash-friday-validation-demo.mintlify.app/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/integrations/google-sheets) and upload results from Google Sheets on `charts` on your on self-hosted Lightdash server.
- [Resource recommendations](https://lightdash-friday-validation-demo.mintlify.app/self-host/customize-deployment/recommended-resources.md): The recommended resource requests for each Lightdash component are as follows
- [Secure Lightdash with HTTPS](https://lightdash-friday-validation-demo.mintlify.app/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/) or [traefik](https://traefik.io).
- [Configure Lightdash to use passwords or SSO for authentication](https://lightdash-friday-validation-demo.mintlify.app/self-host/customize-deployment/use-sso-login-for-self-hosted-lightdash.md)
- [Lightdash Cloud vs. Self-Hosted](https://lightdash-friday-validation-demo.mintlify.app/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](https://lightdash-friday-validation-demo.mintlify.app/self-host/self-host-lightdash.md)
- [Self-host Lightdash using docker compose](https://lightdash-friday-validation-demo.mintlify.app/self-host/self-host-lightdash-docker-compose.md)
- [Self-Host Lightdash with Restack](https://lightdash-friday-validation-demo.mintlify.app/self-host/self-host-lightdash-restack.md)
- [Updating Lightdash to the latest version](https://lightdash-friday-validation-demo.mintlify.app/self-host/update-lightdash.md)

## 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)