Skip to content
New issue

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

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

Already on GitHub? # to your account

StarRocks DBT connector to support schema evolution #17

Open
alberttwong opened this issue Mar 8, 2024 · 0 comments
Open

StarRocks DBT connector to support schema evolution #17

alberttwong opened this issue Mar 8, 2024 · 0 comments
Assignees

Comments

@alberttwong
Copy link
Contributor

alberttwong commented Mar 8, 2024

Does our StarRocks DBT connector handle the following DBT schema evolution changes? dbt-labs/dbt-spark#124 (comment)

Handle schema evolution with and without partitioning.

* The full import, without partitioning. As @charlottevdscheun mentioned earlier in https://github.com/dbt-labs/dbt-spark/pull/117. Currently we use INSERT INTO, but I would suggest to replace this by CREATE OR REPLACE TABLE, this allows us to atomically update the table, but also allowing changing the schema. This will keep full history of the table, and is fully supported by Delta.
* In the case of partition by, forward compatible schema evolution is allowed. We can add new fields to partitions, and they will be just null for the other partitions.
@alberttwong alberttwong transferred this issue from StarRocks/starrocks Mar 11, 2024
# for free to join this conversation on GitHub. Already have an account? # to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants