Snowflake - Add data-heap and data-test events column in snowflake.

[rashidakanchwala]

Description

Currently, the data-test and data-heap-event attributes, which provide information about the elements users click on, are part of a long string. We currently extract this data using Tableau; however, it would be ideal to have tables created directly in Snowflake. This ticket aims to create a view in Snowflake with additional columns to extract and store this information.

Checklist

• Include labels so that we can categorise your feature request

[rashidakanchwala]

Getting this error - SQL execution error: Creating view on shared database 'HEAP_FRAMEWORK_VIZ_PRODUCTION' is not allowed.
FYI - @astrojuanlu

[astrojuanlu]

The error message says it all, the Heap exports are read-only. We have a KEDRO_BI_DB database with write access (role KEDRO_BI_ROLE, your account has it).

[rashidakanchwala]

I tried creating view there, but because it's two different warehouses; it's not allowing me

[astrojuanlu]

Then the only way will be having an ETL pipeline... hopefully with Kedro :) similar to

It's a good opportunity to aggregate the information and filter only what we need kedro-org/kedro-devrel#145

[astrojuanlu]

We won't do the ETL for now, @rashidakanchwala will make the change in Tableau directly