Set up Openflow - Snowflake Deployment: Create deployment¶

After configuring Core Snowflake, you can create an Openflow deployment.

Creating a deployment is a two step process:

  1. Create a deployment - create the deployment itself.

  2. [Optional] Configure Openflow-specific Event Table - configure an Openflow-specific event table to store Openflow logs and metrics.

Create a deployment¶

  1. Sign in to Snowsight with a role defined in Configure core Snowflake requirements.

  2. Navigate to Data » Openflow.

  3. Select Launch Openflow.

  4. In the Openflow UI, select Create a deployment. The Deployments tab opens.

  5. Select Create a deployment. The Creating a deployment wizard opens.

  6. In the Prerequisites step, ensure that you meet all the requirements. Select Next.

  7. In the Deployment location step, select Snowflake as the deployment location. Enter a name for your deployment. Select Next.

  8. Select Create Deployment.

Your deployment will then be created.

[Optional] Configure Openflow-specific Event Table¶

Note

This task must be performed by a combination of Snowflake administrator and Openflow administrator.

Openflow generates logs and metrics and sends them to the Snowflake Event Table. See the Monitor Openflow for helpful queries that can be used to analyze this Openflow telemetry data.

By default, Openflow uses the account event table but customers can choose to use an Openflow-specific event table per deployment as well.

To create an Openflow-specific event table, perform the following tasks:

Note

<DATABASE> denotes the name of the database that will contain the event table. <SCHEMA> denotes the name of the schema that will contain the event table. <OPENFLOW_DATAPLANE_UUID> denotes the UUID of the Openflow data plane integration.

  1. Grant required privileges to the OPENFLOW_ADMIN role against the database and schema that will contain the event table:

    Note

    This task must be performed by a Snowflake administrator.

    USE ROLE ACCOUNTADMIN;

GRANT USAGE ON DATABASE <DATABASE> TO ROLE OPENFLOW_ADMIN;
GRANT USAGE ON SCHEMA <DATABASE>.<SCHEMA> TO ROLE OPENFLOW_ADMIN;
GRANT CREATE EVENT TABLE ON SCHEMA <db_name>.<schema_name> TO ROLE OPENFLOW_ADMIN;
    Copy

  2. Create the event table and associate it with the Openflow data plane integration:

    USE ROLE OPENFLOW_ADMIN;

CREATE EVENT TABLE IF NOT EXISTS <DATABASE>.<SCHEMA>.EVENTS;
SHOW OPENFLOW DATA PLANE INTEGRATIONS;

ALTER OPENFLOW DATA PLANE INTEGRATION
  <OPENFLOW_DATAPLANE_UUID>
  SET EVENT_TABLE = '<DATABASE>.<SCHEMA>.EVENTS';
    Copy

Next steps¶

Create runtime role

Language: English