I work in a data warehouse environment that controls access using views. For example there is a FactClaimTbl that contains the data, and analysts should use the FactClaim view (that selects data from FactClaimTbl). That way if the underlying table changes, the view can be updated to maintain backwards compatibility.
My issue is there are hundreds of Dim/Fact tables, and all of them have two copies in the autocomplete suggestion, the underlying Tbl and the view. I would like to prevent SQL Prompt from suggesting any objects with the keyword "Tbl" in them.
I'm also experiencing some slowness in auto-complete, and I hope excluding nearly half all objects will alleviate that issue as well.
Is this available in SQL Prompt? If not, can this be added as a feature request?
Comments
1 comment
-
Hello,
Thank you for your inquiry into SQL Prompt.
Regarding filtering, there is an option at the bottom of the suggestions box to show only specific objects. In the example shown below, I have filtered it to show only views.
I hope this information helps.
Best,
Dustin
Add comment
Please sign in to leave a comment.