Connector Improvement: Akamai Janrain Connector - Create new child table from sample_ability column
Answered
I have an Akamai Janrain connector from which we are extracting data to snowflake. The data is mainly in entity table. Few columns on the source data contains list of json objects so they are stored as new child tables (entity_client, entity_optins, entity_post_login). This is the standard structure.
But, there is one more column sample_ability which also contains list of json objects and we should have a separate child table for that as well. Already the data is mapped with UUID so the data can be stored to new table. Attaching the current schema structure and output of sample_ability column in snowflake from entity table below.
Akamai Janrain ERD link : https://fivetran.com/connector-erd/akamai
-
Official comment
Hi Sameer,
Thank you for your feature request regarding the Akamai Janrain connector. While we understand the potential benefits of creating a separate child table for the `sample_ability` column, this request falls outside Fivetran's current strategic focus. However, we will continue to track interest in this feature and reevaluate it as priorities evolve.
Best,
Sanjeevv Maniram T
Please sign in to leave a comment.
Comments
1 comment