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.
Answers
-
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.