do we have any feature to create temp in trifacta. I want to make one temp table which will store current month details. I want to do it in dynamic way as don't want any physical table reference here, which needs to update every month.

[Trifacta_Alumni · Accepted solution]

You posted this URL: https://trifacta-eits.bankofamerica.com/flows

Is that inside the Trifacta application? Can you see a Trifacta logo in the corner?

If so, you should be able to select ? > Product Docs from the menu system.

Cheers,

-SteveO

[Trifacta_Alumni]

Thanks SteveO, got it.

It requires admin credential to follow doc step.

~JK

[Trifacta_Alumni]

Ok. Please contact your Trifacta administrator about enabling this feature. As previously noted, it's possible to write to the database as part of a multi-statement query, so this may not be approved for enablement.

Cheers,

-SteveO