I have a query that was working fine yesterday but not working as expected today. I get this error:
SQL compilation error: error line 1 at position 6,910 invalid identifier '"PO Count per Realm is greater than or equal to 5 - Realm".COMPANY_NAME'
When I look at the ""PO Count per Realm is greater than or equal to 5" (its new name is PO Count per Realm is greater than or equal to 10 btw but it shows the old name), this query itself loads correctly. I am able to visualize it, and it also has "Active customers - Realm__COMPANY_NAME" in it.
We also refreshed DB sync yesterday. How can I debug this?
This happens at the step when I am joining 2 tables. However, both of those tables are loading correctly on their own. I uploaded 2 photos that show the join and how each table is loading correctly individually.
