Find and replace column names across all models in a project (dbt Cloud)

Help
1

The problem I’m having

I’m looking for a way to find and replace column names across all models in a project. For example, I want ‘foo_bar’ to be renamed to ‘foobar’ everywhere that ‘foo_bar’ was used

The context of why I’m trying to do this

My org has decided to change some of our column naming conventions. Our models have been built so that column renames happen pretty far upstream in intermediate models (so that the renaming doesn’t have to be written multiple times for each of our output models)

What I’ve already tried

Haven’t really been able to find a good starting point yet online or on the forums

2

ctrl+shift+f? ctrl+shift+h?

Note: @Mike Stanley originally posted this reply in Slack. It might not have transferred perfectly.

3

ctrl+h works within a single model. But then all downstream models would need to be updated to reference the new column as well. I’m looking for a way (which might not exist) to find and replace across all models

I don’t think ctrl+shift+h is a command in dbt Cloud

4

I don’t think you will be able to do it easily in dbt cloud, the best option I think is

Clone the repo in your machine
Use the VSCode’s search tool to easily replace the column’s names in all files at once