Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add Preview Data feature #356

Open
blafond opened this issue Mar 7, 2016 · 0 comments
Open

Add Preview Data feature #356

blafond opened this issue Mar 7, 2016 · 0 comments

Comments

@blafond
Copy link
Contributor

blafond commented Mar 7, 2016

Add the ability to select a table/view/procedure and execute either a canned query (SELECT * xxx) or a customer query.

Rather than deploying entire VDBs (dependant as well), it might make more sense to construct a temporary dynamic VDB containing a simple entry for each dependent model + the selected model.
These models would contain DDL representing only the tables necessary to execute the query on the source(s).

Benefits : would include removing (or drastically reducing the complexity) the whole framework around maintaining a project VDB as well a preview VDB for each model
Drawbacks

  • there may be a performance hit to always deploy a VDB (and undeploy) for Preview Data
  • Views using UDF methods would need to include the function in the DDL. UDF jar would have to be deployed separately prior to deploying the dyn. vdb.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant