Replace Placeholders
      Back to home
      1. biGENIUS-X Help Center
      2. Generators
      3. Replace Placeholders

      Microsoft Fabric - Replace the placeholders - 1.4

      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.

      For executing commands with Powershell later in this article, please use at least version 7 provided by Microsoft. If you would like to install the latest version, please check here.

      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_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:

      Currently, all the Target Parquet files should be stored in the default Tables folder. Soon, Microsoft Fabric's new releases will allow storing them in subfolders by Layer for example.

      Please delete in the replacement_config.json file all the values filled by the generator for database_name.

          • 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/

      All the paths should have a slash appended at the end: 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

      Some parameters can be added to the replace_placeholders.ps1 command.

      All are described and available by executing:

      .\replace_placeholders.ps1 - help

      The -ReplacementConfigPath parameter mainly allows using a replacement_config.json file in another path. It is beneficial when you are in a development mode for your project.

      Example of usage:

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

      If you run into any issues, please refer to our FAQs section about Generating Artifacts: