Forum Discussion
Copy Job (Preview) ends with error: Fabric Capacity not found
I am selecting the Azure SQL Database option, and pasting in the connection string that you can get from the "Copy SQL Connection string" option of the SQL analytics endpoint artifact that comes with every database.
(Pro tip: I use these connecton strings and set up 'Registered Servers' in SQL Server Management Studio. Being a consultant, I have a few dozen created and sorted into folders. All Warehouses, Lakehouses, and now Fabric SQL Databases in any one workspace are available behind that one single SQL Endpoint. They show up as named databases under the server. You can run cross-database queries like for moving data from Lakehouse to Warehouse. I love it!)
This is my setup:
I am getting a different error today:
Note that I am using my organizational account, which A) is an Admin on the Workspace, and B) was used to create the Fabric SQL Database. Yet that account does NOT have permissions to create objects. I get the same error trying to create a table from SSMS:
THAT is a BUG. If I CREATE the database, I MUST HAVE ADMIN rights on it.
This Copy Job is fraught with issues. IMHO, it should never have been released to preview. So far, in one day I have found:
1) Using a Warehouse or Lakehouse as the destination, there is no way to go back and edit the tables or column mappings.
2) Using a Lakehouse destination, it does not support column names (and I assume table names) with spaces (or other special characters, also assumed). Data Flows correct this for you, but only for NEW tables.
3) You cannot specify an EXISTING Lakehouse or Warehouse. So heaven forbid you mess up your table mappings, there is no way to create a NEW Copy Job that sinks to the warehouse you already have. You have to create a whole NEW Warehouse or Lakehouse. And this is BEFORE you specify FULL or DELTA. So how does DELTA work?
4) Using a Warehouse destination wants you to configure some other Azure storage, but GIVES YOU NO ABILITY TO DO SO. How do I make that work?!?