---
title: "Get project compilation logs"
method: GET
path: "/api/v1/projects/{projectUuid}/compile-logs"
tags: ["Projects"]
---

# Get project compilation logs

`GET /api/v1/projects/{projectUuid}/compile-logs`

Get compilation logs for a project

## Path parameters

- `projectUuid` string, required

## Query parameters

- `pageSize` number, double
- `page` number, double
- `sortBy` 'created_at' | 'compilation_source'
- `sortDirection` 'asc' | 'desc'
- `triggeredByUserUuids` string
- `source` 'cli_deploy' | 'refresh_dbt' | 'create_project' | 'project_connection_form'

## Response `200`

Success

- ApiProjectCompileLogsResponse
  - `results` ApiProjectCompileLogsResults, required
    - `pagination` object
      - `totalResults` number, double, required
      - `totalPageCount` number, double, required
      - `pageSize` number, double, required
      - `page` number, double, required
    - `data` ProjectCompileLog[], required
      - `report` CompilationHistoryReport, required
        - `baseTableNames` string[], required
        - `exploresWithErrors` ExploreError[], required
          - `name` string, required
          - `label` string, required
          - `tags` string[]
          - `groupLabel` string
          - `groups` string[] — Nested groups for the sidebar (max 5 levels). Group keys resolve to labels/descriptions via the project-level `table_groups` config (fetched separately); missing keys fall back to using the key as the label.
          - `baseTable` string
          - `joinedTables` CompiledExploreJoin[]
            - `hidden` boolean
            - `table` string, required
            - `type` 'inner' | 'full' | 'left' | 'right'
            - `sqlOn` string, required
            - `always` boolean
            - `relationship` 'one-to-many' | 'many-to-one' | 'one-to-one' | 'many-to-many'
            - `parameterReferences` string[]
            - `tablesReferences` string[]
            - `compiledSqlOn` string, required
          - `tables` object
          - `unfilteredTables` object
          - `targetDatabase` 'bigquery' | 'databricks' | 'snowflake' | 'redshift' | 'postgres' | 'duckdb' | 'trino' | 'clickhouse' | 'athena' | 'spark'
          - `warehouse` string
          - `databricksCompute` string
          - `ymlPath` string
          - `sqlPath` string
          - `type` 'virtual' | 'default' | 'pre_aggregate'
          - `caseSensitive` boolean
          - `spotlight` object
            - `owner` string
            - `categories` string[]
            - `visibility` 'show' | 'hide', required
          - `aiHint` union
            - string
            - string[]
          - `parameters` RecordStringLightdashProjectParameter — Construct a type with a set of properties K of type T
          - `granularityLabels` PartialRecordTimeFramesString — Make all properties in T optional
            - `RAW` string
            - `YEAR` string
            - `QUARTER` string
            - `MONTH` string
            - `WEEK` string
            - `DAY` string
            - `HOUR` string
            - `MINUTE` string
            - `SECOND` string
            - `MILLISECOND` string
            - `DAY_OF_WEEK_INDEX` string
            - `DAY_OF_MONTH_NUM` string
            - `DAY_OF_YEAR_NUM` string
            - `WEEK_NUM` string
            - `MONTH_NUM` string
            - `QUARTER_NUM` string
            - `YEAR_NUM` string
            - `DAY_OF_WEEK_NAME` string
            - `MONTH_NAME` string
            - `QUARTER_NAME` string
            - `HOUR_OF_DAY_NUM` string
            - `MINUTE_OF_HOUR_NUM` string
          - `savedParameterValues` ParametersValuesMap — Construct a type with a set of properties K of type T
          - `preAggregates` PreAggregateDef[]
            - `materializationRole` PreAggregateMaterializationRole
              - …
            - `refresh` object
              - …
            - `maxRows` number, double
            - `granularity` 'RAW' | 'YEAR' | 'QUARTER' | 'MONTH' | 'WEEK' | 'DAY' | 'HOUR' | 'MINUTE' | 'SECOND' | 'MILLISECOND' | 'DAY_OF_WEEK_INDEX' | 'DAY_OF_MONTH_NUM' | 'DAY_OF_YEAR_NUM' | 'WEEK_NUM' | 'MONTH_NUM' | 'QUARTER_NUM' | 'YEAR_NUM' | 'DAY_OF_WEEK_NAME' | 'MONTH_NAME' | 'QUARTER_NAME' | 'HOUR_OF_DAY_NUM' | 'MINUTE_OF_HOUR_NUM'
            - `timeDimension` string
            - `filters` MetricFilterRule[]
              - …
            - `metrics` string[], required
            - `dimensions` string[], required
            - `name` string, required
          - `preAggregateSource` PreAggregateSource
            - `preAggregateName` string, required
            - `sourceExploreName` string, required
          - `warnings` InlineError[] — Non-fatal compilation or validation warnings (e.g. fields that failed to compile, warehouse-rejected column references). The explore is still usable.
            - `message` string, required
            - `type` 'METADATA_PARSE_ERROR' | 'NO_DIMENSIONS_FOUND' | 'SKIPPED_JOIN' | 'MISSING_TABLE' | 'FIELD_ERROR' | 'SET_VALIDATION_ERROR' | 'INVALID_PARAMETER' | 'DUPLICATE_FIELD_NAME' | 'WAREHOUSE_COLUMN_ERROR', required
          - `errors` InlineError[], required
            - `message` string, required
            - `type` 'METADATA_PARSE_ERROR' | 'NO_DIMENSIONS_FOUND' | 'SKIPPED_JOIN' | 'MISSING_TABLE' | 'FIELD_ERROR' | 'SET_VALIDATION_ERROR' | 'INVALID_PARAMETER' | 'DUPLICATE_FIELD_NAME' | 'WAREHOUSE_COLUMN_ERROR', required
        - `dimensionsCount` number, double, required
        - `metricsCount` number, double, required
        - `errorExploresCount` number, double, required
        - `successfulExploresCount` number, double, required
        - `totalExploresCount` number, double, required
      - `warehouseType` string, nullable, required
      - `requestMethod` string, nullable, required
      - `dbtConnectionType` string, nullable, required
      - `compilationSource` 'cli_deploy' | 'refresh_dbt' | 'create_project' | 'project_connection_form', required
      - `createdAt` string, date-time, required
      - `organizationUuid` string, required
      - `userName` string, nullable, required
      - `userUuid` string, nullable, required
      - `jobUuid` string, nullable, required
      - `projectUuid` string, required
      - `projectCompileLogId` string, required
  - `status` 'ok', required

## Other responses

- `default` — Error

---

[API](https://skmtc.net/lightdash/apis/lightdash-api.md) · [All operations](https://skmtc.net/lightdash/apis/lightdash-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/lightdash/lightdash-api/versions/40c933755c9a/schema)