Creating a Filename Pattern

Filename patterns let you group multiple Object Storage files as logical data entities in data catalog. If an Object Storage file is matched with multiple filename patterns, it can be part of multiple logical data entities.

• Console
• CLI
• API

• 1. On the Home tab of the instance for which you want to create a filename pattern, from the Quick actions section, click Manage filename patterns.
  2. On the Filename Patterns page, click Create Filename Pattern.
  3. In the Create Filename Pattern panel, provide the following details:
     • Name: Enter a name for your filename pattern.

       You can't use the following special characters in the name: & < > " ' / \ = ;

     • Description: Enter a description for the filename pattern.
     • Folder prefix: Select this option to automatically generate logical entities from the starting folder in Oracle Object Storage. If you select this option, Starting Folder field appears. Enter the path of the starting folder in Oracle Object Storage. For example:

       • myFolder1

       • myFolder1/mySubFolder12

     • Regular expression: If you select this option, the following field appears:
       • Expression: Enter a regular expression that corresponds to your Oracle Object Storage files. The files matching this regular expression are grouped into logical data entities in the data catalog. To view examples of the filenames, pattern expressions, and the logical entity names that are derived based on the pattern, click View Pattern Examples.
         • To use the filename pattern of the example, click Select.
         • To return to creating the filename pattern, click Back to Create Filename Pattern.
     • Test Expression: Enter the list of filenames in Test filenames and click Test Expression. The test results show the logical data entities that are derived using the specified expression. Any unmatched files are created as separate file type data entities.

       Modify the filename pattern expression and test it until you get the required logical data entities for your file set.

  4. Click Create.

  Your filename pattern is successfully created. You can now assign this pattern to a data asset. During harvest, these patterns are used to derive logical data entities.

• Use the create command and required parameters to create a filename pattern:

  oci data-catalog pattern create [OPTIONS]

  For a complete list of flags and variable options for CLI commands, see the CLI Command Reference.

• Run the CreatePattern operation to create a filename pattern.