Release 6.8.2
Page tree


Support | Blog | Contact Us 

Versions Compared

Old Version 4

changes.mady.by.user docuser1

Saved on

compared with

New Version Current

changes.mady.by.user docuser1

Saved on

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 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.
    This database must include a PUBLIC schema. For more information, see Enable Snowflake Connections
  • S3 bucket: The user-created stage must point to the same S3 bucket as the default bucket in use 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 Settings menu > Settings > 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

. InfoNOTE: 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.

...

© 2013-2023 Alteryx® Inc Privacy Policy  |  Terms of Use