Get Started with Query Service for Data Engineers
Learn how to validate ingested data, gain insights from data stored in the data lake, and how to prepare the data for making business-critical decisions using Query Service.
Query Service overview
Learn how Query Service in Adobe Experience Platform can help you Understand customer behavior and generate impactful insights.
489
{ "description": "Learn how Query Service in Adobe Experience Platform can help you Understand customer behavior and generate impactful insights.", "duration": "PT0H8M9S", "embedUrl": "https://video.tv.adobe.com/v/29795/", "name": "Query Service overview", "thumbnailUrl": [ "https://images-tv.adobe.com/mpcv3/0663e587-56d7-4521-a00c-c7bd860ce18e/8cb9e3e0-1044-4dad-8e18-4b1ffe147212/5b766a062e4140dc97b8a5588dbf8f99_1626461061-100x56.jpg", "https://images-tv.adobe.com/mpcv3/0663e587-56d7-4521-a00c-c7bd860ce18e/8cb9e3e0-1044-4dad-8e18-4b1ffe147212/5b766a062e4140dc97b8a5588dbf8f99_1626461062-150x84.jpg", "https://images-tv.adobe.com/mpcv3/0663e587-56d7-4521-a00c-c7bd860ce18e/8cb9e3e0-1044-4dad-8e18-4b1ffe147212/5b766a062e4140dc97b8a5588dbf8f99_1626461062-200x113.jpg", "https://images-tv.adobe.com/mpcv3/0663e587-56d7-4521-a00c-c7bd860ce18e/8cb9e3e0-1044-4dad-8e18-4b1ffe147212/5b766a062e4140dc97b8a5588dbf8f99_1626461062-220x124.jpg", "https://images-tv.adobe.com/mpcv3/0663e587-56d7-4521-a00c-c7bd860ce18e/8cb9e3e0-1044-4dad-8e18-4b1ffe147212/5b766a062e4140dc97b8a5588dbf8f99_1626461062-236x133.jpg", "https://images-tv.adobe.com/mpcv3/0663e587-56d7-4521-a00c-c7bd860ce18e/8cb9e3e0-1044-4dad-8e18-4b1ffe147212/5b766a062e4140dc97b8a5588dbf8f99_1626461062-290x186.jpg", "https://images-tv.adobe.com/mpcv3/0663e587-56d7-4521-a00c-c7bd860ce18e/8cb9e3e0-1044-4dad-8e18-4b1ffe147212/5b766a062e4140dc97b8a5588dbf8f99_1626461062-420x236.jpg", "https://images-tv.adobe.com/mpcv3/0663e587-56d7-4521-a00c-c7bd860ce18e/8cb9e3e0-1044-4dad-8e18-4b1ffe147212/5b766a062e4140dc97b8a5588dbf8f99_1626461063-1920x1080.jpg", "https://images-tv.adobe.com/mpcv3/0663e587-56d7-4521-a00c-c7bd860ce18e/8cb9e3e0-1044-4dad-8e18-4b1ffe147212/5b766a062e4140dc97b8a5588dbf8f99_1626461063-640x360.jpg", "https://images-tv.adobe.com/mpcv3/0663e587-56d7-4521-a00c-c7bd860ce18e/8cb9e3e0-1044-4dad-8e18-4b1ffe147212/5b766a062e4140dc97b8a5588dbf8f99_1626461063-666x374.jpg", "https://images-tv.adobe.com/mpcv3/0663e587-56d7-4521-a00c-c7bd860ce18e/8cb9e3e0-1044-4dad-8e18-4b1ffe147212/5b766a062e4140dc97b8a5588dbf8f99_1626461063-720x405.jpg", "https://images-tv.adobe.com/mpcv3/0663e587-56d7-4521-a00c-c7bd860ce18e/8cb9e3e0-1044-4dad-8e18-4b1ffe147212/5b766a062e4140dc97b8a5588dbf8f99_1626461063-960x540.jpg" ], "@type": [ "VideoObject", "LearningResource" ], "uploadDate": "2019-11-19T04:12:36Z", "hasPart": [ { "@type": "Clip", "name": "Example of a business in need of Query Service", "startOffset": 9, "endOffset": 109, "url": "https://video.tv.adobe.com/v/29795/?t=9" }, { "@type": "Clip", "name": "What is Query Service?", "startOffset": 110, "endOffset": 159, "url": "https://video.tv.adobe.com/v/29795/?t=110" }, { "@type": "Clip", "name": "Key Use Cases", "startOffset": 160, "endOffset": 193, "url": "https://video.tv.adobe.com/v/29795/?t=160" }, { "@type": "Clip", "name": "Current Offering", "startOffset": 194, "endOffset": 224, "url": "https://video.tv.adobe.com/v/29795/?t=194" }, { "@type": "Clip", "name": "Ways of consuming data", "startOffset": 225, "endOffset": 234, "url": "https://video.tv.adobe.com/v/29795/?t=225" }, { "@type": "Clip", "name": "Adobe-defined SQL Functions for Experience Analysis", "startOffset": 235, "endOffset": 263, "url": "https://video.tv.adobe.com/v/29795/?t=235" }, { "@type": "Clip", "name": "Query Service Architecture", "startOffset": 264, "endOffset": 343, "url": "https://video.tv.adobe.com/v/29795/?t=264" }, { "@type": "Clip", "name": "Summary of Query Service benefits", "startOffset": 344, "endOffset": 489, "url": "https://video.tv.adobe.com/v/29795/?t=344" } ], "educationLevel": [ "Beginner" ], "learningResourceType": "Query Service overview" }
Query Service UI
Learn how to write and execute queries, view previously executed queries, and access queries saved by others users within your IMS Organization in Adobe Experience Platform Query Service.
419
{ "description": "Learn how to write and execute queries, view previously executed queries, and access queries saved by others users within your IMS Organization in Adobe Experience Platform Query Service.", "duration": "PT0H6M59S", "embedUrl": "https://video.tv.adobe.com/v/333403/", "name": "Query Service UI", "thumbnailUrl": [ "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/c8f466ff-cf60-4c4a-a4c9-d17b6ac2b2fa/54a3b0853c4f4876bdc6e634f85de60d_1622517107-100x56.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/c8f466ff-cf60-4c4a-a4c9-d17b6ac2b2fa/54a3b0853c4f4876bdc6e634f85de60d_1622517107-150x84.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/c8f466ff-cf60-4c4a-a4c9-d17b6ac2b2fa/54a3b0853c4f4876bdc6e634f85de60d_1622517107-200x113.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/c8f466ff-cf60-4c4a-a4c9-d17b6ac2b2fa/54a3b0853c4f4876bdc6e634f85de60d_1622517107-220x124.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/c8f466ff-cf60-4c4a-a4c9-d17b6ac2b2fa/54a3b0853c4f4876bdc6e634f85de60d_1622517107-236x133.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/c8f466ff-cf60-4c4a-a4c9-d17b6ac2b2fa/54a3b0853c4f4876bdc6e634f85de60d_1622517107-290x186.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/c8f466ff-cf60-4c4a-a4c9-d17b6ac2b2fa/54a3b0853c4f4876bdc6e634f85de60d_1622517108-1920x1080.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/c8f466ff-cf60-4c4a-a4c9-d17b6ac2b2fa/54a3b0853c4f4876bdc6e634f85de60d_1622517108-420x236.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/c8f466ff-cf60-4c4a-a4c9-d17b6ac2b2fa/54a3b0853c4f4876bdc6e634f85de60d_1622517108-640x360.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/c8f466ff-cf60-4c4a-a4c9-d17b6ac2b2fa/54a3b0853c4f4876bdc6e634f85de60d_1622517108-666x374.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/c8f466ff-cf60-4c4a-a4c9-d17b6ac2b2fa/54a3b0853c4f4876bdc6e634f85de60d_1622517108-720x405.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/c8f466ff-cf60-4c4a-a4c9-d17b6ac2b2fa/54a3b0853c4f4876bdc6e634f85de60d_1622517108-960x540.jpg" ], "@type": [ "VideoObject", "LearningResource" ], "uploadDate": "2021-05-19T20:47:28Z", "hasPart": [ { "@type": "Clip", "name": "Queries", "startOffset": 46, "endOffset": 141, "url": "https://video.tv.adobe.com/v/333403/?t=46" }, { "@type": "Clip", "name": "Output result to a dataset", "startOffset": 142, "endOffset": 246, "url": "https://video.tv.adobe.com/v/333403/?t=142" }, { "@type": "Clip", "name": "Schedule a query in the UI", "startOffset": 247, "endOffset": 368, "url": "https://video.tv.adobe.com/v/333403/?t=247" }, { "@type": "Clip", "name": "Connect Query Service to desktop applications", "startOffset": 369, "endOffset": 419, "url": "https://video.tv.adobe.com/v/333403/?t=369" } ], "educationLevel": [ "Beginner" ], "learningResourceType": "Query Service UI" }
Query Service API
Learn how to write and execute queries, create schedule queries, and create a query template using Adobe Experience Platform Query Service API.
391
{ "description": "Learn how to write and execute queries, create schedule queries, and create a query template using Adobe Experience Platform Query Service API.", "duration": "PT0H6M31S", "embedUrl": "https://video.tv.adobe.com/v/333700/", "name": "Query Service API", "thumbnailUrl": [ "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/cd5b1a4e-b7ea-45f4-a1fc-6682dc4673d7/41f66be7e78d40dd8589dc6893e4b72e_1622517807-100x56.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/cd5b1a4e-b7ea-45f4-a1fc-6682dc4673d7/41f66be7e78d40dd8589dc6893e4b72e_1622517807-150x84.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/cd5b1a4e-b7ea-45f4-a1fc-6682dc4673d7/41f66be7e78d40dd8589dc6893e4b72e_1622517807-200x113.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/cd5b1a4e-b7ea-45f4-a1fc-6682dc4673d7/41f66be7e78d40dd8589dc6893e4b72e_1622517807-220x124.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/cd5b1a4e-b7ea-45f4-a1fc-6682dc4673d7/41f66be7e78d40dd8589dc6893e4b72e_1622517807-236x133.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/cd5b1a4e-b7ea-45f4-a1fc-6682dc4673d7/41f66be7e78d40dd8589dc6893e4b72e_1622517807-290x186.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/cd5b1a4e-b7ea-45f4-a1fc-6682dc4673d7/41f66be7e78d40dd8589dc6893e4b72e_1622517807-420x236.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/cd5b1a4e-b7ea-45f4-a1fc-6682dc4673d7/41f66be7e78d40dd8589dc6893e4b72e_1622517808-1920x1080.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/cd5b1a4e-b7ea-45f4-a1fc-6682dc4673d7/41f66be7e78d40dd8589dc6893e4b72e_1622517808-640x360.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/cd5b1a4e-b7ea-45f4-a1fc-6682dc4673d7/41f66be7e78d40dd8589dc6893e4b72e_1622517808-666x374.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/cd5b1a4e-b7ea-45f4-a1fc-6682dc4673d7/41f66be7e78d40dd8589dc6893e4b72e_1622517808-720x405.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/cd5b1a4e-b7ea-45f4-a1fc-6682dc4673d7/41f66be7e78d40dd8589dc6893e4b72e_1622517808-960x540.jpg" ], "@type": [ "VideoObject", "LearningResource" ], "uploadDate": "2021-05-31T20:03:56Z", "hasPart": [], "educationLevel": [ "Beginner" ], "learningResourceType": "Query Service API" }
Prepare data
Learn how to clean, prepare, and combine data from multiple datasets to create a new dataset using CTAS (Create Table AS) and Spark SQL functions for reporting and dashboarding.
212
{ "description": "Learn how to clean, prepare, and combine data from multiple datasets to create a new dataset using CTAS (Create Table AS) and Spark SQL functions for reporting and dashboarding.", "duration": "PT0H3M32S", "embedUrl": "https://video.tv.adobe.com/v/333699/", "name": "Prepare data", "thumbnailUrl": [ "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/782df0cd-6334-415b-b1f8-d6aa8c703918/c95deff917984bae8b7bc0f355f778c5_1622517492-100x56.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/782df0cd-6334-415b-b1f8-d6aa8c703918/c95deff917984bae8b7bc0f355f778c5_1622517493-150x84.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/782df0cd-6334-415b-b1f8-d6aa8c703918/c95deff917984bae8b7bc0f355f778c5_1622517493-200x113.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/782df0cd-6334-415b-b1f8-d6aa8c703918/c95deff917984bae8b7bc0f355f778c5_1622517493-220x124.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/782df0cd-6334-415b-b1f8-d6aa8c703918/c95deff917984bae8b7bc0f355f778c5_1622517493-236x133.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/782df0cd-6334-415b-b1f8-d6aa8c703918/c95deff917984bae8b7bc0f355f778c5_1622517493-290x186.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/782df0cd-6334-415b-b1f8-d6aa8c703918/c95deff917984bae8b7bc0f355f778c5_1622517493-420x236.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/782df0cd-6334-415b-b1f8-d6aa8c703918/c95deff917984bae8b7bc0f355f778c5_1622517494-1920x1080.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/782df0cd-6334-415b-b1f8-d6aa8c703918/c95deff917984bae8b7bc0f355f778c5_1622517494-640x360.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/782df0cd-6334-415b-b1f8-d6aa8c703918/c95deff917984bae8b7bc0f355f778c5_1622517494-666x374.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/782df0cd-6334-415b-b1f8-d6aa8c703918/c95deff917984bae8b7bc0f355f778c5_1622517494-720x405.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/782df0cd-6334-415b-b1f8-d6aa8c703918/c95deff917984bae8b7bc0f355f778c5_1622517494-960x540.jpg" ], "@type": [ "VideoObject", "LearningResource" ], "uploadDate": "2021-05-31T20:03:23Z", "hasPart": [], "educationLevel": [ "Beginner" ], "learningResourceType": "Prepare data" }
Adobe Defined Functions
Learn how to use Adobe-defined functions in Adobe Experience Platform Query Service to perform common business-related tasks on Experience Event data.
183
{ "description": "Learn how to use Adobe-defined functions in Adobe Experience Platform Query Service to perform common business-related tasks on Experience Event data.", "duration": "PT0H3M3S", "embedUrl": "https://video.tv.adobe.com/v/333701/", "name": "Adobe Defined Functions", "thumbnailUrl": [ "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/4db0502d-05ca-413a-9072-47949c6d6d89/d5e617eed60e4889bd21a3b09ec6c269_1622517907-100x56.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/4db0502d-05ca-413a-9072-47949c6d6d89/d5e617eed60e4889bd21a3b09ec6c269_1622517907-150x84.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/4db0502d-05ca-413a-9072-47949c6d6d89/d5e617eed60e4889bd21a3b09ec6c269_1622517907-200x113.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/4db0502d-05ca-413a-9072-47949c6d6d89/d5e617eed60e4889bd21a3b09ec6c269_1622517907-220x124.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/4db0502d-05ca-413a-9072-47949c6d6d89/d5e617eed60e4889bd21a3b09ec6c269_1622517908-236x133.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/4db0502d-05ca-413a-9072-47949c6d6d89/d5e617eed60e4889bd21a3b09ec6c269_1622517908-290x186.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/4db0502d-05ca-413a-9072-47949c6d6d89/d5e617eed60e4889bd21a3b09ec6c269_1622517908-420x236.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/4db0502d-05ca-413a-9072-47949c6d6d89/d5e617eed60e4889bd21a3b09ec6c269_1622517908-640x360.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/4db0502d-05ca-413a-9072-47949c6d6d89/d5e617eed60e4889bd21a3b09ec6c269_1622517908-666x374.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/4db0502d-05ca-413a-9072-47949c6d6d89/d5e617eed60e4889bd21a3b09ec6c269_1622517909-1920x1080.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/4db0502d-05ca-413a-9072-47949c6d6d89/d5e617eed60e4889bd21a3b09ec6c269_1622517909-720x405.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/4db0502d-05ca-413a-9072-47949c6d6d89/d5e617eed60e4889bd21a3b09ec6c269_1622517909-960x540.jpg" ], "@type": [ "VideoObject", "LearningResource" ], "uploadDate": "2021-05-31T20:04:20Z", "hasPart": [], "educationLevel": [ "Beginner" ], "learningResourceType": "Adobe Defined Functions" }