Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version r0641

...

  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.

...

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.

...