Overview
Treasure Data provides Premium Audit Log, having all the operations on Treasure Data, such as login, job issues, and so on. Because it has various events and columns, it takes time and effort to build queries to get the information you want. This page introduces sample workflow and queries using Audit Log table for possible cases.
Use cases
| Category | Event | Note |
|
Account Management
|
Invite new users | - |
| Promoted users to Admin | - | |
| Get active users logging in for N days | - | |
| Get non-active users not logging in for N days | - | |
| Change permission type to FullAccess | - | |
| Attach user to policy | - | |
| Modify policy | - | |
|
Data Import
|
Any operation to import data (Except for streaming import) | - |
| File upload | - | |
| Bulk Import | - | |
| Bulk load with Source | The case that Source runs triggered by td_load is included. | |
| Bulk load with yml file | - | |
|
Data Export
|
Result Export Job | - |
| Result Download on GUI | Result Download from Job Result and Download History in Activation | |
| Result Download via TD Toolbelt | - | |
| Run Activation | - | |
| Table export | TD Toolbelt's command (td table:export) | |
|
Create Resources
|
Authentication | - |
| Source | - | |
| Database | - | |
| Workflow projects | Cannot distinguish creating and modifying workflows. | |
| Master Segment | - | |
| Segment | - | |
| Activation | - | |
| Policy | - | |
|
Others
|
Jobs with long duration | - |
| Jobs with query including specific pattern | - | |
| Query issued by pytd | - |
Technical implementation
audiglog_example.dig
This file is a workflow to run all the tasks above. When trying it, please set the following parameters.
| Paramater | Value |
|---|---|
| td.endpoint | - api.treasudata.com - api.treasuredata.co.jp - api.eu01.treasuredata.com - api.ap02.treasuredata.com |
| secret:td.apikey | 1/xxxx |