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

Implement BigQuery alter column type functionality #2546

Closed
azhard opened this issue Jun 15, 2020 · 1 comment · Fixed by #2547
Closed

Implement BigQuery alter column type functionality #2546

azhard opened this issue Jun 15, 2020 · 1 comment · Fixed by #2547
Labels
enhancement New feature or request

Comments

@azhard
Copy link
Contributor

azhard commented Jun 15, 2020

Describe the feature

Currently dbt uses the default macro implementation for altering column types which doesn't actually work with BigQuery. This feature would implement a BigQuery specific macro that allows users to alter column types.

Describe alternatives you've considered

BigQuery currently has two methods user's can use to alter a column type. The first method is done purely in SQL, the second involves uploading data to cloud storage. I believe the SQL specific approach makes more senes for dbt.

https://cloud.google.com/bigquery/docs/manually-changing-schemas#changing_a_columns_data_type

Additional context

Feature is specific to BigQuery

Who will this benefit?

BigQuery dbt users who might find themselves in need of a way to alter a column type through dbt.

@jtcohen6
Copy link
Contributor

Thanks for this @azhard, I'll leave a comment on the PR.

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

Successfully merging a pull request may close this issue.

2 participants