Install the latest .whl package
Check here to see the latest version.
%pip install semantic-link-labs
Import the library and necessary packages
import sempy_labs as labs
lakehouse_name = ''
lakehouse_workspace_name = ''
warehouse_name = ''
warehouse_workspace_name = ''
Run a SQL query (or queries) against a Fabric warehouse
with labs.ConnectWarehouse(warehouse=warehouse_name, workspace=warehouse_workspace_name) as sql:
df = sql.query("SELECT * FROM Product")
display(df)with labs.ConnectWarehouse(warehouse=warehouse_name, workspace=warehouse_workspace_name) as sql:
dfs = sql.query(["SELECT * FROM Product", "SELECT DISTINCT [Category] FROM Product"])
for df in dfs:
display(df)See the tables in a warehouse
labs.get_warehouse_tables(warehouse=warehouse_name, workspace=warehouse_workspace_name)
See the columns in each table in a warehouse
labs.get_warehouse_columns(warehouse=warehouse_name, workspace=warehouse_workspace_name)
Run a T-SQL query (or queries) against a Fabric warehouse
with labs.ConnectWarehouse(warehouse=warehouse_name, workspace=warehouse_workspace_name) as sql:
sql.query("CREATE SCHEMA [Business]")with labs.ConnectWarehouse(warehouse=warehouse_name, workspace=warehouse_workspace_name) as sql:
sql.query(["CREATE SCHEMA [Business]", "CREATE SCHEMA [Marketing]"])Run a SQL query (or queries) against a Fabric lakehouse
with labs.ConnectLakehouse(lakehouse=lakehouse_name, workspace=lakehouse_workspace_name) as sql:
df = sql.query("SELECT * FROM Product")
display(df)with labs.ConnectLakehouse(lakehouse=lakehouse_name, workspace=lakehouse_workspace_name) as sql:
dfs = sql.query(["SELECT * FROM Product", "SELECT DISTINCT [Category] FROM Product"])
for df in dfs:
display(df)
https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fsemantic-link-labs%2Fblob%2Fmain%2Fnotebooks%2FSQL.ipynb
