1  # Use Presto to Query LakeSoul's Table
 2  
 3  :::tip
 4  Available since version 2.4.
 5  :::
 6  
 7  LakeSoul implements Presto Connector and currently supports reading tables. It can read tables without primary keys and tables with primary keys (including [CDC format tables](04-cdc-ingestion-table.mdx)). When reading, Merge on Read will be automatically executed to obtain the latest data.
 8  
 9  ## Download Jar package
10  You can download the Presto package from the Github Release page: https://github.com/lakesoul-io/LakeSoul/releases/download/vVAR::VERSION/lakesoul-presto-presto-0.29-VAR::VERSION.jar
11  
12  ## Configure Presto
13  Create a new lakesoul subdirectory in the plugin subdirectory under the Presto directory. Place the jar downloaded above into this subdirectory.
14  
15  Create a new `etc/catalog/lakesoul.properties` file (the specific etc directory location can be modified according to the presto deployment):
16  ```properties
17  connector.name=lakesoul
18  fs.s3a.access.key=minioadmin1
19  fs.s3a.secret.key=minioadmin1
20  fs.s3a.bucket=lakesoul-test-bucket
21  fs.s3a.endpoint=http://minio:9000
22  ```
23  The setting items starting with `fs.s3a` are the configuration for accessing S3 and can be modified as needed.
24  
25  ## Configure LakeSoul Meta DB Connection
26  Refer to the method in the [Configure Metadata](01-setup-meta-env.md) document and use environment variables or JVM property to setup connection to meta DB. For example, JVM properties can be configured in [Presto JVM Config](https://prestodb.io/docs/current/installation/deployment.html#jvm-config). Alternatively, use the environment variable `LAKESOUL_PG_URL`. For cluster deployments (such as k8S), it is recommended to use Secret + environment variable reference to configure the metadata PG connection.
27  
28  ## Start Presto Client
29  ```shell
30  ./bin/presto --catalog lakesoul --schema default
31  ```