notebook-refresh-tables-in-sql-endpoint

Refresh Tables in the SQL Endpoint

There is a public REST API for synchronising the delta tables in Onelake with the SQL Analytics Endpoint. Details on the REST API can be found here.

New REST API

An updated REST API has been released, which follows the long running operation (LRO) implementation. It is slightly different from the old REST API.
Please update any references to the old REST API, to use this new one.

User Data Function example

Using a service principal - This example is for a User Data Function. Copy and paste the code into a new User Data Function and add the libraries. This can be called from other services in Fabric, i.e. notebooks and pipelines.

Notebooks examples

Using users context - This uses the authenication token of the current user.

Using a service principal - This allows you to use a service prinipal

Using users context with search by name - This uses the authenication token of the current user and searches the Lakehouse by name

Old

REST API is an example of using the 'old' REST API. (This is here for reference only)