You can translate the question and the replies:

Schema change and Source Refresh with Denodo and Cache store

Hello, We have snowflake as our cache store. When we add a new column to source, our cache refresh jobs fails with "Number of columns in file (25) does not match that of the corresponding table (23),". Any process we ned to follow to update cache schema to represent new fields? we tried invaludating the cache and turning it off and then returnig it on. This did not help. Thanks in Advance.
Cache Cache error Source refresh schema change
user
22-04-2019 11:35:10 -0400
code

1 Answer

Hi, I don’t know why exactly your cache refresh job fails, but I tried adding a new column in my cache database and then did a source refresh, the cache database in denodo got refreshed with the new column and doing the cache_preload = ‘true’ I was able to load the values into the database. Another thing you can try is to copy the view into another view and cache it so that a new table is created and then you can rename to the older name. To copy the view you can just right click and click copy and in the same database you can paste the view, this will create another cache table into your cache database. If this new view is working successfully, then you can replace the original with this new one renaming it. If this doesn’t work and you’re a customer, you can file a support case Hope it helps!
Denodo Team
24-04-2019 17:23:09 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here