Iterate over multiple SQL files from Directory and validate syntax

[shiv24saxena]

Hi,

I have multiple SQL files (contain create view statement) in a directory, whose syntax I want to validate through NBi. However I am not able to iterate over the files and pass it to my query execution. Below is the snippet of my testsuite.

[Seddryck]

What's the error that you're receiving with this snippet?

[shiv24saxena]

Thanks Seddryck for your response. It's not able to resolve file path (see attached screenshot). Files are present in C:/Test directory so in file attribute of query section I should get C:/TEST/DIM_ABC_VIEW.sql for DIM_ABC_VIEW.sql & C:/Test/DIM_ADJ_VIEW.sql for DIM_ADJ_VIEW.sql

[Seddryck]

Have you tried to use file="~{@sqlview}" ?

See doc at http://www.nbi.io/docs/primitive-result-set/#external-definition

[shiv24saxena]

Yes, I tried, It throws similar error. Framework is not able to resolve variable in file attribute.

[Seddryck]

Huuum, i think that the variables are not supported for execution. Something to add in framework.

[shiv24saxena]

Thanks for the reply. Is there any way to meet the below requirement with NBi?
"Validate Syntax of multiple view , by reading definition from SQL files (1 file per view) present in a directory"

[Seddryck]

Unfortunately not and I'm really busy with a huge migration to the v2.0 of NBi so I won't include this soon. But I'm adding that as a feature of v2.1

[shiv24saxena]

Thanks. Eagerly waiting for new major release 2.0, any tentative release date :)