How do I check if azure table storage exist in data factory

Question

How do I check if azure table storage exist in data factory

OGINTZ Marina 175

Hi, I have pipeline that copy azure table storage, I inject parameters to this pipeline (for the linked service and dataset). One of the parameters could be source table name that doesn't exist, I tried to use this

"azureTableSourceIgnoreTableNotFound": true

but it doesn't work and I still get an exception when the table is not exist. So, I want to check if the table is exist before the copy activity because I don't want my pipeline to fall if the table is not exist. I didn't find a way to do it. Please assist

Azar 31,725 Reputation points MVP Volunteer Moderator

2024-01-11T08:58:20.43+00:00

Hi OGINTZ Marina i dont think (ADF) ha built-in activities to directly check if an Azure Table Storage table exists before the copy activity.
OGINTZ Marina 175 Reputation points

2024-01-11T09:03:10.9633333+00:00

There is some way to do it? any idea?
OGINTZ Marina 175 Reputation points

2024-01-11T09:06:37.7833333+00:00

Thanks for replaying, any idea how to do it in some way?
Azar 31,725 Reputation points MVP Volunteer Moderator

2024-01-11T09:07:17.4133333+00:00

Yup ill give u a possible work around with combination of Azure Functions, Azure Logic Apps in the answer

2 answers

Your answer

Azar 31,725 Reputation points MVP Volunteer Moderator

2024-01-11T08:58:20.43+00:00

Hi OGINTZ Marina i dont think (ADF) ha built-in activities to directly check if an Azure Table Storage table exists before the copy activity.
OGINTZ Marina 175 Reputation points

2024-01-11T09:03:10.9633333+00:00

There is some way to do it? any idea?
OGINTZ Marina 175 Reputation points

2024-01-11T09:06:37.7833333+00:00

Thanks for replaying, any idea how to do it in some way?
Azar 31,725 Reputation points MVP Volunteer Moderator

2024-01-11T09:07:17.4133333+00:00

Yup ill give u a possible work around with combination of Azure Functions, Azure Logic Apps in the answer

Answer 1

Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

1 deleted comment

Comments have been turned off. Learn more

Answer 2

ShaikMaheer-MSFT 38,631 Microsoft Employee Moderator

Hi OGINTZ Marina, Thank you for posting query in Microsoft Q&A Platform.

You can consider using Lookup activity. If Lookup activity fails, that means table does not exist and on failure of it connect a wait activity. This avoids pipeline failure.On success of lookup activity, that means when table exists, we can run copy activity.

User's image

Hope this helps. Please let me know if any further queries.

---Please consider hitting Accept Answer button. Accepted answers help community as well. Thank you.

OGINTZ Marina 175 Reputation points

2024-01-11T11:50:13.7333333+00:00

I'm still getting pipeline status as failed: