locked
Data Flow between two Azure Sql Server - CREATE TABLE permission denied RRS feed

  • Question

  • We have data in an Azure Sql Server DB. We are using a Data Flow to transform some of it into another Azure Sql Server DB. The source and destination (sink) databases are already defined. It appears that the Data Flow attempts to create temporary tables. Is this true? It would explain the CREATE TABLE error. 

    If it is true, is there a recommended way to have a temporary space that is not in the destination database?

    Tuesday, July 16, 2019 7:09 PM

Answers

  • Hi there,

    You are correct that CREATE table permissions are required right now to write a Data Flow to a SQL DB. We understand this permission is not always available and are internally figuring out ways to make this experience better.

    As a workaround, would you be able to write to ADLS or Blob and then do a Copy to SQL?

    Thanks,

    Daniel

    • Marked as answer by dukeratwork Tuesday, July 16, 2019 8:44 PM
    • Unmarked as answer by dukeratwork Wednesday, July 17, 2019 6:55 PM
    • Marked as answer by dukeratwork Wednesday, July 17, 2019 7:28 PM
    Tuesday, July 16, 2019 8:26 PM
  • Hi dukeratwork,

    Just checking to see if you are still looking for assistance on this?

    Thanks.


    [If a post helps to resolve your issue, please click the "Mark as Answer" of that post and/or click Answered "Vote as helpful" button of that post. By marking a post as Answered and/or Helpful, you help others find the answer faster. ]

    • Marked as answer by dukeratwork Wednesday, July 17, 2019 9:21 PM
    Wednesday, July 17, 2019 8:18 PM
  • Nope - all good now.
    • Marked as answer by dukeratwork Wednesday, July 17, 2019 9:21 PM
    Wednesday, July 17, 2019 9:21 PM

All replies

  • Hi there,

    You are correct that CREATE table permissions are required right now to write a Data Flow to a SQL DB. We understand this permission is not always available and are internally figuring out ways to make this experience better.

    As a workaround, would you be able to write to ADLS or Blob and then do a Copy to SQL?

    Thanks,

    Daniel

    • Marked as answer by dukeratwork Tuesday, July 16, 2019 8:44 PM
    • Unmarked as answer by dukeratwork Wednesday, July 17, 2019 6:55 PM
    • Marked as answer by dukeratwork Wednesday, July 17, 2019 7:28 PM
    Tuesday, July 16, 2019 8:26 PM
  • So I attempted to create a blob data set. However the Data Flow will not let me select that dataset as a sink.

    How do I write the flow to a blob?

    I figured it out.
    • Edited by dukeratwork Wednesday, July 17, 2019 7:29 PM
    Wednesday, July 17, 2019 6:56 PM
  • Hi dukeratwork,

    Just checking to see if you are still looking for assistance on this?

    Thanks.


    [If a post helps to resolve your issue, please click the "Mark as Answer" of that post and/or click Answered "Vote as helpful" button of that post. By marking a post as Answered and/or Helpful, you help others find the answer faster. ]

    • Marked as answer by dukeratwork Wednesday, July 17, 2019 9:21 PM
    Wednesday, July 17, 2019 8:18 PM
  • Nope - all good now.
    • Marked as answer by dukeratwork Wednesday, July 17, 2019 9:21 PM
    Wednesday, July 17, 2019 9:21 PM
  • Thanks for confirming, dukeratwork!

    [If a post helps to resolve your issue, please click the "Mark as Answer" of that post and/or click Answered "Vote as helpful" button of that post. By marking a post as Answered and/or Helpful, you help others find the answer faster. ]

    Thursday, July 18, 2019 4:46 PM