alias column for snowflake external table

cakkinep commented 7 months ago

Description & motivation

resolves: #213 These changes will specifically solve the issue with snowflake tables where the underlying file format or table format has a column named VALUE ( error below) . In general this change will allow aliasing column name for any reason.

Encountered an error while running operation: Database Error 091311 (42601): SQL compilation error: 'VALUE' cannot be used as a column name for external tables.

More about the changes:

check if alias exists for a column, if it exists it will use alias for column name and reference original column name in the file/table format.

Checklist

[x] I have verified that these changes work locally
[ ] I have updated the README.md (if applicable)
[x] I have added an integration test for my fix/feature (if applicable)

cakkinep commented 7 months ago

@jeremyyeo , the CI seems to be failing, it is not related to this PR

wjhrdy commented 7 months ago

This is useful. Thanks for the work on this.

thomas-vl commented 7 months ago

@jeremyyeo , the CI seems to be failing, it is not related to this PR

CI fails because of a protobuf issue in DBT Core, I have created a PR with a temporary fix that will resolve this issue: https://github.com/dbt-labs/dbt-external-tables/pull/258

cakkinep commented 5 months ago

@dataders Added integration test to validate column alias.

dbt-labs / dbt-external-tables

alias column for snowflake external table #257

Description & motivation

Checklist