Query error reasons
Permission denied
The Databrain user in your warehouse cannot read a table that the query uses.
Reason in E1005 | Diagnostic code | Who can fix it | Does a retry help? |
|---|---|---|---|
PERMISSION_DENIED | DBN-WH-005 | Your admin | No |
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
| Who | Message | Next step |
|---|---|---|
| Admin or API caller | The data source denied access to a table this query reads. | Ask your admin to grant SELECT on this table to the Databrain user. |
| Embed viewer | This chart has a data setup problem. | Contact your admin. |
How to fix it
- In the warehouse, grant
SELECTon the table to the user that Databrain signs in with. - In Datasources, select Sync schema on the datasource.
- Open the chart again.
Warehouse codes behind it
| Warehouse | Codes |
|---|---|
| MySQL, SingleStore | 1044, 1142, 1143 |
| PostgreSQL, Redshift, CockroachDB | SQLSTATE 42501 |
| ClickHouse | 497 (ACCESS_DENIED) |
| SQL Server, Microsoft Fabric | 229 |
| Databricks | INSUFFICIENT_PERMISSIONS |
| BigQuery | accessDenied, billingNotEnabled |
| Trino | PERMISSION_DENIED |
| Athena, Amazon S3, CSV | AccessDeniedException |
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.