Paramaterise the Schema Name in connection to Databricks

[rosherg]

i have a dataset where all of the data exists in an Azure Databricks server, I can paramaterise the http and sql end point connections but within the hive_metastore I have multiple schemas and want to parametarise the schema name but can seem to work out how?

[Anonymous]

Hi @rosherg ,
Based on your description, to parameterize an architecture name in Azure Databricks, you can pass the parameter to the notebook's functionality using a property in the Azure Databricks activity in the Data Factory pipeline. This method allows the architecture name to be set dynamically during the execution of the Azure Databricks activity, and then the name can be used in the data processing logic.
You can refer to these documents for more details:
Azure Databricks activity - Microsoft Fabric | Microsoft Learn
Notebook activity - Microsoft Fabric | Microsoft Learn
Work with Unity Catalog and the legacy Hive metastore - Azure Databricks | Microsoft Learn

Best regards,

Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[rosherg]

Thanks for the reply, I was really hoping to be able to parametrise this at the Power Bi end so within the connection string