Q&A

You must sign in to ask a question. If you do not have an account, you can register here

Query optimization
answered 16-10-2020 05:23:32 -0400

Hi Denodo community, We have a big tree-view and multiple branch of the tree use same source/query. As is, Denodo reexecute the same query many times during the same execution.I understand that caching might be a solution but I understand too that cach...

Answers: 1

Flattening a Mongo Array
answered 15-10-2020 08:09:58 -0400

I have a Mongo connection that returns data similar to the following: _id : VARCHAR, ticket: { status : VARCHAR, recipient : VARCHAR, request_type : VARCHAR }, stages: { supplier: { status : VARCHAR, eta : VARCHAR }, recipient: { status : VARCHAR, eta...

Answers: 1

Denodo Scheduler Jobs
answered 15-10-2020 07:52:47 -0400

I have a scheduled job that runs 15 minutes after the hour, 24 hours a day. When a long running, heavy resource job is running at the same time, the scheduled job that runs 15 minutes after the hour does not complete before the next hourly execution of...

Answers: 1

Denodo Scheduler 7.0

Connecting MS SQL Server through Denodo Testing tool throws error.
answered 15-10-2020 07:07:41 -0400

I'm trying to establish a connection to SQL Server using the below properties through config file. mssql.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver mssql.jdbcUrl=jdbc:sqlserver://sqlsrv- devtest.database.windows.net:1433;databaseName...

Answers: 1

SQL Server SQL

Where to download google analytics .vql scripts?
answered 15-10-2020 06:35:58 -0400

Hi there, Can you please advise where I can locate the the 2 scripts: google_analytics_administration_templates_denodo.vql google_analytics_report_templates_denodo.vql as reffered to in the user manual: https://community.denodo.com/docs/html/d...

Answers: 1

Ms-Access database connection
answered 14-10-2020 06:54:03 -0400

Dear Sir, I have data in the MS-Access database and please let me know the procedure for connecting these database from the Denodo Tool. Give with example of connectivity. Regards, Senthil

Answers: 3

MS-Access-db-connection

QUERY [VIRTUAL] [ERROR] when i group by some columns in the baseview.
answered 14-10-2020 06:31:32 -0400

I am getting QUERY [VIRTUAL] [ERROR] when i group by some columns in the baseview. Please let me know why do i face the issue only when adding some specific columns. At times this error occurs even for all the column.

Answers: 1

#VirtualError #Groupby #projectionError

Getting Source Tables and Columns of a Datasource through Query
answered 14-10-2020 06:23:36 -0400

Hi Denodo team, Are there any queries to get all the tables in the datasource and also columns in a datasource for a specified table. I have seen that GET_SOURCE_TABLE() procedure is giving table but it takes view name as a parameter,but I don't want t...

Answers: 1

JDBC query Database JDBC DataSource

Snowflake connection - change warehouse based on e.g. a particular role
answered 13-10-2020 09:04:54 -0400

Hi, With Snowflake as our backend, we keep track of the compute consumption per departement. Users are assigned a "department role" and each departement role uses a dedicated warehouse. How can I do something similar in Denodo? I want to give users acc...

Answers: 3

snowflake

Programmatic IN Operator
answered 13-10-2020 08:36:09 -0400

I am trying to pass in a set of selection criteria for an IN operator but I can't seem to find any way for Denodo to accept it. Example: User enters A,B,C into a text box, and I would like to have that become SELECT * FROM <view> WHERE <column...

Answers: 1