Build data-intensive applications without  operational burden

var snowflake = require('snowflake-sdk');

createConnectionObject = function () { /* Set account details using var */
    connection.connect(function(err, conn) { /* Add error-checking. */  } );
    connection.execute({
        sqlText: 'select * from ' + MY_DB + '.public.test_table',
        complete: function(err, stmt, rows) {
            for (var i = 0; i < rows.length; i++)  {
                console.log(rows[i]['COL1'] + ', ' + rows[i]['COL2']);
                }
            }
        });
}

createConnectionObject();

/* Add code to import java.sql.Connection, java.sql.DriverManager,
   java.sql.ResultSet, java.sql.Statement, java.util.Properties */

public class JDBCExample {
public static void main(String[] args) throws Exception {
   Properties properties = new Properties();

   // Set account details using properties.put(...
   Connection connection = DriverManager.getConnection(MY_CONNECT_STR, properties);
   Statement statement = connection.createStatement();
   ResultSet rs = statement.executeQuery("select * from test_table order by col1");
   while (rs.next()) {
      System.out.println(rs.getString(1) + ", " + rs.getString(2));
   }
   connection.close();
}
}

package main
import ( "database/sql"
         "fmt"
         sf "github.com/snowflakedb/gosnowflake" )
func main() {
    // Set account details using cfg := &sf.Config{...
    dsn, err := sf.DSN(cfg)
    if err != nil {fmt.Printf("ERROR")}
    db, err := sql.Open("snowflake", dsn)
    if err != nil {fmt.Printf("ERROR")}
    rows, err := db.Query("SELECT col1, col2 FROM " + MY_DB + "." + " public.test_table ORDER BY col1")
    defer rows.Close()
    var c1, c2 int
    for rows.Next() {
        err := rows.Scan(&c1, &c2)
        if err != nil {fmt.Printf("ERROR")}
        fmt.Printf("%d, %dn", c1, c2)
        }
    db.Close()    
}

using (IDbConnection conn = new SnowflakeDbConnection())
{
// Set account details using conn.ConnectionString = ...
 
    conn.Open();
    IDbCommand cmd = conn.CreateCommand();
	   cmd.CommandText = "SELECT col1, col2 FROM test_table ORDER BY col1";
	   IDataReader reader = cmd.ExecuteReader();          
    while(reader.Read())
    {
    	Console.WriteLine(reader.GetString(0) + " , " + reader.GetString(1));
	}
    conn.Close();
}

SELECT e.name as "DOCTOR",
       year(treatment_date) as "YEAR",
       d.name as "DIAGNOSIS",
       sum(t.cost_per_treatment)
       over (partition by doctor, year(treatment_date))
       as yearly_revenue
  FROM patients as p inner join treatments_applied as ta inner join
       treatments as t inner join diagnosis_types as d inner join employees as e
    ON ta.patient_ID = p.ID and
       ta.diagnosis_ID = d.ID and
       ta.treatment_ID = t.ID and
       e.ID = ta.doctor_ID
 WHERE lower(d.name) = 'python bite'
       -- extract from the JSON in the VARIANT column named "side_effects"
       and side_effects:physical.skin = 'pale'
  ORDER BY doctor, year(treatment_date);