Add an Extract for Snowflake

Learn to capture data from a Snowflake source in OCI GoldenGate.

Before you begin

Ensure that you have:

Add an Extract

  1. In the OCI GoldenGate deployment console navigation menu, select Extracts.

  2. On the Extracts page, select Add Extract.

  3. In the Add Extract panel, on the Extract Information page, complete the following fields as needed, and then select Next:

    1. Enter a Process Name, no more than 8 characters long.

    2. (Optional) Enter a Description to help you distinguish this process from others.

    3. Select Snowflake from the Source dropdown.

    4. Select an Extract Type:

  4. On the Extract Options page, complete the following fields as needed, and then select Next:

    1. Select Source Credentials.

    2. For Extract Trail:

      1. Enter a Name for the Extract process.

      2. Enter Trail Sequence to set the starting number for Trail files.

      3. Enter a Trail Size to set the max size for the generated trail file.

      4. For Begin, select when to start the extract. For more details, see Precise instantiation for Oracle using Initial Load Extract.

      5. Select an Encryption Profile. The Local Wallet profile is selected by default if an encryption profile wasn’t created.

      6. Select an Encryption Algorithm.

  5. On the Managed Options page, complete the following optional fields as needed, and then select Next:

    • Profile Name

    • Critical to deployment health

    • Auto Start

    • Auto Restart

  6. On the Parameter file page, update the source mapping. For example: TABLE "CATALOG_A"."SALES"."ORDERS";

  7. Select Create and Run to create and start the Extract. If you select Create, then you can manually start the Extract later from the Extracts page.

You return to the Extracts page, where you can view the status of the Extract process. Select Details from the Extract Action menu to view process information, checkpoint, statistics, parameters, and reports.