Each job in Treasure Data has a database. There is a one-to-one correspondence between a job and a database.
Open TD Console.
Navigate to Jobs.
Select a job and then select Details.
You must have database permissions to display job activities. Be careful how to grant or revoke permissions. For example, if you don't want a user to see the results of a query job, do not grant permission to the Job's database to the user. However, if you only revoke permission to the database referenced by the query from the user, the user can still see the job results as long as the user has view permission for the job's database.
- Open TD Console.
- Navigate to Data Workbench > Queries.
- Select the database for the job.
The selected database is the default for the database of the query statement. When referring to tables under the selected database, you can omit the database name, such as '... FROM <table_name>...instead of '... FROM <database_name>.<table_name>...’.
You can specify the job's database for the td>: operator when you run a Hive/Presto job via Workflow.
+run_query:
td>:
query: "SELECT * FROM sample_datasets.nasdaq LIMIT 1;"
database: blog_testIn Bulk Load jobs, the database is the destination of an import.
- Open TD Console.
- Navigate to Integrations Hub > Sources.
- Select Data Placement.
- Select a database.
You can specify the job's database for the td_load>: operator when you run the Bulk Load job via Workflow.
+import_bulk_load:
td_load>: config/import.yml
database: blog_test
table: dest_table