How to enable profile for ad-hoc datasets (generated from query output) | Community
Skip to main content
Umamaheswari_Yakkala
Community Advisor
Umamaheswari_YakkalaCommunity Advisor
Community Advisor
December 5, 2022
Solved

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

  • December 5, 2022
  • 1 reply
  • 895 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Danny-Miller

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-table-as-select
  2. Create the dataset beforehand and using INSERT INTO
    1. https://experienceleague.adobe.com/docs/experience-platform/query/sql/syntax.html?lang=en#insert-into

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

1 reply

Danny-Miller
Adobe Employee
Danny-MillerAdobe EmployeeAccepted solution
Adobe Employee
December 5, 2022

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-table-as-select
  2. Create the dataset beforehand and using INSERT INTO
    1. https://experienceleague.adobe.com/docs/experience-platform/query/sql/syntax.html?lang=en#insert-into

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

    Terms & ConditionsAccessibility statement

    Loading footer...