- 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.
- 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.
is connected to an EMR cluster.
D s item item instance Info
NOTE: EMRFS Consistency View must be enabled.
See Configure for EMR.
is deployed in EC2.
D s platform
- PUBLIC schema: If you do not create an external staging database:
PUBLICschema is required in your default database.
- If you do not provide a stage database, then a temporary stage is created for you under the
PUBLICschema 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
- You cannot perform ad-hoc publication to Snowflake.
- SSO connections are not supported.