Section Application; dim_table: LOAD AutoNumberHash128(id,date) as table_id, table_name, upper(table_id) as REDUCTION;
[dim_table]: SELECT `table_id`, `table_name`, `date` FROM `schema`.`table`;
I have tried different approaches where I swap the names in upper case or lower case, where I remove the section application an try loading the REDUCTION straight from the data, but always the same error.
It looks like he doesn't recognise the username, but I copied the name & user directly straight from the QMC (and it actually matches the windows user directory so it should work).