Clickhouse connector - How to query

Hi sun-sboyanapall 

Please try the following M code:

let     
Source = ClickHouse.Database("0.00.00.00", 8123, "default", null),     
default_Database = Source{[Name="default",Kind="Database"]}[Data],     
ad_lookup_Table = default_Database{[Name="ad_lookup",Kind="Table"]}[Data],     
FilteredRows = Table.SelectRows(ad_lookup_Table, each [YourColumnName] = "YourDesiredValue") 
in     
FilteredRows

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

okay what i found was If I add a filter it is able to add it to the query. and it is not retrieving all the data before executing. Thank You.