Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error with Snowflake source NUMBER(X,0) field type #19

Open
adaykoth opened this issue May 3, 2024 · 0 comments
Open

Error with Snowflake source NUMBER(X,0) field type #19

adaykoth opened this issue May 3, 2024 · 0 comments

Comments

@adaykoth
Copy link

adaykoth commented May 3, 2024

I run into this error whenever I try to ingest a table from snowflake where a field is of the format NUMBER(X,0):

[2024-04-29 23:22:27] [ua.ingestrrrpred] <class 'dlt.destinations.exceptions.DatabaseTransientException'> [2024-04-29 23:22:27] [ua.ingestrrrpred] 400 POST https://bigquery.googleapis.com/bigquery/v2/projects/idle-fast-food-bbf2a/queries?prettyPrint=false: In NUMERIC(P, 0), P must be between 1 and 29 at [8:15]

This does not happen when I convert the type to either integer or allow a precision for the floating point number (e.g. NUMBER(X,2)).

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant