Prise en main de Query Service pour les ingénieurs de données
Découvrez comment valider les données ingérées, comment obtenir des informations des données stockées dans le lac de données et comment préparer les données nécessaires pour prendre des décisions commerciales critiques à l’aide de Query Service.
Présentation de Query Service
Découvrez comment Query Service dans Adobe Experience Platform peut vous aider à comprendre le comportement des clients et à générer des insights d’impact.
489
{ "description": "Découvrez comment Query Service dans Adobe Experience Platform peut vous aider à comprendre le comportement des clients et à générer des insights d’impact.", "duration": "PT0H8M9S", "embedUrl": "https://video.tv.adobe.com/v/33589/", "name": "Présentation de Query Service", "thumbnailUrl": [ "https://images-tv.adobe.com/mpcv3/83df592c-0019-4a8c-b00d-2ebe28093024/ad0eea89-9f36-4f66-9fb4-87ab0a570b19/f3400dd7751b455490e0ae83db86f2bd_1587652152-100x56.jpg", "https://images-tv.adobe.com/mpcv3/83df592c-0019-4a8c-b00d-2ebe28093024/ad0eea89-9f36-4f66-9fb4-87ab0a570b19/f3400dd7751b455490e0ae83db86f2bd_1587652152-150x84.jpg", "https://images-tv.adobe.com/mpcv3/83df592c-0019-4a8c-b00d-2ebe28093024/ad0eea89-9f36-4f66-9fb4-87ab0a570b19/f3400dd7751b455490e0ae83db86f2bd_1587652152-200x113.jpg", "https://images-tv.adobe.com/mpcv3/83df592c-0019-4a8c-b00d-2ebe28093024/ad0eea89-9f36-4f66-9fb4-87ab0a570b19/f3400dd7751b455490e0ae83db86f2bd_1587652153-220x124.jpg", "https://images-tv.adobe.com/mpcv3/83df592c-0019-4a8c-b00d-2ebe28093024/ad0eea89-9f36-4f66-9fb4-87ab0a570b19/f3400dd7751b455490e0ae83db86f2bd_1587652153-236x133.jpg", "https://images-tv.adobe.com/mpcv3/83df592c-0019-4a8c-b00d-2ebe28093024/ad0eea89-9f36-4f66-9fb4-87ab0a570b19/f3400dd7751b455490e0ae83db86f2bd_1587652154-290x186.jpg", "https://images-tv.adobe.com/mpcv3/83df592c-0019-4a8c-b00d-2ebe28093024/ad0eea89-9f36-4f66-9fb4-87ab0a570b19/f3400dd7751b455490e0ae83db86f2bd_1587652154-420x236.jpg", "https://images-tv.adobe.com/mpcv3/83df592c-0019-4a8c-b00d-2ebe28093024/ad0eea89-9f36-4f66-9fb4-87ab0a570b19/f3400dd7751b455490e0ae83db86f2bd_1587652154-640x360.jpg", "https://images-tv.adobe.com/mpcv3/83df592c-0019-4a8c-b00d-2ebe28093024/ad0eea89-9f36-4f66-9fb4-87ab0a570b19/f3400dd7751b455490e0ae83db86f2bd_1587652155-666x374.jpg", "https://images-tv.adobe.com/mpcv3/83df592c-0019-4a8c-b00d-2ebe28093024/ad0eea89-9f36-4f66-9fb4-87ab0a570b19/f3400dd7751b455490e0ae83db86f2bd_1587652155-720x405.jpg", "https://images-tv.adobe.com/mpcv3/83df592c-0019-4a8c-b00d-2ebe28093024/ad0eea89-9f36-4f66-9fb4-87ab0a570b19/f3400dd7751b455490e0ae83db86f2bd_1587652156-1920x1080.jpg", "https://images-tv.adobe.com/mpcv3/83df592c-0019-4a8c-b00d-2ebe28093024/ad0eea89-9f36-4f66-9fb4-87ab0a570b19/f3400dd7751b455490e0ae83db86f2bd_1587652156-960x540.jpg" ], "@type": [ "VideoObject", "LearningResource" ], "uploadDate": "2020-04-23T14:24:10Z", "hasPart": [], "educationLevel": [ "Beginner" ], "learningResourceType": "Présentation de Query Service" }
Interface utilisateur de Query Service
Apprenez comment écrire et exécuter des requêtes, afficher des requêtes précédemment exécutées et accéder à des requêtes enregistrées par dʼautres utilisateurs au sein de votre organisation IMS dans Query Service dʼAdobe Experience Platform.
419
{ "description": "Apprenez comment écrire et exécuter des requêtes, afficher des requêtes précédemment exécutées et accéder à des requêtes enregistrées par dʼautres utilisateurs au sein de votre organisation IMS dans Query Service dʼAdobe Experience Platform.", "duration": "PT0H6M59S", "embedUrl": "https://video.tv.adobe.com/v/333403/", "name": "Interface utilisateur de Query Service", "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": "Interface utilisateur de Query Service" }
API Query Service
Découvrez comment écrire et exécuter des requêtes, créer des requêtes de planification et créer un modèle de requête à l’aide de l’API Adobe Experience Platform Query Service.
391
{ "description": "Découvrez comment écrire et exécuter des requêtes, créer des requêtes de planification et créer un modèle de requête à l’aide de l’API Adobe Experience Platform Query Service.", "duration": "PT0H6M31S", "embedUrl": "https://video.tv.adobe.com/v/3414085/", "name": "API Query Service", "thumbnailUrl": [ "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/357b6863-dfb1-44e5-b077-7a91a7bbb2ac/ef8a70b7c2af49feaf57aac4605bea2c_1675450936-100x56.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/357b6863-dfb1-44e5-b077-7a91a7bbb2ac/ef8a70b7c2af49feaf57aac4605bea2c_1675450937-150x84.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/357b6863-dfb1-44e5-b077-7a91a7bbb2ac/ef8a70b7c2af49feaf57aac4605bea2c_1675450937-200x113.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/357b6863-dfb1-44e5-b077-7a91a7bbb2ac/ef8a70b7c2af49feaf57aac4605bea2c_1675450937-220x124.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/357b6863-dfb1-44e5-b077-7a91a7bbb2ac/ef8a70b7c2af49feaf57aac4605bea2c_1675450937-236x133.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/357b6863-dfb1-44e5-b077-7a91a7bbb2ac/ef8a70b7c2af49feaf57aac4605bea2c_1675450937-290x186.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/357b6863-dfb1-44e5-b077-7a91a7bbb2ac/ef8a70b7c2af49feaf57aac4605bea2c_1675450937-420x236.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/357b6863-dfb1-44e5-b077-7a91a7bbb2ac/ef8a70b7c2af49feaf57aac4605bea2c_1675450938-1920x1080.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/357b6863-dfb1-44e5-b077-7a91a7bbb2ac/ef8a70b7c2af49feaf57aac4605bea2c_1675450938-640x360.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/357b6863-dfb1-44e5-b077-7a91a7bbb2ac/ef8a70b7c2af49feaf57aac4605bea2c_1675450938-666x374.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/357b6863-dfb1-44e5-b077-7a91a7bbb2ac/ef8a70b7c2af49feaf57aac4605bea2c_1675450938-720x405.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/357b6863-dfb1-44e5-b077-7a91a7bbb2ac/ef8a70b7c2af49feaf57aac4605bea2c_1675450938-960x540.jpg" ], "@type": [ "VideoObject", "LearningResource" ], "uploadDate": "2023-02-03T18:56:30Z", "hasPart": [], "educationLevel": [ "Beginner" ], "learningResourceType": "API Query Service" }
Préparer les données
Découvrez comment nettoyer, préparer et combiner les données de plusieurs jeux de données pour créer un nouveau jeu de données à l’aide des fonctions CTAS (Create Table AS) et Spark SQL pour la création de rapports et la création de tableaux de bord.
212
{ "description": "Découvrez comment nettoyer, préparer et combiner les données de plusieurs jeux de données pour créer un nouveau jeu de données à l’aide des fonctions CTAS (Create Table AS) et Spark SQL pour la création de rapports et la création de tableaux de bord.", "duration": "PT0H3M32S", "embedUrl": "https://video.tv.adobe.com/v/3414067/", "name": "Préparer les données", "thumbnailUrl": [ "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/5a59ac25-6d28-43a7-bfef-eb74b19b68d6/62ad51cdbb324dbba6f40d6b6bf0323c_1675449238-100x56.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/5a59ac25-6d28-43a7-bfef-eb74b19b68d6/62ad51cdbb324dbba6f40d6b6bf0323c_1675449238-150x85.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/5a59ac25-6d28-43a7-bfef-eb74b19b68d6/62ad51cdbb324dbba6f40d6b6bf0323c_1675449238-200x113.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/5a59ac25-6d28-43a7-bfef-eb74b19b68d6/62ad51cdbb324dbba6f40d6b6bf0323c_1675449238-220x124.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/5a59ac25-6d28-43a7-bfef-eb74b19b68d6/62ad51cdbb324dbba6f40d6b6bf0323c_1675449239-236x133.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/5a59ac25-6d28-43a7-bfef-eb74b19b68d6/62ad51cdbb324dbba6f40d6b6bf0323c_1675449239-290x163.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/5a59ac25-6d28-43a7-bfef-eb74b19b68d6/62ad51cdbb324dbba6f40d6b6bf0323c_1675449239-420x236.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/5a59ac25-6d28-43a7-bfef-eb74b19b68d6/62ad51cdbb324dbba6f40d6b6bf0323c_1675449239-640x360.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/5a59ac25-6d28-43a7-bfef-eb74b19b68d6/62ad51cdbb324dbba6f40d6b6bf0323c_1675449239-666x375.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/5a59ac25-6d28-43a7-bfef-eb74b19b68d6/62ad51cdbb324dbba6f40d6b6bf0323c_1675449239-720x405.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/5a59ac25-6d28-43a7-bfef-eb74b19b68d6/62ad51cdbb324dbba6f40d6b6bf0323c_1675449240-1920x1080.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/5a59ac25-6d28-43a7-bfef-eb74b19b68d6/62ad51cdbb324dbba6f40d6b6bf0323c_1675449240-960x540.jpg" ], "@type": [ "VideoObject", "LearningResource" ], "uploadDate": "2023-02-03T18:31:28Z", "hasPart": [], "educationLevel": [ "Beginner" ], "learningResourceType": "Préparer les données" }
Fonctions définies par Adobe
Découvrez comment utiliser des fonctions définies par l’Adobe dans Adobe Experience Platform Query Service pour exécuter des tâches commerciales courantes sur les données d’événement d’expérience.
183
{ "description": "Découvrez comment utiliser des fonctions définies par l’Adobe dans Adobe Experience Platform Query Service pour exécuter des tâches commerciales courantes sur les données d’événement d’expérience.", "duration": "PT0H3M3S", "embedUrl": "https://video.tv.adobe.com/v/3414049/", "name": "Fonctions définies par Adobe", "thumbnailUrl": [ "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/5f34fdab-96eb-41c7-9e85-07131d06ea9b/912987e5c21d444093e742e83b354064_1675447598-100x56.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/5f34fdab-96eb-41c7-9e85-07131d06ea9b/912987e5c21d444093e742e83b354064_1675447599-150x85.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/5f34fdab-96eb-41c7-9e85-07131d06ea9b/912987e5c21d444093e742e83b354064_1675447599-200x113.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/5f34fdab-96eb-41c7-9e85-07131d06ea9b/912987e5c21d444093e742e83b354064_1675447599-220x124.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/5f34fdab-96eb-41c7-9e85-07131d06ea9b/912987e5c21d444093e742e83b354064_1675447599-236x133.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/5f34fdab-96eb-41c7-9e85-07131d06ea9b/912987e5c21d444093e742e83b354064_1675447599-290x163.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/5f34fdab-96eb-41c7-9e85-07131d06ea9b/912987e5c21d444093e742e83b354064_1675447600-420x236.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/5f34fdab-96eb-41c7-9e85-07131d06ea9b/912987e5c21d444093e742e83b354064_1675447600-640x360.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/5f34fdab-96eb-41c7-9e85-07131d06ea9b/912987e5c21d444093e742e83b354064_1675447600-666x375.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/5f34fdab-96eb-41c7-9e85-07131d06ea9b/912987e5c21d444093e742e83b354064_1675447600-720x405.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/5f34fdab-96eb-41c7-9e85-07131d06ea9b/912987e5c21d444093e742e83b354064_1675447601-1920x1080.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/5f34fdab-96eb-41c7-9e85-07131d06ea9b/912987e5c21d444093e742e83b354064_1675447601-960x540.jpg" ], "@type": [ "VideoObject", "LearningResource" ], "uploadDate": "2023-02-03T18:03:19Z", "hasPart": [], "educationLevel": [ "Beginner" ], "learningResourceType": "Fonctions définies par Adobe" }