googleapis/python-bigquery

Direct specification of NUMERIC columns in bigquery.SchemaField

Opened this issue · 2 comments

shering243 commented

Thanks for stopping by to let us know something could be better!

PLEASE READ: If you have a support contract with Google, please create an issue in the support console instead of filing on GitHub. This will ensure a timely response.

Is your feature request related to a problem? Please describe.

Direct specification of NUMERIC columns in bigquery.SchemaField. This is available for INT, FLOAT, STRING etc but only NUMERIC is missing. This leads to the need of client side conversion of datatype in case the column data type in bigquery is NUMERIC. An optimum solution for the customer would be that the bigquery client library supports NUMERIC too just like the other datatypes

Describe the solution you'd like

Interested in the default option where we can specific NUMERIC datatype in the schemaField in the client library itself just like it can be done with other data types.

Describe alternatives you've considered

Manual conversion of datatype before upload is performed to avoid datatype mismatch error.

Additional context

NA

chalmerlowe commented

Thanks for adding this feature request. Much appreciated.

chalmerlowe commented

For more details: see this internal Google bug: b/372186573 for history and more details on this Issue.