Virtualized dataset in a SQL Query recipe

allan
Level 3
Virtualized dataset in a SQL Query recipe

How do we reference the name of a virtualized dataset in a SQL Query recipe when running in a pipeline?

I had thought that the variable prepended with tbl: would contain the name of the view that represents the virtualized dataset, but that doesn't seem to be the case.

DataIKU 8.0.3

SQL Server backing store.

0 Kudos
1 Reply
allan
Level 3
Author

I should add that I'm asking this question due to what I believe is either a gap in the documentation or a bug in DSS. The limitations say that SQL Query recipes with multiple recipes aren't supported - implying that those that have single statements should work. However, I cannot get this to work with a virtualized dataset.

https://doc.dataiku.com/dss/8.0/sql/pipelines/sql_pipelines.html

Limitations

Additional limitations when running a SQL pipeline:

The SQL datasets must be part of the same database connection.
SQL script recipes, SQL query recipes with multiple statements, or the TopN visual recipes with rejected output tables are not currently supported.

 

0 Kudos