ETL - Azure Data Factory Data Flows - Source shows no columns?

Question

I have a stored procedure that utilizes temp tables in Azure SQL and I'm trying to build an ETL process that loads the output into a table.

In ADF >> Data Flows >> When i try to debug , it doesn't load because there is no columns? I tried import schema from source and says there are 0 columns? see my config below.

Answer 1

Hi @Matt A ,
Thankyou for using Microsoft Q&A platform and posting your query.

Could you please help me understand which schema you are trying to import? Are you trying to import schema for the table used underneath the stored procedure.

As you are using Stored procedure as Input in Source Options, schema is not showing up . In case you want to import schema of the underneath table then you need to use dataset pointing to the table instead of Inline that would help in importing schema for the table.

But as I understand you are using Stored procedure ultimately, which doesn't really have any schema. So it's failing while you are trying to import schema.

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you.
  Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators