Community Topics

HI,I'm working on incremental dataset exports (150 days historical + daily incremental) - Destinations.Quick points I want clarity on: 1. Incremental Export file name : Handling customization filename with timestamps.How are filenames changed or updates when doing this?2. Suppose we've already confi...

Hi all,I would like to know the list of fields that belongs to this metadata path "_acp_system_metadata", I know that one of them is "_acp_system_metadata.ingestTime", but I want the complete list. Please, could anyone provide me this? Thank you! Cristhian N

We are trying to load a table that we created in Query Service for adhoc Dashboard. To load this table containing aggregate stats we are pulling the data from system datasets like ajo_entity_datasets, journey_step_events or Adobe API and then loading the data from Dataframe which hold aggregate data...

I want to write a query that contains the Segment Name within Audiences, as well as each attribute/event that is written within that audience. How can I write this query? 

Hello community,I am trying to use insert into sql command in AEP query services, my end goal is to create a CTAS schedule queries to ingest data from one dataset to another dataset for a specific phone number column. Dataset A has a schema field '_abc.phone.number.number' which has data, Dataset B ...

Query Service - is user able to Create Table ( without Data Distiller SKU ) ?

I would like to understand how FLATTEN feature work. While connecting to Power BI it should be put like that?Then thanks to that I can work with nested tables from Data Lake without the need to make them flat?The other solution which I think about is flattening the Data Lake tables using the Query S...

I have got a problem, do you know what only the highest key in schema hierarchy shows up? Two screenshots for you to understand what I talk about.Of course this column is empty:The particular event as you all know looks like this:  

Hi  I keep getting into this error where I try to access query service and the "Initializing connection..." message in the terminal never disappear and therefore I cannot run queries. I tried clearing the cache, reloading the page multiple times and restarting the browser, but nothing works. This ha...

Hi,  I created a data set few days ago and made simple data ingestion. Ingestion was successful. However if I run query like 'SHOW TABLES' in query service I do not see my dataset. Do you know why is that? I am sure I am under UI limit display for results.  Thanks Mike 

Hi, I'm trying to query a dataset using the query service. I would like to query only the latest batch data received. We are using a fully custom schema (_tenant...). I've tried accessing the system-generated such as createdByBatchID, but it seems that it is not accessible in the dataset.ex.SELECT c...

Hi, I've a simple query which I'm executing from Query Service UI & API. Query Service UI execution return records successfully where as API query execution fails. I can see status of both the execution in Query Service log.   I'm executing the same query from UI & API. Query : Select * FROM <table...