Home > front end >  i can't connect to input container. but the container is acccessible and the file is there
i can't connect to input container. but the container is acccessible and the file is there

Time:01-31

I learning azure, specifically datafactory, so in a basic exercice.

1 - I should create a input container, and a output container (using azure sorage 2).

2 - After that, i created the datasets for input and output.

3 - And finally. I should connect the dataflow to my input dataset.

but

i can test conections on the datasets to prove that i created it without problems. but i cant test the connection on my dataflow to the input dataset.

enter image description here

i tryed

  • recreating it with different names.
  • keep only the needed file in the storage
  • use different input file (i am using a sample similar to the "movies.csv" expected to the exercise.

CodePudding user response:

I created azure blob container and uploaded file

enter image description here

I created linked service with azure storage account

enter image description here

I created a dataset with above linked service following below procedure:

enter image description here

enter image description here

enter image description here

I tested the connection, it connected successfully.

enter image description here

I didn't get any error. The error which you mentioned above is related to dynamic content. If you assign any parameters in dataset provide the values of parameters correctly. I added parameters in dataset as below

enter image description here

I try to test the dataset I got error:

enter image description here

I added values for parameters in debug settings

enter image description here

Tested the connection, it connected successfully

enter image description here

Otherwise add the sink to the dataflow and try to debug it, it may work.

CodePudding user response:

I think I found the solution.

when i am working with "debug on" and for some reason i create another "data flow", you cant connect to the new datasets.

But

if I restart the debug (put off and on again), the connections start working again.

  • Related