Forum Discussion

Hongju_Jung's avatar
Hongju_Jung
Super User
2 years ago
Solved

UnsupportedWorkspaceName error in schema enabled lakehouse

 

Hi, Team

 

I created a schema enabled lakehouse, and the name is 'lakeschema'.

My workspace name has only letters in it, but I'm getting the error below.

 

1. An error occurred when trying to load from Files to a table.

 

 

Server Error.

Message : Operation is not supported for workspaces with non-alphanumeric characters in the workspace name. Please ensure that your workspace name has only letters or digits.

Error Code : UnsupportedWorkspaceName

 

 

2. An error occurred when Notebook tried to load a file.

 

InvalidHttpRequestToLivy: [TJS_OnelakecatalogUnsupportedWorkspaceName] Use only letters and numbers for workspace names with schema enabled lakehouse. HTTP status code: 400.

 

 

Thanks,

Hong

lakehouse
  • Hongju_Jung's avatar
    Hongju_Jung
    2 years ago

    Hi, VinayKumar7 

     

    Thank you for your response.

     

    I tested the same again in the workspace where the error occurred, but it works fine.

    I then created new workspaces (letters only, lettes with space, and non-alphabetic letters) and tested them, and they work fine.

     

    So, the feature is in preview.

     

    Thanks,

    Hong

2 Replies

  • VinayKumar7's avatar
    VinayKumar7
    Regular Visitor
    2 years ago

    Hi Hongju_Jung ,

    Even I also faced same issue when I started learning Fabric. Below are the steps I tried and it works for me.

     

    First Delete existing workspace you created "lakeschema" under Lakehouse.


    Step 1: Create a new general workspace with a name of your choice, selecting a licensing mode in the Advanced section that includes Fabric capacity (Trial, Premium, or Fabric).

    Now that you have a workspace, it's time to create a data lakehouse for your data files.

     

    Step 2: In the Synapse Data Engineering home page, create a new Lakehouse with a name of your "lakeschema".

    Step 3: View the new "lakeschema" lakehouse, and note that the Lakehouse explorer pane on the left enables you to browse tables and files in the lakehouse.

    Step 4: In your workspace it's created by "dbo" schema, in below screenshot by default it should be empty files/folders.

     

     

    Step 5: Finally load you CSV files into Tables.

     

  • Hongju_Jung's avatar
    Hongju_Jung
    Super User
    2 years ago

    Hi, VinayKumar7 

     

    Thank you for your response.

     

    I tested the same again in the workspace where the error occurred, but it works fine.

    I then created new workspaces (letters only, lettes with space, and non-alphabetic letters) and tested them, and they work fine.

     

    So, the feature is in preview.

     

    Thanks,

    Hong