The Snowflake Open Catalog, storage bucket, and StreamNative BYOC Ursa cluster should be in the same cloud provider and region. Snowflake Open Catalog doesn’t support cross-region buckets. To avoid costs associated with cross-region traffic, we highly recommend your storage bucket and StreamNative BYOC Ursa cluster are in the same region.Edition: any
The Snowflake Open Catalog, storage bucket, and StreamNative BYOC Ursa cluster should be in the same cloud provider and region.** Snowflake Open Catalog doesn’t support cross-region buckets. To avoid costs associated with cross-region traffic, we highly recommend your storage bucket and StreamNative BYOC Ursa cluster are in the same region.Option 1: Use your own bucket (recommended) You need to create your own storage bucket, with the option to create a bucket path. When using your own bucket, the resulting path you will use for creation of the Snowflake Open Catalog will be as follows. The compaction folder will be created automatically by the StreamNative cluster. AWS
s3://<your-bucket-name>/<your-bucket-path>/compaction
GCP
gs://<your-bucket-name>/<your-bucket-path>/compaction
Azure :
The option to use your own bucket is currently not available on Azure
StreamNative will require access to this storage bucket. To grant access, execute the following Terraform module based on your cloud provider.
Terraform module for AWS
s3://<your-cloud-environement-id>/<your-cluster-id>/compaction
GCP
gs://<your-cloud-environment-id-tiered-storage>/<your-cluster-id>/compaction
Azure
gs://<your-cloud-environment-id-tiered-storage>/<your-cluster-id>/compaction
<your-bucket-name>
and <your-bucket-path>
s3://<your-bucket-name>/<your-bucket-path>/compaction
StreamNative provided bucket:
s3://<your-cloud-environement-id>/<your-cluster-id>/compaction
gs://<your-bucket-name>/<your-bucket-path>/compaction
gs://<your-cloud-environment-id>/<your-cluster-id>/compaction
<your-bucket-name>
<your-cloud-environment-id-tiered-storage>
<CLIENT ID>:<SECRET>
. Our engine needs it to access the Snowflake Open Catalog.
s3://<your-cloud-environement-id>/<your-cluster-id>/compaction
e.g.
s3://aws-usw2-test-rni68-tiered-storage-snc/o-naa2l-c-vo06zqe-ursa/compaction
GCP
gs://<your-cloud-environment-id-tiered-storage>/<your-cluster-id>/compaction
AZURE
abfss://tiered-storage@<your-storage-account>.dfs.core.windows.net/<your-organization-and-cluster-id>/compaction
e.g.
gs://gcp-usw2-test-hhein-tiered-storage/o-78m1b-c-9ahma2v-ursa/compaction
Note : If you are using the StreamNative provided bucket, do not close the browser while creating the catalog. This will cause StreamNative to create a new cluster id. Once a catalog is created in Snowflake Open Catalog, the base location and additional locations cannot be changed. If the cluster id changes, you would need to create a new catalog.To integrate with Snowflake Open Catalog, Enable Catalog Integration and select Snowflake Open Catalog.
<CLIENT ID>:<SECRET>
s3://<>/<>/compaction
.<CLIENT ID>:<SECRET>
for Snowflake Open Catalog to allow access for Snowflake. The <CLIENT ID>
refers to OAUTH_CLIENT_ID and <SECRET>
refers to OAUTH_CLIENT_SECRET.