Connect Snowflake from Rakam

With the native integration with Snowflake, you can model your data and build up analytical interfaces for end-users.

Once the data analyst model your data,

The non-technical people will see the similar interfaces to run queries on data easily:

Segmentation

for product managers

Event metrics and Transactional Data

Drill-down and pivot your data in order to understand how to data distributes.

SELECT
                        
      CAST(DATE_TRUNC('week', "install_date") AS DATE) ,   
      "apps"."name" AS "name",
      sum("iap_revenue") AS "Revenue"
  FROM
     "tenjin"."reporting_cohort_metrics"
  LEFT JOIN
       "tenjin"."apps" AS "apps"
          ON
          (
              "reporting_cohort_metrics"."app_id" = "apps"."id"
       )
  WHERE(
          "apps"."platform" = 'ios'
        )
      AND(
          "install_date" BETWEEN '2019-10-30' AND '2019-11-13'
          )
  GROUP BY
      1,
      2
  ORDER BY
      1 DESC

Compiles to this SQL query

The UI above compiles this SQL query. Hover the SQL in order to see the details.

P.S: The users can export the SQL query whenever they want and customize it later on.

Why Rakam?

You don't have to write SQL for every report.

You might be familiar with SQL but not all the people are. We have a data modeling language that lets you model your data once and build up analytical interfaces that can answer complex questions.

Our services