New fields added to view after Refresh Schema, but Omni still throw "Field not found" error

Modeling
1

Hi, this is my issue:

  • I add new columns to a table

  • I click refresh schema

  • the new columns are detected and correctly added to the view files

  • Omni says “column not found” for those exact columns

  • Error message in dashboard: “No such column … Only the following fields are available: [list of old fields]”

There are no branches for this model. And I’m working from the shared layer.

I have tried refreshing the schema again multiple times. This seems like a schema cache issue. Does anyone know how I can fix this?

Thank you for your help!

image
image1442×586 56.9 KB

2

Hey Khoa, refreshing the schema is the right call but it sounds like that wasn’t successful in clearing the errors. Could you reach out to Omni support via Slack/Teams or email support@omni.co? If you can include a link to the model or this view file we’ll be able to take a closer look!

3

Hey Khoa, in case you’re using dbt, you’ll also need to re-run dbt on this connection in omni.