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.

https://video.tv.adobe.com/v/33589?learn=on

Présentation 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

https://video.tv.adobe.com/vc/33589/fre_fr.json

{ "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" }

https://video.tv.adobe.com/v/333403?learn=on

Interface utilisateur 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

https://video.tv.adobe.com/vc/333403/fre_fr.json

{ "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" }

https://video.tv.adobe.com/v/3414085?learn=on

API 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

https://video.tv.adobe.com/vc/3414085/fre_fr.json

{ "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" }

https://video.tv.adobe.com/v/3414067?learn=on

Préparer les données

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

https://video.tv.adobe.com/vc/3414067/fre_fr.json

{ "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" }

https://video.tv.adobe.com/v/3414049?learn=on

Fonctions définies par Adobe

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

https://video.tv.adobe.com/vc/3414049/fre_fr.json

{ "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" }