Creating Database in Datalake Gen2

Muthusankari 21 Reputation points
2023-01-02T09:52:37.043+00:00

Need to create a database in azure datalake. But now with Gen2, I am not able to a way to create a database. Also, needs to create the tables, schemas and scripts to run on the table. Can you please provide me the solution

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
895 questions
No comments
{count} votes

Accepted answer
  1. AnnuKumari-MSFT 19,116 Reputation points Microsoft Employee
    2023-01-25T08:46:52.92+00:00

    Hi Muthusankari ,

    Welcome to Microsoft Q&A platform and thanks for posting your question here.

    As I am trying to understand your question, it seems you want to find a way to create database in azure datalake storage and tables within it. However, it doesn't seem to be feasible.

    ADLS Gen2 includes most of the features from both ADLS Gen1 and Azure Blob storage, including:

    • Limitless storage capacity
    • Azure Active Directory (AAD) integration
    • Hierarchical File System (HFS)
    • Read-access geo-redundant storage
    • 5 TB file size limit
    • Blob tiers (Hot, Cool, Archive)

    However, if you want to create database and table within , either you should opt for Azure SQL database, or check Azure Synapse capabilities to leverage Lake database .

    If this doesn't answer your question, kindly share some more details on what you are trying to achieve by posting screenshot or sample snippet. Thankyou.


    Hope it helps. Please do consider clicking Accept Answer and Up-Vote for the same as accepted answers help community as well.

    No comments

2 additional answers

Sort by: Most helpful
  1. Garth 4,486 Reputation points
    2023-01-02T13:43:50.07+00:00

    Configmgr is not supported in azure data lakes. Are you in the right group?

    No comments

  2. Simon Ren-MSFT 13,226 Reputation points Microsoft Employee
    2023-01-05T09:22:48.483+00:00

    Hi,

    About Azure question, you can contact Azure support to get more accurate help. Here are the links:

    https://learn.microsoft.com/en-us/answers/topics/azure-data-lake-storage.html
    https://learn.microsoft.com/en-us/answers/products/azure?product=all

    Thanks for your time. Have a nice day!

    Best regards,
    Simon


    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    No comments