Hi guys,I created a role on my database for reporting purposes. CREATE
ROLE REPORTING;Assigned users can select on some views from our access
layer. For example:GRANT SELECT ON ACCESSLAYER.DIM_CUSTOMERS TO
REPORTING; However, after some time they loo...
Hi guys,We are having performance issues with our Exasol - query times
are extraordinary long and volatile. The database has 16 GB RAM and the
underlying Server 32 GB RAM and 16 CPUs.Here you can see basic
information provided by the UI indicating th...
Hi friends, How can I get rid of decimal places in my exported csv
files?Currently the entries of my exported csv file looks like this: The
underlying TYPE of the attribute is a DECIMAL. I would be pleased if
someone could help me out. BestMoritz
Hi guys,I wonder how I can get rid of currency symbols in the exasol
database (except using the function TRIM).As you can see, it works fine
for display purposes.Apparently, as soon as I perfom calculations with
the referring column, the following er...
Hi mwellbro,Basically, the SQL was too time consuming and we solved the
problem by persisting some code in our database.We are also improving
our codes to further accelarate speed.Thank you very much and best
Hi Charlie,Thanks for your quick reply.We just found out that recration
of the view results in loosing the right to see the view for reporting
users.Do you know how to solve this problem?I am not sure whether audit
is enabled or not. How can I check ...