bigint not displayed correctly in query results when using Athena connector - Githubissues

AltimateAI / vscode-dbt-power-user

This extension makes vscode seamlessly work with dbt™: Auto-complete, preview, column lineage, AI docs generation, health checks, cost estimation etc

https://www.altimate.ai

MIT License

447 stars 86 forks source link

bigint not displayed correctly in query results when using Athena connector #1296

Open vilhomaa opened 2 months ago

vilhomaa commented 2 months ago

Expected behavior

when querying bigints, e.g. 5177825985796768123, the number should be displayed in the query results tab unmodified

Actual behavior

the number 5177825985796768123 gets displayed as 5177825985796768000

Steps To Reproduce

using query select 5177825985796768123 as test_bigint returns

Log output/Screenshots

No response

Operating System

macOS-14.4-arm64-arm-64bit

dbt version

1.8.3

dbt Adapter

Athena, redshift

dbt Power User version

v0.41.5

Are you willing to submit PR?

[ ] Yes I am willing to submit a PR!

pransito commented 2 months ago

also happens with dbt-redshift adapter