Vaisakh Mohan
03/11/2025, 3:58 PMedr report --project-dir . --profiles-dir . I am working using the package elementary-data[athena]
Running dbt command --log-format json run-operation elementary.log_macro_results --args {"macro_name": "elementary_cli.get_test_results", "macro_args": {"days_back": 7, "invocations_per_test": 720, "disable_passed_test_metrics": false}} --project-dir /opt/homebrew/lib/python3.11/site-packages/elementary/monitor/dbt_project --profiles-dir /Users/vaisakh.mohan/Documents/fusion/dbt/fusion-data-pipelines/dbt
{"data": {"exc": "Runtime Error\n Runtime Error\n NOT_SUPPORTED: Incorrect timestamp precision for timestamp(6); the configured precision is MILLISECONDS; column name: detected_at. You may need to manually clean the data at location '<s3://exmaplecom-com-fusion-dbt-transformed-euc1-bd/query_results/tables/aa4df4e2-7428-44b4-aea2-9adf15e0a7ca>' before retrying. Athena will not delete data in your account."}, "info": {"category": "", "code": "Q001", "extra": {}, "invocation_id": "256505b1-6cf0-447d-bf33-695e603b97e2", "level": "error", "msg": "Encountered an error while running operation: Runtime Error\n Runtime Error\n NOT_SUPPORTED: Incorrect timestamp precision for timestamp(6); the configured precision is MILLISECONDS; column name: detected_at. You may need to manually clean the data at location '<s3://exmaplecom-com-fusion-dbt-transformed-euc1-bd/query_results/tables/aa4df4e2-7428-44b4-aea2-9adf15e0a7ca>' before retrying. Athena will not delete data in your account.", "name": "RunningOperationCaughtError", "pid": 44350, "thread": "MainThread", "ts": "2025-03-11T15:30:20.350010Z"}}Zach Chang
03/11/2025, 4:39 PMNoya Offer
03/12/2025, 12:59 PMNoya Offer
03/12/2025, 1:30 PMtimestamp(3)) by default, while the data contains timestamps with microsecond precision (timestamp(6)).
Our Athena integration is a contribution, let me try reaching out to the contributor to see if he's willing to make these adjustments. If you're interested that's also a good option 🙂Noya Offer
03/31/2025, 2:16 PMNoya Offer
04/06/2025, 1:47 PM