10 days of Microsoft Fabric challenge – #7 Data Warehouses in Fabric

  • 10 days of Microsoft Fabric challenge – #7 Data Warehouses in Fabric

    Posted by Pablo Moreno on July 4, 2023 at 8:12 am

    Hello community,

    here is the post of my key take aways for section 7 of the 10 days of Microsoft Fabric challenge “Get Started with Data Warehouses in Microsoft Fabric”:

    1. Data Lake <> Data Warehouse <> Data Base <> Data Mart, oh yes! each one has its own purpose

    2. SQL is your best friend here

    3. There are some limitations nowadays, as some table features are not supported yet in Fabric Warehouses

    Hey @Victoria , what do you think?

    If you are interested to be involved at the 10 days of Microsoft Fabric Challenge, just visit: Collections – cloudskillschallenge | Microsoft Learn

    Victoria Temitope replied 10 months, 4 weeks ago 2 Members · 1 Reply
  • 1 Reply
  • Victoria Temitope

    Member
    July 4, 2023 at 9:20 am
    Up
    0
    Down
    ::

    1. Emphasizing on SQL, knowledge of SQL Server Management Studio (SSMS) or any other SQL client is essential to create tables in the data warehouse.

    2. For more information on the Tables in data warehousing, this documentation expands on it –https://learn.microsoft.com/en-us/fabric/data-warehouse/tables

    3. You can query data from the warehouse using the Visual Query editor or SQL query editor.

    4. The security of the data warehouse is very important. Take advantage of the role-based control in Fabric to prevent unauthorized access to your data.

Log in to reply.

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!