Q&A BY TAG 'vql'

I have several SQL Server tables where there are column names with spaces. The datasource shows the spaces, but the baseViews column names are created with no spaces and append '_0' to the column names. What configuration or setting can prevent the...

VQL

Hello, We are looking to automate view creation using VQL from a delimited file data source. We are currently able to create a delimited data source and create the views themselves, however it requires the attributes to be provided while creating the ...

vql metadata file delimited

Hi team, we have new rules setting, and it has some conflicts of existing rules, but new rules should be the 1st priority, do you know after create new rules, how to use vql to make the new rules is before the existing old rules. It will be helpful for...

vql order change rules

I created a view that tists the metagroups (roles) that have been imported into Denodo. I'd like to send an email to these metagroups whenever there is an expected outage (when upgrading), or when a Denodo restored to service when it unexpectedly goes ...

VQL Custom stored procedure email

Hi I have a field which contains text. Id like to extract a certain part of that text field which being "Model: 123 Customer ABC" I would like to extract only the "123" part of this field Any help would appreciated Thanks D

VQL string conversion

Hi Denodo Community , Please , I need your help , How can get database URL in denodo , using VQL or any other solution Thank you a lot .

VQL GET_VIEWS VQL Base view database URI GET_SOURCE_TABLE URL GET_ELEMENTS

Hi, Can we query a subfield from a register in vql shell without knowing the exact path of the subfield. is there a query like : select [subfield name] from xxview. So if the subfield is under register1.register2..registerN, we dont have to specify th...

vql register

HI everyone, I have a task to transform a text field to a timestamp field. The content of the initial field looks like this: "2017007", so it's like "YYYY0MM". I was trying aroudn with totimestamptz, but I don't know how to deal with this 0 in the ...

VQL

How do you determine the mandatory parameters/search methods given a view using VQL?

VQL Parameter

Is there a way to determine which queries Denodo will not delegate in full to source via VQL or otherwise ?

VQL