Microsoft Fabric Stage Files - Replace the placeholders - 1.5

The Generated Artifacts zip file contains files with placeholders for the target environment parameters.

You should replace all the placeholders to deploy to Microsoft Fabric Target System.

Replace the Placeholders

A toolkit is provided in the generated artifacts to replace the placeholders.

It is composed of a Powershell script to execute: replace_placeholders.ps1.

The process to follow is:

• Update the replacement_config.json file with your values:
  
  • Insert the value to replace into the value node
• Each database_name is filled by default with the layer name (example: rawvault)
  • It should contain the database name of the target lakehouse
    • In our example, we want to create the target tables in the lakehouse bglakehouse1

• Each database_directory placeholder should contain the path to create the Target Parquet files
  • • If you are using our Microsoft Fabric environment example, you can copy the path by:
      • Opening the Lake House (bglakehouse1 in our example) in the left menu:
        
      • Opening the Context menu of the Tables folder and choosing the Properties entry:
        
      • Copying the ABFS path:
        

• Each file_path placeholder should contain the path where the Source Parquet files are available.

• • If you are using our Microsoft Fabric environment example, you can copy the path by:
    • Opening the Lake House (bglakehouse1 in our example) in the left menu:
      
    • Opening the Context menu of the Files folder and choosing the Properties entry:
      
    • Copying the ABFS path:
      
    • Add at the end your folder structure for each source as for the Creditcard source data:
      • They are stored inside the Files folder on the path Parquet
        
      • The ABFS path of the Files folder is abfss://bgfabricworkspace1@onelake.dfs.fabric.microsoft.com/bglakehouse1.Lakehouse/Files
      • The file_path to fill in the replacement_config.json file for the credit card source is: abfss://bgfabricworkspace1@onelake.dfs.fabric.microsoft.com/bglakehouse1.Lakehouse/Files/Parquet/

Replace the placeholders in the files:

• Open Windows Powershell (or equivalent) in the replace_placeholders.ps1 location:
  
• Execute the following command :

• .\replace_placeholders.ps1

  • You should have a similar result:
    
• The configured values in all generated artifacts replaced the placeholders
• You can now use these files and deploy your Target system

.\replace_placeholders.ps1 - help

.\replace_placeholders.ps1 -ReplacementConfigPath "C:\TEMP\Replacement config files\replacement_config_