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 datacoral password

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

set datacoral password

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

set datacoral password

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.

Next steps