Query to a FDA Table not working

[CampaignerForLife]

Hello, i created a FDA table, but when I try to query it in a workflow it's giving me this error:

06-02-2025 9:40:49  ODB-240000 ODBC error: [Teradata][ODBC Teradata Driver][Teradata Database](-5495)Stored Procedure  'SIC_ACM_DESA.DropTableIfExists' does not exist. SQLState: S1000

I've seen that in the external account - Parameters, in Fuctions, there is a Deploy Function method, but I'm not sure if that's the issue

Anyone knows ? Thank you in advance!

[Amine_Abedour · Accepted solution]

Hello @CampaignerForLife,
Indeed, you need to launch the deployment of the custom Adobe Campaign functions in Teradata from the external account. This will create, among other things, the DropTableIfExists function below :

Br,