Virtualized dataset in a SQL Query recipe

Options
allan
allan Registered Posts: 13 ✭✭✭✭

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

  • allan
    allan Registered Posts: 13 ✭✭✭✭
    Options

    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.

Setup Info
    Tags
      Help me…