Page tree

Versions Compared

Key

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

...

  • Snowflake is an S3-based data warehouse service hosted in the cloud. Auto-scaling, automatic failover, and other features simplify the deployment and management of your enterprise's data warehouse. For more information, see https://www.snowflake.com

Pre-requisites


  1. S3 base storage layer: Snowflake access requires installation of
    D s item
    itemsoftware
    in the AWS infrastructure and use of S3 as the base storage layer, which must be enabled. See Set Base Storage Layer. 
  2. Same region:  The Snowflake cluster must be in the same region as the default S3 bucket.
  3. Integration: Your  

    D s item
    iteminstance
     is   is connected to an EMR cluster. 

    Info

    NOTE: EMRFS Consistency View must be enabled.

    See

    See Configure for EMR.

  4. Deployment: 

    D s platform
    is deployed in EC2.


  • PUBLIC schema: If you do not create an external staging database:
    • A PUBLIC 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 PUBLIC schema in the default database.
  • S3 bucket: The user-created stage must point to the same S3 bucket as the default bucket in use by 
    D s product
    .

Limitations

  • You cannot perform ad-hoc publication to Snowflake.
  • SSO connections are not supported.

...

  1. Login to the application.
  2. In the menu, click Settings menu > 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.

For more information, see Create Connection Window.

...