...

1. In the Import Data page, navigate your environment to locate one of the files or tables that you wish to parameterize.  

2. Click Create Dataset with Parameters. 

    
   

   D caption
   Create Dataset with Parameters

3. Within the Define Parameterized Path, select a segment of text. Then select one of the following options:
   1. Add Datetime Parameter
   2. Add Variable
   3. Add Pattern Parameter - wildcards and patterns
   4. For more information on limitations, see Overview of Parameterization.
   5. If you need to navigate elsewhere, select Browse.
4. Specify the parameter. Click Save.

5. Click Update matches. Verify that all of your preferred datasets are matching.

   Info
   NOTE: If you are matching with more datasets than you wish, you should review your parameters.

6. Click Create.

7. The parameterized dataset is loaded. See Import Data Page.

A flow containing a dataset with parameters has additional options for managing them. See Flow View Page.

Add Datetime Parameter

Datetime parameters require the following elements:

...

Default Value: If the variable value is not overridden at execution time, this value is inserted in the variable location in the path.

...

Uses:

• Parameterized bucket names are very useful when you are moving flows between workspaces or projects. When the flow is imported into a new workspace, the environment parameter references the appropriate bucket name in the new workspace. 
• If you change source buckets or move data to a new storage bucket, updating the paths to your objects can be as simple as changing the value of the environment parameter where your data is stored.

...

$env.sourceBucketName = 'MyCo_Dev'

$env.sourceBucketName = 'MyCo_Prod'

For more information, see Overview of Parameterization. see Environment Parameters Page.

Add Pattern Parameter

In the screen above, you can see an example of pattern-based parameterization. In this case, you are trying to parameterize the two digits after the value: POS-r.

...

• If disabled, the scan stops when the next slash (/) in the path is encountered. Folders are not matched. 

• If enabled, the scan continues to any depth of folders.

  Info
  NOTE: A high number of files and folders to scan can significantly increase the time required to load your dataset with parameters.

Example 1: all text files

Suppose your file and folder structure look like the following:

...

The following regular expression matches the same two sources in the previous screen:

...

A 

...

This simpler syntax is easier to parse and performs the same match as the regular expression version.

For more information on