Hi Team, In CDP License Usage section, we can see an Addressable Audience count in the Usage. There is no split between B2B or B2C component in it. Is there a way we can look into the split based on Profile Dataset or any other approach? considering we have B2P license. And How is the Addressable au...

Thank you @nnakirikanti , I tried using the explode function as you suggested and the query is working now. Thank you for the support!

Hi @hariprasathg  I tried the following syntax -  (changing the position of ' in ANY clause)1. select * from TEST_DATASET where ENTITLEMENTINFO.EUPID = ANY('{prod1}')ErrorCode: 08P01 queryId: d3ae9b28-dd4b-44c5-ae86-58286844b2d1 Unknown error encountered. Reason: [cannot resolve '(`entitlementinfo`....

Hi Team, I am trying to query service for a dataset 'TEST_DATASET" which has an Array field - "products"I am trying to query in Query Service -select field1, field2, field3, productsfrom TEST_DATASETwhere VARCHAR(products) like '%pencil%'  Basically i am trying to check if the 'product' field, which...

@jayakrishnaaparthasarathy  the DateTime field is in CDP, but in the source data (snowflake in this case) - the data value is a Varchar. So CDP won't perform conversion in this case i believe?  Snowflake View ABC -----------------------> source ingestion ----->  CDP Schema ABC (field name - loginDat...

thanks @hariprasathg that is helpful.

Hi Team, If Snowflake is the source connection to CDP and LoginDate field is a Varchar in snowflake View 'ABC' - when dataflow is created for the View ABC to ABC Schema in CDP, and the data type of field LoginDate is set up as DateTime in Schema.. will CDP automatically convert the data type of that...

Thanks @arpan-garg , this makes sense. Will try using scheduled query

Hi @Verticurl  I'm not sure if I understand this correctly. The Sources of XDM individual profile Schema and Lookup Schema (with relationship) are Snowflake, through Daily Batch ingestion. I created segment using attributes of both these Schemas to test stitching and exporting Email from XDM schema ...

Hi Team, I have created a segment and exporting Profile attribute (email address identity map) to the destination (SFTP). Can I export a Lookup Schema attribute along with Email for the segment (eg: Campaign name, IDs etc?)