Dataset virtualization

simond
Level 1
Dataset virtualization

Hi,

 

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 17.10.00.22] [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
SarinaS
Dataiker

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,
Sarinaโ€ƒ

 

0 Kudos