How to enable profile for ad-hoc datasets (generated from query output)

[Umamaheswari_Yakkala]

Hi Team ,

I have generated a dataset from the query output and plan on using it for segmentation.

In order to use this dataset for segmentation, I need to enable it for profile, right? if yes, how do I need to enable or what other options do I have ?

Thank You,

UMa

[Danny-Miller · Accepted solution]

I would consider two approaches if you are creating the dataset and want to enable it for Profile:

1. Specifying the schema when creating it
   1. https://experienceleague.adobe.com/docs/experience-platform/query/sql/syntax.html?lang=en#create-tab...
2. Create the dataset beforehand and using INSERT INTO
   1. https://experienceleague.adobe.com/docs/experience-platform/query/sql/syntax.html?lang=en#insert-int...

I believe both will allow you to enable the dataset for Profile.