Is there a way to rename a column name in a Database Query component. The source column name is different from my Target column name. I'm connected to a SQL server database. Any suggestions please?

Matillion ETL
1

Is there a way to rename a column name in a Database Query component. The source column name is different from my Target column name. I’m connected to a SQL server database. Any suggestions please?

2

I figured it out.

3

I just used column aliases in the Select Query ( Database Query Component) and it worked. So, something like

Select column_name1 AS column1 from <table_name>.

4

Hey @VVeda​

Glad to hear you worked this out, can you explain how you did it? It would be brilliant to hear how and I am sure it will help other community users too! 😁

Thanks Joe

5

Thanks for sharing that with us @VVeda​ nice work!

Kind Regards, Joe