Snowflex (Snowflex v0.2.1)

The client interface for connecting to the Snowflake data warehouse.

The main entry point to this module is Snowflex.sql_query. This function takes a string containing a SQL query and returns a list of maps (one per row). NOTE: due to the way the Erlang ODBC works, all values comeback as strings. You will need to cast values appropriately.

Link to this section Summary

Link to this section Types

Link to this type

query_param()

Specs

query_param() :: {:odbc.odbc_data_type(), [:odbc.value()]}

Specs

sql_data() :: [%{optional(String.t()) => String.t()}]

Link to this section Functions

Link to this function

cast_results(data, schema)

Link to this function

param_query(pool_name, query, params \\ [], timeout)

Specs

param_query(atom(), String.t(), [query_param()], timeout()) ::
  sql_data() | {:error, term()}
Link to this function

sql_query(pool_name, query, timeout)

Specs

sql_query(atom(), String.t(), timeout()) :: sql_data() | {:error, term()}
Link to this function

string_param(val, length \\ 250)