- Bring Your Own DB
Bring Your Own DB (BYODB)
The KBC Storage component manages different kinds of data.
Normally, we provide all of the backend technologies for your project, so that you do not have to
worry about anything. However, you might want to use your own database with KBC in the following situations:
- You already use a Redshift or a Snowflake database.
- You want to use them for other purposes as well.
- You want to customize them somehow.
If you decide to use your own database, consider using your own S3 Storage as a backend for KBC
File Storage as well.
It makes sense in case you use it anyway, or if you want to have your database in
another region than our standard AWS region
us-east-1 (US East (N. Virginia)).
Because of substantial traffic between Table Storage
and File Storage, it is advisable to have both S3 and the database in the same AWS
region. Traffic across regions is less efficient and more expensive.
If you want to create a new project on your own database, follow these steps:
- For Redshift:
- Set up a Redshift cluster.
If you have no preference over the region, use
- Create a Redshift Superuser.
- Make sure the Redshift DB has a public IP address.
- Set Allow Version Upgrade to true.
- For Snowflake:
- Create a Warehouse.
- Create a user according to our API instructions.
- Optionally, set up Amazon S3 based on our CloudFormation template.
- Collect the credentials to be shared with Keboola Support:
- For Redshift —
region are required.
- For Snowflake —
password are required.
- For S3 —
name of the bucket for storage are required.
- Contact your Maintainer or Support, and request a new
project (or project migration). Provide us with the credentials and, in case of project migration, also with the
project ID (or URL) and preferred maintenance window.