Forum Discussion
Data source error: Value was not specified..
Ok, I've found the solution. Last month, I enabled the 'New Snowflake connector implementation' feature which is still in preview. The refresh obviously didn't like this! Anyway I've disabled it and all works fine now.
What I meant about the queries being set up differently is that in a sql query you could have a source that is ‘server_name.database’ or you could just use ‘database’. However, within one flow or model if you go to the same source and on one query you use server_name.database and on another you use just database it may error out.
With that said I don’t think that is your problem once you mentioned you have custom-made tables. Do any of your custom-made tables reference your snowflake queries?
Ah, right.
No direct references in the code, no. There is a relationship between one of them and a Snowflake table. But earlier I tested deleting it and then refreshing - same error. I've now deleted all queries but the two most essential ones (both Snowflake) and still the same error. I'm stumped.