Fivetran HVR 04 - Setup Destination Snowflake Database

Creating a Snowflake account and setting up a database involves several steps, including signing up for the service, configuring your environment, and creating the necessary database objects. Here's a step-by-step guide to get you started:

Step 1: Sign Up for a Snowflake Account

• Visit the Snowflake Website:

• Go to the Snowflake sign-up page.

• Fill in Your Details:
• Provide your name, company, email address, and other required information.
• Choose your cloud provider (AWS, Azure, or Google Cloud) and region where you want your Snowflake instance to be hosted.

• Complete the Registration:

• Submit the form and follow the instructions in the confirmation email you receive to activate your account.

Step 2: Log In to Your Snowflake Account

• Access the Snowflake Console:

• After activation, log in to your Snowflake account using the URL provided in the confirmation email.
• The URL typically looks like https://<account_name>.snowflakecomputing.com.

Step 3: Create a Database

• Open the Snowflake Web Interface:

• Once logged in, navigate to the Snowflake web interface.

• Navigate to Databases:

• In the top menu, click on Databases to open the databases section.

• Create a New Database:

• Click on the Create button to open the Create Database dialog.
• Enter the name for your new database and provide any optional comments.
• Click Finish to create the database.

Alternatively, you can use SQL to create a database:

CREATE DATABASE HVR_DESTINATION;