You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
When following the instructions to set up Elementary on a project with Athena data warehouse, the following error is encountered when creating the Elementary models
NOT_SUPPORTED: Incorrect timestamp precision for timestamp(6); the configured precision is MILLISECONDS; column name: bucket_start.
This is a known issue with Athena and CTAS statements. See additional context below
To Reproduce
Steps to reproduce the behavior:
Add Elementary package 0.16.0 to a dbt project
Run the following command as specific in the documentation
dbt run --select elementary
Expected behavior
All model complete successfully
Screenshots
Environment (please complete the following information):
Elementary CLI (edr) version: 0.16.0
Elementary dbt package version: 0.16.0
dbt version: 1.8.3
Data warehouse: Athena
Infrastructure details (e.g. operating system, prod / dev / staging, deployment infra, CI system, etc)
Additional context
This error is documented in the Athena Engine V3 release notes
Athena engine version 3 checks to make sure that the precision of timestamps in the data is the same as the precision specified for the column data type in the table specification. Currently, this precision is always 3. If the data has a precision greater than this (for example, microseconds instead of milliseconds), queries can fail with the error noted. [...] Then, because Athena does not support timestamp 6, cast the value again to timestamp (for example, in a view).
Would you be willing to contribute a fix for this issue?
Yes I would be willing to help contribute a fix
The text was updated successfully, but these errors were encountered:
Describe the bug
When following the instructions to set up Elementary on a project with Athena data warehouse, the following error is encountered when creating the Elementary models
This is a known issue with Athena and CTAS statements. See additional context below
To Reproduce
Steps to reproduce the behavior:
Expected behavior
All model complete successfully
Screenshots
Environment (please complete the following information):
0.16.0
0.16.0
Additional context
This error is documented in the Athena Engine V3 release notes
Would you be willing to contribute a fix for this issue?
Yes I would be willing to help contribute a fix
The text was updated successfully, but these errors were encountered: