Begin by exporting the data you need from Metabase. In Metabase, navigate to the question or dashboard with the desired data and use the export options available (CSV/Excel) to download the dataset to your local machine.

Open the exported file and ensure that the format and structure are ready for ClickHouse. Check for any data cleaning needs, such as removing unnecessary columns or correcting formats, to ensure compatibility.

If not already installed, download and install the ClickHouse client on your local machine. This will allow you to execute SQL commands and interact directly with your ClickHouse database.

Using the ClickHouse client, connect to your ClickHouse server and create a new database (if needed) and a table to store the imported data. Define the table schema to match the structure of your exported Metabase data.

Example SQL to create a table:
```sql
CREATE TABLE my_database.my_table (
column1 DataType1,
column2 DataType2,
...
) ENGINE = MergeTree()
ORDER BY column1;
```

If necessary, convert your CSV file into a format suitable for ClickHouse. Ensure that your CSV file uses the appropriate delimiter and that all data types match the table schema you created in ClickHouse.

Use the `clickhouse-client` command-line interface to import the CSV file into your ClickHouse table. This can be done using the `--query` flag with an appropriate `INSERT INTO` or `LOAD DATA` command.

Example command:
```bash
clickhouse-client --query="INSERT INTO my_database.my_table FORMAT CSV" < /path/to/your/file.csv
```

After importing, verify that the data has been successfully moved to ClickHouse. Run a few SELECT queries to ensure that all records are present and correctly formatted, checking for any discrepancies or errors.

Example SQL to verify:
```sql
SELECT FROM my_database.my_table LIMIT 10;
```

By following these steps, you can effectively move data from Metabase to ClickHouse without relying on any third-party connectors or integrations.