Snow Flake Integration with OACS

Snowflake Integration with OACS.

Snowflake is an analytical data warehouse provided as a software as a service (SaaS).

It provides a data warehouse that is faster and easier to use and more flexible.

Multiple ways to connect snowflake.

      1. Command Line Utilities. (SnowSQL)

      2. ODBC and JDBC drivers that can be used by other applications. (Tableau)

      3. Native Connectors. (Python)

    4. Third party connectors can be used to connect applications such as ETL and BI tools to snowflake.

Steps to Integrate snowflake with Data Visualization (DV).

    1. Create a snowflake account.

          www.snowflake.com

    2.  First we need to create one snowflake account by filling the details as shown in below figure.

    3. Here we have editions in snowflake.

          1. Standard

          2. Premier

          3. Enterprise

          4. Business Critical.

    4. We need to choose one cloud account.

    5.  After filling all the details of the snowflake account, then we get one snowflake worksheet as shown in below.

    6.    Here we can create one data warehouse and one database.

Initially we have some sample databases.
   7.  If we want to create one new database, we can create by clicking on databases.

    8.  Similarly, we can also create data warehouse by clicking on warehouses.

    9.  Here I used one sample database which was already created in snowflake to connect with DV.

    10.  Here I used snowflake sample data as my database to connect with DV.

Under that database we have some schemas and tables.

    11. After creation of the database in snowflake we can connect with DV.

        12.  Open the Oracle cloud account and fill the credentials to open.

   13.  We need to create one connection to integrate with snowflake.

   14.  Select snowflake data warehouse as connection type and fill the details of the connection.

   15.    Then we need to create data set to build project in DV.

   16.    We need to select snowflakec as a source.

   17.    In below figure, we have different schemas to select any schema to build data set.

   18.    After selecting different data sets, we need to create joins between that data sets.

   19.    We can create one visualization by selecting columns in different data sets.

This is the process to integrate snowflake with DV.