Forum Discussion

russelp's avatar
russelp
Icon for Helper I rankHelper I
2 years ago
Solved

Getting a list of schema + tables from a warehouse

Hi,   I am trying to automate the creation of shortcuts via the API and one requirement that we have is to create shortcuts in a lakehouse from a warehouse. I am already able to do this if there is...
data engineering
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi russelp 
    Thanks for using Fabric Community.
    Currently we cannot get the information regarding schemas in Warehouse using Fabric Notebooks. 

    However, your suggestion is definitely valuable! We use customer feedback like yours to prioritize future features. The more users who request the ability to customize backgrounds, the higher it moves on our list.

     

    Appreciate if you could share the feedback on our Microsoft Fabric Ideas. Which would be open for the user community to upvote & comment on. This allows our product teams to effectively prioritize your request against our existing feature backlog and gives insight into the potential impact of implementing the suggested feature.

     

    I hope this information helps. If you have any further queries please do let us know.

    Thanks

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

I know this is a year old. But just in case anyone else is searching...

 

You could try:
creating a user data function w/ something like:

    query = f"""
    SELECT '{warehouse}' as WarehouseName,
        s.name AS SchemaName
    FROM
        {warehouse}.sys.schemas s
    """

then in notebook get token, call user data function, get results, transform results as needed. This uses the user data function as a bridge between querying the compute node and saving to storage node.