Denodo community Q&A RSS feed Latest Denodo community answered questions Is CREATE MATERIALIZED TABLE AS SELECT ? with Folder Location possible? 2024-05-29T21:46:52Z 2024-05-29T21:46:52Z The example of a CREATE MATERIALIZED TABLE AS SELECT creates the table without issue, but places the base view in the root of the database folder structure. Is there a way to add the FOLDER literal to the CREATE MATERIALIZED TABLE AS SELECT execution? CREATE MATERIALIZED TABLE order_current_year AS SELECT * FROM order WHERE TRUNC(sale_date, 'YEAR') = TRUNC(CURRENT_DATE, 'YEAR'); 2024-05-29T21:46:52Z LEAD/LAG function with IGNORE NULLS 2024-05-29T21:01:51Z 2024-05-29T21:01:51Z Hello Support Team Denodo, is there any implementation for IGNORE NULLS functionality for functions LEAD and LAG? We try to convert Oracle sql queries to vql and need support for this. Also if there is a workaround you recommend, please tell us. The only result I found in Q&A is from 2017 where a user asked in connection with the FIRST VALUE function, but it seemed as it is not supported and there is also no helpful workaround existing ( Now, 7 years later, maybe there is a solution to this topic. Thanks in advance. 2024-05-29T21:01:51Z Data Catalog Data profiling of view 2024-05-29T10:17:51Z 2024-05-29T10:17:51Z I have a question about how to activate the data profiling of view menu in the data catalog, I didn't find any information in the manuals. Thanks 2024-05-29T10:17:51Z Encryption and Decryption in Denodo layer 2024-05-29T07:47:26Z 2024-05-29T07:47:26Z Need to encrypt PII data in Denodo layer. Also, decrypt data when user who has necessary acces executes view. Could you please share the step by step process to achive this ? 2024-05-29T07:47:26Z Virtual DataPort using a JDBC data source. 2024-05-22T12:34:43Z 2024-05-22T12:34:43Z . We have a company database which we can connect to from Virtual DataPort using a JDBC data source. Everything works fine, but we have detected a problem when using the function 'LOWER' in Virtual DataPort (the 'UPPER' function works correctly) when querying views over that data source. What should we modify in Virtual DataPort as a workaround for this problem? 2024-05-22T12:34:43Z How to escape special character in username field 2024-05-20T10:29:26Z 2024-05-20T10:29:26Z I'm setting up a JDBC connection to an Azure SQL database server. The problem I'm getting is when I enter the username which is in the format of an email address, then the @ character is interpreted by the JDBC connector as an indicator for the Hostname. How do I escape this character entered into the username field? ANSWER: I had to add authentication=ActiveDirectoryPassword to the connection string. 2024-05-20T10:29:26Z Connect DataHub as a datasource in Denodo 2024-05-17T14:05:10Z 2024-05-17T14:05:10Z Hi, Please advise on the steps to connect DataHub ( as a datasource in Denodo. Thank you! 2024-05-17T14:05:10Z OAuth 2.0 API connection Issue 2024-05-17T10:39:25Z 2024-05-17T10:39:25Z I have a GET URL, It was working fine with postman. When I trying to connect this Rest API to Denodo I have facing an error. like **Unable to establish connection: Connection refused** The Authentication type is OAuth 2.0 Authentication grant - Client credential grant Authentication method used by the authorization servers - Send client credentials using the HTTP Basic authentication scheme I mentioned Client ID, Client Secret, Access token, Token endpoint URL. As well as HTTP Headers also. 2024-05-17T10:39:25Z MFA 2024-05-16T21:27:43Z 2024-05-16T21:27:43Z How do you setup the data source to use MFA authentication? 2024-05-16T21:27:43Z Import Materialized View Data Lineage in Denodo 2024-05-09T22:41:46Z 2024-05-09T22:41:46Z We would like to import an Oracle MV dependencies into Denodo, do we have an design option here Below will give all the underlying references of the MV, and we wanted to import those underlying tables/views and associate to the final view, so that we have a tree view. Please advise a optimal auotmated design for this? ``` SELECT * FROM dba_dependencies WHERE owner = 'dts' AND name = 'CAT_MV'; ``` 2024-05-09T22:41:46Z