> ## Documentation Index
> Fetch the complete documentation index at: https://docs.elementary-data.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Troubleshooting

<Accordion title="I connected my data warehouse but I don't see any test results">
  If you already connected your data warehouse to Elementary but are not seeing anything in the Elementary UI, there could be several reasons.
  Try following these steps to troubleshoot:

  **1. Validate elementary dbt package is deployed, working, and using the latest version**

  * Refer to the [dbt package installation guide](/cloud/quickstart#install-the-dbt-package), and validate that your version in packages.yml is the one mentioned there. If not, upgrade and run `dbt deps`. Make sure to execute `dbt run --select elementary` for the package tables to be created.

  **2. Check if the table `elementary_test_results` exists and has data**

  * If the table does not exist - refer to the [dbt package installation guide](/cloud/quickstart#install-the-dbt-package). Make sure to execute `dbt run --select elementary` for the package tables to be created.
  * If the table exists but has no data - Did you execute `dbt test` since deploying the package and creating the models?
  * If you have, make sure the table was created as an incremental table (not a regular table or view).
  * If not, there is a materialization configuration in your `dbt_project.yml` file that overrides the package config. Remove it, and run `dbt run --select elementary --full-refresh` to recreate the tables. After that run `dbt test` again and check if there is data.

  **4. Still no data in the table? Reach out to the Elementary team by starting an intercom chat from the Elementary UI.**
</Accordion>

<Accordion title="Parallel dbt jobs error when writing to Elementary metadata artifact tables">
  When multiple dbt jobs run in parallel, they can contend on the same Elementary metadata artifact tables.

  **Disable automatic metadata artifact uploads** in `dbt_project.yml`:

  ```yaml dbt_project.yml theme={null}
  vars:
    disable_dbt_artifacts_autoupload: true
  ```

  **Add a separate scheduled job** (daily or hourly) to upload the artifacts:

  ```bash theme={null}
  dbt run --select elementary --vars '{"enable_elementary_models": true}'
  ```

  For the `enable_elementary_models` pattern in `dbt_project.yml`, see [Can I disable / exclude the Elementary models?](/oss/general/faq#can-i-disable-exclude-the-elementary-models). For more context, see [on-run-end hooks](/data-tests/dbt/on-run-end_hooks), [Reduce on-run-end time](/data-tests/dbt/reduce-on-run-end-time), and [Dev / prod configuration](/cloud/guides/dev-prod-configuration).

  Let us know if you run into anything — start a chat from the Elementary UI or reach us on [Slack](https://elementary-data.com/community).
</Accordion>

<Accordion title="Column information cannot be retrieved">
  This error can happen because of a few reasons:

  1. Check that your elementary dbt package version is 0.12.0 or higher.
  2. Check that the user you are using to connect to your database has permission to access the information schema of all the schemas built or used by your dbt project.

  For more information on the permissions required by each data warehouse:

  [Snowflake](/cloud/integrations/dwh/snowflake#permissions-and-security)

  [Bigquery](/cloud/integrations/dwh/bigquery#permissions-and-security)

  [Redshift](/cloud/integrations/dwh/redshift#permissions-and-security)

  [Databricks](/cloud/integrations/dwh/databricks#permissions-and-security)

  [Postgres](/cloud/integrations/dwh/postgres#permissions-and-security)
</Accordion>

<Accordion title="How do I set up the table name of my Singular test?">
  Singular tests are sql queries that can reference more than one table, but are often intended to test a logic that is related to one table in particular.
  In order to have that table name appear in the UI in the test results, test execution and more screens, you can set it up by adding the following to the config block of your singular test file:

  ```
  {{ config(
      override_primary_test_model_id="model_unique_id"
  ) }}
  ```

  Note: Use the `model_unique_id`, not the model name.
  The `model_unique_id` is the unique identifier of the model in dbt, and can be found by running the query:

  ```
  SELECT unique_id
  FROM <elementary-schema-name>.dbt_models
  WHERE name=<model-name>
  ```
</Accordion>