Community Topics

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...

Hi, I've a dataset which contains 51 columns but when I query my dataset in query service it return just 16 columns. Column in dataset :  _idendUserIDs._experience.emailid.idweb.webInteraction.URL application.launches.valueendUserIDs._experience.emailid.namespace.codeweb.webInteraction.linkClicks.id...

Why do these queries throw the same error in Queries? SELECT * FROM table WHERE table.eventType LIKE "purchases" LIMIT 10; SELECT * FROM table WHERE table.eventType = "commerce.purchases" LIMIT 10; Error: ErrorCode: 08P01 Unknown error encountered. Reason: [Column 'commerce.purchases' does not exist...