How to Scale up and down Datawarehouse Fabric compute via ADF

[AJAJ]

Hi there,

Existing environment uses ADF + Azure SQL (500GB) PROVISIONED
Every night ADF triggers, it scales up Azure SQL to vCore 20 and at the End of ADF process scales back to vCore 4 to save cost on unused times.

Q1: Existing set up is Azure SQL but in fabric wanted to use lakehouse approach = fabric warehouse - is there way to scale up or down the fabric dwh compute like F2/F16/F32 (NOT Azure SQL). ALTER DATABASE [',@dbname,'] MODIFY (SERVICE_OBJECTIVE = 'GP_Gen5_20') if yes, what is the equivalent of scaling up and down fabric compute via ADF.

Q2: I assume fabric dwh connects via SSMS. Please guide me if there is a better interface than SSMS.
- Does select * from information_schema.columns / tables work on fabric DWH
- You can right click on SSMS table name, see properties, view dependencies, etc. Is that possible? I use it to see what tables are being used by what SP , etc.

Thanks

[V-yubandi-msft]

Hi @AJAJ ,
Please let us know if you are facing any issues so that we will take a look into it and address ASAP.

Thank You.

[V-yubandi-msft]

Hi @AJAJ ,

Could you let us know if your issue has been resolved or if you are still experiencing difficulties? Your feedback is valuable to the community and can help others facing similar problems.

Thank You.

[V-yubandi-msft]

Hi @AJAJ ,

Alongside the responses already provided, here are some additional details and references.

1. In Fabric, compute for both Warehouse and Lakehouse is provided by a Fabric Capacity (F series SKU such as F2, F4, F16, etc.). Unlike Azure SQL, scaling is not done using ALTER DATABASE ... MODIFY (SERVICE_OBJECTIVE = '...').

2. You can connect to Fabric Warehouse using SQL Server Management Studio. Most standard SQL metadata views, such as INFORMATION_SCHEMA.TABLES and INFORMATION_SCHEMA.COLUMNS, are supported (T SQL support in Warehouse).

You can query object properties in SSMS, but note that some SQL Server features like TRUNCATE TABLE, MERGE, and identity columns are not yet supported in Fabric.

References:

Workload Management - Microsoft Fabric | Microsoft Learn

Limitations of Fabric Data Warehouse - Microsoft Fabric | Microsoft Learn

Regards,
Yugandhar.

[spaceman127]

Hello @AJAJ ,

I would like to add something here.
Power BI Premium P1 can no longer be purchased, with a few exceptions. All Power BI Premium P capacities will be transferred to Fabric's F capacities, which will then be the only ones available for purchase.

Here is an article on this topic. 

https://powerbi.microsoft.com/de-de/blog/important-update-coming-to-power-bi-premium-licensing/

Best regards

[BhaveshPatel]

Hi @AJAJ 

Azure SQL and ADF is running on Windows whereas Delta Lake aka Fabric Data Warehouse running on Linux System. 

To the context, Yes it is feasible to perform select * from information_schema.columns / tables query in Fabric DWH but the concept is totally new to Apache Spark ( Data Lake ) and Delta Lake aka Fabric Data Warehouse. Also,

You can see all the details via right click on SSMS table name, see properties, view dependencies. etc.

There is two ways approaches when scale up and down to fabric datawarehouse or Fabric SQL. In one instance, it is using Power BI Premium Capacity P1 Node where the price is fixed ( P1 Capacity - USD 8,409.60 ) whereas in the other instance, Pay as you go approach, where the pricing is bit more expensive.