Native Query

[Marico]

Can anyone help to write the Native Query for the following power query? Source is snowflake - I just need help with the SQL inside the native query.

let
Source=SF_Connect,
GetData = Source{[Name="V1",Kind="View"]}[Data],
#"Filtered Rows" = if #Sample = "Y" then Table.SelectRows(GetData", each ([Cluster] = #"Sample Cluster")) else Table.SelectRows(GetData, each List.Contains(#"LiveMarketGroups",[Market Group C]) and [Cluster] <> "Unknown")
in
#"Filtered Rows"

@Greg_Deckler @amitchandak

[Marico]

@amitchandak Can you please help with the code for above? Specially, how to add multiple parameters and subqueries in the where condition as it is above.

[amitchandak]

@Marico , After July 2021, We have the option to write the query in the advance option of connection, you should use that

As the query is a string, you can break a string add a parameter

"select * from table where date ='" & startDate &"' "