Q&A BY TAG 'get_view_columns'

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

row_number not working with the get_view_columns
answered 14-02-2020 21:44:17 -0500

Hello Denodo gurus! Why does row_number not work with the get_view_columns? select database_name, view_name, column_name as denodo_column_name, ROW_NUMBER() OVER ( PARTITION BY view_name ORDER BY database_name ) row_number_with_partition from get_vi...

Answers: 1

row number Delegate get_view_columns

get_view_columns
answered 01-10-2019 06:44:41 -0400

We are using the get_view_columns() function to pull denodo interfaces and columns into the MicroStrategy warehouse catalog. We have run into an issue that if a transformation has had manual vql manipulation, the function fails to return all columns. ...

Answers: 1

Microstrategy VQL get_view_columns

View column order metadata
answered 15-10-2018 05:53:36 -0400

I am using Denodo 7, latest update. I'm using get_view_columns() to extract metadata on columns included in views for various purposes. There doesn't seem to be anything that provides the order of the columns in the views. Is this metadata available a...

Answers: 1

metadata column order get_view_columns