Dataset virtualization

Level 1
Dataset virtualization



I'm trying to utilize dataset virtualization and followed all the steps mentioned in Using SQL pipelines — Dataiku DSS 12 documentation. However, when I try to build my flow in combination with Teradata datasets, I will receive the following error message:

SQL dialect does not support automatically rolling back view creation, manually dropping any created views.Error when cleaning up intermediate pipeline views. Error when trying to roll back pipeline. Manual cleanup might be necessary. , caused by: SQLException: [Teradata Database] [TeraJDBC] [Error 3807] [SQLState 42S02] Object 'DSSVIEW_MONITORINGTEST_plw_joined_iI68J' does not exist.

It therefore seems that there is something wrong and I can't figure out what the problem is. Is there something wrong with the configuration or do I need to adjust something else?  Thanks in advance!


Kind regards

0 Kudos
1 Reply

Hi @simond,

Can you please try enabling "auto-commit mode" on your Teradata connection and retry your pipeline?

Screenshot 2023-09-08 at 5.13.10 PM.png

Thank you,


0 Kudos