private async Task <string> CreateSimpleDatatypesTableIfNotExist()
{
var query = "CREATE TABLE DEMO_DB.PUBLIC.DATATYPES_SIMPLE IF NOT EXIST " +
"(ID INT, SomeInt INT, SomeFloat FLOAT, SomeVarchar VARCHAR, SomeBoolean BOOLEAN, SomeBinary BINARY);";
var result = await _snowflakeClient.ExecuteScalarAsync(query);
return(result);
}
public async Task ExecuteScalar_WithResult()
{
string result = await _snowflakeClient.ExecuteScalarAsync("SELECT CURRENT_USER();");
Assert.IsTrue(!string.IsNullOrWhiteSpace(result));
}