Informatica PowerCenter: Prepare the data source files for Cloud Storage connection

Prepare the data source files and store them in your cloud-based storage system. The files must be in one of the following:

• An AWS S3 bucket.
• An Azure Data Lake Storage container.
• A Google Cloud Storage bucket.

1. In the dbt Core environment, locate the target/ directory of your dbt project. The target/ directory must contain the manifest JSON file and compiled SQL files. This directory is created by running the dbt run and dbt compile commands.
2. If the target/ directory does not exist or the directory does not contain the manifest JSON file or compiled SQL files, complete the following steps to create the directory and the required files:
   1. Set the profile of your dbt Core to the environment that you want to retrieve the lineage information from.
   2. Use the dbt compile command to generate SQL files. For details, go to About dbt compile command and Manifest JSON file in dbt documentation.
3. Store the target/ directory in a bucket or directory in your cloud-based storage system and ensure that you maintain the folder structure. The bucket or container must contain all files and subdirectories, such as target/manifest.json and target/compiled/project-name/models/.

What's next

Add the Technical Lineage for Informatica PowerCenter (Cloud) capability for Cloud Storage connections.