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.

Sign up for GitHub

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

Jump to bottom

Unable to find fields that can help set default collation while creating table #1505

Open
amulya06holla opened this issue Feb 22, 2023 · 2 comments
Open

Unable to find fields that can help set default collation while creating table #1505

amulya06holla opened this issue Feb 22, 2023 · 2 comments
Labels
api: bigquery Issues related to the googleapis/python-bigquery API. priority: p2 Moderately-important priority. Fix may not be included in next release. type: feature request ‘Nice-to-have’ improvement, new feature or different behavior or design.

Comments

@amulya06holla
Copy link

We are trying to automate the process of creation of table using python rather than using GCP console. However we are unable to specify default collation while creating table.
we also explored the option to mention that in the schema but the field "collation" or "defaultCollation" are not recognised.

A similar feature was added in go and Java : googleapis/google-cloud-go@9f7bbeb can this be made available for python too?
@product-auto-label product-auto-label bot added the api: bigquery Issues related to the googleapis/python-bigquery API. label Feb 22, 2023
@shollyman
Copy link
Contributor

Duplicate of internal FR issue 266066168

@shollyman shollyman added type: feature request ‘Nice-to-have’ improvement, new feature or different behavior or design. priority: p2 Moderately-important priority. Fix may not be included in next release. labels Mar 3, 2023
@chalmerlowe
Copy link
Contributor

At this time, the Python libraries do not support collation.
A work around is to include SQL to perform the collation manually.
See here for more details on generating collation via straight SQL.
https://cloud.google.com/bigquery/docs/reference/standard-sql/collation-concepts

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
api: bigquery Issues related to the googleapis/python-bigquery API. priority: p2 Moderately-important priority. Fix may not be included in next release. type: feature request ‘Nice-to-have’ improvement, new feature or different behavior or design.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@shollyman @chalmerlowe @amulya06holla