Synapse create lake table from data lake giving error: Failed to execute query. Error: CREATE DATABASE failed. User database limit has been already reached (20).

Leslie 56 Reputation points
2022-08-11T21:45:47.727+00:00

I have an existing folder with delta log and parquet files. This was working up until yesterday. I could via workspace/database gui - add a table via "from data lake" and select the folder for that table and it previously would create schema for table. It is now failing with the above error.

This is to create a table in a lake database.

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,671 questions
Azure Data Lake Analytics
{count} votes

1 answer

Sort by: Most helpful
  1. Vinodh247 13,301 Reputation points
    2022-08-12T11:03:21.883+00:00

    Hi Leslie,

    Thanks for reaching out to Microsoft Q&A.

    You are facing issue in creating table but the error states that 'Create database failed'. This happens when you have reached your database creation limits, see the below link from microsoft related to this.

    https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/resources-self-help-sql-on-demand?tabs=x80070002#cant-create-a-database

    Please Upvote and Accept as answer if the reply was helpful.