0

I'm quite new in 'Azure'. Is it possible to create many databases in SQL Elastic Pool by Azure Data Factory (Data Flow)?

Given:

Table

Row1 | Value1
Row2 | Value2

After execution I need to get two databases in specific elastic pool. One DB named: "Value1", second DB named: "Value2".

Alexey Klipilin
  • 1,866
  • 13
  • 29
  • How many database do you want to create? Where is the Table? – Leon Yue Dec 27 '19 at 05:50
  • @LeonYue I will have around 300 databases. Source table is in DB in Azure SQL. I know how to get data but don't know how to create databases dynamically with Data Flow – Alexey Klipilin Dec 27 '19 at 07:05
  • According my experience, Data Flow doesn't have the feature or component can help you create the databases. We can not do that with Data Flow. – Leon Yue Dec 27 '19 at 07:41
  • Any other idea is that you can create a stored procedure which create database in elastic pool with source column data in sink database, using Foreach to copy data from source table and call the stored procedure in sink. – Leon Yue Dec 27 '19 at 07:53
  • Possibly it can work, need to try. In the end I will also need to create separate users with read-only permissions for each DB separately, so probably I will go with simple C# application which will do that. Thank you. – Alexey Klipilin Dec 27 '19 at 08:00
  • You're welcome. Should I put this as the answer? Hope you can vote up or accept(mark) it. – Leon Yue Dec 27 '19 at 08:10
  • About creating read-only user for each database, you could post another question, maybe others can give you more suggestions. – Leon Yue Dec 27 '19 at 08:18
  • @LeonYue Sure, please write as answer. – Alexey Klipilin Dec 27 '19 at 08:19

1 Answers1

0

According my experience, Data Flow doesn't have the feature or component can help you create the databases. We can not do that with Data Flow.

With Data Factory, I have an idea is that you can create a stored procedure which create database in elastic pool with source column data in sink database, using Foreach to copy data from source table and call the stored procedure in sink.

Hope this helps.

Leon Yue
  • 15,693
  • 1
  • 11
  • 23