How to configure your ClickHouse database
queries/
folder.
Create the source `.yaml` file within the `queries` folder if you haven't already
/queries/source.yml
Add the following code for your ClickHouse connection
Replace the details section with your info and save
Done, now you can test your connection
url
, username
, password
, and database
attributes. However, for more advanced configurations, here’s the list of all available attributes:
https://latitude.server.aws.clickhouse.cloud:8443
''
.30_000
.default
.''
.default
.{}
.{}
.
.sql
in the queries
directory that points to a table of your new connection in the FROM
clause. See the section SQL Syntax Basics to learn more.latitude run query_file_name
where query_file_name
is the name of your .sql
file. This will display the results in your terminal. See the section Running queries to learn more about how to query your data.