Hi all,
We are planning to take up saved queries and parameterisation use case in
lens. First of all I would like to know if there is any WIP item towards
this.
We have identified a bunch of use cases -
- User should be able to save a query parameterising parts of it.
- User should be able to list all saved queries that are created by him and
shared with him.
- User should be able to share a query with other people with privileges.
- User should be able to execute a saved query if his privilege allows
(READ, EXECUTE).
- User should be able to clone a saved query (READ).
*Additional use-cases *
- User should be able to choose from a list of values to resolve a
parameter.
Eg. there could be a parameter called 'city_name'. The ad-hoc query UI can
probably show the list of values for the city to help resolving the
parameter. All user might have to do is at the time of saving a query, he
can optionally associate the parameter with a dimension level.
*Parameterisation :*
Parameterisation can be applicable to various clauses
*- where *:
select col1 from table *where col=$(param_name); *
select col2 from table where *time_range between now,
now-$(last_n_days_param)*
*- groupBy :*
select *$(group_by_col)*, sum(measure) from table group by *$(group_by_col)*
*- orderBy : *
select col1, col2 from table *order by $(order_by_col)* ASC
*- orderByType : *
select col1, col2 from table *order by col1 $(order_by_type)*
*- limit : *
select col1, col2 from table order by col1 ASC
*limit ${no_of_rows}*
Let us know your thoughts and suggestions around this.
Thanks,
--
Amruth S
(09486075517)
--
------------------------------------------------------------------------------------------------------------------------------------------
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the system manager.
This message contains confidential information and is intended only for the
individual named. If you are not the named addressee you should not
disseminate, distribute or copy this e-mail. Please notify the sender
immediately by e-mail if you have received this e-mail by mistake and
delete this e-mail from your system. If you are not the intended recipient
you are notified that disclosing, copying, distributing or taking any
action in reliance on the contents of this information is strictly
prohibited. Although Flipkart has taken reasonable precautions to ensure no
viruses are present in this email, the company cannot accept responsibility
for any loss or damage arising from the use of this email or attachments
