I somewhat agree, but I am not sure whether this approach would fit all needs.I would say for historical, structured data I would like to be able to access them using EXASOL, whether the data actually resides in Exasol or in a hadoop cluster. If it r...

Hello We stopped discovering files, that did not lead to the result we expected. Instead we have started defining an interface specification in csv/xls, this contains all the required information (and can in must cases directly be generated from the ...

Yes, we do something similar, we actually have >2'000 small files (10-50 rows) which we want to load all into the same table, each of the files has 2 header rows(1 row column names, 2 row datatype definition). The files reside on an sftp-server.We ha...

Hello NituWakanWhen we started with the migration from Teradata to Exasol Wherescape's standard for Exasol was also PowerShell. We absolutely did not like this approach, because we didn't want to introduce another language, it was not transparent and...

Hello ChrisDefinitely, however I would suggest that we first show that it works. Therefore I would suggest that we wait until we have at least one part of our datawarehouse in production (the plan was to have the first part by end of October in produ...