DF-SRC-002 at Sink 'DatasetSink'(Line 176/Col 13): 'tableName' (Table Name) is required

Question

Hi,
I have a dataflow that reads data from a source (Azure dataset), here is the source config:

I have the desired output before the sink. The sink configuration as as follows:

The problem is when I try to preview the data, it gives error:

I have no tableName variable anywhere is the pipeline. I am just trying to take data from a dataset, process it, and store the results in other datastet.

Also,
whenever I try to do the data preview for sink in dataflow, a new set of parameters are generated (named DatasetSink linked Service parameter for dataflow:

Answer 1

Hi @Obaid Ur Rehman , would you please share screenshot of the Dataset. Thanks!

Answer 2

I don't have the solution yet but I can contribute this :

• "tableName" is not YOUR variable, it's ADF complaining that it's missing a table name for doing the thing.
• I have the same error, except with "database". In my case, ADF complains that it's missing a database name for doing the thing.

Something is not right in the sink, both for you and me.

I will continue investigating.

=================

EDIT :

In my case, the root cause was that I created the Factory through an ARM template import, and even though the import worked, some settings were reset in the process.

Specifically, when I went to look at the Linked Service corresponding to my cosmos db, the "database" field was empty. Normally, you can't leave it empty because the UI won't let you. But since this was not created through UI (again : it was created by an ARM template import), it was empty.

So, in conclusion : Check that absolutely every value is there, both in the Linked Service connection settings and in the logic bricks that make use of it (in the pipeline).

If you really can't find the missing value, then delete the Linked Service and recreate it. The UI won't let you overlook a value.

Answer 3

Had the same issue, deleting re-creating the sink helps.