Skip to Content

Query error reasons

Permission denied

The Databrain user in your warehouse cannot read a table that the query uses.

Reason in E1005Diagnostic codeWho can fix itDoes a retry help?
PERMISSION_DENIEDDBN-WH-005Your adminNo

What this means

The Databrain user in your warehouse cannot read a table that the query uses. The login worked, but the warehouse refused to let the Databrain user read a table, a column or a database.

What people see

WhoMessageNext step
Admin or API callerThe data source denied access to a table this query reads.Ask your admin to grant SELECT on this table to the Databrain user.
Embed viewerThis chart has a data setup problem.Contact your admin.

How to fix it

  1. In the warehouse, grant SELECT on the table to the user that Databrain signs in with.
  2. In Datasources, select Sync schema on the datasource.
  3. Open the chart again.

Warehouse codes behind it

WarehouseCodes
MySQL, SingleStore1044, 1142, 1143
PostgreSQL, Redshift, CockroachDBSQLSTATE 42501
ClickHouse497 (ACCESS_DENIED)
SQL Server, Microsoft Fabric229
DatabricksINSUFFICIENT_PERMISSIONS
BigQueryaccessDenied, billingNotEnabled
TrinoPERMISSION_DENIED
Athena, Amazon S3, CSVAccessDeniedException

Ask for help

Every error has a six-character ref, for example Ref A1B2C3. API callers find it in details.ref. Search for the ref in Settings > Diagnostics > Logs to see the full log line, or send the ref and the time of the error to support.

On this page