Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Integration: Your  

    D s item
    iteminstance
     is connected to an EMR cluster.

    Info

    NOTE: EMRFS Consistency View must be enabled.

    See Configure for EMR.

  • Deployment:  
    D s platform
    is deployed in EC2.
  • PUBLIC schema: If you do not create an external staging database:
    • A PUBLIC schema  schema is required in your default database.
    • If you do not provide a stage database, then a temporary stage is created for you under the the PUBLIC schema  schema in the default database.
  • S3 bucket: The  The user-created stage must point to the same S3 bucket as the default bucket in use by by 
    D s product
    .
  • Same region:  The Snowflake cluster must be in the same region as the default S3 bucket.

...

  1. Login to the application.
  2. In the menu, click User menu > Preferences > Connections.
  3. In the Create Connection page, click the Snowflake connection card.
  4. Specify the properties for your Snowflake database connection. The following parameters are specific to Snowflake connections:

    Info

    NOTE: In Snowflake connections, property values are case-sensitive. Snowflake-related locations are typically specified in capital letters.


PropertyDescription
Account Name

Snowflake account to use. Suppose your hostname is the following:

Code Block
mycompany.snowflakecomputing.com

Your account name is the following:

Code Block
mycompany


WarehouseThe name of the warehouse to which to connect
Stage

If you have deployed a Snowflake stage for managing file conversion to tables, you can enter its name here. A stage is a database object that points to an external location on S3. It must be an external stage containing access credentials.

If a stage is used, then this value is typically the schema and the name of the stage. Example value:

Code Block
MY_SCHEMA.MY_STAGE	

If a stage is not specified, a temporary stage is created using the current user's AWS credentials.

Info

NOTE: Without a defined stage, you must have write permissions to the database from which you import. This database is used to create the temporary stage.


For more information on stages, see https://docs.snowflake.net/manuals/sql-reference/sql/create-stage.html.

Database for Stage

(optional) If you are using a Snowflake stage, you can specify a database other than the default one to host the stage.

Info

NOTE: If you are creating a read-only connection to Snowflake, this field is required. The accessing user must have write permission to the specified database.

If no value is specified, then your stage must be in the default database.

For more information, see Create Connection Window.

...