Can Looker use Stored Procedures?

[brecht]

Knowledge Drop

Last tested: Jan 21, 2019
 

No

There is a semi-workaround for this with the `create_process` parameter with sql_step subparameters. If your database dialect uses custom Data Definition Language (DDL) commands, you can use create_process to create PDTs, by defining a list of SQL statements that will be executed in the order listed.

This content is subject to limited support.                

[Santosh4]

Hi Brecht,

Totally agree with you… one can execute multiple sql commands with create_process and sql_step parameters. However which are not useful when your case has plsql like looping condition in it..
So currently Looker doesn't support calling stored procedure..!

If any one knows work around please let me know...