Hosted By Datacoral - Setup Guide
Here is a quick guide to sign-up with Datacoral. Click on free trial on the Datacoral website
note
- Please note that Datacoral does not create any data warehouse in this option. You are required to provide credentials of the warehouse that you want to use as destination. Datacoral currently supports loading data into Snowflake and Redshift.
- There are two key prerequisites to connect to your destination warehouse, which will be discussed in detail in subsequent sections
- Grant appropriate privileges for Datacoral to access the warehouse
- Add Datacoral elastic IP to the security group of your destination warehouse
Step 1: Activate your Datacoral account
Invite email: On entering your name, email address, and company name, you will receive an email with a link to create an account. Note that this link expires in 7 days.
Set password: On clicking Get Started button, you will be redirected to the Datacoral web application where you can set the password and activate your free account. On activating, you will receive a confirmation email.
The account will be available for 30 days
Step 2: Choose your installation type
The first step to set up your installation is to provide a team name.
note
- Going forward you will need the team name to login into your account. The team name is unique and cannot be changed after initial setup.
- Datacoral uses the team name to create AWS resources in your installation. Due to restrictions on AWS resource names, the team name has to meet the requirements below:
- Team name can take in alpha-numeric lowercase characters
- The first character should be an alphabet.
- Team name should not exceed 20 characters.
- Select Hosted By Datacoral
Step 3: Choose AWS region
Choose the AWS region of your choice. You will be directed to the warehouse page. The default AWS region is us-west-2, in case of no immediate availability, we will notify you via email when ready.
Step 4: Choose Destination warehouse
We offer support for Redshift and Snowflake warehouses.
Step 5: Add credentials
Redshift warehouse
1. Setup warehouse:
To connect to an existing Redshift cluster with the Datacoral installation, the following steps need to be completed
- Step 1: Create datacoral user
- Step 2: Grant Privileges to datacoral user
- Step 3: Attach Redshift Copy Role to Redshift Cluster
- Step 4: Add Elastic IP to your security group
Please follow the setup steps here before proceeding to add Redshift warehouse to your Datacoral installation
2. Add the connection credentials
Fill in the host, port, database, username, and password.
Snowflake warehouse
1. Setup warehouse:
To connect to an existing Snowflake cluster with the Datacoral installation, the following steps need to be completed
- Step 1: Create datacoral user
- Step 2: Grant Privileges to datacoral user
- Step 3: Attach Role to Snowflake Cluster
- Step 4: Add Elastic IP to your network policy
Please follow the setup steps here before proceeding to add Snowflake warehouse to your Datacoral installation
2. Add the connection credentials
Fill in the below fields as created in Step 1
- Account : The snowflake account name
- Database : The Snowflake database that you created to be populated by Datacoral
- Username : The username that you created for Datacoral as part of prerequisites
- Password : The password you set for the above username
Add the credentials and click on check connection.
Step 6: Add a connector
Choose the connector of your choice to add. Please refer to Ingest connectors to add any connector through the UI.