Q&A BY TAG 'Create Base View'

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

Need help creating a Base View from a SQL Server Stored Procedure
answered 11-08-2020 11:14:08 -0400

I have a SQL Stored Procedure which I will use to create a Base View in Denodo. The issue is that the Stored Procedure takes an User-Defined Table type as input parameter. If I select the SP and click Create from Selected I get an error that says the ...

Answers: 2

Base view Create Base View Stored Procedure SQL Server

Creating A Base View On Snowflake Stored Proc/ Multiple Statements
answered 22-07-2020 18:04:16 -0400

Hi, I was wondering if you could tell me if there was a way to create a base view on snowflake stored procs. What I am trying to do is: Run the stored proc Capture the result of the proc The Snowflake statments are like these: -----CALLING ...

Answers: 1

snowflake Base view Create Base View Stored Procedure

Restriction User From Creating More View
answered 23-06-2020 06:35:39 -0400

I would like to know is there any possible way to restriction a user (newly created or existing one) when creation views. Example: a user " trainer" who have create, read, write privileges. but need to restriction the user from creating more than 5 view.

Answers: 1

assign privilages Create User Create Base View LIMIT

Optional interpolation variables
answered 17-06-2020 08:14:12 -0400

Each time I create a base view over a JSON data source with interpolation variables, denodo asks me to provide all of the variables. But what if the API does not support the combination of all the variables together? E.g. there is external_id and local...

Answers: 3

Base view Interpolation Variables Create Base View

create base view for column
answered 06-04-2020 13:26:08 -0400

Can I create new base view for specific colum at table (imported from csv file) ?

Answers: 1

Create Base View

Querry execution return error
answered 26-03-2020 10:30:07 -0400

Hi I just strart testing denodo Sandbox free trial but when executing some querry its return error DataBriks.historical_store_sales Finished with error: Error executing query. Total time 92.279 seconds. HISTORICAL_STORE_SALES [BASE] [ERROR] HISTORICAL...

Answers: 1

Base view Create Base View

Cannot Create BaseView Form SQL Server Partition Table
answered 08-03-2020 22:21:50 -0400

I will create 6 baseview from sql datasource, i'm not sure the table have partition table or not. But on denodo only 1 table created and another table error (conflict table name). Illustration, i will create base view - https://imgur.com/HdsObLD + ...

Answers: 2

on conflict partition Create Base View Baseview Denodo_SQL_Server SQL

Date Range error
answered 10-02-2020 05:55:55 -0500

Hi, I am doing the denodo on demand training. One chapter has this excersize 'DEN70EDUD1102LAB02 - Create a Delimited File data source using DateRange function" The file saved in my local directory as below 20160101 20160102 20160103 20160104 2016010...

Answers: 1

Create Base View

Date Range parameter doesn't accept date
answered 10-02-2020 05:50:58 -0500

Hi, I am doing the denodo on demand training. One chapter has this excersize 'DEN70EDUD1102LAB02 - Create a Delimited File data source using DateRange function" The file saved in my local directory as below 20160101 20160102 20160103 20160104 2016010...

Answers: 1

Delimited file data source Create Base View delimited file sources rows columns pattern tupple

GENERATE_VQL_TO_CREATE_<json>_BASE_VIEW()
answered 07-02-2020 20:22:19 -0500

Hey, There is a stored procedure to generate vql to create base view for jdbc sources - GENERATE_VQL_TO_CREATE_JDBC_BASE_VIEW() but is there a option i can generate vql for otehr datasource. I.e json, csv, custom, etc

Answers: 1

Create Base View JSON Delimited Files