How do I clear the cache
The scenario was that,
1. I had source query for a table and the data was loaded. Call it Table1 and had a join with another Table2.
2. I needed to make source query changes to this table, and remove the join between Table1 and Table2.
3. I try to load the table freshly, also tried loading the schema.
This does not reflect the expected changes, o matter how many times I try , it just shows the previous data.
Is there any way to clear the cached data. Kindly help.