Make project variables available in SQL Probe Metrics

SQL probe metrics along with associated checks that compare characteristics of the current table with other tables can be important validation steps. 

It is possible to write probes that reference other tables in a project. However, since project variables are not accessible the table names must be hard coded rather than using the DSS feature that enables referencing tables via variables (e.g., ${projectKey}_tablename) so that the resolved table names are automatically unique across projects.

Not having this functionality means when projects are copied (e.g., for others on the team to work on) such probes either fail or give misleading results (by referencing a table from a previous project). Or alternatively we don't write such probes even when they would be useful to avoid the extra work of fixing problems and the risk of forgetting to make table name changes.

The request then is to be able use project variables in a SQL probe.

5 Comments
Mark_Treveil
Dataiker Alumni

Marlan 

Thanks for the request.  This is already logged in our feature backlog and is slated for development in the near future.

Mark

Marlan 

Thanks for the request.  This is already logged in our feature backlog and is slated for development in the near future.

Mark

Mark_Treveil
Dataiker Alumni
 
Status changed to: Planned
 

@Mark_Treveil, that's great to hear! 

Thanks!

Marlan

@Mark_Treveil, that's great to hear! 

Thanks!

Marlan

CoreyS
Dataiker Alumni
 
Looking for more resources to help you use Dataiku effectively and upskill your knowledge? Check out these great resources: Dataiku Academy | Documentation | Knowledge Base

A reply answered your question? Mark as โ€˜Accepted Solutionโ€™ to help others like you!
Status changed to: Released
 

Thanks,  this is working for me.  

 

--Tom

Thanks,  this is working for me.