I have a query that has a where statement that look at between two different date ranges. These date ranges move depending on todays date. In MSSQL I would define 4 variables and then use them in the where statement. The current solution I have looked ...
Answers:
3
Hi Team, Could you please help me with the vql command to modify the column names in the row level restriction for the AD groups and roles. For example before the RLS is implemented for the columns 'x' and 'y' now i have to change to column 'Y for all...
Answers:
1
In Denodo 8.0, what is the best way to automate the gathering of view stats and keep them updated for a large number of views (over 1000)?
Answers:
1
Need to extract data from element_metadata() procedure. I'm getting below error while executing this procedure. __P__S_NULL_79531090828947838643116096234859310357981553095826998064586988454878675543788_2743334557 [PROJECTION] [ERROR] ELEMENT_METADAT...
Answers:
2
I am trying to connect to Denodo express server running on localhost on port 9999 using NPGSQL version 5.0.3.0. The exception is : "Exception while reading from stream" The exception stack is shown below. at Npgsql.NpgsqlReadBuffer.<<Ensure>g...
Answers:
1
Hi, When i create a data source from other vdb using database adapter DENODO virtual dataport 7.0 with driver denodo com.denodo.vdp.jdbc.Driver how i import descriptions from views? Thanks
Answers:
1
I did this configuration in my resource manger and didn't worked. for exemple, I intent to have maximum 5 queries per user and not maximum 5 queries running in the server. what's happening for my is: user 1: running 2 queries user 2: running 2 quer...
Answers:
1
Is there a simple way to write a VQL script that not only shows all of the views -- i.e. LIST VIEWS on [database] but also would show the view and the columns, and field type from that view... (as well as description if possible). We are trying to g...
Answers:
2
Analytic Functions (Window Functions) using denodo 8.0 i have added functions into datasource (oracle19c) using source_configuration still getting below error Error executing view: Function row_number is not executable Any possible ways to use Analyt...
Answers:
3
How can I implement a rule with Resource Manager in order to limit the concurrent queries by user. I believe 5 query by user is ok. Thanks.
Answers:
2