# Selecting a Database for a Job

Each job in Treasure Data has a database. There is a one-to-one correspondence between a job and a database.

1. Open **TD Console**.
2. Navigate to **Jobs**.
![](/assets/image2023-5-9_13-39-38.f0d4dc509ab56031e80acf68b171a69ad7af376059433355552602f4074daa78.b40d6bf5.png)
3. Select a job and then select **Details**.
![](/assets/image2023-5-9_13-46-54.74dc76645d9fce64c194ec67695c47d0bbd00235ec4b9c88f2712ab632cf5a31.b40d6bf5.png)


## Permitting Access to Job Activities

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.

## Selecting the Database of a Hive/Presto Job

### Hive/Presto Job in TD Console

1. Open TD Console.
2. Navigate to **Data** **Workbench** > **Queries**.


![](/assets/image2023-5-10_12-27-57.b627946fe2eb565e192b0f51b3f7540eedc942f72c63bf35883fcad176e272fa.b40d6bf5.png)

1. 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>`...’.

### Hive/Presto Job via Workflow

You can specify the job's database for the td>: operator when you run a Hive/Presto job via Workflow.


```yaml
+run_query:
  td>:
  query: "SELECT * FROM sample_datasets.nasdaq LIMIT 1;"
  database: blog_test
```

## Selecting the Database in a Bulk Load Job

In Bulk Load jobs, the database is the destination of an import.

### Bulk Load Job in TD Console

1. Open **TD Console**.
2. Navigate to **Integrations Hub** > **Sources**.
3. Select Data Placement.
4. Select a database.


![](/assets/image2023-5-10_13-28-25.09f063aed6c61ea9c52e9f8f752033c4b7896b727ad9ae32007947d79b89f30e.b40d6bf5.png)

### Bulk Load Job via Workflow

You can specify the job's database for the td_load>: operator when you run the Bulk Load job via Workflow.


```yaml
+import_bulk_load:
  td_load>: config/import.yml
  database: blog_test
  table: dest_table
```