Query to a FDA Table not working | Community
Skip to main content
CampaignerForLife
CampaignerForLife
Level 5
February 6, 2025
Solved

Query to a FDA Table not working

  • February 6, 2025
  • 1 reply
  • 502 views

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!

Best answer by Amine_Abedour

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,

1 reply

Amine_Abedour
Community Advisor
Amine_AbedourCommunity AdvisorAccepted solution
Community Advisor
February 10, 2025

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,

Amine ABEDOUR
    Terms & ConditionsAccessibility statement

    Loading footer...