Project UDFs (Databricks)
You can switch project contexts and view a list of your current project or available projects through UDFs in Spark.
Available functions
| UDF | Description |
|---|---|
| immuta.set_current_project(id) | Sets the user's current project to the project ID denoted by the id parameter. This UDF must be called in its own notebook cell to ensure the changes take effect. |
| immuta.set_current_project() (no parameters) | Sets the user's current project to None. |
| immuta.clear_caches() | Clears all client caches for the current user's ImmutaClient instance. This can be used when a user would like to invalidate cached items, like data source subscription information or if the state of Immuta has changed and the cache is outdated. For backward compatibility, this UDF is also available at default.immuta_clear_caches() |
| default.immuta_clear_metastore_cache() | Clears the cluster-wide Metastore cache. This UDF can only be run by a privileged user. |
Virtual tables
To view a list of your current project or available projects in a Spark job, you can query these virtual tables.
| Virtual Table | Query | Return |
|---|---|---|
| immuta.get_current_project | select * from immuta.get_current_project | This virtual table returns a single row with "name" and "id" columns that show your currently selected project. |
| immuta.list_projects | select * from immuta.list_projects | This virtual table returns rows with "name," "id," and "current_project" columns. Each row is a different project to which you are subscribed (and can use as your current project). The "current_project" row will be true for the row defining the project that you have set as your current project. |