データエンジニア向けクエリサービスの概要

取り込んだータの検証方法、データレイクに格納されているデータからインサイトを取得する方法、クエリサービスを使用して、ビジネスに重要な決定を下すデータを準備する方法を説明します。

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

クエリサービスの概要

クエリサービスの概要

Adobe Experience Platformのクエリサービスが、お客様の行動を理解し、効果的なインサイトを生み出すのにどのように役立つかを説明します。

489

https://video.tv.adobe.com/vc/35089/jpn.json

{ "description": "Adobe Experience Platformのクエリサービスが、お客様の行動を理解し、効果的なインサイトを生み出すのにどのように役立つかを説明します。", "duration": "PT0H8M9S", "embedUrl": "https://video.tv.adobe.com/v/35089/", "name": "クエリサービスの概要", "thumbnailUrl": [ "https://images-tv.adobe.com/mpcv3/c72e4016-3bdf-40a7-aa07-1ff15ece92d1/a07b179d-1d1d-4f9a-ac2a-1bde509f6828/88adcba5ba59434381c20e947b833090_1591616826-100x56.jpg", "https://images-tv.adobe.com/mpcv3/c72e4016-3bdf-40a7-aa07-1ff15ece92d1/a07b179d-1d1d-4f9a-ac2a-1bde509f6828/88adcba5ba59434381c20e947b833090_1591616826-150x84.jpg", "https://images-tv.adobe.com/mpcv3/c72e4016-3bdf-40a7-aa07-1ff15ece92d1/a07b179d-1d1d-4f9a-ac2a-1bde509f6828/88adcba5ba59434381c20e947b833090_1591616827-200x113.jpg", "https://images-tv.adobe.com/mpcv3/c72e4016-3bdf-40a7-aa07-1ff15ece92d1/a07b179d-1d1d-4f9a-ac2a-1bde509f6828/88adcba5ba59434381c20e947b833090_1591616827-220x124.jpg", "https://images-tv.adobe.com/mpcv3/c72e4016-3bdf-40a7-aa07-1ff15ece92d1/a07b179d-1d1d-4f9a-ac2a-1bde509f6828/88adcba5ba59434381c20e947b833090_1591616827-236x133.jpg", "https://images-tv.adobe.com/mpcv3/c72e4016-3bdf-40a7-aa07-1ff15ece92d1/a07b179d-1d1d-4f9a-ac2a-1bde509f6828/88adcba5ba59434381c20e947b833090_1591616827-290x186.jpg", "https://images-tv.adobe.com/mpcv3/c72e4016-3bdf-40a7-aa07-1ff15ece92d1/a07b179d-1d1d-4f9a-ac2a-1bde509f6828/88adcba5ba59434381c20e947b833090_1591616827-420x236.jpg", "https://images-tv.adobe.com/mpcv3/c72e4016-3bdf-40a7-aa07-1ff15ece92d1/a07b179d-1d1d-4f9a-ac2a-1bde509f6828/88adcba5ba59434381c20e947b833090_1591616827-640x360.jpg", "https://images-tv.adobe.com/mpcv3/c72e4016-3bdf-40a7-aa07-1ff15ece92d1/a07b179d-1d1d-4f9a-ac2a-1bde509f6828/88adcba5ba59434381c20e947b833090_1591616828-1920x1080.jpg", "https://images-tv.adobe.com/mpcv3/c72e4016-3bdf-40a7-aa07-1ff15ece92d1/a07b179d-1d1d-4f9a-ac2a-1bde509f6828/88adcba5ba59434381c20e947b833090_1591616828-666x374.jpg", "https://images-tv.adobe.com/mpcv3/c72e4016-3bdf-40a7-aa07-1ff15ece92d1/a07b179d-1d1d-4f9a-ac2a-1bde509f6828/88adcba5ba59434381c20e947b833090_1591616828-720x405.jpg", "https://images-tv.adobe.com/mpcv3/c72e4016-3bdf-40a7-aa07-1ff15ece92d1/a07b179d-1d1d-4f9a-ac2a-1bde509f6828/88adcba5ba59434381c20e947b833090_1591616828-960x540.jpg" ], "@type": [ "VideoObject", "LearningResource" ], "uploadDate": "2020-06-08T11:44:04Z", "hasPart": [], "educationLevel": [ "Beginner" ], "learningResourceType": "クエリサービスの概要" }

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

クエリサービス UI

クエリサービス UI

Adobe Experience Platform クエリサービスで、クエリの書き込みと実行、以前に実行されたクエリの表示、IMS 組織内の他のユーザーが保存したクエリへのアクセスをおこなう方法について説明します。

419

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

{ "description": "Adobe Experience Platform クエリサービスで、クエリの書き込みと実行、以前に実行されたクエリの表示、IMS 組織内の他のユーザーが保存したクエリへのアクセスをおこなう方法について説明します。", "duration": "PT0H6M59S", "embedUrl": "https://video.tv.adobe.com/v/333403/", "name": "クエリサービス 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": "クエリサービス UI" }

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

クエリサービス API

クエリサービス API

Adobe Experience Platform クエリサービス API を使用して、クエリの記述と実行、スケジュールクエリの作成、およびクエリテンプレートの作成をおこなう方法について説明します。

391

https://video.tv.adobe.com/vc/3414087/jpn.json

{ "description": "Adobe Experience Platform クエリサービス API を使用して、クエリの記述と実行、スケジュールクエリの作成、およびクエリテンプレートの作成をおこなう方法について説明します。", "duration": "PT0H6M31S", "embedUrl": "https://video.tv.adobe.com/v/3414087/", "name": "クエリサービス API", "thumbnailUrl": [ "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/213325d4-92db-41de-8cda-2968950bc0dd/db2369fa71314f279d5d472a8246d4ee_1675450991-100x56.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/213325d4-92db-41de-8cda-2968950bc0dd/db2369fa71314f279d5d472a8246d4ee_1675450991-150x85.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/213325d4-92db-41de-8cda-2968950bc0dd/db2369fa71314f279d5d472a8246d4ee_1675450991-200x113.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/213325d4-92db-41de-8cda-2968950bc0dd/db2369fa71314f279d5d472a8246d4ee_1675450992-220x124.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/213325d4-92db-41de-8cda-2968950bc0dd/db2369fa71314f279d5d472a8246d4ee_1675450992-236x133.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/213325d4-92db-41de-8cda-2968950bc0dd/db2369fa71314f279d5d472a8246d4ee_1675450992-290x163.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/213325d4-92db-41de-8cda-2968950bc0dd/db2369fa71314f279d5d472a8246d4ee_1675450992-420x236.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/213325d4-92db-41de-8cda-2968950bc0dd/db2369fa71314f279d5d472a8246d4ee_1675450993-640x360.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/213325d4-92db-41de-8cda-2968950bc0dd/db2369fa71314f279d5d472a8246d4ee_1675450993-666x375.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/213325d4-92db-41de-8cda-2968950bc0dd/db2369fa71314f279d5d472a8246d4ee_1675450993-720x405.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/213325d4-92db-41de-8cda-2968950bc0dd/db2369fa71314f279d5d472a8246d4ee_1675450993-960x540.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/213325d4-92db-41de-8cda-2968950bc0dd/db2369fa71314f279d5d472a8246d4ee_1675450994-1920x1080.jpg" ], "@type": [ "VideoObject", "LearningResource" ], "uploadDate": "2023-02-03T18:57:52Z", "hasPart": [], "educationLevel": [ "Beginner" ], "learningResourceType": "クエリサービス API" }

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

データを準備

データを準備

レポートやダッシュボードに CTAS (Create Table AS)関数と Spark SQL 関数を使用して、複数のデータセットのデータを消去、準備、組み合わせて新しいデータセットを作成する方法を説明します。

212

https://video.tv.adobe.com/vc/3414069/jpn.json

{ "description": "レポートやダッシュボードに CTAS (Create Table AS)関数と Spark SQL 関数を使用して、複数のデータセットのデータを消去、準備、組み合わせて新しいデータセットを作成する方法を説明します。", "duration": "PT0H3M32S", "embedUrl": "https://video.tv.adobe.com/v/3414069/", "name": "データを準備", "thumbnailUrl": [ "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/f36a057e-9753-4d51-9f45-141ef419ded7/60f51b8b5e6f4c10b7051c321a3b05a4_1675449441-100x56.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/f36a057e-9753-4d51-9f45-141ef419ded7/60f51b8b5e6f4c10b7051c321a3b05a4_1675449441-150x85.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/f36a057e-9753-4d51-9f45-141ef419ded7/60f51b8b5e6f4c10b7051c321a3b05a4_1675449441-200x113.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/f36a057e-9753-4d51-9f45-141ef419ded7/60f51b8b5e6f4c10b7051c321a3b05a4_1675449442-220x124.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/f36a057e-9753-4d51-9f45-141ef419ded7/60f51b8b5e6f4c10b7051c321a3b05a4_1675449442-236x133.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/f36a057e-9753-4d51-9f45-141ef419ded7/60f51b8b5e6f4c10b7051c321a3b05a4_1675449442-290x163.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/f36a057e-9753-4d51-9f45-141ef419ded7/60f51b8b5e6f4c10b7051c321a3b05a4_1675449442-420x236.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/f36a057e-9753-4d51-9f45-141ef419ded7/60f51b8b5e6f4c10b7051c321a3b05a4_1675449443-640x360.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/f36a057e-9753-4d51-9f45-141ef419ded7/60f51b8b5e6f4c10b7051c321a3b05a4_1675449443-666x375.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/f36a057e-9753-4d51-9f45-141ef419ded7/60f51b8b5e6f4c10b7051c321a3b05a4_1675449443-720x405.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/f36a057e-9753-4d51-9f45-141ef419ded7/60f51b8b5e6f4c10b7051c321a3b05a4_1675449443-960x540.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/f36a057e-9753-4d51-9f45-141ef419ded7/60f51b8b5e6f4c10b7051c321a3b05a4_1675449444-1920x1080.jpg" ], "@type": [ "VideoObject", "LearningResource" ], "uploadDate": "2023-02-03T18:34:07Z", "hasPart": [], "educationLevel": [ "Beginner" ], "learningResourceType": "データを準備" }

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

Adobe定義関数

Adobe定義関数

Adobe Experience Platform クエリサービスのAdobe定義関数を使用して、エクスペリエンスイベントデータに対して一般的なビジネス関連タスクを実行する方法について説明します。

183

https://video.tv.adobe.com/vc/3414051/jpn.json

{ "description": "Adobe Experience Platform クエリサービスのAdobe定義関数を使用して、エクスペリエンスイベントデータに対して一般的なビジネス関連タスクを実行する方法について説明します。", "duration": "PT0H3M3S", "embedUrl": "https://video.tv.adobe.com/v/3414051/", "name": "Adobe定義関数", "thumbnailUrl": [ "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/a3cb6356-dc7e-4d6f-b7a5-96853c182a65/dfec3592a95b4b6b87bfa717d1e91e20_1675447804-100x56.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/a3cb6356-dc7e-4d6f-b7a5-96853c182a65/dfec3592a95b4b6b87bfa717d1e91e20_1675447804-150x85.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/a3cb6356-dc7e-4d6f-b7a5-96853c182a65/dfec3592a95b4b6b87bfa717d1e91e20_1675447804-200x113.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/a3cb6356-dc7e-4d6f-b7a5-96853c182a65/dfec3592a95b4b6b87bfa717d1e91e20_1675447804-220x124.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/a3cb6356-dc7e-4d6f-b7a5-96853c182a65/dfec3592a95b4b6b87bfa717d1e91e20_1675447804-236x133.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/a3cb6356-dc7e-4d6f-b7a5-96853c182a65/dfec3592a95b4b6b87bfa717d1e91e20_1675447804-290x163.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/a3cb6356-dc7e-4d6f-b7a5-96853c182a65/dfec3592a95b4b6b87bfa717d1e91e20_1675447805-420x236.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/a3cb6356-dc7e-4d6f-b7a5-96853c182a65/dfec3592a95b4b6b87bfa717d1e91e20_1675447805-640x360.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/a3cb6356-dc7e-4d6f-b7a5-96853c182a65/dfec3592a95b4b6b87bfa717d1e91e20_1675447805-666x375.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/a3cb6356-dc7e-4d6f-b7a5-96853c182a65/dfec3592a95b4b6b87bfa717d1e91e20_1675447805-720x405.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/a3cb6356-dc7e-4d6f-b7a5-96853c182a65/dfec3592a95b4b6b87bfa717d1e91e20_1675447805-960x540.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/a3cb6356-dc7e-4d6f-b7a5-96853c182a65/dfec3592a95b4b6b87bfa717d1e91e20_1675447806-1920x1080.jpg" ], "@type": [ "VideoObject", "LearningResource" ], "uploadDate": "2023-02-03T18:07:02Z", "hasPart": [], "educationLevel": [ "Beginner" ], "learningResourceType": "Adobe定義関数" }