...
- 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
- S3 base storage layer: Snowflake access requires installation of
in the AWS infrastructure and use of S3 as the base storage layer, which must be enabled. See Set Base Storage Layer.D s item item software - Same region: The Snowflake cluster must be in the same region as the default S3 bucket.
Integration: Your
is connected to an EMR cluster.D s item item instance Info NOTE: EMRFS Consistency View must be enabled.
See Configure for EMR.
Deployment:
is deployed in EC2.D s platform - 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.
- A
- 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.
...